| 0.0006 |
SHOW TABLES FROM `app_hyjobs`
|
| 0.0001 |
SELECT * FROM `migrations` LIMIT 1
|
| 0.0001 |
SELECT * FROM `app_sectiondefine` WHERE `class` = 'job' AND `func` = 'index'
|
| 0.0001 |
SELECT * FROM `app_settings` WHERE `vartype` = '1' AND `vartype` != '0' ORDER BY `id`
|
| 0.0001 |
SELECT * FROM `siteusers` WHERE `userId` IS NULL
|
| 0.0016 |
SELECT `jobs`.*, `jobs`.`id` as `JobID`, `position_name`, `job_description`, `min_salary`, `max_salary`, `currency`, `jobs`.`slug`, `open_positions`, `organizations`.`id` as `OrganizationID`, `organization_name`, `organization_country`, `organization_county`, `organization_city`, `logo_image`, `organization_phone`, `organization_email`, `tbl_job_type`.`id` as `JobTypeID`, `tbl_job_type`.`name` as `JobType`, `tbl_job_type`.`slug` as `JobTypeSlug`, `nom_industries`.`industry_id`, `industry`, `industry_slug`, (select IFNULL(AVG(score_ratings.rating), 0) FROM score_ratings WHERE score_ratings.organization_id = organizations.id) as avg_rating, (select IFNULL(COUNT(score_ratings.rating), 0) FROM score_ratings WHERE score_ratings.organization_id = organizations.id) as rating_count, `jobs`.`created_on` as `_date_posted`, `job_stats`.* FROM `jobs` LEFT JOIN `organizations` ON `jobs`.`id_organization` = `organizations`.`id` LEFT JOIN `nom_values` as `tbl_job_type` ON (`jobs`.`id_job_type` = `tbl_job_type`.`id` AND `tbl_job_type`.`id_nom` = (select id FROM nomenclateurs WHERE nom = "job_type")) LEFT JOIN `nom_industries` ON `jobs`.`industry_id` = `nom_industries`.`industry_id` LEFT JOIN `job_stats` ON `jobs`.`id` = `job_stats`.`id_job` LEFT JOIN `score_ratings` ON `score_ratings`.`organization_id` = `organizations`.`id` WHERE ( `jobs`.`is_active` = 1 AND `jobs`.`id` = '117' ) AND ( ( `published_since` <= '2026-04-17 13:25:33' OR `published_since` IS NULL ) AND ( `expires_at` >= '2026-04-17 13:25:33' OR `expires_at` IS NULL ) )
|
| 0.0069 |
SELECT * FROM `job_meta` WHERE `data_key` IN('languages', 'locations', 'keywords') AND `id_job` = '117'
|
| 0.0001 |
SELECT `job_attributes`.`name`, `slug`, `is_single` FROM `job_attributes`
|
| 0.0003 |
SELECT `job_attribute_values`.`id_job`, `job_attribute_values`.`id_attribute`, `id_value`, `attribute_options`.`id_attribute`, `option`, `job_attributes`.`name`, `slug`, `is_single` FROM `job_attribute_values` LEFT JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` LEFT JOIN `job_attributes` ON `attribute_options`.`id_attribute` = `job_attributes`.`id` WHERE `job_attribute_values`.`id_job` = '117'
|
| 0.0004 |
SELECT `rating`, `content`, `created_on`, `siteusers_extend`.`isVerified`, `siteusers_extend`.`person_city`, IF (siteusers.userId IS NULL, `platform_reviews`.`guest_name`, CONCAT(COALESCE(siteusers.firstName, ""), " ", COALESCE(siteusers.lastName, ""))) as reviewer_name FROM `platform_reviews` LEFT JOIN `siteusers` ON `siteusers`.`userId` = `platform_reviews`.`user_id` LEFT JOIN `siteusers_extend` ON `siteusers_extend`.`userId` = `platform_reviews`.`user_id` WHERE `id_job` = '117' AND `is_approved` = 1
|
| 0.0003 |
SELECT `rating`, count(*) as count FROM `platform_reviews` WHERE `id_job` = '117' AND `is_approved` = 1 GROUP BY `rating`
|
| 0.0009 |
UPDATE `job_stats` SET views = views + 1 WHERE `id_job` = '117'
|
| 0.0005 |
SELECT `jobs`.`id` as `JobID`, `position_name`, `job_description`, `min_salary`, `max_salary`, `currency`, `jobs`.`slug`, `open_positions`, `organizations`.`id` as `OrganizationID`, `organization_name`, `organization_country`, `organization_county`, `organization_city`, `logo_image`, `organizations`.`register_date` FROM `jobs` LEFT JOIN `organizations` ON `jobs`.`id_organization` = `organizations`.`id` WHERE `jobs`.`industry_id` = '1' AND `jobs`.`id` != '117' LIMIT 5
|
| 0.0001 |
SELECT * FROM `organizations` WHERE `id` = '1'
|
| 0.0008 |
SELECT `jobs`.`id`, `position_name`, `slug`, `locality`, `published_since`, `organizations`.`organization_name`, `organizations`.`organization_city` FROM `jobs` LEFT JOIN `organizations` ON `jobs`.`id_organization` = `organizations`.`id` WHERE `jobs`.`industry_id` = '1' AND `jobs`.`id` != '117' AND `jobs`.`is_active` = 1 AND `jobs`.`is_deleted` = 0 AND `jobs`.`expires_at` > '2026-04-17 13:25:33' ORDER BY `jobs`.`published_since` DESC LIMIT 3
|
| 0.0003 |
SELECT IFNULL(AVG(rating), 0) as avg_rating, COUNT(*) as rating_count FROM `platform_reviews` WHERE `id_job` = '117' AND `is_approved` = 1
|
| 0.0004 |
SELECT COUNT(*) as favorites_count FROM `favorite_jobs` WHERE `job_id` = '117'
|
| 0.0003 |
SELECT `platform_reviews`.*, `siteusers`.`firstName`, `siteusers`.`lastName` FROM `platform_reviews` LEFT JOIN `siteusers` ON `siteusers`.`userId` = `platform_reviews`.`user_id` WHERE `platform_reviews`.`id_job` = '117' AND `platform_reviews`.`is_approved` = 1 ORDER BY `platform_reviews`.`created_on` DESC
|