Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `StaticPage`.`slug` FROM `demoe3_topsuffolkjobs`.`static_pages` AS `StaticPage` WHERE 1 = 1 | 9 | 9 | 0 | |
SELECT `Setting`.`id`, `Setting`.`page_limit`, `Setting`.`front_page_limit`, `Setting`.`from_name`, `Setting`.`fromemail`, `Setting`.`email_signature`, `Setting`.`reply_to_email`, `Setting`.`staff_mail`, `Setting`.`additional_staff_mail`, `Setting`.`copyright`, `Setting`.`meta_description`, `Setting`.`meta_title`, `Setting`.`meta_keywords`, `Setting`.`site_title`, `Setting`.`postal_address`, `Setting`.`currency`, `Setting`.`site_on_maintenance`, `Setting`.`site_emergency_note`, `Setting`.`phone`, `Setting`.`allowed_image_type`, `Setting`.`allowed_image_mime_type`, `Setting`.`allowed_doc_type`, `Setting`.`allowed_doc_mime_type`, `Setting`.`fax`, `Setting`.`payment_mode`, `Setting`.`paypal_test_api_username`, `Setting`.`paypal_test_api_password`, `Setting`.`paypal_test_api_signature`, `Setting`.`paypal_live_api_username`, `Setting`.`paypal_live_api_password`, `Setting`.`paypal_live_api_signature`, `Setting`.`bank_transfer_details`, `Setting`.`facebook_lnk`, `Setting`.`twitter_lnk`, `Setting`.`youtube_lnk`, `Setting`.`google_plus_lnk`, `Setting`.`linkedin_link`, `Setting`.`show_linkedin`, `Setting`.`show_googleplus`, `Setting`.`show_facebook`, `Setting`.`show_twitter`, `Setting`.`show_youtube`, `Setting`.`fast_sms_api_token`, `Setting`.`support_widget_1_text`, `Setting`.`homepage_advertising_package_widget1`, `Setting`.`homepage_job_alert_widget2`, `Setting`.`homepage_banner_image`, `Setting`.`homepage_text`, `Setting`.`advertiser_registration_page_text`, `Setting`.`jobseeker_registration_page_text`, `Setting`.`created`, `Setting`.`modified` FROM `demoe3_topsuffolkjobs`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `City`.`id`, `City`.`country_id`, `City`.`state_id`, `City`.`name`, `City`.`slug`, `City`.`zipcode`, `City`.`content_title`, `City`.`description`, `City`.`meta_keywords`, `City`.`meta_description`, `City`.`status`, `City`.`created`, `City`.`modified` FROM `demoe3_topsuffolkjobs`.`cities` AS `City` WHERE `City`.`slug` = 'moray' AND `City`.`status` = 1 LIMIT 1 | 0 | 0 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `demoe3_topsuffolkjobs`.`advertiser_jobs` AS `AdvertiserJob` LEFT JOIN `demoe3_topsuffolkjobs`.`users` AS `User` ON (`AdvertiserJob`.`user_id` = `User`.`id`) WHERE `AdvertiserJob`.`city_id` = (0) AND ((`AdvertiserJob`.`is_active` = 1) AND (`AdvertiserJob`.`is_deleted` = 0) AND (`AdvertiserJob`.`payment_received` = 1) AND (`User`.`is_temporary_deleted` = 0) AND (`User`.`status` = 1) AND (`User`.`is_blocked` = 0) AND (`User`.`is_deleted` = 0) AND (`AdvertiserJob`.`is_closed` = 0) AND (`AdvertiserJob`.`plan_status` = 'active')) | 1 | 1 | 0 | |
SELECT `AdvertiserJob`.`id`, `AdvertiserJob`.`user_id`, `AdvertiserJob`.`advertiser_purchased_package_id`, `AdvertiserJob`.`job_title`, `AdvertiserJob`.`slug`, `AdvertiserJob`.`job_reference`, `AdvertiserJob`.`job_unique_id`, `AdvertiserJob`.`job_location`, `AdvertiserJob`.`job_salary`, `AdvertiserJob`.`job_type`, `AdvertiserJob`.`job_hour`, `AdvertiserJob`.`job_description`, `AdvertiserJob`.`company_name`, `AdvertiserJob`.`company_logo`, `AdvertiserJob`.`business_type`, `AdvertiserJob`.`contact_name`, `AdvertiserJob`.`contact_email`, `AdvertiserJob`.`address`, `AdvertiserJob`.`postcode`, `AdvertiserJob`.`country_id`, `AdvertiserJob`.`state_id`, `AdvertiserJob`.`city_id`, `AdvertiserJob`.`payment_received`, `AdvertiserJob`.`plan_status`, `AdvertiserJob`.`is_premium`, `AdvertiserJob`.`is_active`, `AdvertiserJob`.`is_closed`, `AdvertiserJob`.`is_deleted`, `AdvertiserJob`.`created_by`, `AdvertiserJob`.`created`, `AdvertiserJob`.`modified`, `User`.`id`, `User`.`profile_image`, `Country`.`name`, `State`.`name`, `City`.`name` FROM `demoe3_topsuffolkjobs`.`advertiser_jobs` AS `AdvertiserJob` LEFT JOIN `demoe3_topsuffolkjobs`.`users` AS `User` ON (`AdvertiserJob`.`user_id` = `User`.`id`) LEFT JOIN `demoe3_topsuffolkjobs`.`countries` AS `Country` ON (`AdvertiserJob`.`country_id` = `Country`.`id`) LEFT JOIN `demoe3_topsuffolkjobs`.`states` AS `State` ON (`AdvertiserJob`.`state_id` = `State`.`id`) LEFT JOIN `demoe3_topsuffolkjobs`.`cities` AS `City` ON (`AdvertiserJob`.`city_id` = `City`.`id`) WHERE `AdvertiserJob`.`city_id` = (0) AND ((`AdvertiserJob`.`is_active` = 1) AND (`AdvertiserJob`.`is_deleted` = 0) AND (`AdvertiserJob`.`payment_received` = 1) AND (`User`.`is_temporary_deleted` = 0) AND (`User`.`status` = 1) AND (`User`.`is_blocked` = 0) AND (`User`.`is_deleted` = 0) AND (`AdvertiserJob`.`is_closed` = 0) AND (`AdvertiserJob`.`plan_status` = 'active')) ORDER BY `AdvertiserJob`.`is_premium` DESC, `AdvertiserJob`.`created` DESC LIMIT 10 | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name` FROM `demoe3_topsuffolkjobs`.`categories` AS `Category` WHERE ((`is_active` = 1) AND (`deleted` = 0) AND (`parent_id` = 0)) AND ((`type` = 'industry') AND (`parent_id` = 0)) ORDER BY `name` ASC | 54 | 54 | 0 | |
SELECT `Country`.`id` FROM `demoe3_topsuffolkjobs`.`countries` AS `Country` WHERE `Country`.`status` = 1 AND `Country`.`is_default` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `State`.`id` FROM `demoe3_topsuffolkjobs`.`states` AS `State` WHERE `State`.`status` = 1 AND `State`.`is_default` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `City`.`id`, `City`.`name` FROM `demoe3_topsuffolkjobs`.`cities` AS `City` WHERE `status` = 1 AND `country_id` = 1 AND `state_id` = 39 ORDER BY `name` ASC | 29 | 29 | 0 | |
SELECT `BannerPosition`.`id`, `BannerPosition`.`page_slug`, `BannerPosition`.`page_name`, `BannerPosition`.`is_random`, `BannerPosition`.`no_of_banners`, `BannerPosition`.`banner_order`, `BannerPosition`.`time_interval`, `BannerPosition`.`banner_width`, `BannerPosition`.`banner_height`, `BannerPosition`.`description_character_limit`, `BannerPosition`.`created`, `BannerPosition`.`modified` FROM `demoe3_topsuffolkjobs`.`banner_positions` AS `BannerPosition` WHERE `BannerPosition`.`page_slug` = 'search_results_banner' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`link`, `Banner`.`banner_position_id`, `Banner`.`image`, `Banner`.`start_date`, `Banner`.`end_date`, `Banner`.`description`, `Banner`.`is_active`, `Banner`.`user_id`, `Banner`.`advertiser_purchased_package_id`, `Banner`.`created`, `Banner`.`modified` FROM `demoe3_topsuffolkjobs`.`banners` AS `Banner` WHERE `Banner`.`banner_position_id` = 3 AND `Banner`.`start_date` <= 1730428526 AND `Banner`.`end_date` > 1730428526 AND `Banner`.`is_active` = 1 ORDER BY rand() ASC, `Created` DESC | 0 | 0 | 1 | maybe slow |
SELECT `Metatag`.`id`, `Metatag`.`name`, `Metatag`.`path`, `Metatag`.`meta_title`, `Metatag`.`meta_keywords`, `Metatag`.`meta_description`, `Metatag`.`created`, `Metatag`.`modified` FROM `demoe3_topsuffolkjobs`.`metatags` AS `Metatag` WHERE `Metatag`.`path` = 'jobs/location/moray' ORDER BY `Metatag`.`created` DESC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Menu`.`id`, `Menu`.`menu_title`, `Menu`.`parent_id`, `Menu`.`link_page_url`, `Menu`.`menu_type`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`action`, `Menu`.`slug`, `Menu`.`slug1`, `Menu`.`display_page_type`, `Menu`.`header_menu`, `Menu`.`footer_menu_column1`, `Menu`.`footer_menu_column2`, `Menu`.`footer_menu_column3`, `Menu`.`position_id`, `Menu`.`menu_order`, `Menu`.`after_menu_id`, `Menu`.`show_to_jobseeker`, `Menu`.`show_to_advertiser`, `Menu`.`registered`, `Menu`.`is_active`, `Menu`.`deleted`, `Menu`.`created`, `Menu`.`modified` FROM `demoe3_topsuffolkjobs`.`menus` AS `Menu` WHERE ((`Menu`.`header_menu` = '1') AND (`Menu`.`is_active` = 1) AND (`Menu`.`deleted` = 0)) ORDER BY `Menu`.`menu_order` ASC | 5 | 5 | 0 | |
SELECT `Menu`.`id`, `Menu`.`menu_title`, `Menu`.`parent_id`, `Menu`.`link_page_url`, `Menu`.`menu_type`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`action`, `Menu`.`slug`, `Menu`.`slug1`, `Menu`.`display_page_type`, `Menu`.`header_menu`, `Menu`.`footer_menu_column1`, `Menu`.`footer_menu_column2`, `Menu`.`footer_menu_column3`, `Menu`.`position_id`, `Menu`.`menu_order`, `Menu`.`after_menu_id`, `Menu`.`show_to_jobseeker`, `Menu`.`show_to_advertiser`, `Menu`.`registered`, `Menu`.`is_active`, `Menu`.`deleted`, `Menu`.`created`, `Menu`.`modified` FROM `demoe3_topsuffolkjobs`.`menus` AS `Menu` WHERE ((`Menu`.`footer_menu_column1` = 1) AND (`Menu`.`is_active` = 1) AND (`Menu`.`deleted` = 0)) ORDER BY `Menu`.`menu_order` ASC | 8 | 8 | 0 | |
SELECT `Menu`.`id`, `Menu`.`menu_title`, `Menu`.`parent_id`, `Menu`.`link_page_url`, `Menu`.`menu_type`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`action`, `Menu`.`slug`, `Menu`.`slug1`, `Menu`.`display_page_type`, `Menu`.`header_menu`, `Menu`.`footer_menu_column1`, `Menu`.`footer_menu_column2`, `Menu`.`footer_menu_column3`, `Menu`.`position_id`, `Menu`.`menu_order`, `Menu`.`after_menu_id`, `Menu`.`show_to_jobseeker`, `Menu`.`show_to_advertiser`, `Menu`.`registered`, `Menu`.`is_active`, `Menu`.`deleted`, `Menu`.`created`, `Menu`.`modified` FROM `demoe3_topsuffolkjobs`.`menus` AS `Menu` WHERE ((`Menu`.`footer_menu_column2` = 1) AND (`Menu`.`is_active` = 1) AND (`Menu`.`deleted` = 0)) ORDER BY `Menu`.`menu_order` ASC | 9 | 9 | 0 | |
SELECT `Menu`.`id`, `Menu`.`menu_title`, `Menu`.`parent_id`, `Menu`.`link_page_url`, `Menu`.`menu_type`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`action`, `Menu`.`slug`, `Menu`.`slug1`, `Menu`.`display_page_type`, `Menu`.`header_menu`, `Menu`.`footer_menu_column1`, `Menu`.`footer_menu_column2`, `Menu`.`footer_menu_column3`, `Menu`.`position_id`, `Menu`.`menu_order`, `Menu`.`after_menu_id`, `Menu`.`show_to_jobseeker`, `Menu`.`show_to_advertiser`, `Menu`.`registered`, `Menu`.`is_active`, `Menu`.`deleted`, `Menu`.`created`, `Menu`.`modified` FROM `demoe3_topsuffolkjobs`.`menus` AS `Menu` WHERE ((`Menu`.`footer_menu_column3` = 1) AND (`Menu`.`is_active` = 1) AND (`Menu`.`deleted` = 0)) ORDER BY `Menu`.`menu_order` ASC | 9 | 9 | 0 | |