| 0.0008 |
SHOW TABLES FROM `app_hyjobs`
|
| 0.0002 |
SELECT *
FROM `migrations`
LIMIT 1
|
| 0.0011 |
SELECT *
FROM `app_sectiondefine`
WHERE `class` = 'job'
AND `func` = 'listing'
|
| 0.0002 |
SELECT *
FROM `app_settings`
WHERE `vartype` = '1'
AND `vartype` != '0'
ORDER BY `id`
|
| 0.0002 |
SELECT *
FROM `siteusers`
WHERE `userId` IS NULL
|
| 0.0008 |
SELECT `slug`, `id`
FROM `job_attributes`
|
| 0.0077 |
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 13:25:32'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 13:25:32'
OR `expires_at` IS NULL
)
)
GROUP BY `jobs`.`id`
ORDER BY `jobs`.`created_on` DESC
LIMIT 10
|
| 0.0018 |
SELECT COUNT(*) AS `numrows`
FROM `jobs`
LEFT JOIN `organizations` ON `jobs`.`id_organization` = `organizations`.`id`
WHERE (
(
`published_since` <= '2026-04-17 13:25:32'
OR `published_since` IS NULL
)
AND (
`expires_at` >= '2026-04-17 13:25:32'
OR `expires_at` IS NULL
)
)
|
| 0.0008 |
SELECT `rating`, `content`
FROM `score_ratings`
WHERE `organization_id` = '1'
AND `reviewer_user_id` IS NULL
|
| 0.0002 |
SELECT `rating`, `content`
FROM `score_ratings`
WHERE `organization_id` = '1'
AND `reviewer_user_id` IS NULL
|
| 0.0014 |
SELECT `nom_industries`.`industry_id`, `nom_industries`.`industry` as `name`, `nom_industries`.`industry_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `nom_industries` ON `jobs`.`industry_id` = `nom_industries`.`industry_id`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `nom_industries`.`is_active` = 1
GROUP BY `nom_industries`.`industry_id`
HAVING `count` > 0
ORDER BY `nom_industries`.`industry` ASC
|
| 0.0015 |
SELECT `nom_values`.`id`, `nom_values`.`name`, `nom_values`.`slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `nom_values` ON `jobs`.`id_job_type` = `nom_values`.`id`
INNER JOIN `nomenclateurs` ON `nom_values`.`id_nom` = `nomenclateurs`.`id`
WHERE `nomenclateurs`.`nom` = 'job_type'
AND (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `nom_values`.`is_active` = 1
GROUP BY `nom_values`.`id`
HAVING `count` > 0
ORDER BY `nom_values`.`name` ASC
|
| 0.0011 |
SELECT `jobs`.`locality` as `name`, `jobs`.`locality` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `jobs`.`locality` IS NOT NULL
AND `jobs`.`locality` != ''
GROUP BY `jobs`.`locality`
HAVING `count` > 0
ORDER BY `jobs`.`locality` ASC
|
| 0.0006 |
SELECT `nom_country`.`country_id` as `id`, `nom_country`.`name`, `nom_country`.`alfa2` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `nom_country` ON `jobs`.`country_id` = `nom_country`.`country_id`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `nom_country`.`is_active` = 1
GROUP BY `nom_country`.`country_id`
HAVING `count` > 0
ORDER BY `nom_country`.`name` ASC
|
| 0.0007 |
SELECT `nom_values`.`id`, `nom_values`.`name`, `nom_values`.`slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `nom_values` ON `jobs`.`id_experiece_level` = `nom_values`.`id`
INNER JOIN `nomenclateurs` ON `nom_values`.`id_nom` = `nomenclateurs`.`id`
WHERE `nomenclateurs`.`nom` = 'Experience level'
AND (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `nom_values`.`is_active` = 1
GROUP BY `nom_values`.`id`
HAVING `count` > 0
ORDER BY `nom_values`.`name` ASC
|
| 0.0006 |
SELECT COUNT(DISTINCT jobs.id) as count
FROM `jobs`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND (
(
`jobs`.`min_salary` >= 0
AND `jobs`.`max_salary` <= 1000
)
OR (
`jobs`.`min_salary` <= 1000
AND `jobs`.`max_salary` >= 0
)
)
|
| 0.0006 |
SELECT COUNT(DISTINCT jobs.id) as count
FROM `jobs`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND (
(
`jobs`.`min_salary` >= 1000
AND `jobs`.`max_salary` <= 2500
)
OR (
`jobs`.`min_salary` <= 2500
AND `jobs`.`max_salary` >= 1000
)
)
|
| 0.0006 |
SELECT COUNT(DISTINCT jobs.id) as count
FROM `jobs`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND (
(
`jobs`.`min_salary` >= 2500
AND `jobs`.`max_salary` <= 5000
)
OR (
`jobs`.`min_salary` <= 5000
AND `jobs`.`max_salary` >= 2500
)
)
|
| 0.0006 |
SELECT COUNT(DISTINCT jobs.id) as count
FROM `jobs`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND (
(
`jobs`.`min_salary` >= 5000
AND `jobs`.`max_salary` <= 10000
)
OR (
`jobs`.`min_salary` <= 10000
AND `jobs`.`max_salary` >= 5000
)
)
|
| 0.0006 |
SELECT COUNT(DISTINCT jobs.id) as count
FROM `jobs`
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `jobs`.`min_salary` >= 10000
|
| 0.0003 |
SELECT `id`, `name`, `slug`, `is_single`
FROM `job_attributes`
ORDER BY `sort_order` ASC
|
| 0.0010 |
SELECT `attribute_options`.`id`, `attribute_options`.`option` as `name`, `attribute_options`.`option_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `job_attribute_values` ON `jobs`.`id` = `job_attribute_values`.`id_job`
INNER JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` AND `attribute_options`.`id_attribute` = 1
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `attribute_options`.`option_slug` IS NOT NULL
AND `attribute_options`.`option_slug` != ''
GROUP BY `attribute_options`.`id`
HAVING `count` > 0
ORDER BY `attribute_options`.`option` ASC
|
| 0.0005 |
SELECT `attribute_options`.`id`, `attribute_options`.`option` as `name`, `attribute_options`.`option_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `job_attribute_values` ON `jobs`.`id` = `job_attribute_values`.`id_job`
INNER JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` AND `attribute_options`.`id_attribute` = 2
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `attribute_options`.`option_slug` IS NOT NULL
AND `attribute_options`.`option_slug` != ''
GROUP BY `attribute_options`.`id`
HAVING `count` > 0
ORDER BY `attribute_options`.`option` ASC
|
| 0.0005 |
SELECT `attribute_options`.`id`, `attribute_options`.`option` as `name`, `attribute_options`.`option_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `job_attribute_values` ON `jobs`.`id` = `job_attribute_values`.`id_job`
INNER JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` AND `attribute_options`.`id_attribute` = 3
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `attribute_options`.`option_slug` IS NOT NULL
AND `attribute_options`.`option_slug` != ''
GROUP BY `attribute_options`.`id`
HAVING `count` > 0
ORDER BY `attribute_options`.`option` ASC
|
| 0.0005 |
SELECT `attribute_options`.`id`, `attribute_options`.`option` as `name`, `attribute_options`.`option_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `job_attribute_values` ON `jobs`.`id` = `job_attribute_values`.`id_job`
INNER JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` AND `attribute_options`.`id_attribute` = 4
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `attribute_options`.`option_slug` IS NOT NULL
AND `attribute_options`.`option_slug` != ''
GROUP BY `attribute_options`.`id`
HAVING `count` > 0
ORDER BY `attribute_options`.`option` ASC
|
| 0.0005 |
SELECT `attribute_options`.`id`, `attribute_options`.`option` as `name`, `attribute_options`.`option_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `job_attribute_values` ON `jobs`.`id` = `job_attribute_values`.`id_job`
INNER JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` AND `attribute_options`.`id_attribute` = 5
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `attribute_options`.`option_slug` IS NOT NULL
AND `attribute_options`.`option_slug` != ''
GROUP BY `attribute_options`.`id`
HAVING `count` > 0
ORDER BY `attribute_options`.`option` ASC
|
| 0.0003 |
SELECT `attribute_options`.`id`, `attribute_options`.`option` as `name`, `attribute_options`.`option_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `job_attribute_values` ON `jobs`.`id` = `job_attribute_values`.`id_job`
INNER JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` AND `attribute_options`.`id_attribute` = 6
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `attribute_options`.`option_slug` IS NOT NULL
AND `attribute_options`.`option_slug` != ''
GROUP BY `attribute_options`.`id`
HAVING `count` > 0
ORDER BY `attribute_options`.`option` ASC
|
| 0.0003 |
SELECT `attribute_options`.`id`, `attribute_options`.`option` as `name`, `attribute_options`.`option_slug` as `slug`, COUNT(DISTINCT jobs.id) as count
FROM `jobs`
INNER JOIN `job_attribute_values` ON `jobs`.`id` = `job_attribute_values`.`id_job`
INNER JOIN `attribute_options` ON `job_attribute_values`.`id_value` = `attribute_options`.`id` AND `attribute_options`.`id_attribute` = 7
WHERE (
(
`jobs`.`published_since` <= '2026-04-17 13:25:32'
OR `jobs`.`published_since` IS NULL
)
AND (
`jobs`.`expires_at` >= '2026-04-17 13:25:32'
OR `jobs`.`expires_at` IS NULL
)
)
AND `attribute_options`.`option_slug` IS NOT NULL
AND `attribute_options`.`option_slug` != ''
GROUP BY `attribute_options`.`id`
HAVING `count` > 0
ORDER BY `attribute_options`.`option` ASC
|
