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 `Project`.`category_id`, `Project`.`slug`, `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `demoe3_getezquotes`.`projects` AS `Project` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`Project`.`category_id` = `Category`.`id`) WHERE `Project`.`running_status` = 4 GROUP BY `Project`.`category_id` | 3 | 3 | 1 | maybe slow |
SELECT `ProjectManagementRequestService`.`id`, `ProjectManagementRequestService`.`project_management_request_id`, `ProjectManagementRequestService`.`project_id`, `ProjectManagementRequestService`.`title`, `ProjectManagementRequestService`.`description`, `ProjectManagementRequestService`.`photo`, `ProjectManagementRequestService`.`created`, `ProjectManagementRequestService`.`modified`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`slug`, `Project`.`country_id`, `Project`.`postal_code`, `Project`.`city_name`, `Project`.`city_id`, `Project`.`project_type`, `Project`.`category_id`, `Project`.`quote_type`, `Project`.`due_date`, `Project`.`anticipated_start_date`, `Project`.`project_acceptance_due_date`, `Project`.`start_date`, `Project`.`award_date`, `Project`.`expiry_date`, `Project`.`close_date`, `Project`.`estimated_date`, `Project`.`completed_date`, `Project`.`canceled_date`, `Project`.`decline_date`, `Project`.`job_start`, `Project`.`project_documents_link`, `Project`.`description`, `Project`.`attachments_file_name`, `Project`.`attachments`, `Project`.`level_of_urgency`, `Project`.`meeting`, `Project`.`meet_day`, `Project`.`business_contact`, `Project`.`contact_specific_time`, `Project`.`contact_time`, `Project`.`show_contact_info`, `Project`.`show_name`, `Project`.`alias_name`, `Project`.`is_admin_approved`, `Project`.`posted_on`, `Project`.`approval_date`, `Project`.`status`, `Project`.`is_deleted`, `Project`.`deleted_date`, `Project`.`is_posted`, `Project`.`running_status`, `Project`.`decline_reason`, `Project`.`created`, `Project`.`modified`, `Project`.`project_status_question`, `Project`.`additional_information`, `Project`.`project_need_financing`, `Project`.`project_need_require_doc`, `Project`.`financing_type`, `Project`.`hourly_rate_applied`, `Project`.`hourly_rate_charges`, `Project`.`need_hire_project_manager`, `Project`.`actual_completion_cost`, `Project`.`last_date_request_additional_info`, `Project`.`currency_code`, `Project`.`conversion_currency_code`, `Project`.`conversion_currency_exchange_rate`, `Project`.`action_performed_by`, `Project`.`rebid_reminder_before_24`, `ProjectManagementRequest`.`id`, `ProjectManagementRequest`.`project_id`, `ProjectManagementRequest`.`user_id`, `ProjectManagementRequest`.`project_coordinator_id`, `ProjectManagementRequest`.`city_postal`, `ProjectManagementRequest`.`start_project`, `ProjectManagementRequest`.`project_needs`, `ProjectManagementRequest`.`local_currency_code`, `ProjectManagementRequest`.`budget`, `ProjectManagementRequest`.`contact_number`, `ProjectManagementRequest`.`status`, `ProjectManagementRequest`.`category_id`, `ProjectManagementRequest`.`pm_rate_per_hour`, `ProjectManagementRequest`.`pm_hours_in_progress`, `ProjectManagementRequest`.`pm_hours_at_completion`, `ProjectManagementRequest`.`pm_hours_at_termination`, `ProjectManagementRequest`.`reason`, `ProjectManagementRequest`.`terminated_reason`, `ProjectManagementRequest`.`date_of_inprogress`, `ProjectManagementRequest`.`date_of_completion`, `ProjectManagementRequest`.`date_of_termination`, `ProjectManagementRequest`.`is_deleted`, `ProjectManagementRequest`.`featured_on_list`, `ProjectManagementRequest`.`created`, `ProjectManagementRequest`.`modified` FROM `demoe3_getezquotes`.`project_management_request_services` AS `ProjectManagementRequestService` LEFT JOIN `demoe3_getezquotes`.`projects` AS `Project` ON (`ProjectManagementRequestService`.`project_id` = `Project`.`id`) LEFT JOIN `demoe3_getezquotes`.`project_management_requests` AS `ProjectManagementRequest` ON (`ProjectManagementRequestService`.`project_management_request_id` = `ProjectManagementRequest`.`id`) WHERE ((`ProjectManagementRequest`.`featured_on_list` = 1) AND (`ProjectManagementRequest`.`is_deleted` = 0) AND (`ProjectManagementRequest`.`project_id` IS NOT NULL) AND (`ProjectManagementRequest`.`status` IN (2, 1)) AND (`Project`.`running_status` IN (4, 3))) ORDER BY `ProjectManagementRequestService`.`created` DESC LIMIT 30 | 0 | 0 | 7 | maybe slow |
SELECT `ProjectManagementRequest`.`id`, `ProjectManagementRequest`.`project_id`, `ProjectManagementRequest`.`user_id`, `ProjectManagementRequest`.`project_coordinator_id`, `ProjectManagementRequest`.`city_postal`, `ProjectManagementRequest`.`start_project`, `ProjectManagementRequest`.`project_needs`, `ProjectManagementRequest`.`local_currency_code`, `ProjectManagementRequest`.`budget`, `ProjectManagementRequest`.`contact_number`, `ProjectManagementRequest`.`status`, `ProjectManagementRequest`.`category_id`, `ProjectManagementRequest`.`pm_rate_per_hour`, `ProjectManagementRequest`.`pm_hours_in_progress`, `ProjectManagementRequest`.`pm_hours_at_completion`, `ProjectManagementRequest`.`pm_hours_at_termination`, `ProjectManagementRequest`.`reason`, `ProjectManagementRequest`.`terminated_reason`, `ProjectManagementRequest`.`date_of_inprogress`, `ProjectManagementRequest`.`date_of_completion`, `ProjectManagementRequest`.`date_of_termination`, `ProjectManagementRequest`.`is_deleted`, `ProjectManagementRequest`.`featured_on_list`, `ProjectManagementRequest`.`created`, `ProjectManagementRequest`.`modified`, (select ROUND(`user_reviews`.`overall_rating`) from user_reviews where `user_reviews`.`project_id` = `ProjectManagementRequest`.`project_id` AND `user_reviews`.`is_deleted` = 0 AND `user_reviews`.`is_active` = 1 AND `user_reviews`.`status` = 1 AND `user_reviews`.`parent_id` = 0 AND review_for = "coordinator" limit 1) AS `ProjectManagementRequest__coordinator_rating`, `Project`.`name`, `Project`.`running_status`, `Project`.`slug`, `Category`.`name` FROM `demoe3_getezquotes`.`project_management_requests` AS `ProjectManagementRequest` LEFT JOIN `demoe3_getezquotes`.`projects` AS `Project` ON (`ProjectManagementRequest`.`project_id` = `Project`.`id`) LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`ProjectManagementRequest`.`category_id` = `Category`.`id`) WHERE `ProjectManagementRequest`.`is_deleted` = 0 AND `ProjectManagementRequest`.`status` IN (2, 1) AND `ProjectManagementRequest`.`project_id` IS NOT NULL AND `Project`.`running_status` IN (4, 3) ORDER BY `ProjectManagementRequest`.`created` DESC LIMIT 30 | 0 | 0 | 1 | maybe slow |
SELECT `UserReview`.`id`, `UserReview`.`service_provider_id` FROM `demoe3_getezquotes`.`user_reviews` AS `UserReview` WHERE `UserReview`.`is_deleted` = 0 AND `UserReview`.`is_active` = 1 AND `UserReview`.`status` = 1 | 1 | 1 | 0 | |
SELECT `UserReview`.`id`, `UserReview`.`service_provider_id` FROM `demoe3_getezquotes`.`user_reviews` AS `UserReview` WHERE `UserReview`.`is_deleted` = 0 AND `UserReview`.`is_active` = 1 AND `UserReview`.`status` = 1 AND `UserReview`.`overall_rating` > 8 | 1 | 1 | 0 | |
SELECT `UserRecommendation`.`id`, `UserRecommendation`.`user_id` FROM `demoe3_getezquotes`.`user_recommendations` AS `UserRecommendation` WHERE `UserRecommendation`.`is_verified` = 1 AND `UserRecommendation`.`is_approved` = 1 AND `UserRecommendation`.`status` = 1 | 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`.`user_type` = 'user' AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0 AND `User`.`is_apporoved` = 1 | 1 | 1 | 16 | maybe slow |
SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`slug`, `Project`.`country_id`, `Project`.`postal_code`, `Project`.`city_name`, `Project`.`city_id`, `Project`.`project_type`, `Project`.`category_id`, `Project`.`quote_type`, `Project`.`due_date`, `Project`.`anticipated_start_date`, `Project`.`project_acceptance_due_date`, `Project`.`start_date`, `Project`.`award_date`, `Project`.`expiry_date`, `Project`.`close_date`, `Project`.`estimated_date`, `Project`.`completed_date`, `Project`.`canceled_date`, `Project`.`decline_date`, `Project`.`job_start`, `Project`.`project_documents_link`, `Project`.`description`, `Project`.`attachments_file_name`, `Project`.`attachments`, `Project`.`level_of_urgency`, `Project`.`meeting`, `Project`.`meet_day`, `Project`.`business_contact`, `Project`.`contact_specific_time`, `Project`.`contact_time`, `Project`.`show_contact_info`, `Project`.`show_name`, `Project`.`alias_name`, `Project`.`is_admin_approved`, `Project`.`posted_on`, `Project`.`approval_date`, `Project`.`status`, `Project`.`is_deleted`, `Project`.`deleted_date`, `Project`.`is_posted`, `Project`.`running_status`, `Project`.`decline_reason`, `Project`.`created`, `Project`.`modified`, `Project`.`project_status_question`, `Project`.`additional_information`, `Project`.`project_need_financing`, `Project`.`project_need_require_doc`, `Project`.`financing_type`, `Project`.`hourly_rate_applied`, `Project`.`hourly_rate_charges`, `Project`.`need_hire_project_manager`, `Project`.`actual_completion_cost`, `Project`.`last_date_request_additional_info`, `Project`.`currency_code`, `Project`.`conversion_currency_code`, `Project`.`conversion_currency_exchange_rate`, `Project`.`action_performed_by`, `Project`.`rebid_reminder_before_24` FROM `demoe3_getezquotes`.`projects` AS `Project` WHERE `Project`.`is_deleted` = 0 AND `Project`.`is_posted` = 1 AND `Project`.`status` = 1 AND `Project`.`is_admin_approved` = 1 | 26 | 26 | 1 | |
SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`slug`, `Project`.`country_id`, `Project`.`postal_code`, `Project`.`city_name`, `Project`.`city_id`, `Project`.`project_type`, `Project`.`category_id`, `Project`.`quote_type`, `Project`.`due_date`, `Project`.`anticipated_start_date`, `Project`.`project_acceptance_due_date`, `Project`.`start_date`, `Project`.`award_date`, `Project`.`expiry_date`, `Project`.`close_date`, `Project`.`estimated_date`, `Project`.`completed_date`, `Project`.`canceled_date`, `Project`.`decline_date`, `Project`.`job_start`, `Project`.`project_documents_link`, `Project`.`description`, `Project`.`attachments_file_name`, `Project`.`attachments`, `Project`.`level_of_urgency`, `Project`.`meeting`, `Project`.`meet_day`, `Project`.`business_contact`, `Project`.`contact_specific_time`, `Project`.`contact_time`, `Project`.`show_contact_info`, `Project`.`show_name`, `Project`.`alias_name`, `Project`.`is_admin_approved`, `Project`.`posted_on`, `Project`.`approval_date`, `Project`.`status`, `Project`.`is_deleted`, `Project`.`deleted_date`, `Project`.`is_posted`, `Project`.`running_status`, `Project`.`decline_reason`, `Project`.`created`, `Project`.`modified`, `Project`.`project_status_question`, `Project`.`additional_information`, `Project`.`project_need_financing`, `Project`.`project_need_require_doc`, `Project`.`financing_type`, `Project`.`hourly_rate_applied`, `Project`.`hourly_rate_charges`, `Project`.`need_hire_project_manager`, `Project`.`actual_completion_cost`, `Project`.`last_date_request_additional_info`, `Project`.`currency_code`, `Project`.`conversion_currency_code`, `Project`.`conversion_currency_exchange_rate`, `Project`.`action_performed_by`, `Project`.`rebid_reminder_before_24` FROM `demoe3_getezquotes`.`projects` AS `Project` WHERE `Project`.`is_deleted` = 0 AND `Project`.`is_posted` = 1 AND `Project`.`status` = 1 AND `Project`.`is_admin_approved` = 1 AND `Project`.`completed_date` = 'Project.estimated_date' | 0 | 0 | 1 | maybe slow |
SELECT `Block`.`page_slug`, `Block`.`block_slug`, `Block`.`description` FROM `demoe3_getezquotes`.`blocks` AS `Block` WHERE `Block`.`page_slug` = 'hire-a-project-manager-hint' AND `Block`.`block_slug` = 'hire-project-manager-hint' LIMIT 1 | 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 `Quote`.`is_deleted` = 0 AND `Quote`.`created` >= 1734673306 AND `Project`.`country_id` = 2 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`user_deals` AS `UserDeal` WHERE `UserDeal`.`accepted` = 1 | 1 | 1 | 15 | maybe slow |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`user_deals` AS `UserDeal` WHERE `UserDeal`.`accepted` = 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`user_purchased_offers` AS `UserPurchasedOffer` WHERE `UserPurchasedOffer`.`offer_status` = 'accepted' AND `UserPurchasedOffer`.`is_offer` = 1 GROUP BY `UserPurchasedOffer`.`psps_photos_deal_id` | 2 | 2 | 24 | maybe slow |
SELECT COUNT(*) AS `count` 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`.`running_status` = 4 AND `Project`.`project_type` = 'hourly_rate' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` 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`.`running_status` = 4 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` 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`.`is_deleted` = 0 | 1 | 1 | 0 | |
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_current_plans where `user_current_plans`.`user_id` = `ServiceProvider`.`id` ORDER BY `user_current_plans`.`created` DESC limit 1) = 'completed' | 1 | 1 | 1 | |
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 | |