Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.auth_seller AS auth_seller_3, t0.city AS city_4, t0.street AS street_5, t0.check_vin AS check_vin_6, t0.visible AS visible_7, t0.basic_advertising AS basic_advertising_8, t0.email AS email_9, t0.www AS www_10, t0.description AS description_11, t0.lng AS lng_12, t0.lat AS lat_13, t0.rank AS rank_14, t0.logo AS logo_15, t0.import_id AS import_id_16, t0.name_import_vehicle AS name_import_vehicle_17, t0.id_import_vehicle AS id_import_vehicle_18, t0.id_export_cars AS id_export_cars_19, t0.url AS url_20, t0.opening_hours_note AS opening_hours_note_21, t0.district_id AS district_id_22 FROM dealer t0 WHERE t0.url = ? LIMIT 1

[
  "autohrach-cz-3287"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.auth_seller AS auth_seller_3,
  t0.city AS city_4,
  t0.street AS street_5,
  t0.check_vin AS check_vin_6,
  t0.visible AS visible_7,
  t0.basic_advertising AS basic_advertising_8,
  t0.email AS email_9,
  t0.www AS www_10,
  t0.description AS description_11,
  t0.lng AS lng_12,
  t0.lat AS lat_13,
  t0.rank AS rank_14,
  t0.logo AS logo_15,
  t0.import_id AS import_id_16,
  t0.name_import_vehicle AS name_import_vehicle_17,
  t0.id_import_vehicle AS id_import_vehicle_18,
  t0.id_export_cars AS id_export_cars_19,
  t0.url AS url_20,
  t0.opening_hours_note AS opening_hours_note_21,
  t0.district_id AS district_id_22
FROM
  dealer t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.auth_seller AS auth_seller_3, t0.city AS city_4, t0.street AS street_5, t0.check_vin AS check_vin_6, t0.visible AS visible_7, t0.basic_advertising AS basic_advertising_8, t0.email AS email_9, t0.www AS www_10, t0.description AS description_11, t0.lng AS lng_12, t0.lat AS lat_13, t0.rank AS rank_14, t0.logo AS logo_15, t0.import_id AS import_id_16, t0.name_import_vehicle AS name_import_vehicle_17, t0.id_import_vehicle AS id_import_vehicle_18, t0.id_export_cars AS id_export_cars_19, t0.url AS url_20, t0.opening_hours_note AS opening_hours_note_21, t0.district_id AS district_id_22 FROM dealer t0 WHERE t0.url = 'autohrach-cz-3287' LIMIT 1;

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id WHERE v0_.visible <> 0 AND d1_.visible = 1 AND v0_.dealer_id = ?

[
  "396"
]

SELECT
  count(DISTINCT v0_.id) AS sclr_0
FROM
  vehicle v0_
  LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id
  LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id
WHERE
  v0_.visible <> 0
  AND d1_.visible = 1
  AND v0_.dealer_id = ?

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id WHERE v0_.visible <> 0 AND d1_.visible = 1 AND v0_.dealer_id = '396';

SELECT DISTINCT v0_.id AS id_0, v0_.price AS price_1 FROM vehicle v0_ LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id WHERE v0_.visible <> 0 AND d1_.visible = 1 AND v0_.dealer_id = ? ORDER BY CASE WHEN d1_.basic_advertising = 1 THEN 1 ELSE 0 END ASC, CASE WHEN v0_.price IS NULL OR v0_.price = 0 THEN 1 ELSE 0 END ASC, v0_.price ASC LIMIT 10

[
  "396"
]

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.price AS price_1
FROM
  vehicle v0_
  LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id
  LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id
WHERE
  v0_.visible <> 0
  AND d1_.visible = 1
  AND v0_.dealer_id = ?
ORDER BY
  CASE WHEN d1_.basic_advertising = 1 THEN 1 ELSE 0 END ASC,
  CASE WHEN v0_.price IS NULL
  OR v0_.price = 0 THEN 1 ELSE 0 END ASC,
  v0_.price ASC
LIMIT
  10

SELECT DISTINCT v0_.id AS id_0, v0_.price AS price_1 FROM vehicle v0_ LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id WHERE v0_.visible <> 0 AND d1_.visible = 1 AND v0_.dealer_id = '396' ORDER BY CASE WHEN d1_.basic_advertising = 1 THEN 1 ELSE 0 END ASC, CASE WHEN v0_.price IS NULL OR v0_.price = 0 THEN 1 ELSE 0 END ASC, v0_.price ASC LIMIT 10;

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_manufacturer v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id WHERE v1_.dealer_id = ? AND v1_.visible = 1 ORDER BY v0_.name ASC

[
  396
]

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.url AS url_2
FROM
  vehicle_manufacturer v0_
  LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id
WHERE
  v1_.dealer_id = ?
  AND v1_.visible = 1
ORDER BY
  v0_.name ASC

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_manufacturer v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id WHERE v1_.dealer_id = 396 AND v1_.visible = 1 ORDER BY v0_.name ASC;

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_manufacturer v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id WHERE v1_.dealer_id = ? AND v1_.visible = 1 ORDER BY v0_.name ASC

[
  396
]

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.url AS url_2
FROM
  vehicle_manufacturer v0_
  LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id
WHERE
  v1_.dealer_id = ?
  AND v1_.visible = 1
ORDER BY
  v0_.name ASC

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_manufacturer v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id WHERE v1_.dealer_id = 396 AND v1_.visible = 1 ORDER BY v0_.name ASC;

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2, v0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_3 FROM vehicle_model v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.model_id WHERE v1_.dealer_id = ? AND v1_.visible = 1 ORDER BY v0_.name ASC

[
  396
]

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.url AS url_2,
  v0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_3
FROM
  vehicle_model v0_
  LEFT JOIN vehicle v1_ ON v0_.id = v1_.model_id
WHERE
  v1_.dealer_id = ?
  AND v1_.visible = 1
ORDER BY
  v0_.name ASC

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2, v0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_3 FROM vehicle_model v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.model_id WHERE v1_.dealer_id = 396 AND v1_.visible = 1 ORDER BY v0_.name ASC;

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = ? AND t0.main = ? ORDER BY t0.rank ASC

[
  1
  1
]

SELECT
  t0.id AS id_1,
  t0.rank AS rank_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.visible AS visible_5,
  t0.main AS main_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.text AS text_9
FROM
  page t0
WHERE
  t0.visible = ?
  AND t0.main = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = 1 AND t0.main = 1 ORDER BY t0.rank ASC;

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = ? AND t0.main = ? ORDER BY t0.rank ASC

[
  1
  0
]

SELECT
  t0.id AS id_1,
  t0.rank AS rank_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.visible AS visible_5,
  t0.main AS main_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.text AS text_9
FROM
  page t0
WHERE
  t0.visible = ?
  AND t0.main = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = 1 AND t0.main = 0 ORDER BY t0.rank ASC;