| 0.0009 |
SHOW TABLES FROM `app_hyjobs`
|
| 0.0002 |
SELECT *
FROM `migrations`
LIMIT 1
|
| 0.0006 |
SELECT *
FROM `app_sectiondefine`
WHERE `class` = 'company'
AND `func` = 'index'
|
| 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.0006 |
SELECT *
FROM `organizations`
WHERE `id` = '4'
|
| 0.0008 |
SELECT IFNULL(AVG(rating), 0) as avg_rating, COUNT(*) as review_count
FROM `platform_reviews`
WHERE `id_organization` = '4'
AND `is_approved` = 1
AND parent_id IS NULL
|
| 0.0004 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'facebook'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'twitter'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'linkedin'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'instagram'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'website'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'company_size'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'benefits'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'esg_compliant'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'diversity_inclusion_statement'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'equal_opportunity_employer'
AND `id_organization` = '4'
|
| 0.0003 |
SELECT *
FROM `organization_vars`
WHERE `data_key` = 'sustainability_initiatives'
AND `id_organization` = '4'
|
| 0.0012 |
SELECT COUNT(*) AS `numrows`
FROM `jobs`
WHERE `id_organization` = '4'
AND `is_deleted` = 0
|
| 0.0009 |
SELECT COUNT(*) AS `numrows`
FROM `jobs`
WHERE `id_organization` = '4'
AND `is_active` = 1
AND `is_deleted` = 0
AND `expires_at` > '2026-04-17 13:25:32'
|
| 0.0008 |
SELECT COUNT(job_applications.id) as total_applications
FROM `job_applications`
LEFT JOIN `jobs` ON `job_applications`.`job_id` = `jobs`.`id`
WHERE `jobs`.`id_organization` = '4'
|
| 0.0004 |
SELECT AVG(rating) as avg_rating, COUNT(rating) as total_reviews
FROM `platform_reviews`
WHERE `id_organization` = '4'
AND `is_approved` = 1
|
| 0.0004 |
SELECT `is_verified`, `updated_at`
FROM `organizations`
WHERE `id` = '4'
|
| 0.0009 |
SELECT COALESCE(SUM(open_positions), 0) as open_positions_count
FROM `jobs`
WHERE `id_organization` = '4'
AND `is_active` = 1
AND `is_deleted` = 0
AND `expires_at` > '2026-04-17 13:25:32'
|
| 0.0005 |
SELECT AVG(DATEDIFF(ja.decision_date, ja.apply_date)) as avg_hiring_days
FROM `job_applications` `ja`
INNER JOIN `jobs` `j` ON `ja`.`job_id` = `j`.`id`
WHERE `j`.`id_organization` = '4'
AND `ja`.`status` = 'hired'
|
| 0.0004 |
SELECT COUNT(*) as total_apps
FROM `job_applications` `ja`
INNER JOIN `jobs` `j` ON `ja`.`job_id` = `j`.`id`
WHERE `j`.`id_organization` = '4'
|
| 0.0003 |
SELECT COUNT(*) as responded_apps
FROM `job_applications` `ja`
INNER JOIN `jobs` `j` ON `ja`.`job_id` = `j`.`id`
WHERE `j`.`id_organization` = '4'
AND `ja`.`status` != 'pending'
|
| 0.0004 |
SELECT MAX(created_on) as last_job_date
FROM `jobs`
WHERE `id_organization` = '4'
|
| 0.0021 |
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 20
|
| 0.0001 |
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.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_organization` = '4'
AND `platform_reviews`.`is_approved` = 1
AND platform_reviews.parent_id IS NULL
ORDER BY `platform_reviews`.`created_on` DESC
|
