Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.thumbnail AS thumbnail_3,
  t0.address AS address_4,
  t0.map AS map_5,
  t0.modified AS modified_6,
  t0.created AS created_7
FROM
  regions t0

SELECT t0.id AS id_1, t0.region AS region_2, t0.thumbnail AS thumbnail_3, t0.address AS address_4, t0.map AS map_5, t0.modified AS modified_6, t0.created AS created_7 FROM regions t0;

SELECT
  t0.id AS id_1,
  t0.page AS page_2,
  t0.title AS title_3,
  t0.copy AS copy_4,
  t0.banner AS banner_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.og_image AS og_image_8,
  t0.is_published AS is_published_9,
  t0.modified AS modified_10,
  t0.created AS created_11
FROM
  content t0
WHERE
  t0.page = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page AS page_2, t0.title AS title_3, t0.copy AS copy_4, t0.banner AS banner_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.og_image AS og_image_8, t0.is_published AS is_published_9, t0.modified AS modified_10, t0.created AS created_11 FROM content t0 WHERE t0.page = 'home-page' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.compulsory AS compulsory_2,
  t0_.grade AS grade_3,
  t0_.beeee AS beeee_4,
  t0_.location AS location_5,
  t0_.closing_date AS closing_date_6,
  t0_.project_number AS project_number_7,
  t0_.awarded AS awarded_8,
  t0_.contract_description AS contract_description_9,
  t0_.tender_notice AS tender_notice_10,
  t0_.meta_title AS meta_title_11,
  t0_.meta_description AS meta_description_12,
  t0_.is_published AS is_published_13,
  t0_.modified AS modified_14,
  t0_.created AS created_15,
  t0_.brief_date AS brief_date_16,
  t0_.closing_time AS closing_time_17,
  t0_.category_id AS category_id_18,
  t0_.region_id AS region_id_19
FROM
  tenders t0_
WHERE
  t0_.closing_date <= ?
  AND t0_.closing_date > ?
ORDER BY
  t0_.closing_date DESC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.compulsory AS compulsory_2, t0_.grade AS grade_3, t0_.beeee AS beeee_4, t0_.location AS location_5, t0_.closing_date AS closing_date_6, t0_.project_number AS project_number_7, t0_.awarded AS awarded_8, t0_.contract_description AS contract_description_9, t0_.tender_notice AS tender_notice_10, t0_.meta_title AS meta_title_11, t0_.meta_description AS meta_description_12, t0_.is_published AS is_published_13, t0_.modified AS modified_14, t0_.created AS created_15, t0_.brief_date AS brief_date_16, t0_.closing_time AS closing_time_17, t0_.category_id AS category_id_18, t0_.region_id AS region_id_19 FROM tenders t0_ WHERE t0_.closing_date <= '2024-10-08 03:30:55' AND t0_.closing_date > '2024-09-24 03:30:55' ORDER BY t0_.closing_date DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.website AS website_4,
  t0.modified AS modified_5,
  t0.created AS created_6
FROM
  entrants t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.website AS website_4, t0.modified AS modified_5, t0.created AS created_6 FROM entrants t0;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.compulsory AS compulsory_2,
  t0_.grade AS grade_3,
  t0_.beeee AS beeee_4,
  t0_.location AS location_5,
  t0_.closing_date AS closing_date_6,
  t0_.project_number AS project_number_7,
  t0_.awarded AS awarded_8,
  t0_.contract_description AS contract_description_9,
  t0_.tender_notice AS tender_notice_10,
  t0_.meta_title AS meta_title_11,
  t0_.meta_description AS meta_description_12,
  t0_.is_published AS is_published_13,
  t0_.modified AS modified_14,
  t0_.created AS created_15,
  t0_.brief_date AS brief_date_16,
  t0_.closing_time AS closing_time_17,
  t0_.category_id AS category_id_18,
  t0_.region_id AS region_id_19
FROM
  tenders t0_
WHERE
  t0_.status = ?
  AND t0_.region_id = ?
ORDER BY
  t0_.closing_date DESC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.compulsory AS compulsory_2, t0_.grade AS grade_3, t0_.beeee AS beeee_4, t0_.location AS location_5, t0_.closing_date AS closing_date_6, t0_.project_number AS project_number_7, t0_.awarded AS awarded_8, t0_.contract_description AS contract_description_9, t0_.tender_notice AS tender_notice_10, t0_.meta_title AS meta_title_11, t0_.meta_description AS meta_description_12, t0_.is_published AS is_published_13, t0_.modified AS modified_14, t0_.created AS created_15, t0_.brief_date AS brief_date_16, t0_.closing_time AS closing_time_17, t0_.category_id AS category_id_18, t0_.region_id AS region_id_19 FROM tenders t0_ WHERE t0_.status = 1 AND t0_.region_id = 1 ORDER BY t0_.closing_date DESC LIMIT 3;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.compulsory AS compulsory_2,
  t0_.grade AS grade_3,
  t0_.beeee AS beeee_4,
  t0_.location AS location_5,
  t0_.closing_date AS closing_date_6,
  t0_.project_number AS project_number_7,
  t0_.awarded AS awarded_8,
  t0_.contract_description AS contract_description_9,
  t0_.tender_notice AS tender_notice_10,
  t0_.meta_title AS meta_title_11,
  t0_.meta_description AS meta_description_12,
  t0_.is_published AS is_published_13,
  t0_.modified AS modified_14,
  t0_.created AS created_15,
  t0_.brief_date AS brief_date_16,
  t0_.closing_time AS closing_time_17,
  t0_.category_id AS category_id_18,
  t0_.region_id AS region_id_19
FROM
  tenders t0_
WHERE
  t0_.status = ?
  AND t0_.region_id = ?
ORDER BY
  t0_.closing_date DESC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.compulsory AS compulsory_2, t0_.grade AS grade_3, t0_.beeee AS beeee_4, t0_.location AS location_5, t0_.closing_date AS closing_date_6, t0_.project_number AS project_number_7, t0_.awarded AS awarded_8, t0_.contract_description AS contract_description_9, t0_.tender_notice AS tender_notice_10, t0_.meta_title AS meta_title_11, t0_.meta_description AS meta_description_12, t0_.is_published AS is_published_13, t0_.modified AS modified_14, t0_.created AS created_15, t0_.brief_date AS brief_date_16, t0_.closing_time AS closing_time_17, t0_.category_id AS category_id_18, t0_.region_id AS region_id_19 FROM tenders t0_ WHERE t0_.status = 1 AND t0_.region_id = 2 ORDER BY t0_.closing_date DESC LIMIT 3;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.compulsory AS compulsory_2,
  t0_.grade AS grade_3,
  t0_.beeee AS beeee_4,
  t0_.location AS location_5,
  t0_.closing_date AS closing_date_6,
  t0_.project_number AS project_number_7,
  t0_.awarded AS awarded_8,
  t0_.contract_description AS contract_description_9,
  t0_.tender_notice AS tender_notice_10,
  t0_.meta_title AS meta_title_11,
  t0_.meta_description AS meta_description_12,
  t0_.is_published AS is_published_13,
  t0_.modified AS modified_14,
  t0_.created AS created_15,
  t0_.brief_date AS brief_date_16,
  t0_.closing_time AS closing_time_17,
  t0_.category_id AS category_id_18,
  t0_.region_id AS region_id_19
FROM
  tenders t0_
WHERE
  t0_.status = ?
  AND t0_.region_id = ?
ORDER BY
  t0_.closing_date DESC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.compulsory AS compulsory_2, t0_.grade AS grade_3, t0_.beeee AS beeee_4, t0_.location AS location_5, t0_.closing_date AS closing_date_6, t0_.project_number AS project_number_7, t0_.awarded AS awarded_8, t0_.contract_description AS contract_description_9, t0_.tender_notice AS tender_notice_10, t0_.meta_title AS meta_title_11, t0_.meta_description AS meta_description_12, t0_.is_published AS is_published_13, t0_.modified AS modified_14, t0_.created AS created_15, t0_.brief_date AS brief_date_16, t0_.closing_time AS closing_time_17, t0_.category_id AS category_id_18, t0_.region_id AS region_id_19 FROM tenders t0_ WHERE t0_.status = 1 AND t0_.region_id = 3 ORDER BY t0_.closing_date DESC LIMIT 3;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.compulsory AS compulsory_2,
  t0_.grade AS grade_3,
  t0_.beeee AS beeee_4,
  t0_.location AS location_5,
  t0_.closing_date AS closing_date_6,
  t0_.project_number AS project_number_7,
  t0_.awarded AS awarded_8,
  t0_.contract_description AS contract_description_9,
  t0_.tender_notice AS tender_notice_10,
  t0_.meta_title AS meta_title_11,
  t0_.meta_description AS meta_description_12,
  t0_.is_published AS is_published_13,
  t0_.modified AS modified_14,
  t0_.created AS created_15,
  t0_.brief_date AS brief_date_16,
  t0_.closing_time AS closing_time_17,
  t0_.category_id AS category_id_18,
  t0_.region_id AS region_id_19
FROM
  tenders t0_
WHERE
  t0_.status = ?
  AND t0_.region_id = ?
ORDER BY
  t0_.closing_date DESC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.compulsory AS compulsory_2, t0_.grade AS grade_3, t0_.beeee AS beeee_4, t0_.location AS location_5, t0_.closing_date AS closing_date_6, t0_.project_number AS project_number_7, t0_.awarded AS awarded_8, t0_.contract_description AS contract_description_9, t0_.tender_notice AS tender_notice_10, t0_.meta_title AS meta_title_11, t0_.meta_description AS meta_description_12, t0_.is_published AS is_published_13, t0_.modified AS modified_14, t0_.created AS created_15, t0_.brief_date AS brief_date_16, t0_.closing_time AS closing_time_17, t0_.category_id AS category_id_18, t0_.region_id AS region_id_19 FROM tenders t0_ WHERE t0_.status = 1 AND t0_.region_id = 4 ORDER BY t0_.closing_date DESC LIMIT 3;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.compulsory AS compulsory_2,
  t0_.grade AS grade_3,
  t0_.beeee AS beeee_4,
  t0_.location AS location_5,
  t0_.closing_date AS closing_date_6,
  t0_.project_number AS project_number_7,
  t0_.awarded AS awarded_8,
  t0_.contract_description AS contract_description_9,
  t0_.tender_notice AS tender_notice_10,
  t0_.meta_title AS meta_title_11,
  t0_.meta_description AS meta_description_12,
  t0_.is_published AS is_published_13,
  t0_.modified AS modified_14,
  t0_.created AS created_15,
  t0_.brief_date AS brief_date_16,
  t0_.closing_time AS closing_time_17,
  t0_.category_id AS category_id_18,
  t0_.region_id AS region_id_19
FROM
  tenders t0_
WHERE
  t0_.status = ?
  AND t0_.region_id = ?
ORDER BY
  t0_.closing_date DESC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.compulsory AS compulsory_2, t0_.grade AS grade_3, t0_.beeee AS beeee_4, t0_.location AS location_5, t0_.closing_date AS closing_date_6, t0_.project_number AS project_number_7, t0_.awarded AS awarded_8, t0_.contract_description AS contract_description_9, t0_.tender_notice AS tender_notice_10, t0_.meta_title AS meta_title_11, t0_.meta_description AS meta_description_12, t0_.is_published AS is_published_13, t0_.modified AS modified_14, t0_.created AS created_15, t0_.brief_date AS brief_date_16, t0_.closing_time AS closing_time_17, t0_.category_id AS category_id_18, t0_.region_id AS region_id_19 FROM tenders t0_ WHERE t0_.status = 1 AND t0_.region_id = 5 ORDER BY t0_.closing_date DESC LIMIT 3;

SELECT
  c0_.id AS id_0,
  c0_.page AS page_1,
  c0_.banner AS banner_2,
  c0_.alt AS alt_3,
  c0_.order_by AS order_by_4,
  c0_.modified AS modified_5,
  c0_.created AS created_6
FROM
  carousel c0_
WHERE
  c0_.page = ?
ORDER BY
  c0_.order_by ASC

SELECT c0_.id AS id_0, c0_.page AS page_1, c0_.banner AS banner_2, c0_.alt AS alt_3, c0_.order_by AS order_by_4, c0_.modified AS modified_5, c0_.created AS created_6 FROM carousel c0_ WHERE c0_.page = 'home' ORDER BY c0_.order_by ASC;