| 0.0011 |
SHOW TABLES FROM `app_hyjobs`
|
| 0.0081 |
SELECT *
FROM `migrations`
LIMIT 1
|
| 0.0020 |
SELECT *
FROM `app_sectiondefine`
WHERE `class` = 'page'
AND `func` = 'home'
|
| 0.0009 |
SELECT *
FROM `app_settings`
WHERE `vartype` = '1'
AND `vartype` != '0'
ORDER BY `id`
|
| 0.0010 |
SELECT *
FROM `siteusers`
WHERE `userId` IS NULL
|
| 0.0027 |
SELECT `nom_values`.`id`, `nom_values`.`name`, `nom_values`.`slug`
FROM `nom_values`
INNER JOIN `nomenclateurs` ON `nom_values`.`id_nom` = `nomenclateurs`.`id`
WHERE `nomenclateurs`.`nom` = 'job_type'
AND `nom_values`.`is_active` = 1
ORDER BY `nom_values`.`name` ASC
|
| 0.0109 |
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`, `jobs`.`id_job_type`, `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, `jobs`.`created_on` as `_date_posted`
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 `score_ratings` ON `score_ratings`.`organization_id` = `organizations`.`id`
WHERE (
`id_job_type` = '14'
)
AND (
(
`published_since` <= '2026-04-17 12:07:42'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 12:07:42'
OR `expires_at` IS NULL
)
)
GROUP BY `jobs`.`id`
ORDER BY `jobs`.`created_on` DESC
LIMIT 3
|
| 0.0024 |
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`, `jobs`.`id_job_type`, `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, `jobs`.`created_on` as `_date_posted`
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 `score_ratings` ON `score_ratings`.`organization_id` = `organizations`.`id`
WHERE (
`id_job_type` = '16'
)
AND (
(
`published_since` <= '2026-04-17 12:07:42'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 12:07:42'
OR `expires_at` IS NULL
)
)
GROUP BY `jobs`.`id`
ORDER BY `jobs`.`created_on` DESC
LIMIT 3
|
| 0.0020 |
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`, `jobs`.`id_job_type`, `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, `jobs`.`created_on` as `_date_posted`
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 `score_ratings` ON `score_ratings`.`organization_id` = `organizations`.`id`
WHERE (
`id_job_type` = '21'
)
AND (
(
`published_since` <= '2026-04-17 12:07:42'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 12:07:42'
OR `expires_at` IS NULL
)
)
GROUP BY `jobs`.`id`
ORDER BY `jobs`.`created_on` DESC
LIMIT 3
|
| 0.0024 |
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`, `jobs`.`id_job_type`, `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, `jobs`.`created_on` as `_date_posted`
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 `score_ratings` ON `score_ratings`.`organization_id` = `organizations`.`id`
WHERE (
(
`published_since` <= '2026-04-17 12:07:42'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 12:07:42'
OR `expires_at` IS NULL
)
)
GROUP BY `jobs`.`id`
ORDER BY `jobs`.`created_on` DESC
LIMIT 6
|
| 0.0023 |
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`, `jobs`.`id_job_type`, `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, `jobs`.`created_on` as `_date_posted`
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 `score_ratings` ON `score_ratings`.`organization_id` = `organizations`.`id`
WHERE (
`jobs`.`is_featured` = 1
)
AND (
(
`published_since` <= '2026-04-17 12:07:42'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 12:07:42'
OR `expires_at` IS NULL
)
)
GROUP BY `jobs`.`id`
ORDER BY `jobs`.`created_on` DESC
LIMIT 6
|
| 0.0005 |
SELECT `organizations`.*, `nom_industries`.`industry`
FROM `organizations`
LEFT JOIN `nom_industries` ON `organizations`.`id` = `nom_industries`.`industry_id`
WHERE `organizations`.`is_featured` = 1
ORDER BY `organizations`.`organization_name` ASC
LIMIT 10
|
| 0.0006 |
SELECT COUNT(*) AS `numrows`
FROM `jobs`
WHERE `id_organization` = '4'
|
| 0.0006 |
SELECT COUNT(*) AS `numrows`
FROM `jobs`
WHERE `id_organization` = '4'
AND `published_since` <= '2026-04-17 12:07:42'
AND `expires_at` >= '2026-04-17 12:07:42'
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `jobs`
WHERE `id_organization` = '1'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `jobs`
WHERE `id_organization` = '1'
AND `published_since` <= '2026-04-17 12:07:42'
AND `expires_at` >= '2026-04-17 12:07:42'
|
| 0.0009 |
SELECT `organizations`.*, `nom_industries`.`industry`, COUNT(jobs.id) as active_jobs_count
FROM `organizations`
LEFT JOIN `nom_industries` ON `organizations`.`id` = `nom_industries`.`industry_id`
LEFT JOIN `jobs` ON `organizations`.`id` = `jobs`.`id_organization`
WHERE `jobs`.`is_active` = 1
AND `jobs`.`is_deleted` = 0
AND `jobs`.`expires_at` > '2026-04-17 12:07:42'
GROUP BY `organizations`.`id`
ORDER BY `active_jobs_count` DESC
LIMIT 10
|
| 0.0005 |
SELECT *
FROM `nom_industries`
WHERE `is_active` = 1
AND `is_featured` = 1
LIMIT 10
|
