Home

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

Cake Params
- plugin(null)
- controllerhomes
- actionindex
- named(empty)
- pass(empty)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerhomes
  actionindex
  plugin(null)
- template/
====

Sql Logs

default

Total Time: 162 ms
Total Queries: 28 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 `Testimonial`.`id`, `Testimonial`.`user_id`, `Testimonial`.`title`, `Testimonial`.`type`, `Testimonial`.`description`, `Testimonial`.`posted_by`, `Testimonial`.`designation`, `Testimonial`.`image`, `Testimonial`.`rating`, `Testimonial`.`is_apporove`, `Testimonial`.`is_active`, `Testimonial`.`created`, `Testimonial`.`modified`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`username`, `ServiceProvider`.`business_name` FROM `demoe3_getezquotes`.`testimonials` AS `Testimonial` LEFT JOIN `demoe3_getezquotes`.`users` AS `ServiceProvider` ON (`Testimonial`.`user_id` = `ServiceProvider`.`id`) WHERE `Testimonial`.`type` = 'website' AND `is_active` = 1 AND `is_apporove` = 1 ORDER BY RAND() ASC LIMIT 20	11	11	1	maybe slow
SELECT `SliderCountry`.`id`, `SliderCountry`.`slider_id` FROM `demoe3_getezquotes`.`slider_countries` AS `SliderCountry` WHERE `country_id` = 2	13	13	23	maybe slow
SELECT `Sliderimage`.`id`, `Sliderimage`.`image`, `Sliderimage`.`title`, `Sliderimage`.`slider_order`, `Sliderimage`.`is_active`, `Sliderimage`.`created`, `Sliderimage`.`modified` FROM `demoe3_getezquotes`.`sliderimages` AS `Sliderimage` WHERE `is_active` = 1 AND `id` IN (8, 10, 9, 7, 5, 1, 2, 4, 12, 6, 11, 3, 13) ORDER BY `slider_order` desc	11	11	17	maybe slow
SELECT COUNT(*) AS `count` 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_purchased_plans where `user_purchased_plans`.`user_id` = `ServiceProvider`.`id` AND (`user_purchased_plans`.`status` = 'completed' OR `user_purchased_plans`.`status` IN ('pending','expired')) ORDER BY `user_purchased_plans`.`created` DESC limit 1) = 'completed'	1	1	53	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 `Project`.`country_id` = 2	1	1	0
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 `Project`.`country_id` = 2 AND `Quote`.`quote_status` = 1	1	1	0
SELECT `QuoteType`.`id`, `QuoteType`.`name`, `QuoteType`.`description`, `QuoteType`.`slug`, `QuoteType`.`status`, `QuoteType`.`show_in_list`, `QuoteType`.`created`, `QuoteType`.`modified` FROM `demoe3_getezquotes`.`quote_types` AS `QuoteType` WHERE `status` = 1	5	5	12	maybe slow
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 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 COUNT(id) from user_deals where psps_photos_deal_id = `PhotosDeal`.`id`) AS `PhotosDeal__user_deal_count`, (select status from user_current_plans where `user_current_plans`.`user_id` = `User`.`id` AND is_expired = 0 ORDER BY `user_current_plans`.`created` DESC limit 1) AS `PhotosDeal__plan_status`, `User`.`user_type`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`business_name`, `Category`.`name` 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`.`is_deleted` = 0 AND `PhotosDeal`.`deal_status` = 'accepted' AND `PhotosDeal`.`is_deal` = 1 AND `PhotosDeal`.`expiry_date` >= 1734845872 AND `PhotosDeal`.`country_id` = 2 AND (select status from user_current_plans where `user_current_plans`.`user_id` = `User`.`id` AND is_expired = 0 ORDER BY `user_current_plans`.`created` DESC limit 1) != '' ORDER BY `PhotosDeal`.`view_count` DESC LIMIT 3	0	0	1	maybe slow
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 `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(`user_purchased_offers`.`id`) FROM user_purchased_offers WHERE `user_purchased_offers`.`payment_status` IN ('completed','pending') AND `user_purchased_offers`.`psps_photos_deal_id` = `PhotosDeal`.`id`) AS `PhotosDeal__offer_purchased_count`, (select status from user_current_plans where `user_current_plans`.`user_id` = `User`.`id` AND is_expired = 0 ORDER BY `user_current_plans`.`created` DESC limit 1) AS `PhotosDeal__plan_status`, (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`.`user_type`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`business_name`, `Category`.`name` 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`.`is_deleted` = 0 AND `PhotosDeal`.`offer_status` = 'accepted' AND `PhotosDeal`.`is_offer` = 1 AND `PhotosDeal`.`country_id` = 2 AND `PhotosDeal`.`expiry_date` >= 1734845872 AND (select status from user_current_plans where `user_current_plans`.`user_id` = `User`.`id` AND is_expired = 0 ORDER BY `user_current_plans`.`created` DESC limit 1) != '' AND `PhotosDeal`.`maximum_offers` > `PhotosDeal`.`total_sold` ORDER BY `PhotosDeal`.`view_count` DESC	0	0	1	maybe slow
SELECT `QuoteType`.`id`, `QuoteType`.`name` FROM `demoe3_getezquotes`.`quote_types` AS `QuoteType` WHERE `status` = 1	5	5	0
SELECT `ServiceProvider`.`logo`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`username`, `ServiceProvider`.`business_name`, `ServiceProvider`.`psps_rating`, (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 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` 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)) ORDER BY `is_psps` desc, (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) desc, `created` desc LIMIT 3	3	3	1	maybe slow
SELECT `BannerPosition`.`id`, `BannerPosition`.`page_slug`, `BannerPosition`.`page_name`, `BannerPosition`.`allow_category`, `BannerPosition`.`is_random`, `BannerPosition`.`banner_type`, `BannerPosition`.`no_of_banners`, `BannerPosition`.`banner_order`, `BannerPosition`.`time_interval`, `BannerPosition`.`banner_width`, `BannerPosition`.`banner_height`, `BannerPosition`.`banner_position_image`, `BannerPosition`.`created`, `BannerPosition`.`modified` FROM `demoe3_getezquotes`.`banner_positions` AS `BannerPosition` WHERE `BannerPosition`.`page_slug` = 'home' LIMIT 1	1	1	0
SELECT `Banner`.`id`, `Banner`.`user_id`, `Banner`.`user_purchased_banner_package_id`, `Banner`.`banner_position_package_id`, `Banner`.`title`, `Banner`.`banner_type`, `Banner`.`link`, `Banner`.`advertiser_name`, `Banner`.`banner_position_id`, `Banner`.`category_id`, `Banner`.`banner_price`, `Banner`.`image`, `Banner`.`start_date`, `Banner`.`end_date`, `Banner`.`unix_start_date`, `Banner`.`unix_end_date`, `Banner`.`actual_end_date`, `Banner`.`duration`, `Banner`.`duration_unit`, `Banner`.`payment_status`, `Banner`.`banner_status`, `Banner`.`is_active`, `Banner`.`is_admin_approved`, `Banner`.`is_deleted`, `Banner`.`reason`, `Banner`.`created`, `Banner`.`modified` FROM `demoe3_getezquotes`.`banners` AS `Banner` WHERE `Banner`.`banner_position_id` = 1 AND `Banner`.`start_date` <= 1734845872 AND `Banner`.`end_date` > 1734845872 AND `Banner`.`is_admin_approved` = 1 AND `Banner`.`is_active` = 1 AND `Banner`.`banner_type` = 'static_banner' AND `Banner`.`payment_status` = 'completed' ORDER BY rand() ASC, `Banner`.`Created` DESC	0	0	0
SELECT `ProjectOwner`.`first_name`, `ProjectOwner`.`last_name`, `ProjectOwner`.`profile_image`, `Project`.`name`, `Project`.`slug`, `Project`.`category_id`, `ServiceProvider`.`id`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`business_name`, `ServiceProvider`.`username`, `Quote`.`award_date`, (SELECT is_expired FROM user_current_plans where `user_current_plans`.`user_id` = `Quote`.`psps_id` AND `user_current_plans`.`status` = "completed" ) AS `Quote__current_plan`, (SELECT name FROM countries where id = `ProjectOwner`.`country_id` ) AS `Quote__country`, (SELECT name FROM categories where id = (SELECT parent_id FROM categories where id = Project. category_id)) AS `Quote__category`, (SELECT parent_id FROM categories where id = `Quote`.`project_category_id` ) AS `Quote__parent_category` 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`.`quote_status` = 1 AND (SELECT is_expired FROM user_current_plans where `user_current_plans`.`user_id` = `Quote`.`psps_id` AND `user_current_plans`.`status` = "completed" ) = 0 AND `Project`.`country_id` = 2 AND `Project`.`project_type` = 'fixed_rate' AND `Quote`.`award_date` >= 1734238800 ORDER BY `Quote`.`award_date` DESC LIMIT 10	0	0	18	maybe slow
SELECT `Project`.`name`, `Project`.`slug`, `User`.`first_name`, `User`.`last_name`, `User`.`profile_image`, `Project`.`created`, `Project`.`city_name`, (SELECT name FROM countries where id = `Project`.`country_id` ) AS `Project__country`, (SELECT name FROM categories where id = (SELECT parent_id FROM categories where id = Project. category_id)) AS `Project__category` FROM `demoe3_getezquotes`.`projects` AS `Project` LEFT JOIN `demoe3_getezquotes`.`countries` AS `Country` ON (`Project`.`country_id` = `Country`.`id`) LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`Project`.`category_id` = `Category`.`id`) LEFT JOIN `demoe3_getezquotes`.`quote_types` AS `QuoteType` ON (`Project`.`quote_type` = `QuoteType`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE `Project`.`country_id` = 2 AND `Project`.`created` >= 1734238800 AND `Project`.`status` = 1 AND `Project`.`is_admin_approved` = 1 AND `Project`.`is_posted` = 1 AND `Project`.`is_deleted` = 0 AND `Project`.`running_status` = 0 AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0 ORDER BY `Project`.`created` DESC LIMIT 10	0	0	1	maybe slow
SELECT `Project`.`name`, `Project`.`slug`, `User`.`first_name`, `User`.`last_name`, `User`.`profile_image`, `Project`.`created`, `Quote`.`psps_id`, `Quote`.`total_cost`, `Quote`.`currency_code`, `Project`.`city_name`, `Project`.`running_status`, `Project`.`completed_date` FROM `demoe3_getezquotes`.`projects` AS `Project` LEFT JOIN `demoe3_getezquotes`.`countries` AS `Country` ON (`Project`.`country_id` = `Country`.`id`) LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`Project`.`category_id` = `Category`.`id`) LEFT JOIN `demoe3_getezquotes`.`quote_types` AS `QuoteType` ON (`Project`.`quote_type` = `QuoteType`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`Project`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_getezquotes`.`project_quotes` AS `Quote` ON (`Quote`.`project_id` = `Project`.`id` AND `Project`.`id` = `Quote`.`project_id` AND `Quote`.`quote_status` = 1) WHERE `Project`.`country_id` = 2 AND `Project`.`created` >= 1734238800 AND `Project`.`status` = 1 AND `Project`.`is_admin_approved` = 1 AND `Project`.`is_posted` = 1 AND `Project`.`is_deleted` = 0 AND `Project`.`running_status` = 4 AND `Project`.`project_type` = 'fixed_rate' AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0 ORDER BY `Project`.`created` DESC LIMIT 10	0	0	1	maybe slow
SELECT `User`.`first_name`, `User`.`profile_image`, `ServiceProvider`.`last_name`, `ServiceProvider`.`first_name`, `ServiceProvider`.`business_name`, `ServiceProvider`.`username`, `User`.`last_name`, `UserRecommendation`.`verification_date`, `UserRecommendation`.`recommandation_category`, (SELECT name FROM countries where id = `User`.`country_id` ) AS `UserRecommendation__country`, (SELECT is_expired FROM user_current_plans where `user_current_plans`.`user_id` = `UserRecommendation`.`service_provider_id` AND `user_current_plans`.`status` = "completed") AS `UserRecommendation__current_plan` 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`) WHERE `UserRecommendation`.`verification_date` >= 1734238800 AND `UserRecommendation`.`status` = 1 AND `UserRecommendation`.`is_verified` = 1 AND `UserRecommendation`.`is_approved` = 1 AND (SELECT is_expired FROM user_current_plans where `user_current_plans`.`user_id` = `UserRecommendation`.`service_provider_id` AND `user_current_plans`.`status` = "completed") = 0 ORDER BY `UserRecommendation`.`verification_date` DESC LIMIT 10	0	0	31	maybe slow
SELECT `UserReview`.`id`, `UserReview`.`parent_id`, `UserReview`.`user_id`, `UserReview`.`service_provider_id`, `UserReview`.`project_id`, `UserReview`.`project_quote_id`, `UserReview`.`category_id`, `UserReview`.`project_amount`, `UserReview`.`work_completed_date`, `UserReview`.`project_hire_status`, `UserReview`.`project_recommendation`, `UserReview`.`review`, `UserReview`.`overall_rating`, `UserReview`.`review_reply_by`, `UserReview`.`review_for`, `UserReview`.`status`, `UserReview`.`total_like_count`, `UserReview`.`total_unlike_count`, `UserReview`.`approval_date`, `UserReview`.`is_active`, `UserReview`.`is_deleted`, `UserReview`.`created`, `UserReview`.`modified`, (SELECT is_expired FROM user_current_plans where `user_current_plans`.`user_id` = `UserReview`.`service_provider_id` AND `user_current_plans`.`status` = "completed") AS `UserReview__current_plan`, `Project`.`name`, `Project`.`slug`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`username`, `ServiceProvider`.`business_name`, `User`.`first_name`, `User`.`last_name`, `User`.`country_id` FROM `demoe3_getezquotes`.`user_reviews` AS `UserReview` LEFT JOIN `demoe3_getezquotes`.`projects` AS `Project` ON (`UserReview`.`project_id` = `Project`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ServiceProvider` ON (`UserReview`.`service_provider_id` = `ServiceProvider`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`UserReview`.`user_id` = `User`.`id`) WHERE `UserReview`.`status` = 1 AND `UserReview`.`overall_rating` >= 7 AND `Project`.`is_posted` = 1 AND `Project`.`is_deleted` = 0 AND `Project`.`running_status` = 4 AND (SELECT is_expired FROM user_current_plans where `user_current_plans`.`user_id` = `UserReview`.`service_provider_id` AND `user_current_plans`.`status` = "completed") = 0 ORDER BY `UserReview`.`created` DESC LIMIT 10	0	0	1	maybe slow
SELECT `PspsFavorite`.`id`, `PspsFavorite`.`user_id`, `PspsFavorite`.`service_provider_id`, `PspsFavorite`.`created`, `PspsFavorite`.`modified`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`username`, `ServiceProvider`.`business_name`, `User`.`first_name`, `User`.`last_name`, `User`.`country_id`, `UserCurrentPlan`.`status` FROM `demoe3_getezquotes`.`psps_favorites` AS `PspsFavorite` LEFT JOIN `demoe3_getezquotes`.`users` AS `ServiceProvider` ON (`PspsFavorite`.`service_provider_id` = `ServiceProvider`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`PspsFavorite`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_getezquotes`.`user_current_plans` AS `UserCurrentPlan` ON (`PspsFavorite`.`service_provider_id`=`UserCurrentPlan`.`user_id` AND `UserCurrentPlan`.`status` = "completed" AND `UserCurrentPlan`.`is_expired` = 0) WHERE `UserCurrentPlan`.`status` = 'completed' ORDER BY `PspsFavorite`.`created` DESC LIMIT 10	0	0	1	maybe slow
SELECT `Block`.`page_slug`, `Block`.`block_slug`, `Block`.`description` FROM `demoe3_getezquotes`.`blocks` AS `Block` WHERE `Block`.`page_slug` = 'Post-Project' AND `Block`.`block_slug` = 'post-project' LIMIT 1	1	1	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` LEFT JOIN `demoe3_getezquotes`.`user_groups` AS `UserGroup` ON (`User`.`user_group_id` = `UserGroup`.`id`) 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` LEFT JOIN `demoe3_getezquotes`.`user_groups` AS `UserGroup` ON (`User`.`user_group_id` = `UserGroup`.`id`) 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 22.86 MB

Message	Memory use
Component initialization	8.22 MB
Controller action start	9.13 MB
Controller render start	11.48 MB
View render complete	15.28 MB

Timers

Total Request Time: 877 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	215.21
Event: Controller.initialize	78.90
Event: Controller.startup	2.80
Controller action	257.62
Event: Controller.beforeRender	30.20
» Processing toolbar data	29.87
Rendering View	202.68
» Event: View.beforeRender	0.04
» Rendering APP/View/Homes/index.ctp	153.93
» » Rendering APP/View/Elements/Banners/home_banners.ctp	7.95
» » » Rendering APP/View/Elements/Banners/single_banner.ctp	7.58
» » Rendering APP/Plugin/Users/View/Elements/PhotosDeals/home_page_deals.ctp	0.36
» » Rendering APP/View/Elements/Banners/success_story.ctp	0.99
» » Rendering APP/View/Elements/latest_activity.ctp	110.34
» » Rendering APP/View/Elements/testimonial_slider.ctp	2.72
» » Rendering APP/View/Elements/PageBlockPopup/quote_type_hint_popup.ctp	3.15
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/home.ctp	47.37
» » Rendering APP/View/Elements/header_js.ctp	1.64
» » Rendering APP/View/Elements/header.ctp	10.21
» » Rendering APP/View/Elements/footer.ctp	33.08
» » » Rendering APP/View/Elements/city_search_popup_psps.ctp	3.96
» » Rendering APP/View/Elements/footer_js.ctp	1.16
» » » Rendering APP/View/Elements/user_time_out_popup.ctp	0.75
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- third_blog(array)
  0(array)
  titlePost
  contentLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
  dateSeptember 22, 2017
  linkhttp://getezquotes.demoe3.com/blog/post/
  thumbnailhttp://getezquotes.demoe3.com/blog/wp-content/uploads/2017/09/Chrysanthemum.jpg
  meta_keyservice_provider_name
  meta_valueGetEZQuotes Admin
  post_views_count_value11
- second_blog(array)
  0(array)
  titlePost1
  contentLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
  dateDecember 14, 2017
  linkhttp://getezquotes.demoe3.com/blog/post1/
  thumbnailhttp://getezquotes.demoe3.com/blog/wp-content/uploads/2017/09/Chrysanthemum.jpg
  meta_keyservice_provider_name
  meta_valueGetEZQuotes Admin
  post_views_count_value9
- first_blog(array)
  0(array)
  titlePost 3
  contentLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
  dateDecember 14, 2017
  linkhttp://getezquotes.demoe3.com/blog/post-3/
  thumbnailhttp://getezquotes.demoe3.com/blog/wp-content/uploads/2015/09/slider_img.jpg
  meta_keyservice_provider_name
  meta_valueGetEZQuotes Admin
  post_views_count_value48
- blog_posts(array)
  0(array)
  titlePost 3
  contentLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
  meta_keyservice_provider_name
  meta_valueGetEZQuotes Admin
  post_views_count_value48
  dateDecember 14, 2017
  linkhttp://getezquotes.demoe3.com/blog/post-3/
  thumbnailhttp://getezquotes.demoe3.com/blog/wp-content/uploads/2015/09/slider_img.jpg
  1(array)
  titlePost1
  contentLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
  meta_keyservice_provider_name
  meta_valueGetEZQuotes Admin
  post_views_count_value9
  dateDecember 14, 2017
  linkhttp://getezquotes.demoe3.com/blog/post1/
  thumbnailhttp://getezquotes.demoe3.com/blog/wp-content/uploads/2017/09/Chrysanthemum.jpg
  2(array)
  titlePost
  contentLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
  meta_keyservice_provider_name
  meta_valueGetEZQuotes Admin
  post_views_count_value11
  dateSeptember 22, 2017
  linkhttp://getezquotes.demoe3.com/blog/post/
  thumbnailhttp://getezquotes.demoe3.com/blog/wp-content/uploads/2017/09/Chrysanthemum.jpg
- fb_page_like0
- third_offers(empty)
- second_offers(empty)
- first_offers(empty)
- result(empty)
- slug
- quotetype(array)
  0(array)
  QuoteType(array)
  id1
  nameFull Cost Quote
  descriptionThis is the total amount that it will cost to get the project done.
  slugfull-cost-quote
  status1
  show_in_list1
  created1426582395
  modified1435844738
  1(array)
  QuoteType(array)
  id2
  nameLabour + Materials + Equipment Quote
  descriptionThis is the total amount that it will cost to get the project done but broken down into cost categories.Used in construction, home owner projects & any general project you wish to manage yourself.
  sluglabour-materials-equipment-quote
  status1
  show_in_list1
  created1426582418
  modified1435844743
  2(array)
  QuoteType(array)
  id3
  nameSet Service Quote
  descriptionThis is the cost of performing a specific service. Mainly used by professional service firms such as lawyers, real estate agents, accountants, corporate service providers and consultants.
  slugset-service-quote
  status1
  show_in_list1
  created1426582591
  modified1426582591
  3(array)
  QuoteType(array)
  id4
  nameVariable Range Quote
  descriptionAll quotes cannot be calculated with 100% certainty so a range is provided. The approximate cost to complete a project will be between the low end and the high end range in this quote. This quote is used by lawyers, real estate agents, contractor, consultants and many more service providers when there is uncertainty.
  slugvariable-range-quote
  status1
  show_in_list1
  created1426582611
  modified1426582611
  4(array)
  QuoteType(array)
  id5
  nameHourly Rate Quote
  descriptionWe do not allow hourly rate quotes because pricing is not restricted to a maximum amount. Our aim is to help consumers save money. We do, however, allow consumers to request that service providers include an hourly rate when posting a project.
  slughourly-rate-quote
  status1
  show_in_list0
  created1426582611
  modified1567598943
- sliderimage(array)
  0(array)
  Sliderimage(array)
  id12
  imageslider_image_3058092271448440751.jpg
  titleGet FREE Quotes From Local Corporate Service Providers Ready For Your Job
  slider_order11
  is_active1
  created1448440751
  modified1448440751
  1(array)
  Sliderimage(array)
  id11
  imageslider_image_5795163401446198008.jpg
  titleGet FREE Quotes From Local Contractors & Tradesmen Ready For Your Job
  slider_order10
  is_active1
  created1438472483
  modified1456778483
  2(array)
  Sliderimage(array)
  id10
  imageslider_image_5030724781446025094.jpg
  titleGet FREE Quotes From Local Corporate Service Providers Ready For Your Job
  slider_order9
  is_active1
  created1438472459
  modified1446025094
  3(array)
  Sliderimage(array)
  id9
  imageslider_image_1992327651446025103.jpg
  titleGet FREE Quotes From Local Corporate Service Providers Ready For Your Job
  slider_order8
  is_active1
  created1438472425
  modified1446025103
  4(array)
  Sliderimage(array)
  id7
  imageslider_image_6626266801446106560.jpg
  titleGet FREE Quotes From Local Corporate Service Providers Ready For Your Job
  slider_order7
  is_active1
  created1438471876
  modified1446106560
  5(array)
  Sliderimage(array)
  id6
  imageslider_image_5795163401446198029.jpg
  titleGet FREE Quotes From Local Contractors Ready For Your Job
  slider_order6
  is_active1
  created1438471641
  modified1454901769
  6(array)
  Sliderimage(array)
  id5
  imageslider_image_6488189911446106567.jpg
  titleGet FREE Quotes From Local Contractors s Ready For Your Job
  slider_order5
  is_active1
  created1438471529
  modified1446106567
  7(array)
  Sliderimage(array)
  id4
  imageslider_image_6759214561448440593.jpg
  titleGet FREE Quotes From Local Corporate Service Providers Ready For Your Job
  slider_order4
  is_active1
  created1434087941
  modified1448440649
  8(array)
  Sliderimage(array)
  id3
  imageslider_image_353048781448440537.jpg
  titleGet FREE Quotes From Local Lawyers Ready For Your Job
  slider_order3
  is_active1
  created1434087877
  modified1461222742
  9(array)
  Sliderimage(array)
  id2
  imageslider_image_3454363791448440515.jpg
  titleGet FREE Quotes From Local Businesses Ready For Your Job
  slider_order2
  is_active1
  created1434087819
  modified1448440629
  10(array)
  Sliderimage(array)
  id1
  imageslider_image_4702428041448440436.jpg
  titleGet FREE Quotes From Local Businesses Ready For Your Job
  slider_order1
  is_active1
  created1434087780
  modified1448440619
- testimonials(array)
  0(array)
  Testimonial(array)
  id9
  user_id3
  titleNew Testimonial
  typewebsite
  descriptionLorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam
  posted_bydemo1 demoe3
  designationOwner, Sheena Consulting
  imagetestimonial_image_3835244941438756190.jpg
  rating4
  is_apporove1
  is_active1
  created1438756190
  modified1440155061
  ServiceProvider(array)
  first_nameDemo
  last_nameTwo
  usernamedemo2
  business_nameDemo2 Business
  1(array)
  Testimonial(array)
  id1
  user_id0
  titleVery Needed
  typewebsite
  descriptionAwesome Service...fast quotes and best of all it's free.
  posted_byDylan
  designationWebsite User
  imagetestimonial_image_4508961411434154876.jpg
  rating4
  is_apporove1
  is_active1
  created1434154876
  modified1440154022
  ServiceProvider(array)
  first_name(null)
  last_name(null)
  username(null)
  business_name(null)
  2(array)
  Testimonial(array)
  id13
  user_id9
  titleVery needed service
  typewebsite
  descriptionBest thing since the Internet.
  posted_byRyan Haylock
  designationRyan Haylock
  imagetestimonial_image_9509734461497416431.jpg
  rating5
  is_apporove1
  is_active1
  created1497416431
  modified1497416431
  ServiceProvider(array)
  first_nameDemo
  last_nameThree
  usernamedemo
  business_nameDemo Three Bussiness
  3(array)
  Testimonial(array)
  id14
  user_id5
  titleTest for the update
  typewebsite
  descriptiontest
  posted_bydemo4 demo4
  designationProject Owner
  imagetestimonial_image_6001423671505479027.png
  rating4
  is_apporove1
  is_active1
  created1505479027
  modified1505479027
  ServiceProvider(array)
  first_nameAlex
  last_nameHaylock
  usernamemikel
  business_name(null)
  4(array)
  Testimonial(array)
  id15
  user_id10
  titledddddd
  typewebsite
  descriptionwe erewqqtqtttt
  posted_byryan haylock
  designationHomeowner
  imagetestimonial_image_4303154271506655252.jpg
  rating5
  is_apporove1
  is_active1
  created1506655252
  modified1506655252
  ServiceProvider(array)
  first_nameDemo
  last_nameFour
  usernamedemofour
  business_nameDemo Four Bussiness
  5(array)
  Testimonial(array)
  id7
  user_id0
  titleWord of Mouth Referral is awesome
  typewebsite
  descriptionReally never thought a referral site like GetEZQuotes would be for my type of industry, but I have been completely proved wrong. At this point, GetEZQuotes is one of the highest referring sources for our business.
  posted_byPatrick Idle
  designationBalps Legal Services
  imagetestimonial_image_8293409831435745466.jpg
  rating5
  is_apporove1
  is_active1
  created1435745466
  modified1440154183
  ServiceProvider(array)
  first_name(null)
  last_name(null)
  username(null)
  business_name(null)
  6(array)
  Testimonial(array)
  id8
  user_id0
  titlemy matrimonial
  typewebsite
  descriptiona written declaration certifying to a person's character, conduct,
  posted_bypravesh
  designationtester
  imagetestimonial_image_2479544601438781185.jpeg
  rating5
  is_apporove1
  is_active1
  created1436276295
  modified1440154030
  ServiceProvider(array)
  first_name(null)
  last_name(null)
  username(null)
  business_name(null)
  7(array)
  Testimonial(array)
  id11
  user_id3
  titleThis is nice website ...
  typewebsite
  descriptionLorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.
  posted_bydemo1 demoe3
  designationHome owner
  imagetestimonial_image_2825601991440155390.jpg
  rating4
  is_apporove1
  is_active1
  created1440155390
  modified1440155390
  ServiceProvider(array)
  first_nameDemo
  last_nameTwo
  usernamedemo2
  business_nameDemo2 Business
  8(array)
  Testimonial(array)
  id3
  user_id0
  titleHighly Needed
  typewebsite
  descriptionSave money on advertising get quality insurance leads direct to your inbox.
  posted_byJason
  designationInsurance Agent
  imagetestimonial_image_4676120841434155157.jpg
  rating1
  is_apporove1
  is_active1
  created1434155157
  modified1440154043
  ServiceProvider(array)
  first_name(null)
  last_name(null)
  username(null)
  business_name(null)
  9(array)
  Testimonial(array)
  id2
  user_id0
  titleWicked Quotes
  typewebsite
  descriptionLove this Service...leads to my inbox...good for my business
  posted_bySheena
  designationOwner, Sheena Consulting
  imagetestimonial_image_1979501531434155041.jpg
  rating3
  is_apporove1
  is_active1
  created1434155041
  modified1440154030
  ServiceProvider(array)
  first_name(null)
  last_name(null)
  username(null)
  business_name(null)
  10(array)
  Testimonial(array)
  id12
  user_id9
  titleI am pleasantly surprised by this service
  typewebsite
  descriptionI was rushed for time and needed my project done fast. I however, did not know service providers or who to trust. I entered my project details and wow...service providers came by within hours. Getezquotes saved the day.
  posted_byRyan Haylock
  designationHomewoner
  imagetestimonial_image_922815191440181192.jpg
  rating3
  is_apporove1
  is_active1
  created1440181192
  modified1440181192
  ServiceProvider(array)
  first_nameDemo
  last_nameThree
  usernamedemo
  business_nameDemo Three Bussiness
- number_of_awarded2
- number_of_quote2
- number_of_bussness2
- title_for_layoutHome
- pageTitleHome
- modelNewsletterSubscriber
- allNotifications0
- $request->data(empty)
- $this->validationErrors(array)
  StaticPage(empty)
  Country(empty)
  CurrencyCountry(empty)
  Currency(empty)
  Notification(empty)
  SliderCountry(empty)
  Sliderimage(empty)
  PhotosDeal(empty)
  Testimonial(empty)
  ServiceProvider(empty)
  Quote(empty)
  Project(empty)
  ProjectOwner(empty)
  QuoteType(empty)
  User(empty)
  Category(empty)
- Loaded Helpers(array)
  0Number
  1SimpleGraph
  2DebugTimer
  3Toolbar
  4GeneralFunctions
  5Html
  6Form
  7Session
  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://getezquotes.demoe3.com/
SET_COOKIE_TIME	2592000
HOST_URL	getezquotes.demoe3.com
WEBSITE_ADMIN_URL	http://getezquotes.demoe3.com/admin/
WEBSITE_IMG_URL	http://getezquotes.demoe3.com/img/
WEBSITE_ADMIN_IMG_URL	http://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://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	1734241071
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://getezquotes.demoe3.com/stuff/
ONTHEFLY_IMAGE_ROOT_PATH	stuff/
CATEGORY_IMAGE_URL	http://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://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://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://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://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://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://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://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://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://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://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://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://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://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://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://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://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://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://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://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://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 Status	200
Http Host	getezquotes.demoe3.com
Http X Real Ip	18.224.54.118
Http X Forwarded For	18.224.54.118
Http Connection	close
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
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	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	44300
Redirect Url	/index.php
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1734845871.966
Request Time	1734845871

====

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
  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
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/ValidateBehavior.php
  Component(array)
  0APP/Controller/Component/MathCaptchaComponent.php
  1APP/Controller/Component/GeneralFunctionsComponent.php
  2APP/Controller/Component/WordpressComponent.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/HomesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Country.php
  2APP/Model/Currency.php
  3APP/Model/QuoteType.php
  4APP/Model/Category.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
  2Project/Model/Project.php
  Search(array)
  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
  Model(array)
  0Testimonials/Model/Testimonial.php
  1Testimonials/Model/TestimonialsAppModel.php
  Users(array)
  Config(array)
  0Users/Config/routes.php
  Model(array)
  0Users/Model/PhotosDeal.php
  1Users/Model/UsersAppModel.php
  2Users/Model/User.php
====

How it works

Post Your Project

Featured Service Providers

Success Stories

Post 3

Post1

Post

Latest Activity

GETEZQUOTES Testimonials

Contact Us

ABOUT US

GUIDES

BROWSE

HELP

USEFUL LINKS

Our Numbers

default

Total Time: 162 ms
Total Queries: 28 queries

Query Explain:

Memory

Timers

How it works

Post Your Project

Featured Service Providers

Success Stories

Post 3

Post1

Post

Latest Activity

GETEZQUOTES Testimonials

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: 162 ms Total Queries: 28 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 162 ms
Total Queries: 28 queries