Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• Configuration

Query Metrics

Grouped Statements

Show all queries

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

[
  "price-tax"
]

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.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 = ?

[
  10865
]

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 = 10865;

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 = ?

[
  10865
]

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 = 10865;

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

[
  "service"
]

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.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

[
  "audi"
]

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.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 = ?

[
  2770
]

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 = 2770;

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.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.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;

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 = ?

[
  2770
]

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 = 2770;

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 = ?

[
  2770
]

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 = 2770;

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_ WHERE c0_.slug = ? AND c0_.status = ? LIMIT 1

[
  "volkswagen-polo-1-0-tsi-life-wvwzzzawzpu107156"
  "published"
]

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_
WHERE
  c0_.slug = ?
  AND c0_.status = ?
LIMIT
  1

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_ WHERE c0_.slug = 'volkswagen-polo-1-0-tsi-life-wvwzzzawzpu107156' AND c0_.status = 'published' LIMIT 1;

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_ INNER JOIN car_car_category c1_ ON (c1_.id_car = c0_.id) INNER JOIN car_category c2_ ON (c2_.id = c1_.id_car_category AND c2_.id IN (?, ?, ?)) WHERE (c0_.is_visible = 1 AND c0_.status = ?) AND c0_.id <> ? ORDER BY c0_.date_modified DESC LIMIT 4

[
  4
  2
  5
  "published"
  2770
]

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_
  INNER JOIN car_car_category c1_ ON (c1_.id_car = c0_.id)
  INNER JOIN car_category c2_ ON (
    c2_.id = c1_.id_car_category
    AND c2_.id IN (?, ?, ?)
  )
WHERE
  (
    c0_.is_visible = 1
    AND c0_.status = ?
  )
  AND c0_.id <> ?
ORDER BY
  c0_.date_modified DESC
LIMIT
  4

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_ INNER JOIN car_car_category c1_ ON (c1_.id_car = c0_.id) INNER JOIN car_category c2_ ON (c2_.id = c1_.id_car_category AND c2_.id IN (4, 2, 5)) WHERE (c0_.is_visible = 1 AND c0_.status = 'published') AND c0_.id <> 2770 ORDER BY c0_.date_modified DESC LIMIT 4;

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

[
  10864
]

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 = 10864 LIMIT 1;

SELECT t0.id AS id_1, t0.id_car AS id_car_2, t0.id_car_category AS id_car_category_3 FROM car_car_category t0 WHERE t0.id_car = ?

[
  2770
]

SELECT
  t0.id AS id_1,
  t0.id_car AS id_car_2,
  t0.id_car_category AS id_car_category_3
FROM
  car_car_category t0
WHERE
  t0.id_car = ?

SELECT t0.id AS id_1, t0.id_car AS id_car_2, t0.id_car_category AS id_car_category_3 FROM car_car_category t0 WHERE t0.id_car = 2770;

SELECT t0.id AS id_1, t0.value AS value_2, t0.id_car AS id_car_3 FROM car_equipment t0 WHERE t0.id_car = ?

[
  2770
]

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.id_car AS id_car_3
FROM
  car_equipment t0
WHERE
  t0.id_car = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.id_car AS id_car_3 FROM car_equipment t0 WHERE t0.id_car = 2770;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping