Service Provider 1

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent16b8cd1ceede409b1a452a9019b512ab
  time1714902142
  countdown10
- country(array)
  id2
  currency(array)
  exchange_rate1.2195
  codeKYD
  symbol_postions0
  nameCayman
  slugcayman-islands
  timezoneEST
====
Request
+
Request

Cake Params
- pluginusers
- controllerservice_providers
- actionuser_detail
- named(empty)
- pass(array)
  0service
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  pluginusers
  controllerservice_providers
  actionuser_detail
- template/service-providers-profile/*
====

Sql Logs

default

Total Time: 185 ms
Total Queries: 40 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `StaticPage`.`slug` FROM `demoe3_getezquotes`.`static_pages` AS `StaticPage` WHERE 1 = 1	30	30	0
SELECT `Country`.`slug` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE 1 = 1	15	15	0
SELECT `Country`.`slug`, `Country`.`name`, `Country`.`id`, `Country`.`timezone` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `is_default` = 1 ORDER BY `country_order` ASC, `name` ASC LIMIT 1	1	1	0
SELECT `CurrencyCountry`.`currency_id`, `Currency`.`exchange_rate`, `Currency`.`code`, `Currency`.`symbol_postions` FROM `demoe3_getezquotes`.`currency_countries` AS `CurrencyCountry` LEFT JOIN `demoe3_getezquotes`.`currencies` AS `Currency` ON (`CurrencyCountry`.`currency_id` = `Currency`.`id`) WHERE `CurrencyCountry`.`country_id` = 2 LIMIT 1	1	1	0
SELECT `ServiceProvider`.`id`, `ServiceProvider`.`session_id`, `ServiceProvider`.`facebook_id`, `ServiceProvider`.`google_id`, `ServiceProvider`.`twitter_id`, `ServiceProvider`.`auth_type`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`email`, `ServiceProvider`.`username`, `ServiceProvider`.`show_name`, `ServiceProvider`.`password`, `ServiceProvider`.`contact_number`, `ServiceProvider`.`address`, `ServiceProvider`.`country_id`, `ServiceProvider`.`state_id`, `ServiceProvider`.`city_id`, `ServiceProvider`.`activation_key`, `ServiceProvider`.`email_token`, `ServiceProvider`.`email_token_exp`, `ServiceProvider`.`user_type`, `ServiceProvider`.`user_group_id`, `ServiceProvider`.`status`, `ServiceProvider`.`encrypted_user_key`, `ServiceProvider`.`business_name`, `ServiceProvider`.`business_description`, `ServiceProvider`.`website`, `ServiceProvider`.`logo`, `ServiceProvider`.`profile_image`, `ServiceProvider`.`background_profile_image`, `ServiceProvider`.`receive_deal_notification`, `ServiceProvider`.`allow_psps_contact_regarding_financing`, `ServiceProvider`.`deal_services`, `ServiceProvider`.`service_area`, `ServiceProvider`.`trade`, `ServiceProvider`.`license`, `ServiceProvider`.`expiration`, `ServiceProvider`.`business_since`, `ServiceProvider`.`helpful_information`, `ServiceProvider`.`emergency_service_charges`, `ServiceProvider`.`service_provider_type_id`, `ServiceProvider`.`have_worker_compensation_insurance`, `ServiceProvider`.`worker_compensation_insurance_expiry`, `ServiceProvider`.`have_public_liability_insurance`, `ServiceProvider`.`public_liability_insurance_expiry`, `ServiceProvider`.`is_blocked`, `ServiceProvider`.`is_deleted`, `ServiceProvider`.`user_ip`, `ServiceProvider`.`profile_completed`, `ServiceProvider`.`is_apporoved`, `ServiceProvider`.`is_notify_me`, `ServiceProvider`.`is_show_contact_info`, `ServiceProvider`.`is_featured`, `ServiceProvider`.`is_psps`, `ServiceProvider`.`is_first`, `ServiceProvider`.`is_unethical`, `ServiceProvider`.`psps_rating`, `ServiceProvider`.`average_response_time`, `ServiceProvider`.`last_login`, `ServiceProvider`.`account_disable_email`, `ServiceProvider`.`is_online`, `ServiceProvider`.`created`, `ServiceProvider`.`modified`, (SELECT GROUP_CONCAT(`categories`.`name` SEPARATOR ', ') FROM user_industries LEFT JOIN categories ON `user_industries`.`category_id`=`categories`.`id` WHERE user_id = `ServiceProvider`.`id`) AS `ServiceProvider__industry`, (SELECT GROUP_CONCAT(`categories`.`name` SEPARATOR ', ') FROM user_categories LEFT JOIN categories ON `user_categories`.`category_id`=`categories`.`id` WHERE user_id = `ServiceProvider`.`id`) AS `ServiceProvider__user_categories`, (SELECT GROUP_CONCAT(`payment_methods`.`name` SEPARATOR ', ') FROM user_payment_methods LEFT JOIN payment_methods ON `user_payment_methods`.`payment_method_id`=`payment_methods`.`id` WHERE user_id = `ServiceProvider`.`id` ) AS `ServiceProvider__user_payment_methods`, (SELECT name FROM countries where id = `ServiceProvider`.`country_id` ) AS `ServiceProvider__country`, (SELECT name FROM cities where id = `ServiceProvider`.`city_id` ) AS `ServiceProvider__city`, (SELECT IFNULL(ROUND(AVG(`user_reviews`.`overall_rating`)), 0) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND service_provider_id = `ServiceProvider`.`id` AND review_for='service_provider' AND `user_reviews`.`overall_rating` IS NOT NULL) AS `ServiceProvider__user_reviews`, (SELECT count(`user_reviews`.`id`) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND service_provider_id = `ServiceProvider`.`id` AND `user_reviews`.`parent_id`=0 AND review_for='service_provider') AS `ServiceProvider__nu_of_reviews`, (SELECT count(`project_quotes`.`id`) FROM project_quotes WHERE quote_status =1 AND psps_id = `ServiceProvider`.`id`) AS `ServiceProvider__project_awarded`, (SELECT count(`psps_photos_deals`.`id`) FROM psps_photos_deals WHERE is_deal = 1 and user_id = `ServiceProvider`.`id` AND deal_status = 'accepted') AS `ServiceProvider__user_deals`, (select status from user_current_plans where `user_current_plans`.`user_id` = `ServiceProvider`.`id` ORDER BY `user_current_plans`.`created` DESC limit 1) AS `ServiceProvider__plan_status`, (select count(`user_categories`.`id`) from user_categories where `user_categories`.`user_id` = `ServiceProvider`.`id` AND `user_categories`.`allow_hourly_rate` = 1) AS `ServiceProvider__allow_hourly_rate`, (select send_invoice from user_current_plans where `user_current_plans`.`user_id` = `ServiceProvider`.`id` AND is_expired =0 ORDER BY `user_current_plans`.`created` DESC limit 1) AS `ServiceProvider__basic_fixed_plan` FROM `demoe3_getezquotes`.`users` AS `ServiceProvider` WHERE `ServiceProvider`.`user_type` = 'service-provider' AND ((`is_blocked` = 0) AND (`is_deleted` = 0) AND (`is_apporoved` = 1) AND (`status` = 1) AND (`activation_key` = '')) AND `ServiceProvider`.`country_id` = 2 AND (select status from user_current_plans where `user_current_plans`.`user_id` = `ServiceProvider`.`id` ORDER BY `user_current_plans`.`created` DESC limit 1) != '' AND `ServiceProvider`.`username` = 'service' LIMIT 1	1	1	74	maybe slow
SELECT `UserCurrentPlan`.`id`, `UserCurrentPlan`.`user_id`, `UserCurrentPlan`.`user_purchased_plan_id`, `UserCurrentPlan`.`payment_id`, `UserCurrentPlan`.`subscription_id`, `UserCurrentPlan`.`subscription_variant_id`, `UserCurrentPlan`.`subscription_name`, `UserCurrentPlan`.`is_free_plan`, `UserCurrentPlan`.`is_unlimited_plan`, `UserCurrentPlan`.`start_date`, `UserCurrentPlan`.`end_date`, `UserCurrentPlan`.`plan_duration`, `UserCurrentPlan`.`plan_type`, `UserCurrentPlan`.`quote_per_month`, `UserCurrentPlan`.`sub_category_directory`, `UserCurrentPlan`.`portfolio_samples`, `UserCurrentPlan`.`send_invoice`, `UserCurrentPlan`.`admin_commission_percetage`, `UserCurrentPlan`.`plan_amount`, `UserCurrentPlan`.`status`, `UserCurrentPlan`.`is_expired`, `UserCurrentPlan`.`cron_last_checked`, `UserCurrentPlan`.`created`, `UserCurrentPlan`.`modified` FROM `demoe3_getezquotes`.`user_current_plans` AS `UserCurrentPlan` WHERE `UserCurrentPlan`.`is_expired` = 0 AND `UserCurrentPlan`.`user_id` = (11) ORDER BY `UserCurrentPlan`.`created` DESC	1	1	1
SELECT `UserPortfolio`.`id`, `UserPortfolio`.`user_id`, `UserPortfolio`.`title`, `UserPortfolio`.`portfolio`, `UserPortfolio`.`is_deleted`, `UserPortfolio`.`created`, `UserPortfolio`.`modified` FROM `demoe3_getezquotes`.`user_portfolios` AS `UserPortfolio` WHERE `UserPortfolio`.`is_deleted` = 0 AND `UserPortfolio`.`user_id` = (11) ORDER BY `UserPortfolio`.`created` DESC	0	0	1	maybe slow
SELECT `UserCategory`.`id`, `UserCategory`.`user_id`, `UserCategory`.`category_id`, `UserCategory`.`allow_hourly_rate`, `UserCategory`.`hourly_rate`, `UserCategory`.`local_currency_code`, `UserCategory`.`created`, `UserCategory`.`modified` FROM `demoe3_getezquotes`.`user_categories` AS `UserCategory` WHERE `UserCategory`.`user_id` = (11)	11	11	1	maybe slow
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 366	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 1154	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 362	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 1155	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 1035	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 1119	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 1034	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 1231	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 365	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 252	1	1	0
SELECT `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` = 253	1	1	0
SELECT `UserPaymentMethod`.`id`, `UserPaymentMethod`.`payment_method_id`, `UserPaymentMethod`.`user_id`, `UserPaymentMethod`.`created`, `UserPaymentMethod`.`modified` FROM `demoe3_getezquotes`.`user_payment_methods` AS `UserPaymentMethod` WHERE `UserPaymentMethod`.`user_id` = (11)	2	2	0
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`user_reviews` AS `UserReview` WHERE `UserReview`.`service_provider_id` = 11 AND `UserReview`.`user_id` IS NULL AND `UserReview`.`review_for` = 'service_provider'	1	1	0
SELECT COUNT(`UserReview`.`project_id`) as total_projects, ROUND(`UserReview`.`overall_rating`) as overall_rating FROM `demoe3_getezquotes`.`user_reviews` AS `UserReview` WHERE `UserReview`.`service_provider_id` = 11 AND `UserReview`.`review_for` = 'service_provider' AND `UserReview`.`status` = 1 AND `UserReview`.`is_deleted` = 0 AND `UserReview`.`is_active` = 1 AND `UserReview`.`parent_id` = 0 GROUP BY ROUND(`UserReview`.`overall_rating`)	0	0	0
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`user_reviews` AS `UserReview` WHERE `UserReview`.`service_provider_id` = 11 AND `UserReview`.`review_for` = 'service_provider' AND `UserReview`.`status` = 1 AND `UserReview`.`is_deleted` = 0 AND `UserReview`.`is_active` = 1 AND `UserReview`.`parent_id` = 0	1	1	0
SELECT `UserReview`.`id`, `UserReview`.`user_id`, `UserReview`.`review`, `UserReview`.`overall_rating`, `UserReview`.`work_completed_date`, `UserReview`.`project_amount`, `UserReview`.`project_hire_status`, `UserReview`.`service_provider_id`, `UserReview`.`total_like_count`, `UserReview`.`total_unlike_count`, `UserReview`.`review_for`, `UserReview`.`created`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`show_name`, `User`.`profile_image`, `User`.`user_type`, `Project`.`id`, `Project`.`name`, `Project`.`show_name`, `Project`.`alias_name`, `Project`.`estimated_date`, `Project`.`completed_date`, `Project`.`award_date`, (SELECT review FROM user_reviews AS USER_REVIW_REPLY WHERE `USER_REVIW_REPLY`.`parent_id` = `UserReview`.`id`) AS `UserReview__review_reply`, (SELECT ROUND(AVG(`user_reviews`.`overall_rating`)) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND `user_reviews`.`review_for` = 'consumer' AND user_id = `UserReview`.`user_id`) AS `UserReview__consumer_avg_rating`, (SELECT count(`user_reviews`.`id`) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND `user_reviews`.`parent_id`=0 AND `user_reviews`.`review_for` = 'consumer' AND user_id = `UserReview`.`user_id`) AS `UserReview__consumer_nu_of_reviews`, (select count(`user_review_likes`.`id`) from user_review_likes where `user_review_likes`.`user_id` = 0 AND `user_review_likes`.`user_review_id`= `UserReview`.`id` AND `user_review_likes`.`like`=1 ) AS `UserReview__like_status`, (select count(`user_review_likes`.`id`) from user_review_likes where `user_review_likes`.`user_id` = 0 AND `user_review_likes`.`user_review_id`= `UserReview`.`id` AND `user_review_likes`.`unlike`=1 ) AS `UserReview__unlike_status` FROM `demoe3_getezquotes`.`user_reviews` AS `UserReview` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`UserReview`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_getezquotes`.`projects` AS `Project` ON (`UserReview`.`project_id` = `Project`.`id`) WHERE `UserReview`.`service_provider_id` = 11 AND `UserReview`.`review_for` = 'service_provider' AND `UserReview`.`status` = 1 AND `UserReview`.`is_deleted` = 0 AND `UserReview`.`is_active` = 1 AND `UserReview`.`parent_id` = 0 ORDER BY `UserReview`.`id` DESC LIMIT 30	0	0	2	maybe slow
SELECT `Project`.`name`, `Project`.`description`, `Project`.`category_id`, `Project`.`show_name`, `Project`.`alias_name`, `ProjectOwner`.`first_name`, `ProjectOwner`.`last_name`, `ProjectOwner`.`username`, `ProjectOwner`.`show_name`, `QuoteType`.`name` FROM `demoe3_getezquotes`.`project_quotes` AS `Quote` LEFT JOIN `demoe3_getezquotes`.`projects` AS `Project` ON (`Quote`.`project_id` = `Project`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ProjectOwner` ON (`Quote`.`user_id` = `ProjectOwner`.`id`) LEFT JOIN `demoe3_getezquotes`.`quote_types` AS `QuoteType` ON (`Quote`.`quote_type` = `QuoteType`.`id`) WHERE ((`Quote`.`psps_id` = 11) AND (`quote_status` = 1)) ORDER BY `Quote`.`award_date` DESC LIMIT 30	0	0	19	maybe slow
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`project_quotes` AS `Quote` LEFT JOIN `demoe3_getezquotes`.`projects` AS `Project` ON (`Quote`.`project_id` = `Project`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ServiceProvider` ON (`Quote`.`psps_id` = `ServiceProvider`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ProjectOwner` ON (`Quote`.`user_id` = `ProjectOwner`.`id`) LEFT JOIN `demoe3_getezquotes`.`quote_types` AS `QuoteType` ON (`Quote`.`quote_type` = `QuoteType`.`id`) WHERE ((`Quote`.`psps_id` = 11) AND (`quote_status` = 1))	1	1	0
SELECT `PhotosDeal`.`id`, `PhotosDeal`.`offer_id`, `PhotosDeal`.`user_id`, `PhotosDeal`.`category_id`, `PhotosDeal`.`country_id`, `PhotosDeal`.`slug`, `PhotosDeal`.`photo_original_name`, `PhotosDeal`.`photo_name`, `PhotosDeal`.`is_deal`, `PhotosDeal`.`is_offer`, `PhotosDeal`.`is_photo`, `PhotosDeal`.`allow_for_proposed_offer`, `PhotosDeal`.`proposed_offer_rating`, `PhotosDeal`.`regular_price`, `PhotosDeal`.`member_price`, `PhotosDeal`.`local_currency_code`, `PhotosDeal`.`saving_percent`, `PhotosDeal`.`expiry_date`, `PhotosDeal`.`offer_details`, `PhotosDeal`.`offer_text`, `PhotosDeal`.`offer_price`, `PhotosDeal`.`exclusion_offer`, `PhotosDeal`.`key_features`, `PhotosDeal`.`maximum_deals_offered`, `PhotosDeal`.`maximum_offers`, `PhotosDeal`.`total_sold`, `PhotosDeal`.`client_requirements`, `PhotosDeal`.`add_property_stamp`, `PhotosDeal`.`view_count`, `PhotosDeal`.`deal_status`, `PhotosDeal`.`offer_status`, `PhotosDeal`.`is_deleted`, `PhotosDeal`.`created`, `PhotosDeal`.`modified`, (SELECT AVG(`user_deals`.`deal_overall_rating`) FROM user_deals WHERE deal_overall_rating != '' AND `user_deals`.`is_active` = 1 AND `user_deals`.`is_approved` = 1 AND psps_photos_deal_id = `PhotosDeal`.`id` ) AS `PhotosDeal__deal_rating`, (SELECT count(`user_deals`.`id`) FROM user_deals WHERE accepted = 1 AND psps_photos_deal_id = `PhotosDeal`.`id`) AS `PhotosDeal__deal_accepted_count`, (SELECT ROUND(AVG(`user_reviews`.`overall_rating`)) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND service_provider_id = `PhotosDeal`.`user_id` AND review_for = 'service_provider') AS `PhotosDeal__psps_reviews`, (SELECT count(`user_reviews`.`id`) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND service_provider_id = `PhotosDeal`.`user_id` AND `user_reviews`.`parent_id`=0 AND review_for = 'service_provider') AS `PhotosDeal__psps_nu_of_reviews`, (SELECT `countries`.`name` from countries where `User`.`country_id` = `countries`.`id`) AS `PhotosDeal__country_name`, (SELECT `cities`.`name` from cities where `User`.`city_id` = `cities`.`id`) AS `PhotosDeal__city_name`, (SELECT COUNT(id) from user_deals where psps_photos_deal_id = `PhotosDeal`.`id`) AS `PhotosDeal__user_deal_count`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`username`, `User`.`user_type`, `User`.`business_name`, `User`.`profile_image`, `Category`.`name`, `Category`.`id` FROM `demoe3_getezquotes`.`psps_photos_deals` AS `PhotosDeal` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`PhotosDeal`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`PhotosDeal`.`category_id` = `Category`.`id`) WHERE `PhotosDeal`.`deal_status` = 'accepted' AND `PhotosDeal`.`is_deleted` = 0 AND `PhotosDeal`.`is_deal` = 1 AND `PhotosDeal`.`user_id` = 11 AND `PhotosDeal`.`expiry_date` >= 1714971599 LIMIT 30	0	0	1	maybe slow
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`psps_photos_deals` AS `PhotosDeal` WHERE `PhotosDeal`.`deal_status` = 'accepted' AND `PhotosDeal`.`is_deleted` = 0 AND `PhotosDeal`.`is_deal` = 1 AND `PhotosDeal`.`user_id` = 11 AND `PhotosDeal`.`expiry_date` >= 1714971599	1	1	0
SELECT `PhotosDeal`.`id`, `PhotosDeal`.`offer_id`, `PhotosDeal`.`user_id`, `PhotosDeal`.`category_id`, `PhotosDeal`.`country_id`, `PhotosDeal`.`slug`, `PhotosDeal`.`photo_original_name`, `PhotosDeal`.`photo_name`, `PhotosDeal`.`is_deal`, `PhotosDeal`.`is_offer`, `PhotosDeal`.`is_photo`, `PhotosDeal`.`allow_for_proposed_offer`, `PhotosDeal`.`proposed_offer_rating`, `PhotosDeal`.`regular_price`, `PhotosDeal`.`member_price`, `PhotosDeal`.`local_currency_code`, `PhotosDeal`.`saving_percent`, `PhotosDeal`.`expiry_date`, `PhotosDeal`.`offer_details`, `PhotosDeal`.`offer_text`, `PhotosDeal`.`offer_price`, `PhotosDeal`.`exclusion_offer`, `PhotosDeal`.`key_features`, `PhotosDeal`.`maximum_deals_offered`, `PhotosDeal`.`maximum_offers`, `PhotosDeal`.`total_sold`, `PhotosDeal`.`client_requirements`, `PhotosDeal`.`add_property_stamp`, `PhotosDeal`.`view_count`, `PhotosDeal`.`deal_status`, `PhotosDeal`.`offer_status`, `PhotosDeal`.`is_deleted`, `PhotosDeal`.`created`, `PhotosDeal`.`modified`, (SELECT count(`user_purchased_offers`.`id`) FROM user_purchased_offers WHERE `user_purchased_offers`.`payment_status` = 'completed' AND `user_purchased_offers`.`psps_photos_deal_id` = `PhotosDeal`.`id`) AS `PhotosDeal__offer_purchased_count`, (SELECT `countries`.`name` from countries where `User`.`country_id` = `countries`.`id`) AS `PhotosDeal__country_name`, (SELECT `cities`.`name` from cities where `User`.`city_id` = `cities`.`id`) AS `PhotosDeal__city_name`, (SELECT ROUND(AVG(`psps_offer_ratings`.`rating`),1) FROM psps_offer_ratings WHERE `psps_offer_ratings`.`is_approved` = 1 AND `psps_offer_ratings`.`is_deleted` =0 AND `psps_offer_ratings`.`is_active` = 1 AND `psps_offer_ratings`.`psps_photo_deal_id` = `PhotosDeal`.`id` AND review_for = 'purchased_offer') AS `PhotosDeal__offer_rating`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`username`, `User`.`user_type`, `User`.`business_name`, `User`.`profile_image`, `Category`.`name`, `Category`.`id` FROM `demoe3_getezquotes`.`psps_photos_deals` AS `PhotosDeal` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`PhotosDeal`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`PhotosDeal`.`category_id` = `Category`.`id`) WHERE `PhotosDeal`.`offer_status` = 'accepted' AND `PhotosDeal`.`is_deleted` = 0 AND `PhotosDeal`.`is_offer` = 1 AND `PhotosDeal`.`user_id` = 11 AND `PhotosDeal`.`expiry_date` >= 1714971599 LIMIT 30	0	0	84	maybe slow
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`psps_photos_deals` AS `PhotosDeal` WHERE `PhotosDeal`.`offer_status` = 'accepted' AND `PhotosDeal`.`is_deleted` = 0 AND `PhotosDeal`.`is_offer` = 1 AND `PhotosDeal`.`user_id` = 11 AND `PhotosDeal`.`expiry_date` >= 1714971599	1	1	0
SELECT `UserRecommendation`.`id`, `UserRecommendation`.`user_id`, `UserRecommendation`.`service_provider_id`, `UserRecommendation`.`recommandation_reason`, `UserRecommendation`.`recommandation_category`, `UserRecommendation`.`recommandation_comment`, `UserRecommendation`.`status`, `UserRecommendation`.`is_approved`, `UserRecommendation`.`is_verified`, `UserRecommendation`.`verification_date`, `UserRecommendation`.`created`, `UserRecommendation`.`modified`, `User`.`id`, `User`.`session_id`, `User`.`facebook_id`, `User`.`google_id`, `User`.`twitter_id`, `User`.`auth_type`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`username`, `User`.`show_name`, `User`.`password`, `User`.`contact_number`, `User`.`address`, `User`.`country_id`, `User`.`state_id`, `User`.`city_id`, `User`.`activation_key`, `User`.`email_token`, `User`.`email_token_exp`, `User`.`user_type`, `User`.`user_group_id`, `User`.`status`, `User`.`encrypted_user_key`, `User`.`business_name`, `User`.`business_description`, `User`.`website`, `User`.`logo`, `User`.`profile_image`, `User`.`background_profile_image`, `User`.`receive_deal_notification`, `User`.`allow_psps_contact_regarding_financing`, `User`.`deal_services`, `User`.`service_area`, `User`.`trade`, `User`.`license`, `User`.`expiration`, `User`.`business_since`, `User`.`helpful_information`, `User`.`emergency_service_charges`, `User`.`service_provider_type_id`, `User`.`have_worker_compensation_insurance`, `User`.`worker_compensation_insurance_expiry`, `User`.`have_public_liability_insurance`, `User`.`public_liability_insurance_expiry`, `User`.`is_blocked`, `User`.`is_deleted`, `User`.`user_ip`, `User`.`profile_completed`, `User`.`is_apporoved`, `User`.`is_notify_me`, `User`.`is_show_contact_info`, `User`.`is_featured`, `User`.`is_psps`, `User`.`is_first`, `User`.`is_unethical`, `User`.`psps_rating`, `User`.`average_response_time`, `User`.`last_login`, `User`.`account_disable_email`, `User`.`is_online`, `User`.`created`, `User`.`modified`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`username`, `ServiceProvider`.`business_name`, `Category`.`name` FROM `demoe3_getezquotes`.`user_recommendations` AS `UserRecommendation` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`UserRecommendation`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ServiceProvider` ON (`UserRecommendation`.`service_provider_id` = `ServiceProvider`.`id`) LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`UserRecommendation`.`recommandation_category` = `Category`.`id`) WHERE `UserRecommendation`.`service_provider_id` = 11 AND `UserRecommendation`.`is_approved` = 1 AND `UserRecommendation`.`status` = 1 ORDER BY `UserRecommendation`.`created` DESC	0	0	1	maybe slow
SELECT `UserEmergencyServiceRating`.`id`, `UserEmergencyServiceRating`.`user_id`, `UserEmergencyServiceRating`.`service_provider_id`, `UserEmergencyServiceRating`.`user_emergency_service_provider_id`, `UserEmergencyServiceRating`.`service_quality`, `UserEmergencyServiceRating`.`currency`, `UserEmergencyServiceRating`.`service_category`, `UserEmergencyServiceRating`.`comments`, `UserEmergencyServiceRating`.`cost`, `UserEmergencyServiceRating`.`service_date`, `UserEmergencyServiceRating`.`reason`, `UserEmergencyServiceRating`.`status`, `UserEmergencyServiceRating`.`is_approved`, `UserEmergencyServiceRating`.`is_verified`, `UserEmergencyServiceRating`.`verification_date`, `UserEmergencyServiceRating`.`created`, `UserEmergencyServiceRating`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`profile_image`, `User`.`username`, `User`.`user_type`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name` FROM `demoe3_getezquotes`.`user_emergency_service_ratings` AS `UserEmergencyServiceRating` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`UserEmergencyServiceRating`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ServiceProvider` ON (`UserEmergencyServiceRating`.`service_provider_id` = `ServiceProvider`.`id`) WHERE `UserEmergencyServiceRating`.`service_provider_id` = 11 AND `UserEmergencyServiceRating`.`is_approved` = 1 AND `UserEmergencyServiceRating`.`status` = 1 ORDER BY `UserEmergencyServiceRating`.`created` DESC	0	0	1	maybe slow
SELECT `Country`.`id`, `Country`.`country_code` FROM `demoe3_getezquotes`.`countries` AS `Country` LEFT JOIN `demoe3_getezquotes`.`currency_countries` AS `CurrencyCountry` ON (`CurrencyCountry`.`country_id` = `Country`.`id`) WHERE `Country`.`id` = 2 LIMIT 1	1	1	0
SELECT `CurrencyCountry`.`id`, `CurrencyCountry`.`currency_id`, `CurrencyCountry`.`country_id`, `CurrencyCountry`.`created`, `CurrencyCountry`.`modified` FROM `demoe3_getezquotes`.`currency_countries` AS `CurrencyCountry` WHERE `CurrencyCountry`.`country_id` = 2	1	1	0
SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`symbol`, `Currency`.`code`, `Currency`.`exchange_rate`, `Currency`.`symbol_postions`, `Currency`.`is_default`, `Currency`.`is_active`, `Currency`.`created`, `Currency`.`modified` FROM `demoe3_getezquotes`.`currencies` AS `Currency` WHERE `Currency`.`id` = 1	1	1	0
SELECT `City`.`id`, `City`.`name` FROM `demoe3_getezquotes`.`cities` AS `City` WHERE `City`.`id` IN (595, 596, 602, 603)	4	4	0
SELECT `Country`.`id`, `Country`.`slug`, `Country`.`name`, `Country`.`country_code`, `Country`.`is_default`, `Country`.`country_flag` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `Country`.`show_in_menu` = 1 AND `Country`.`status` = 1 ORDER BY `country_order` ASC, `name` ASC	3	3	0
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` WHERE `user_type` = 'service-provider' AND ((`is_blocked` = 0) AND (`is_deleted` = 0) AND (`is_apporoved` = 1) AND (`status` = 1) AND (`activation_key` = ''))	1	1	0
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` WHERE `user_type` = 'user'	1	1	0
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`projects` AS `Projects` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`Projects`.`user_id` = `User`.`id`) WHERE `Projects`.`status` = 1 AND `Projects`.`is_admin_approved` = 1 AND `Projects`.`is_posted` = 1 AND `Projects`.`is_deleted` = 0 AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 19.03 MB

Message	Memory use
Component initialization	9.99 MB
Controller action start	11.09 MB
Controller render start	13.79 MB
View render complete	16.98 MB

Timers

Total Request Time: 1180 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	226.11
Event: Controller.initialize	117.41
Event: Controller.startup	4.05
Controller action	631.81
Event: Controller.beforeRender	10.08
» Processing toolbar data	9.80
Rendering View	70.75
» Event: View.beforeRender	0.04
» Rendering APP/Plugin/Users/View/ServiceProviders/user_detail.ctp	24.18
» » Rendering APP/Plugin/Users/View/Elements/psps_detail_top_info.ctp	12.85
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	45.04
» » Rendering APP/View/Elements/header_js.ctp	1.82
» » Rendering APP/View/Elements/header.ctp	13.42
» » Rendering APP/View/Elements/footer.ctp	28.33
» » » Rendering APP/View/Elements/city_search_popup_psps.ctp	3.04
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- limit30
- logged_in_user0
- usernameservice
- user_typeservice-provider
- psps_rating_breakdown(empty)
- award_count0
- user_quote(empty)
- data(array)
  ServiceProvider(array)
  id11
  session_id(null)
  facebook_id(null)
  google_id(null)
  twitter_id(null)
  auth_type(null)
  first_nameService
  last_nameProvider 1
  emailsp1@stonemansupply.com
  usernameservice
  show_namerealname
  passworddb68b6f4302dbc3f9c1d43aa222b0ffb2d0e1ce8
  contact_number3459121232
  address23 Eastern Avenue
  country_id2
  state_id34
  city_id596
  activation_key
  email_token
  email_token_exp0
  user_typeservice-provider
  user_group_id2
  status1
  encrypted_user_key###@*Bgad12e###@
  business_nameService Provider 1
  business_descriptiond;jklsfa df;a;fj df asd'f;jasd;fj df j'asdfj [edueru a;dhgsdfgd aiafcnj'xk 'fjjA F F FJF F'IOD D' DJFJJF 'fAHSFGS SISIWI gey d lslfj ooo ofoof nfn f fodo dod
  website
  logoservice_provider_5718806831585715489.png
  profile_image
  background_profile_image(null)
  receive_deal_notification0
  allow_psps_contact_regarding_financing0
  deal_services(null)
  service_area595,596,602,603
  tradeMasonry &amp; Tiling Construction
  license34567/TP
  expiration1587617999
  business_since2009
  helpful_information3,5,8
  emergency_service_charges(null)
  service_provider_type_id4
  have_worker_compensation_insurance1
  worker_compensation_insurance_expiry1637038799
  have_public_liability_insurance1
  public_liability_insurance_expiry1637038799
  is_blocked0
  is_deleted0
  user_ip2430178741
  profile_completed1
  is_apporoved1
  is_notify_me1
  is_show_contact_info0
  is_featured(null)
  is_psps1
  is_first0
  is_unethical0
  psps_rating(null)
  average_response_time0.00
  last_login1702611177
  account_disable_email1
  is_online0
  created1585715489
  modified1702611177
  industryGeneral Building Construction
  user_categoriesCommercial Construction, Garage Construction, General Repairs & Construction, Ground Floor Extension, Industrial Construction, Masonry Construction, Office Fit Out Construction, Renovation Construction, Residential Construction, Stone Works Construction, Tiling Construction
  user_payment_methodsCash, Cheque
  countryCayman
  cityGeorge Town
  user_reviews0
  nu_of_reviews0
  project_awarded0
  user_deals0
  plan_statuscompleted
  allow_hourly_rate5
  basic_fixed_plan0
  UserCurrentPlan(array)
  id5
  user_id11
  user_purchased_plan_id16
  payment_id25
  subscription_id4
  subscription_variant_id10
  subscription_namePlatinum Plan
  is_free_plan0
  is_unlimited_plan1
  start_date1700631744
  end_date1708580544
  plan_duration1
  plan_typeMonth
  quote_per_month14
  sub_category_directory15
  portfolio_samples8
  send_invoice0
  admin_commission_percetage0
  plan_amount275.00
  statuscompleted
  is_expired0
  cron_last_checked(null)
  created1585718130
  modified1589010445
  UserPortfolio(empty)
  UserCategory(array)
  0(array)
  id67
  user_id11
  category_id366
  allow_hourly_rate0
  hourly_rate(null)
  local_currency_code(null)
  created1589074524
  modified1700634247
  Category(array)
  nameCommercial Construction
  1(array)
  id68
  user_id11
  category_id1154
  allow_hourly_rate0
  hourly_rate(null)
  local_currency_code(null)
  created1589074524
  modified1700634247
  Category(array)
  nameGarage Construction
  2(array)
  id69
  user_id11
  category_id362
  allow_hourly_rate1
  hourly_rate75.00
  local_currency_code(null)
  created1589074524
  modified1700634247
  Category(array)
  nameGeneral Repairs & Construction
  3(array)
  id70
  user_id11
  category_id1155
  allow_hourly_rate0
  hourly_rate(null)
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameGround Floor Extension
  4(array)
  id71
  user_id11
  category_id1035
  allow_hourly_rate0
  hourly_rate(null)
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameIndustrial Construction
  5(array)
  id72
  user_id11
  category_id1119
  allow_hourly_rate1
  hourly_rate75.00
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameMasonry Construction
  6(array)
  id73
  user_id11
  category_id1034
  allow_hourly_rate0
  hourly_rate(null)
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameOffice Fit Out Construction
  7(array)
  id74
  user_id11
  category_id1231
  allow_hourly_rate1
  hourly_rate80.00
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameRenovation Construction
  8(array)
  id75
  user_id11
  category_id365
  allow_hourly_rate0
  hourly_rate(null)
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameResidential Construction
  9(array)
  id76
  user_id11
  category_id252
  allow_hourly_rate1
  hourly_rate100.00
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameStone Works Construction
  10(array)
  id77
  user_id11
  category_id253
  allow_hourly_rate1
  hourly_rate65.00
  local_currency_code(null)
  created1589074525
  modified1700634247
  Category(array)
  nameTiling Construction
  UserPaymentMethod(array)
  0(array)
  id16
  payment_method_id3
  user_id11
  created1700634247
  modified1700634247
  1(array)
  id17
  payment_method_id5
  user_id11
  created1700634247
  modified1700634247
- if_review_posted0
- all_reviews(empty)
- all_deals(empty)
- all_deals_count0
- all_offers(empty)
- all_offers_count0
- userEmergency(empty)
- userRecommendation(empty)
- lastpage
- count_reviews0
- page2
- current_page1
- all_reviews_count0
- pageTitleService Provider 1
- title_for_layoutService Provider 1
- meta_descriptiond;jklsfa df;a;fj df asd'f;jasd;fj df j'asdfj [edueru a;dhgsdfgd aiafcnj'xk 'fjjA F F FJF F'IOD D' DJFJJF 'fAHSFGS SISIWI gey d lslfj ooo ofoof nfn f fodo dod
- website_share_imagehttp://www.getezquotes.demoe3.com/stuff/logo/service_provider_5718806831585715489.png
- project_name_for_form(null)
- modelServiceProvider
- allNotifications0
- $request->data(empty)
- $this->validationErrors(array)
  StaticPage(empty)
  Country(empty)
  CurrencyCountry(empty)
  Currency(empty)
  Notification(empty)
  UserCategory(empty)
  ServiceProvider(empty)
  UserRecommendation(empty)
  UserCurrentPlan(empty)
  UserPortfolio(empty)
  Category(empty)
  UserPaymentMethod(empty)
  UserReview(empty)
  UserCriteriaRating(empty)
  User(empty)
  Project(empty)
  Quote(empty)
  ProjectOwner(empty)
  QuoteType(empty)
  PhotosDeal(empty)
  UserEmergencyServiceRating(empty)
- Loaded Helpers(array)
  0Number
  1SimpleGraph
  2DebugTimer
  3Toolbar
  4Html
  5Session
  6GeneralFunctions
  7Form
  8HtmlToolbar
====

Environment

App Constants

Constant	Value
MAIN_FOLDER
ADMIN_FOLDER	admin/
SITE_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/
SITE_WEBROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/
WEBSITE_URL	http://www.getezquotes.demoe3.com/
SET_COOKIE_TIME	2592000
HOST_URL	www.getezquotes.demoe3.com
WEBSITE_ADMIN_URL	http://www.getezquotes.demoe3.com/admin/
WEBSITE_IMG_URL	http://www.getezquotes.demoe3.com/img/
WEBSITE_ADMIN_IMG_URL	http://www.getezquotes.demoe3.com/admin/img/
WEBSITE_APP_WEBROOT_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/
DEFAULT_COUNTRY_CODE	CYM
DEFAULT_STATE_CODE	GUY
DEFAULT_CITY_NAME	George Town
DEFAULT_CITY_ZIPCODE	KY1-1100
COORDINATOR_RATING_FORM_FIELD_NAME	coordinator_review_rating_
APP_UPLOADS_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/
PERCENT_SYMBOL	%
WEBSITE_IMG_FILE_URL	http://www.getezquotes.demoe3.com/image.php
DATEPICKER_DATE_FORMATE	m-d-Y
DATE_FROM_DB	'%m-%d-%Y'
DATE_SEPERATOR	-
TIME_SEPARATOR	:
DATE_TIME_SPACE_SEPARATOR
TIME_FORMATE_24_HOUR	H:i
DATE_FORMATE	m-d-Y
DATE_FORMATE_WITH_TIMEZONE	dS F Y, h:i:s A T
DATE_TIME_FORMATE	m-d-Y h:m:s
COMDOWN_DATE_FORMATE	Y/m/d h:i:s
TIME_FORMATE	h:i a
TIMEFORMATE_JS	H:i a
INVOICE_DATE_FORMATE	F d, Y
ADMIN_MASSAGE_DATE_FORMATE	m-d-Y h:i A
PROPOSAL_DATE_FORMAT	d M Y
LESTEST_ACTIVITY_TIME	h:i A
LESTEST_ACTIVITY_TIME_STAMP	1714293741
DATE_FORMATE_JS	mm-dd-yyyy
DATE_TIME_FORMATE_JS	mm-dd-yyyy hh:ii P
DATE_TIME_FORMATE_JS_12_HOURS	dd-mm-yyyy HH:ii P
DATETIME_FORMATE	m-d-Y h:i a
DATETIME_FORMATE_JS	m-d-Y H:i a
REVIEW_DATE_FORMATE	m-d-Y
PROJECT_DETAIL_DATE_FORMATE	m/d/Y
STUFF_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff
STUFF_FOLDER_URL	http://www.getezquotes.demoe3.com/stuff/
ONTHEFLY_IMAGE_ROOT_PATH	stuff/
CATEGORY_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/category_images/
CATEGORY_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/category_images/
CATEGORY_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/category_images/
CATEGORY_BROCHURE_URL	http://www.getezquotes.demoe3.com/stuff/category_brochure/
CATEGORY_BROCHURE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/category_brochure/
CATEGORY_BROCHURE_ONTHEFLY_IMAGE_PATH	stuff/category_brochure/
BANNER_POSTION_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/banner_position_images/
BANNER_POSTION_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/banner_position_images/
BANNER_POSTION_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/banner_position_images/
SERVICE_ASSOCIATION_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/service_association/
SERVICE_ASSOCIATION_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/service_association/
SERVICE_ASSOCIATION_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/service_association/
BANNER_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/banner_image/
BANNER_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/banner_image/
BANNER_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/banner_image/
PROJECT_ATTACHMENTS_URL	http://www.getezquotes.demoe3.com/stuff/project_attachments/
PROJECT_ATTACHMENTS_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/project_attachments/
PROJECT_ATTACHMENTS_ONTHEFLY_IMAGE_PATH	stuff/project_attachments/
QUOTE_ATTACHMENTS_URL	http://www.getezquotes.demoe3.com/stuff/quote_attachments/
QUOTE_ATTACHMENTS_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/quote_attachments/
QUOTE_ATTACHMENTS_ONTHEFLY_IMAGE_PATH	stuff/quote_attachments/
COUPON_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/coupons_images/
COUPON_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/coupons_images/
COUPON_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/coupons_images/
LOGO_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/logo/
LOGO_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/logo/
LOGO_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/logo/
PORTFOLIO_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/portfolio/
PORTFOLIO_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/portfolio/
PORTFOLIO_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/portfolio/
COUNTRY_FLAG_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/countryflag/
COUNTRY_FLAG_ONTHEFLY_IMAGE_PATH	stuff/countryflag/
PHOTO_DEAL_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/photo_deal/
PHOTO_DEAL_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/photo_deal/
PHOTO_DEAL_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/photo_deal/
PROFILE_IMAGE_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/profile_image/
PROFILE_IMAGE_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/profile_image/
WEBSITE_LOGO_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/website_logo/
PROFILE_IMAGE_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/profile_image/
WEBSITE_LOGO_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/website_logo/
BACKGROUND_PROFILE_IMAGE_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/background_profile_image/
BACKGROUND_PROFILE_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/background_profile_image/
BACKGROUND_PROFILE_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/background_profile_image/
BACKGROUND_PROFILE_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/background_profile_image/
TESTIMONIAL_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/testimonial/
TESTIMONIAL_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/testimonial/
TESTIMONIAL_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/testimonial/
DEPARTMENT_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/department/
DEPARTMENT_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/department/
DEPARTMENT_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/department/
ATTACHMENT_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/attachment/
ATTACHMENT_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/attachment/
ATTACHMENT_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/attachment/
CHAT_ATT_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/chatattachment/
CHAT_ATT_ONTHEFLY_IMAGE_PATH	stuff/chatattachment/
PM_REQUEST_SERVICES_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/project_management_request_services/
PM_REQUEST_SERVICES_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/project_management_request_services/
PM_REQUEST_SERVICES_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/project_management_request_services/
HOME_SLIDER_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/slider_images/
HOME_SLIDER_IMAGE_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/slider_images/
HOME_SLIDER_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/slider_images/
COORDINATOR_DOCUMENTS_URL	http://www.getezquotes.demoe3.com/stuff/coordinator_documents/
COORDINATOR_DOCUMENT_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/coordinator_documents/
COORDINATOR_DOCUMENT_ONTHEFLY_PATH	stuff/coordinator_documents/
SETTINGS_IMAGE_URL	http://www.getezquotes.demoe3.com/stuff/settings/
SETTINGS_IMAGE_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/settings/
SETTINGS_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/settings/
PASSWORD_ENCODED_ALGORITHM	sha1
PDF_FILE_UPLOAD_DIRECTROY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/pdf/
PDF_DIRECTROY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/pdf/
SUCCESS	success
INVALID	invalid
ERROR	error
CONVERSION_CURRENCY_USD	USD
NOT_YET_AWARDED	Not Yet Awarded
RATING_FORM_FIELD_NAME	post_review_rating_

CakePHP Constants

Constant	Value
APP	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/
APP_DIR	app
APPLIBS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/Lib/
CACHE	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/tmp/cache/
CAKE	/home/demoe3/web/getezquotes.demoe3.com/public_html/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/lib
CORE_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/lib/
CAKE_VERSION	2.5.3
CSS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://www.getezquotes.demoe3.com
IMAGES	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/img/
IMAGES_URL	img/
JS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/js/
JS_URL	js/
LOGS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/tmp/logs/
ROOT	/home/demoe3/web/getezquotes.demoe3.com/public_html
TESTS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/Test/
TMP	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/tmp/
VENDORS	/home/demoe3/web/getezquotes.demoe3.com/public_html/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40-5+ubuntu14.04.1+deb.sury.org+1
Redirect Redirect Status	200
Redirect Status	200
Http Host	www.getezquotes.demoe3.com
Http X Real Ip	18.188.152.162
Http X Forwarded For	18.188.152.162
Http Connection	close
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
Server Signature
Server Software	Apache/2.4.7 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.0.1f
Server Name	www.getezquotes.demoe3.com
Server Addr	144.217.149.181
Server Port	80
Remote Addr	144.217.149.181
Document Root	/home/demoe3/web/getezquotes.demoe3.com/public_html
Request Scheme	http
Context Prefix
Context Document Root	/home/demoe3/web/getezquotes.demoe3.com/public_html
Server Admin	info@getezquotes.demoe3.com
Script Filename	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/index.php
Remote Port	33398
Redirect Url	/app/webroot/service-providers-profile/service
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/service-providers-profile/service
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1714898541.76
Request Time	1714898541

====

Include
+
Included Files

Include Paths
- 0/home/demoe3/web/getezquotes.demoe3.com/public_html/lib
- 2/usr/share/php
- 3-> /home/demoe3/web/getezquotes.demoe3.com/public_html/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/TreeBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/EmailComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/AuthComponent.php
  4CORE/Controller/Component/PaginatorComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure(array)
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  6CORE/Utility/Set.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/ValidateBehavior.php
  Component(array)
  0APP/Controller/Component/GeneralFunctionsComponent.php
  1APP/Controller/Component/GetCurrentPageComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/global_constants.php
  3APP/Config/routes.php
  4APP/Config/database.php
  Controller(array)
  0APP/Controller/AppController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Country.php
  2APP/Model/Currency.php
  3APP/Model/UserCategory.php
  4APP/Model/Category.php
  5APP/Model/QuoteType.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  Contact(array)
  Config(array)
  0Contact/Config/routes.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Other(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Panel/VariablesPanel.php
  9DebugKit/Lib/Panel/EnvironmentPanel.php
  10DebugKit/Lib/Panel/IncludePanel.php
  11DebugKit/Lib/DebugTimer.php
  Log(array)
  0DebugKit/Lib/Log/Engine/DebugKitLog.php
  Message(array)
  Config(array)
  0Message/Config/routes.php
  Project(array)
  Config(array)
  0Project/Config/routes.php
  Model(array)
  0Project/Model/Quote.php
  1Project/Model/ProjectAppModel.php
  Search(array)
  Component(array)
  0Search/Controller/Component/PrgComponent.php
  Behavior(array)
  0Search/Model/Behavior/SearchableBehavior.php
  Staticpages(array)
  Config(array)
  0Staticpages/Config/routes.php
  Model(array)
  0Staticpages/Model/StaticPage.php
  1Staticpages/Model/StaticpagesAppModel.php
  Supports(array)
  Config(array)
  0Supports/Config/routes.php
  Testimonials(array)
  Config(array)
  0Testimonials/Config/routes.php
  Users(array)
  Config(array)
  0Users/Config/routes.php
  Controller(array)
  0Users/Controller/ServiceProvidersController.php
  1Users/Controller/UsersAppController.php
  Model(array)
  0Users/Model/ServiceProvider.php
  1Users/Model/UsersAppModel.php
  2Users/Model/UserRecommendation.php
  3Users/Model/User.php
  4Users/Model/PhotosDeal.php
  5Users/Model/UserEmergencyServiceRating.php
====

Contact Us

ABOUT US

GUIDES

BROWSE

HELP

USEFUL LINKS

Our Numbers

default

Total Time: 185 ms
Total Queries: 40 queries

Query Explain:

Memory

Timers

Contact Us

ABOUT US

GUIDES

BROWSE

HELP

USEFUL LINKS

Our Numbers

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 185 ms Total Queries: 40 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 185 ms
Total Queries: 40 queries