Symfony Profiler

SELECT
  a.*,
  p.name AS position_name,
  u.logo_list,
  u.company_name,
  c.name as country_name
FROM
  announcement a
  LEFT JOIN "country" c ON a.country_id = c.id
  LEFT JOIN "user" u ON a.user_id = u.id
  LEFT JOIN "positions" p ON a.position_id = p.id
WHERE
  (a.expire >= ?)
  AND (a.status = ?)
  AND (a.main_page = ?)
  AND (a.premium = ?)
ORDER BY
  random() ASC
LIMIT
  7

SELECT a.*, p.name AS position_name, u.logo_list, u.company_name, c.name as country_name FROM announcement a LEFT JOIN "country" c ON a.country_id = c.id LEFT JOIN "user" u ON a.user_id = u.id LEFT JOIN "positions" p ON a.position_id = p.id WHERE (a.expire >= '2026-03-10 11:11:11') AND (a.status = 1) AND (a.main_page = 1) AND (a.premium = 1) ORDER BY random() ASC LIMIT 7;

SELECT
  COUNT(u.id)
FROM
  "user" u
WHERE
  (u.status = ?)
  AND (u.user_group_id = ?)

SELECT COUNT(u.id) FROM "user" u WHERE (u.status = 1) AND (u.user_group_id = 4);

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.title_alt AS title_alt_2,
  a0_.status AS status_3,
  a0_.permalink AS permalink_4,
  a0_.lead_content AS lead_content_5,
  a0_.content AS content_6,
  a0_.meta_description AS meta_description_7,
  a0_.link AS link_8,
  a0_.link_text AS link_text_9,
  a0_.sort AS sort_10,
  a0_.target_blank AS target_blank_11,
  a0_.is_system AS is_system_12,
  a0_.system_name AS system_name_13,
  a0_.locale AS locale_14,
  a0_.form_position AS form_position_15,
  a0_.published_at AS published_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.created_at AS created_at_18,
  a0_.category_id AS category_id_19,
  a0_.image_id AS image_id_20,
  a0_.layout_id AS layout_id_21,
  a0_.owner_id AS owner_id_22,
  a0_.updated_by_id AS updated_by_id_23,
  a0_.form_id AS form_id_24
FROM
  article a0_
  LEFT JOIN article_category a1_ ON a0_.category_id = a1_.id
WHERE
  a1_.name = ?
  AND a0_.status = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.title_alt AS title_alt_2, a0_.status AS status_3, a0_.permalink AS permalink_4, a0_.lead_content AS lead_content_5, a0_.content AS content_6, a0_.meta_description AS meta_description_7, a0_.link AS link_8, a0_.link_text AS link_text_9, a0_.sort AS sort_10, a0_.target_blank AS target_blank_11, a0_.is_system AS is_system_12, a0_.system_name AS system_name_13, a0_.locale AS locale_14, a0_.form_position AS form_position_15, a0_.published_at AS published_at_16, a0_.updated_at AS updated_at_17, a0_.created_at AS created_at_18, a0_.category_id AS category_id_19, a0_.image_id AS image_id_20, a0_.layout_id AS layout_id_21, a0_.owner_id AS owner_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.form_id AS form_id_24 FROM article a0_ LEFT JOIN article_category a1_ ON a0_.category_id = a1_.id WHERE a1_.name = 'Post job' AND a0_.status = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.alias AS alias_2,
  s0_.ordering AS ordering_3,
  s0_.status AS status_4,
  s0_.value AS value_5,
  s0_.setting_section_id AS setting_section_id_6,
  s0_.setting_type_id AS setting_type_id_7
FROM
  setting s0_
  INNER JOIN setting_section s1_ ON s0_.setting_section_id = s1_.id
WHERE
  s1_.alias = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.alias AS alias_2, s0_.ordering AS ordering_3, s0_.status AS status_4, s0_.value AS value_5, s0_.setting_section_id AS setting_section_id_6, s0_.setting_type_id AS setting_type_id_7 FROM setting s0_ INNER JOIN setting_section s1_ ON s0_.setting_section_id = s1_.id WHERE s1_.alias = 'social';

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.ordering AS ordering_2,
  a0_.width AS width_3,
  a0_.height AS height_4,
  a0_.status AS status_5,
  a0_.code AS code_6,
  a0_.file AS file_7,
  a0_.type AS type_8,
  a0_.place AS place_9,
  a0_.url AS url_10
FROM
  advertisement a0_
WHERE
  a0_.status = ?
  AND a0_.place = ?
ORDER BY
  a0_.ordering ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.ordering AS ordering_2, a0_.width AS width_3, a0_.height AS height_4, a0_.status AS status_5, a0_.code AS code_6, a0_.file AS file_7, a0_.type AS type_8, a0_.place AS place_9, a0_.url AS url_10 FROM advertisement a0_ WHERE a0_.status = 1 AND a0_.place = 'logosBar' ORDER BY a0_.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_description AS meta_description_3,
  t0.keywords AS keywords_4,
  t0.author AS author_5,
  t0.copyright AS copyright_6,
  t0.logo_name AS logo_name_7,
  t0.social_media_logo_name AS social_media_logo_name_8,
  t0.banner_name AS banner_name_9,
  t0.map_iframe AS map_iframe_10,
  t0.company_name AS company_name_11,
  t0.address AS address_12,
  t0.post_code AS post_code_13,
  t0.city AS city_14,
  t0.phone AS phone_15,
  t0.phone2 AS phone2_16,
  t0.email AS email_17,
  t0.nip AS nip_18,
  t0.facebook_url AS facebook_url_19,
  t0.instagram_url AS instagram_url_20,
  t0.twitter_url AS twitter_url_21,
  t0.linkedin_url AS linkedin_url_22,
  t0.you_tube_url AS you_tube_url_23,
  t0.pinterest_url AS pinterest_url_24,
  t0.code_head AS code_head_25,
  t0.code_body AS code_body_26,
  t0.contact_form_email AS contact_form_email_27,
  t0.favicon_name AS favicon_name_28,
  t0.tik_tok_url AS tik_tok_url_29
FROM
  site_setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_description AS meta_description_3, t0.keywords AS keywords_4, t0.author AS author_5, t0.copyright AS copyright_6, t0.logo_name AS logo_name_7, t0.social_media_logo_name AS social_media_logo_name_8, t0.banner_name AS banner_name_9, t0.map_iframe AS map_iframe_10, t0.company_name AS company_name_11, t0.address AS address_12, t0.post_code AS post_code_13, t0.city AS city_14, t0.phone AS phone_15, t0.phone2 AS phone2_16, t0.email AS email_17, t0.nip AS nip_18, t0.facebook_url AS facebook_url_19, t0.instagram_url AS instagram_url_20, t0.twitter_url AS twitter_url_21, t0.linkedin_url AS linkedin_url_22, t0.you_tube_url AS you_tube_url_23, t0.pinterest_url AS pinterest_url_24, t0.code_head AS code_head_25, t0.code_body AS code_body_26, t0.contact_form_email AS contact_form_email_27, t0.favicon_name AS favicon_name_28, t0.tik_tok_url AS tik_tok_url_29 FROM site_setting t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.position_type AS position_type_4,
  t0.sort AS sort_5,
  t0.locale AS locale_6
FROM
  menu t0
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.position_type AS position_type_4, t0.sort AS sort_5, t0.locale AS locale_6 FROM menu t0 ORDER BY t0.sort ASC;

SELECT
  dc.id,
  dc.name as category_name
FROM
  document_category dc
WHERE
  dc.id IN (?, ?, ?, ?)
ORDER BY
  dc.ordering ASC

SELECT dc.id, dc.name as category_name FROM document_category dc WHERE dc.id IN (5, 6, 7, 8) ORDER BY dc.ordering ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.active AS active_3
FROM
  cookie c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.active AS active_3 FROM cookie c0_;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.title_alt AS title_alt_2,
  a0_.status AS status_3,
  a0_.permalink AS permalink_4,
  a0_.lead_content AS lead_content_5,
  a0_.content AS content_6,
  a0_.meta_description AS meta_description_7,
  a0_.link AS link_8,
  a0_.link_text AS link_text_9,
  a0_.sort AS sort_10,
  a0_.target_blank AS target_blank_11,
  a0_.is_system AS is_system_12,
  a0_.system_name AS system_name_13,
  a0_.locale AS locale_14,
  a0_.form_position AS form_position_15,
  a0_.published_at AS published_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.created_at AS created_at_18,
  a0_.category_id AS category_id_19,
  a0_.image_id AS image_id_20,
  a0_.layout_id AS layout_id_21,
  a0_.owner_id AS owner_id_22,
  a0_.updated_by_id AS updated_by_id_23,
  a0_.form_id AS form_id_24
FROM
  article a0_
  LEFT JOIN article_category a1_ ON a0_.category_id = a1_.id
WHERE
  a1_.name = ?
  AND a0_.status = ?
ORDER BY
  a0_.sort ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.title_alt AS title_alt_2, a0_.status AS status_3, a0_.permalink AS permalink_4, a0_.lead_content AS lead_content_5, a0_.content AS content_6, a0_.meta_description AS meta_description_7, a0_.link AS link_8, a0_.link_text AS link_text_9, a0_.sort AS sort_10, a0_.target_blank AS target_blank_11, a0_.is_system AS is_system_12, a0_.system_name AS system_name_13, a0_.locale AS locale_14, a0_.form_position AS form_position_15, a0_.published_at AS published_at_16, a0_.updated_at AS updated_at_17, a0_.created_at AS created_at_18, a0_.category_id AS category_id_19, a0_.image_id AS image_id_20, a0_.layout_id AS layout_id_21, a0_.owner_id AS owner_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.form_id AS form_id_24 FROM article a0_ LEFT JOIN article_category a1_ ON a0_.category_id = a1_.id WHERE a1_.name = 'Menu footer' AND a0_.status = 1 ORDER BY a0_.sort ASC;