Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.status AS status_3,
  c0_.date_created AS date_created_4,
  c0_.date_modified AS date_modified_5,
  c0_.is_visible AS is_visible_6,
  c0_.is_active AS is_active_7
FROM
  car c0_
  LEFT JOIN car_car_category c1_ ON (c1_.id_car = c0_.id)
  LEFT JOIN car_category c2_ ON (c2_.id = c1_.id_car_category)
  LEFT JOIN car_car_property c3_ ON (c3_.id_car = c0_.id)
  LEFT JOIN car_property c4_ ON (c4_.id = c3_.id_car_property)
WHERE
  c0_.is_visible = 1
  AND c0_.status = ?
GROUP BY
  c0_.id
HAVING
  MAX(
    IF(c2_.name = ?, 1, 0)
  ) = 1
  AND MAX(
    IF(c2_.name = ?, 1, 0)
  ) = 0
  AND MAX(
    IF(c2_.name = ?, 1, 0)
  ) = 0
ORDER BY
  MAX(
    IF(
      c4_.name = ?,
      CAST(c3_.value AS UNSIGNED),
      NULL
    )
  ) ASC
LIMIT
  12

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.date_created AS date_created_4, c0_.date_modified AS date_modified_5, c0_.is_visible AS is_visible_6, c0_.is_active AS is_active_7 FROM car c0_ LEFT JOIN car_car_category c1_ ON (c1_.id_car = c0_.id) LEFT JOIN car_category c2_ ON (c2_.id = c1_.id_car_category) LEFT JOIN car_car_property c3_ ON (c3_.id_car = c0_.id) LEFT JOIN car_property c4_ ON (c4_.id = c3_.id_car_property) WHERE c0_.is_visible = 1 AND c0_.status = 'published' GROUP BY c0_.id HAVING MAX(IF(c2_.name = 'volkswagen', 1, 0)) = 1 AND MAX(IF(c2_.name = 'used-cars', 1, 0)) = 0 AND MAX(IF(c2_.name = 'demonstration-cars', 1, 0)) = 0 ORDER BY MAX(IF(c4_.name = 'price-tax', CAST(c3_.value AS UNSIGNED), NULL)) ASC LIMIT 12;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.prefix AS prefix_5,
  t0.suffix AS suffix_6
FROM
  car_property t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.type AS type_4, t0.prefix AS prefix_5, t0.suffix AS suffix_6 FROM car_property t0 WHERE t0.name = 'price-tax' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_main AS is_main_2,
  t0.is_thumbnail AS is_thumbnail_3,
  t0.id_car AS id_car_4,
  t0.id_file AS id_file_5
FROM
  car_image t0
WHERE
  t0.id_car = ?

SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.is_thumbnail AS is_thumbnail_3, t0.id_car AS id_car_4, t0.id_file AS id_file_5 FROM car_image t0 WHERE t0.id_car = 3049;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.id_app_file AS id_app_file_4
FROM
  app_file_meta t0
WHERE
  t0.id_app_file = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_app_file AS id_app_file_4 FROM app_file_meta t0 WHERE t0.id_app_file = 1722;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.id_car AS id_car_4
FROM
  car_meta t0
WHERE
  t0.id_car = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_car AS id_car_4 FROM car_meta t0 WHERE t0.id_car = 3049;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.mime_type AS mime_type_4,
  t0.date_created AS date_created_5,
  t0.date_modified AS date_modified_6,
  t0.author AS author_7
FROM
  app_file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.mime_type AS mime_type_4, t0.date_created AS date_created_5, t0.date_modified AS date_modified_6, t0.author AS author_7 FROM app_file t0 WHERE t0.id = 12043;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.template AS template_5,
  t0.date_modified AS date_modified_6
FROM
  cms_page t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.template AS template_5, t0.date_modified AS date_modified_6 FROM cms_page t0 WHERE t0.name = 'service' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.id_car_property AS id_car_property_3,
  t0.id_car AS id_car_4
FROM
  car_car_property t0
WHERE
  t0.id_car = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.id_car_property AS id_car_property_3, t0.id_car AS id_car_4 FROM car_car_property t0 WHERE t0.id_car = 3049;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.date_modified AS date_modified_5
FROM
  car_category t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.date_modified AS date_modified_5 FROM car_category t0 WHERE t0.name = 'audi' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.template AS template_5,
  t0.date_modified AS date_modified_6
FROM
  cms_page t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.template AS template_5, t0.date_modified AS date_modified_6 FROM cms_page t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.mime_type AS mime_type_4,
  t0.date_created AS date_created_5,
  t0.date_modified AS date_modified_6,
  t0.author AS author_7
FROM
  app_file t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.mime_type AS mime_type_4, t0.date_created AS date_created_5, t0.date_modified AS date_modified_6, t0.author AS author_7 FROM app_file t0 WHERE t0.id = 1722 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.date_modified AS date_modified_5
FROM
  car_category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.date_modified AS date_modified_5 FROM car_category t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.date_modified AS date_modified_5
FROM
  car_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.date_modified AS date_modified_5 FROM car_category t0 WHERE t0.slug = 'volkswagen' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.id_car_category AS id_car_category_4
FROM
  car_category_meta t0
WHERE
  t0.id_car_category = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_car_category AS id_car_category_4 FROM car_category_meta t0 WHERE t0.id_car_category = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.id_cms_page AS id_cms_page_4
FROM
  cms_page_meta t0
WHERE
  t0.id_cms_page = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_cms_page AS id_cms_page_4 FROM cms_page_meta t0 WHERE t0.id_cms_page = 1;