Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.region_id AS region_id_6
FROM
  region t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.region_id AS region_id_6 FROM region t0 WHERE t0.path = 'kujawsko-pomorskie/radziejow' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  classified c0_
  LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id
  LEFT JOIN classified_category c3_ ON c0_.id = c3_.classified_id
  LEFT JOIN category c2_ ON c2_.id = c3_.category_id
  LEFT JOIN classified_region c5_ ON c0_.id = c5_.classified_id
  LEFT JOIN region r4_ ON r4_.id = c5_.region_id
  LEFT JOIN user u6_ ON c0_.user_id = u6_.id
  LEFT JOIN classified_region c8_ ON c0_.id = c8_.classified_id
  LEFT JOIN region r7_ ON r7_.id = c8_.region_id
WHERE
  c0_.active = 1
  AND r7_.id = ?

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM classified c0_ LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id LEFT JOIN classified_category c3_ ON c0_.id = c3_.classified_id LEFT JOIN category c2_ ON c2_.id = c3_.category_id LEFT JOIN classified_region c5_ ON c0_.id = c5_.classified_id LEFT JOIN region r4_ ON r4_.id = c5_.region_id LEFT JOIN user u6_ ON c0_.user_id = u6_.id LEFT JOIN classified_region c8_ ON c0_.id = c8_.classified_id LEFT JOIN region r7_ ON r7_.id = c8_.region_id WHERE c0_.active = 1 AND r7_.id = 592;

SELECT
  DISTINCT c0_.id AS id_0,
  (
    CASE WHEN c0_.promoted = 1 THEN
      c0_.promoted_date_start
    ELSE
      0
    END
  ) AS sclr_1,
  c0_.date_start AS date_start_2
FROM
  classified c0_
  LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id
  LEFT JOIN classified_category c3_ ON c0_.id = c3_.classified_id
  LEFT JOIN category c2_ ON c2_.id = c3_.category_id
  LEFT JOIN classified_region c5_ ON c0_.id = c5_.classified_id
  LEFT JOIN region r4_ ON r4_.id = c5_.region_id
  LEFT JOIN user u6_ ON c0_.user_id = u6_.id
  LEFT JOIN classified_region c8_ ON c0_.id = c8_.classified_id
  LEFT JOIN region r7_ ON r7_.id = c8_.region_id
WHERE
  c0_.active = 1
  AND r7_.id = ?
ORDER BY
  sclr_1 DESC,
  c0_.date_start DESC
LIMIT
  26

SELECT DISTINCT c0_.id AS id_0, (CASE WHEN c0_.promoted = 1 THEN c0_.promoted_date_start ELSE 0 END) AS sclr_1, c0_.date_start AS date_start_2 FROM classified c0_ LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id LEFT JOIN classified_category c3_ ON c0_.id = c3_.classified_id LEFT JOIN category c2_ ON c2_.id = c3_.category_id LEFT JOIN classified_region c5_ ON c0_.id = c5_.classified_id LEFT JOIN region r4_ ON r4_.id = c5_.region_id LEFT JOIN user u6_ ON c0_.user_id = u6_.id LEFT JOIN classified_region c8_ ON c0_.id = c8_.classified_id LEFT JOIN region r7_ ON r7_.id = c8_.region_id WHERE c0_.active = 1 AND r7_.id = 592 ORDER BY sclr_1 DESC, c0_.date_start DESC LIMIT 26;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.region_id AS region_id_6
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.region_id AS region_id_6 FROM region t0 WHERE t0.id = 462;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.thumb AS thumb_2,
  c0_.path AS path_3,
  COUNT(c1_.id) AS sclr_4
FROM
  category c0_
  LEFT JOIN classified_category c2_ ON c0_.id = c2_.category_id
  LEFT JOIN classified c1_ ON c1_.id = c2_.classified_id
  AND (c1_.active = 1)
WHERE
  c0_.category_id IS NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.thumb AS thumb_2, c0_.path AS path_3, COUNT(c1_.id) AS sclr_4 FROM category c0_ LEFT JOIN classified_category c2_ ON c0_.id = c2_.category_id LEFT JOIN classified c1_ ON c1_.id = c2_.classified_id AND (c1_.active = 1) WHERE c0_.category_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.slug AS slug_2,
  f0_.type AS type_3,
  f0_.required AS required_4,
  f0_.all_categories AS all_categories_5,
  f0_.search AS search_6,
  f0_.choices AS choices_7,
  f0_.position AS position_8
FROM
  filter f0_
WHERE
  f0_.all_categories = 1
  AND f0_.search = 1
ORDER BY
  f0_.position ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.type AS type_3, f0_.required AS required_4, f0_.all_categories AS all_categories_5, f0_.search AS search_6, f0_.choices AS choices_7, f0_.position AS position_8 FROM filter f0_ WHERE f0_.all_categories = 1 AND f0_.search = 1 ORDER BY f0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.region_id AS region_id_6
FROM
  region t0
WHERE
  t0.region_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.region_id AS region_id_6 FROM region t0 WHERE t0.region_id = 592 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.region_id AS region_id_6
FROM
  region t0
WHERE
  t0.region_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.region_id AS region_id_6 FROM region t0 WHERE t0.region_id = 462 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.region_id AS region_id_6
FROM
  region t0
WHERE
  t0.region_id IS NULL
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.region_id AS region_id_6 FROM region t0 WHERE t0.region_id IS NULL ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.content AS content_5,
  t0.description AS description_6,
  t0.keywords AS keywords_7,
  t0.contact_form AS contact_form_8,
  t0.in_footer AS in_footer_9
FROM
  static_page t0
WHERE
  t0.in_footer = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.content AS content_5, t0.description AS description_6, t0.keywords AS keywords_7, t0.contact_form AS contact_form_8, t0.in_footer AS in_footer_9 FROM static_page t0 WHERE t0.in_footer = 1 ORDER BY t0.position ASC;