Symfony Profiler

SELECT
  j0_.id AS id_0,
  j0_.name AS name_1,
  j0_.slug AS slug_2,
  j0_.description AS description_3,
  j0_.description_text AS description_text_4,
  j0_.address AS address_5,
  j0_.offer AS offer_6,
  j0_.offer_text AS offer_text_7,
  j0_.requirement AS requirement_8,
  j0_.requirement_text AS requirement_text_9,
  j0_.work_hours_type AS work_hours_type_10,
  j0_.salary AS salary_11,
  j0_.is_remote AS is_remote_12,
  j0_.superior AS superior_13,
  j0_.superior_email AS superior_email_14,
  j0_.superior_phone AS superior_phone_15,
  j0_.superior_linkedin AS superior_linkedin_16,
  j0_.link AS link_17,
  j0_.video_link AS video_link_18,
  j0_.suitability AS suitability_19,
  j0_.email AS email_20,
  j0_.phone AS phone_21,
  j0_.image AS image_22,
  j0_.state AS state_23,
  j0_.region AS region_24,
  j0_.created_at AS created_at_25,
  j0_.published_at AS published_at_26,
  j0_.renewed_at AS renewed_at_27,
  j0_.expires_at AS expires_at_28,
  j0_.topped_at AS topped_at_29,
  j0_.type AS type_30,
  j0_.views AS views_31,
  j0_.detail_views AS detail_views_32,
  j0_.web_views AS web_views_33,
  j0_.company_id AS company_id_34
FROM
  job j0_
  LEFT JOIN company c1_ ON j0_.company_id = c1_.id
  LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id
  LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id
  LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id
  LEFT JOIN type t4_ ON t4_.id = j5_.type_id
WHERE
  j0_.state = ?
  AND j0_.expires_at > ?

SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33, j0_.company_id AS company_id_34 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = 'PUBLISHED' AND j0_.expires_at > '2026-02-27 05:59:11';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          j0_.id AS id_0,
          j0_.name AS name_1,
          j0_.slug AS slug_2,
          j0_.description AS description_3,
          j0_.description_text AS description_text_4,
          j0_.address AS address_5,
          j0_.offer AS offer_6,
          j0_.offer_text AS offer_text_7,
          j0_.requirement AS requirement_8,
          j0_.requirement_text AS requirement_text_9,
          j0_.work_hours_type AS work_hours_type_10,
          j0_.salary AS salary_11,
          j0_.is_remote AS is_remote_12,
          j0_.superior AS superior_13,
          j0_.superior_email AS superior_email_14,
          j0_.superior_phone AS superior_phone_15,
          j0_.superior_linkedin AS superior_linkedin_16,
          j0_.link AS link_17,
          j0_.video_link AS video_link_18,
          j0_.suitability AS suitability_19,
          j0_.email AS email_20,
          j0_.phone AS phone_21,
          j0_.image AS image_22,
          j0_.state AS state_23,
          j0_.region AS region_24,
          j0_.created_at AS created_at_25,
          j0_.published_at AS published_at_26,
          j0_.renewed_at AS renewed_at_27,
          j0_.expires_at AS expires_at_28,
          j0_.topped_at AS topped_at_29,
          j0_.type AS type_30,
          j0_.views AS views_31,
          j0_.detail_views AS detail_views_32,
          j0_.web_views AS web_views_33
        FROM
          job j0_
          LEFT JOIN company c1_ ON j0_.company_id = c1_.id
          LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id
          LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id
          LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id
          LEFT JOIN type t4_ ON t4_.id = j5_.type_id
        WHERE
          j0_.state = ?
          AND j0_.expires_at > ?
        ORDER BY
          CASE WHEN j0_.topped_at IS NOT NULL
          AND j0_.topped_at <= CURRENT_TIMESTAMP THEN
            j0_.topped_at
          ELSE
            j0_.published_at
          END DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = 'PUBLISHED' AND j0_.expires_at > '2026-02-27 05:59:11' ORDER BY CASE WHEN j0_.topped_at IS NOT NULL AND j0_.topped_at <= CURRENT_TIMESTAMP THEN j0_.topped_at ELSE j0_.published_at END DESC) dctrn_result) dctrn_table;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.link AS link_2,
  b0_.size AS size_3,
  b0_.image AS image_4,
  b0_.deleted_at AS deleted_at_5,
  b0_.views AS views_6,
  b0_.clicks AS clicks_7,
  b0_.created_at AS created_at_8,
  b0_.updated_at AS updated_at_9,
  b0_.published_from AS published_from_10,
  b0_.published_to AS published_to_11
FROM
  banner b0_
WHERE
  (
    (
      b0_.published_from <= ?
      AND b0_.published_to >= ?
    )
    OR (
      b0_.published_from IS NULL
      AND b0_.published_to IS NULL
    )
    OR (
      b0_.published_from IS NULL
      AND b0_.published_to >= ?
    )
    OR (
      b0_.published_from <= ?
      AND b0_.published_to IS NULL
    )
  )
  AND b0_.size = ?

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.link AS link_2, b0_.size AS size_3, b0_.image AS image_4, b0_.deleted_at AS deleted_at_5, b0_.views AS views_6, b0_.clicks AS clicks_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_from AS published_from_10, b0_.published_to AS published_to_11 FROM banner b0_ WHERE ((b0_.published_from <= '2026-02-27 05:59:11' AND b0_.published_to >= '2026-02-27 05:59:11') OR (b0_.published_from IS NULL AND b0_.published_to IS NULL) OR (b0_.published_from IS NULL AND b0_.published_to >= '2026-02-27 05:59:11') OR (b0_.published_from <= '2026-02-27 05:59:11' AND b0_.published_to IS NULL)) AND b0_.size = 'small_banner';

SELECT
  j0_.id AS id_0,
  j0_.name AS name_1,
  j0_.slug AS slug_2,
  j0_.description AS description_3,
  j0_.description_text AS description_text_4,
  j0_.address AS address_5,
  j0_.offer AS offer_6,
  j0_.offer_text AS offer_text_7,
  j0_.requirement AS requirement_8,
  j0_.requirement_text AS requirement_text_9,
  j0_.work_hours_type AS work_hours_type_10,
  j0_.salary AS salary_11,
  j0_.is_remote AS is_remote_12,
  j0_.superior AS superior_13,
  j0_.superior_email AS superior_email_14,
  j0_.superior_phone AS superior_phone_15,
  j0_.superior_linkedin AS superior_linkedin_16,
  j0_.link AS link_17,
  j0_.video_link AS video_link_18,
  j0_.suitability AS suitability_19,
  j0_.email AS email_20,
  j0_.phone AS phone_21,
  j0_.image AS image_22,
  j0_.state AS state_23,
  j0_.region AS region_24,
  j0_.created_at AS created_at_25,
  j0_.published_at AS published_at_26,
  j0_.renewed_at AS renewed_at_27,
  j0_.expires_at AS expires_at_28,
  j0_.topped_at AS topped_at_29,
  j0_.type AS type_30,
  j0_.views AS views_31,
  j0_.detail_views AS detail_views_32,
  j0_.web_views AS web_views_33,
  j0_.company_id AS company_id_34
FROM
  job j0_
  LEFT JOIN company c1_ ON j0_.company_id = c1_.id
  LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id
  LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id
  LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id
  LEFT JOIN type t4_ ON t4_.id = j5_.type_id
WHERE
  j0_.state = ?
  AND j0_.expires_at > ?
ORDER BY
  CASE WHEN j0_.topped_at IS NOT NULL
  AND j0_.topped_at <= CURRENT_TIMESTAMP THEN
    j0_.topped_at
  ELSE
    j0_.published_at
  END DESC

SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33, j0_.company_id AS company_id_34 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = 'PUBLISHED' AND j0_.expires_at > '2026-02-27 05:59:11' ORDER BY CASE WHEN j0_.topped_at IS NOT NULL AND j0_.topped_at <= CURRENT_TIMESTAMP THEN j0_.topped_at ELSE j0_.published_at END DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4
FROM
  specialization t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM specialization t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4
FROM
  type t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM type t0;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      CASE WHEN topped_at_29 IS NOT NULL
      AND topped_at_29 <= CURRENT_TIMESTAMP THEN
        topped_at_29
      ELSE
        published_at_26
      END
    FROM
      (
        SELECT
          j0_.id AS id_0,
          j0_.name AS name_1,
          j0_.slug AS slug_2,
          j0_.description AS description_3,
          j0_.description_text AS description_text_4,
          j0_.address AS address_5,
          j0_.offer AS offer_6,
          j0_.offer_text AS offer_text_7,
          j0_.requirement AS requirement_8,
          j0_.requirement_text AS requirement_text_9,
          j0_.work_hours_type AS work_hours_type_10,
          j0_.salary AS salary_11,
          j0_.is_remote AS is_remote_12,
          j0_.superior AS superior_13,
          j0_.superior_email AS superior_email_14,
          j0_.superior_phone AS superior_phone_15,
          j0_.superior_linkedin AS superior_linkedin_16,
          j0_.link AS link_17,
          j0_.video_link AS video_link_18,
          j0_.suitability AS suitability_19,
          j0_.email AS email_20,
          j0_.phone AS phone_21,
          j0_.image AS image_22,
          j0_.state AS state_23,
          j0_.region AS region_24,
          j0_.created_at AS created_at_25,
          j0_.published_at AS published_at_26,
          j0_.renewed_at AS renewed_at_27,
          j0_.expires_at AS expires_at_28,
          j0_.topped_at AS topped_at_29,
          j0_.type AS type_30,
          j0_.views AS views_31,
          j0_.detail_views AS detail_views_32,
          j0_.web_views AS web_views_33
        FROM
          job j0_
          LEFT JOIN company c1_ ON j0_.company_id = c1_.id
          LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id
          LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id
          LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id
          LEFT JOIN type t4_ ON t4_.id = j5_.type_id
        WHERE
          j0_.state = ?
          AND j0_.expires_at > ?
      ) dctrn_result_inner
    ORDER BY
      CASE WHEN topped_at_29 IS NOT NULL
      AND topped_at_29 <= CURRENT_TIMESTAMP THEN
        topped_at_29
      ELSE
        published_at_26
      END DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, CASE WHEN topped_at_29 IS NOT NULL AND topped_at_29 <= CURRENT_TIMESTAMP THEN topped_at_29 ELSE published_at_26 END FROM (SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = 'PUBLISHED' AND j0_.expires_at > '2026-02-27 05:59:11') dctrn_result_inner ORDER BY CASE WHEN topped_at_29 IS NOT NULL AND topped_at_29 <= CURRENT_TIMESTAMP THEN topped_at_29 ELSE published_at_26 END DESC) dctrn_result LIMIT 20;