| 0.0011 |
SHOW TABLES FROM `app_hyjobs`
|
| 0.0002 |
SELECT *
FROM `migrations`
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `app_sectiondefine`
WHERE `class` = 'job'
AND `func` = 'index'
|
| 0.0002 |
SELECT *
FROM `app_settings`
WHERE `vartype` = '1'
AND `vartype` != '0'
ORDER BY `id`
|
| 0.0001 |
SELECT *
FROM `siteusers`
WHERE `userId` IS NULL
|
| 0.0036 |
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`.`slug` = 'test-job'
)
AND (
(
`published_since` <= '2026-04-17 14:43:36'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 14:43:36'
OR `expires_at` IS NULL
)
)
|
| 0.0037 |
SELECT *
FROM `job_meta`
WHERE `data_key` IN('languages', 'locations', 'keywords')
AND `id_job` = '116'
|
| 0.0001 |
SELECT `job_attributes`.`name`, `slug`, `is_single`
FROM `job_attributes`
|
| 0.0005 |
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` = '116'
|
| 0.0015 |
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` = '116'
AND `is_approved` = 1
|
| 0.0006 |
SELECT `rating`, count(*) as count
FROM `platform_reviews`
WHERE `id_job` = '116'
AND `is_approved` = 1
GROUP BY `rating`
|
| 0.0161 |
UPDATE `job_stats` SET views = views + 1
WHERE `id_job` = '116'
|
| 0.0010 |
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` != '116'
LIMIT 5
|
| 0.0002 |
SELECT *
FROM `organizations`
WHERE `id` = '1'
|
| 0.0013 |
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` != '116'
AND `jobs`.`is_active` = 1
AND `jobs`.`is_deleted` = 0
AND `jobs`.`expires_at` > '2026-04-17 14:43:36'
ORDER BY `jobs`.`published_since` DESC
LIMIT 3
|
| 0.0005 |
SELECT IFNULL(AVG(rating), 0) as avg_rating, COUNT(*) as rating_count
FROM `platform_reviews`
WHERE `id_job` = '116'
AND `is_approved` = 1
|
| 0.0005 |
SELECT COUNT(*) as favorites_count
FROM `favorite_jobs`
WHERE `job_id` = '116'
|
| 0.0007 |
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` = '116'
AND `platform_reviews`.`is_approved` = 1
ORDER BY `platform_reviews`.`created_on` DESC
|
