Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.billing_name AS billing_name_2,
  c0_.billing_email AS billing_email_3,
  c0_.slug AS slug_4,
  c0_.description AS description_5,
  c0_.ico AS ico_6,
  c0_.dic AS dic_7,
  c0_.street AS street_8,
  c0_.city AS city_9,
  c0_.zip AS zip_10,
  c0_.country AS country_11,
  c0_.website AS website_12,
  c0_.top AS top_13,
  c0_.sequence AS sequence_14,
  c0_.residence AS residence_15,
  c0_.image_name AS image_name_16,
  c0_.video_title AS video_title_17,
  c0_.video_description AS video_description_18,
  c0_.video_link AS video_link_19,
  c0_.gallery_title AS gallery_title_20,
  c0_.gallery_description AS gallery_description_21,
  c0_.linkedin AS linkedin_22,
  c0_.facebook AS facebook_23,
  c0_.instagram AS instagram_24,
  c0_.youtube AS youtube_25,
  c0_.created_at AS created_at_26,
  c0_.updated_at AS updated_at_27,
  c0_.bank_prefix AS bank_prefix_28,
  c0_.bank_account AS bank_account_29,
  c0_.bank_code AS bank_code_30,
  COUNT(j1_.id) AS sclr_31
FROM
  company c0_
  LEFT JOIN job j1_ ON c0_.id = j1_.company_id
  AND (
    j1_.expires_at > ?
    AND j1_.state = ?
  )
WHERE
  c0_.top = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.sequence ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.billing_name AS billing_name_2, c0_.billing_email AS billing_email_3, c0_.slug AS slug_4, c0_.description AS description_5, c0_.ico AS ico_6, c0_.dic AS dic_7, c0_.street AS street_8, c0_.city AS city_9, c0_.zip AS zip_10, c0_.country AS country_11, c0_.website AS website_12, c0_.top AS top_13, c0_.sequence AS sequence_14, c0_.residence AS residence_15, c0_.image_name AS image_name_16, c0_.video_title AS video_title_17, c0_.video_description AS video_description_18, c0_.video_link AS video_link_19, c0_.gallery_title AS gallery_title_20, c0_.gallery_description AS gallery_description_21, c0_.linkedin AS linkedin_22, c0_.facebook AS facebook_23, c0_.instagram AS instagram_24, c0_.youtube AS youtube_25, c0_.created_at AS created_at_26, c0_.updated_at AS updated_at_27, c0_.bank_prefix AS bank_prefix_28, c0_.bank_account AS bank_account_29, c0_.bank_code AS bank_code_30, COUNT(j1_.id) AS sclr_31 FROM company c0_ LEFT JOIN job j1_ ON c0_.id = j1_.company_id AND (j1_.expires_at > '2025-11-08 01:54:07' AND j1_.state = 'PUBLISHED') WHERE c0_.top = 1 GROUP BY c0_.id ORDER BY c0_.sequence ASC;

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,
  c1_.id AS id_34,
  c1_.name AS name_35,
  c1_.billing_name AS billing_name_36,
  c1_.billing_email AS billing_email_37,
  c1_.slug AS slug_38,
  c1_.description AS description_39,
  c1_.ico AS ico_40,
  c1_.dic AS dic_41,
  c1_.street AS street_42,
  c1_.city AS city_43,
  c1_.zip AS zip_44,
  c1_.country AS country_45,
  c1_.website AS website_46,
  c1_.top AS top_47,
  c1_.sequence AS sequence_48,
  c1_.residence AS residence_49,
  c1_.image_name AS image_name_50,
  c1_.video_title AS video_title_51,
  c1_.video_description AS video_description_52,
  c1_.video_link AS video_link_53,
  c1_.gallery_title AS gallery_title_54,
  c1_.gallery_description AS gallery_description_55,
  c1_.linkedin AS linkedin_56,
  c1_.facebook AS facebook_57,
  c1_.instagram AS instagram_58,
  c1_.youtube AS youtube_59,
  c1_.created_at AS created_at_60,
  c1_.updated_at AS updated_at_61,
  c1_.bank_prefix AS bank_prefix_62,
  c1_.bank_account AS bank_account_63,
  c1_.bank_code AS bank_code_64,
  j0_.company_id AS company_id_65
FROM
  job j0_
  INNER JOIN company c1_ ON j0_.company_id = c1_.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
LIMIT
  6

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, c1_.id AS id_34, c1_.name AS name_35, c1_.billing_name AS billing_name_36, c1_.billing_email AS billing_email_37, c1_.slug AS slug_38, c1_.description AS description_39, c1_.ico AS ico_40, c1_.dic AS dic_41, c1_.street AS street_42, c1_.city AS city_43, c1_.zip AS zip_44, c1_.country AS country_45, c1_.website AS website_46, c1_.top AS top_47, c1_.sequence AS sequence_48, c1_.residence AS residence_49, c1_.image_name AS image_name_50, c1_.video_title AS video_title_51, c1_.video_description AS video_description_52, c1_.video_link AS video_link_53, c1_.gallery_title AS gallery_title_54, c1_.gallery_description AS gallery_description_55, c1_.linkedin AS linkedin_56, c1_.facebook AS facebook_57, c1_.instagram AS instagram_58, c1_.youtube AS youtube_59, c1_.created_at AS created_at_60, c1_.updated_at AS updated_at_61, c1_.bank_prefix AS bank_prefix_62, c1_.bank_account AS bank_account_63, c1_.bank_code AS bank_code_64, j0_.company_id AS company_id_65 FROM job j0_ INNER JOIN company c1_ ON j0_.company_id = c1_.id WHERE j0_.state = 'PUBLISHED' AND j0_.expires_at > '2025-11-08 01:54:07' 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 LIMIT 6;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.description AS description_3,
  a0_.content AS content_4,
  a0_.type AS type_5,
  a0_.image_name AS image_name_6,
  a0_.created_at AS created_at_7,
  a0_.updated_at AS updated_at_8
FROM
  article a0_
WHERE
  a0_.type = ?
ORDER BY
  a0_.created_at DESC
LIMIT
  5

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.content AS content_4, a0_.type AS type_5, a0_.image_name AS image_name_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8 FROM article a0_ WHERE a0_.type = 'BLOG' ORDER BY a0_.created_at DESC LIMIT 5;

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
  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
  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 <= '2025-11-08 01:54:07' AND b0_.published_to >= '2025-11-08 01:54:07') OR (b0_.published_from IS NULL AND b0_.published_to IS NULL) OR (b0_.published_from IS NULL AND b0_.published_to >= '2025-11-08 01:54:07') OR (b0_.published_from <= '2025-11-08 01:54:07' AND b0_.published_to IS NULL)) AND b0_.size = 'small_banner';

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 <= '2025-11-08 01:54:07' AND b0_.published_to >= '2025-11-08 01:54:07') OR (b0_.published_from IS NULL AND b0_.published_to IS NULL) OR (b0_.published_from IS NULL AND b0_.published_to >= '2025-11-08 01:54:07') OR (b0_.published_from <= '2025-11-08 01:54:07' AND b0_.published_to IS NULL)) AND b0_.size = 'big_banner';