Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.image_name AS image_name_4,
  t0.company_id AS company_id_5
FROM
  gallery t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.image_name AS image_name_4, t0.company_id AS company_id_5 FROM gallery t0 WHERE t0.company_id = 0x019999D4B52E7003BBB53843C3A6C41D;

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

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,
  j1_.id AS id_31,
  j1_.name AS name_32,
  j1_.slug AS slug_33,
  j1_.description AS description_34,
  j1_.description_text AS description_text_35,
  j1_.address AS address_36,
  j1_.offer AS offer_37,
  j1_.offer_text AS offer_text_38,
  j1_.requirement AS requirement_39,
  j1_.requirement_text AS requirement_text_40,
  j1_.work_hours_type AS work_hours_type_41,
  j1_.salary AS salary_42,
  j1_.is_remote AS is_remote_43,
  j1_.superior AS superior_44,
  j1_.superior_email AS superior_email_45,
  j1_.superior_phone AS superior_phone_46,
  j1_.superior_linkedin AS superior_linkedin_47,
  j1_.link AS link_48,
  j1_.video_link AS video_link_49,
  j1_.suitability AS suitability_50,
  j1_.email AS email_51,
  j1_.phone AS phone_52,
  j1_.image AS image_53,
  j1_.state AS state_54,
  j1_.region AS region_55,
  j1_.created_at AS created_at_56,
  j1_.published_at AS published_at_57,
  j1_.renewed_at AS renewed_at_58,
  j1_.expires_at AS expires_at_59,
  j1_.topped_at AS topped_at_60,
  j1_.type AS type_61,
  j1_.views AS views_62,
  j1_.detail_views AS detail_views_63,
  j1_.web_views AS web_views_64,
  j1_.company_id AS company_id_65
FROM
  company c0_
  LEFT JOIN job j1_ ON c0_.id = j1_.company_id
WHERE
  c0_.slug = ?

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, j1_.id AS id_31, j1_.name AS name_32, j1_.slug AS slug_33, j1_.description AS description_34, j1_.description_text AS description_text_35, j1_.address AS address_36, j1_.offer AS offer_37, j1_.offer_text AS offer_text_38, j1_.requirement AS requirement_39, j1_.requirement_text AS requirement_text_40, j1_.work_hours_type AS work_hours_type_41, j1_.salary AS salary_42, j1_.is_remote AS is_remote_43, j1_.superior AS superior_44, j1_.superior_email AS superior_email_45, j1_.superior_phone AS superior_phone_46, j1_.superior_linkedin AS superior_linkedin_47, j1_.link AS link_48, j1_.video_link AS video_link_49, j1_.suitability AS suitability_50, j1_.email AS email_51, j1_.phone AS phone_52, j1_.image AS image_53, j1_.state AS state_54, j1_.region AS region_55, j1_.created_at AS created_at_56, j1_.published_at AS published_at_57, j1_.renewed_at AS renewed_at_58, j1_.expires_at AS expires_at_59, j1_.topped_at AS topped_at_60, j1_.type AS type_61, j1_.views AS views_62, j1_.detail_views AS detail_views_63, j1_.web_views AS web_views_64, j1_.company_id AS company_id_65 FROM company c0_ LEFT JOIN job j1_ ON c0_.id = j1_.company_id WHERE c0_.slug = 'appli-development-s-r-o-63539';

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_
WHERE
  j0_.company_id = ?
  AND j0_.state = ?
  AND j0_.expires_at > ?
  AND j0_.id IN (?, ?, ?)
ORDER BY
  j0_.created_at 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_ WHERE j0_.company_id = 0x019999D4B52E7003BBB53843C3A6C41D AND j0_.state = 'PUBLISHED' AND j0_.expires_at > '2025-11-08 07:51:15' AND j0_.id IN (0x0199E2137A6D79668E295A8EC9405BAC, 0x01999C0A804074F88CFF03A2DDA46581, 0x019999DFD8DE7E42812B328306952AF4) ORDER BY j0_.created_at DESC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_25
    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_
        WHERE
          j0_.company_id = ?
          AND j0_.state = ?
          AND j0_.expires_at > ?
      ) dctrn_result_inner
    ORDER BY
      created_at_25 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_25 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_ WHERE j0_.company_id = 0x019999D4B52E7003BBB53843C3A6C41D AND j0_.state = 'PUBLISHED' AND j0_.expires_at > '2025-11-08 07:51:15') dctrn_result_inner ORDER BY created_at_25 DESC) dctrn_result LIMIT 10;

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_
        WHERE
          j0_.company_id = ?
          AND j0_.state = ?
          AND j0_.expires_at > ?
        ORDER BY
          j0_.created_at 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_ WHERE j0_.company_id = 0x019999D4B52E7003BBB53843C3A6C41D AND j0_.state = 'PUBLISHED' AND j0_.expires_at > '2025-11-08 07:51:15' ORDER BY j0_.created_at DESC) dctrn_result) dctrn_table;