Query Metrics

81 Database Queries
20 Different statements
1532.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_kind t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "osobni-vozidla"
]
2 14.00 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "skoda"
]
3 9.08 ms
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 LEFT JOIN dealer d2_ ON v1_.dealer_id = d2_.id WHERE v1_.visible = 1 AND d2_.visible = 1 AND v1_.manufacturer_id = ? AND v1_.kind_id = ? ORDER BY v0_.name ASC
Parameters:
[
  247
  1
]
4 13.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "fabia"
]
5 388.46 ms
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_.kind_id = ? AND v0_.manufacturer_id = ? AND v0_.model_id = ?
Parameters:
[
  1
  247
  1501
]
6 275.60 ms
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_.kind_id = ? AND v0_.manufacturer_id = ? AND v0_.model_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 20
Parameters:
[
  1
  247
  1501
]
7 30.45 ms
SELECT v0_.id AS id_0, v0_.id_import AS id_import_1, v0_.visible AS visible_2, v0_.create_at AS create_at_3, v0_.hidden_at AS hidden_at_4, v0_.seo_slug AS seo_slug_5, v0_.seo_title AS seo_title_6, v0_.seo_description AS seo_description_7, v0_.seo_h1 AS seo_h1_8, v0_.url_generated_at AS url_generated_at_9, v0_.vin AS vin_10, v0_.places AS places_11, v0_.doors AS doors_12, v0_.load_capacity AS load_capacity_13, v0_.total_weight AS total_weight_14, v0_.state AS state_15, v0_.mileage AS mileage_16, v0_.mileage_unit AS mileage_unit_17, v0_.made_date AS made_date_18, v0_.price AS price_19, v0_.vat AS vat_20, v0_.price_before AS price_before_21, v0_.price_leasing AS price_leasing_22, v0_.payment_leasing_count AS payment_leasing_count_23, v0_.eco_vat AS eco_vat_24, v0_.engine_volume AS engine_volume_25, v0_.stk_to AS stk_to_26, v0_.first_owner AS first_owner_27, v0_.service_book AS service_book_28, v0_.tuning AS tuning_29, v0_.note AS note_30, v0_.engine_power AS engine_power_31, v0_.type AS type_32, v0_.not_crashed AS not_crashed_33, v0_.financial_info AS financial_info_34, v0_.payment_leasing AS payment_leasing_35, v0_.gearbox AS gearbox_36, v0_.category_id AS category_id_37, v0_.kind_id AS kind_id_38, v0_.sub_kind_id AS sub_kind_id_39, v0_.model_id AS model_id_40, v0_.body_id AS body_id_41, v0_.color_id AS color_id_42, v0_.fuel_id AS fuel_id_43, v0_.condition_vehicle_id AS condition_vehicle_id_44, v0_.part_kind_id AS part_kind_id_45, v0_.manufacturer_id AS manufacturer_id_46, v0_.dealer_id AS dealer_id_47 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_.kind_id = ? AND v0_.manufacturer_id = ? AND v0_.model_id = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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
Parameters:
[
  1
  247
  1501
  54109
  56450
  51677
  9540
  55750
  30016
  7174
  3506
  47179
  5205
  44534
  30054
  53144
  44185
  51156
  21639
  48773
  5110
  51913
  45526
]
8 10.05 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  54109
]
9 8.70 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  56450
]
10 2.21 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  51677
]
11 2.17 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  9540
]
12 3.25 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  55750
]
13 0.78 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  30016
]
14 4.56 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  7174
]
15 1.02 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  3506
]
16 1.19 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  47179
]
17 6.16 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  5205
]
18 2.22 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  44534
]
19 0.75 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  30054
]
20 5.71 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  53144
]
21 0.86 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  21639
]
22 1.55 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  44185
]
23 1.05 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  51156
]
24 0.42 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  48773
]
25 1.02 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  5110
]
26 2.05 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  51913
]
27 10.75 ms
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
  45526
]
28 252.00 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_category v0_ INNER JOIN vehicle v1_ ON v0_.id = v1_.category_id ORDER BY v0_.name ASC
Parameters:
[]
29 2.00 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_manufacturer v0_ INNER JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id LEFT JOIN dealer d2_ ON v1_.dealer_id = d2_.id WHERE v1_.visible = 1 AND d2_.visible = 1 AND v1_.kind_id = ? ORDER BY v0_.name ASC
Parameters:
[
  1
]
30 197.48 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_body v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.body_id WHERE v1_.visible = 1 AND v1_.kind_id = ? AND v1_.manufacturer_id = ? AND v1_.model_id = ? ORDER BY v0_.name ASC
Parameters:
[
  1
  247
  1501
]
31 21.26 ms
SELECT v0_.id AS id_0, v0_.name AS name_1 FROM vehicle_fuel v0_ INNER JOIN vehicle v1_ ON v0_.id = v1_.fuel_id WHERE v1_.visible = 1 ORDER BY v0_.name ASC
Parameters:
[]
32 0.52 ms
SELECT v0_.gearbox AS gearbox_0 FROM vehicle v0_ WHERE v0_.visible <> 0 AND v0_.gearbox IS NOT NULL GROUP BY v0_.gearbox ORDER BY v0_.gearbox ASC
Parameters:
[]
33 4.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4 FROM region t0 ORDER BY t0.name ASC
Parameters:
[]
34 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4, t0.region_id AS region_id_5 FROM district t0 ORDER BY t0.name ASC
Parameters:
[]
35 1.01 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  54109
]
36 10.25 ms
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.id = ?
Parameters:
[
  347
]
37 9.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  56450
]
38 7.70 ms
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.id = ?
Parameters:
[
  227
]
39 1.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  51677
]
40 1.13 ms
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.id = ?
Parameters:
[
  218
]
41 8.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  9540
]
42 8.82 ms
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.id = ?
Parameters:
[
  380
]
43 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  55750
]
44 9.96 ms
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.id = ?
Parameters:
[
  325
]
45 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  30016
]
46 5.06 ms
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.id = ?
Parameters:
[
  422
]
47 1.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  7174
]
48 2.01 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  3506
]
49 0.57 ms
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.id = ?
Parameters:
[
  301
]
50 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  47179
]
51 0.50 ms
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.id = ?
Parameters:
[
  416
]
52 1.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  5205
]
53 3.10 ms
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.id = ?
Parameters:
[
  360
]
54 1.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  44534
]
55 1.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  30054
]
56 9.95 ms
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.id = ?
Parameters:
[
  340
]
57 1.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  53144
]
58 8.03 ms
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.id = ?
Parameters:
[
  429
]
59 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  21639
]
60 0.63 ms
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.id = ?
Parameters:
[
  308
]
61 3.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  44185
]
62 0.37 ms
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.id = ?
Parameters:
[
  185
]
63 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  51156
]
64 9.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  48773
]
65 1.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  5110
]
66 0.86 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  51913
]
67 1.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  45526
]
68 9.04 ms
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.id = ?
Parameters:
[
  229
]
69 6.94 ms
SELECT v0_.id AS id_0, v0_.create_at AS create_at_1, v0_.end_at AS end_at_2, v0_.vehicle_id AS vehicle_id_3 FROM vehicle_tip v0_ LEFT JOIN vehicle v1_ ON v0_.vehicle_id = v1_.id WHERE v1_.visible = 1 ORDER BY RAND() ASC LIMIT 4
Parameters:
[]
70 10.30 ms
SELECT t0.id AS id_1, t0.id_import AS id_import_2, t0.visible AS visible_3, t0.create_at AS create_at_4, t0.hidden_at AS hidden_at_5, t0.seo_slug AS seo_slug_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_h1 AS seo_h1_9, t0.url_generated_at AS url_generated_at_10, t0.vin AS vin_11, t0.places AS places_12, t0.doors AS doors_13, t0.load_capacity AS load_capacity_14, t0.total_weight AS total_weight_15, t0.state AS state_16, t0.mileage AS mileage_17, t0.mileage_unit AS mileage_unit_18, t0.made_date AS made_date_19, t0.price AS price_20, t0.vat AS vat_21, t0.price_before AS price_before_22, t0.price_leasing AS price_leasing_23, t0.payment_leasing_count AS payment_leasing_count_24, t0.eco_vat AS eco_vat_25, t0.engine_volume AS engine_volume_26, t0.stk_to AS stk_to_27, t0.first_owner AS first_owner_28, t0.service_book AS service_book_29, t0.tuning AS tuning_30, t0.note AS note_31, t0.engine_power AS engine_power_32, t0.type AS type_33, t0.not_crashed AS not_crashed_34, t0.financial_info AS financial_info_35, t0.payment_leasing AS payment_leasing_36, t0.gearbox AS gearbox_37, t0.category_id AS category_id_38, t0.kind_id AS kind_id_39, t0.sub_kind_id AS sub_kind_id_40, t0.model_id AS model_id_41, t0.body_id AS body_id_42, t0.color_id AS color_id_43, t0.fuel_id AS fuel_id_44, t0.condition_vehicle_id AS condition_vehicle_id_45, t0.part_kind_id AS part_kind_id_46, t0.manufacturer_id AS manufacturer_id_47, t48.id AS id_49, t48.create_at AS create_at_50, t48.end_at AS end_at_51, t48.vehicle_id AS vehicle_id_52, t0.dealer_id AS dealer_id_53 FROM vehicle t0 LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id WHERE t0.id = ?
Parameters:
[
  39669
]
71 21.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  39669
]
72 11.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = ?
Parameters:
[
  993
]
73 4.67 ms
SELECT t0.id AS id_1, t0.id_import AS id_import_2, t0.visible AS visible_3, t0.create_at AS create_at_4, t0.hidden_at AS hidden_at_5, t0.seo_slug AS seo_slug_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_h1 AS seo_h1_9, t0.url_generated_at AS url_generated_at_10, t0.vin AS vin_11, t0.places AS places_12, t0.doors AS doors_13, t0.load_capacity AS load_capacity_14, t0.total_weight AS total_weight_15, t0.state AS state_16, t0.mileage AS mileage_17, t0.mileage_unit AS mileage_unit_18, t0.made_date AS made_date_19, t0.price AS price_20, t0.vat AS vat_21, t0.price_before AS price_before_22, t0.price_leasing AS price_leasing_23, t0.payment_leasing_count AS payment_leasing_count_24, t0.eco_vat AS eco_vat_25, t0.engine_volume AS engine_volume_26, t0.stk_to AS stk_to_27, t0.first_owner AS first_owner_28, t0.service_book AS service_book_29, t0.tuning AS tuning_30, t0.note AS note_31, t0.engine_power AS engine_power_32, t0.type AS type_33, t0.not_crashed AS not_crashed_34, t0.financial_info AS financial_info_35, t0.payment_leasing AS payment_leasing_36, t0.gearbox AS gearbox_37, t0.category_id AS category_id_38, t0.kind_id AS kind_id_39, t0.sub_kind_id AS sub_kind_id_40, t0.model_id AS model_id_41, t0.body_id AS body_id_42, t0.color_id AS color_id_43, t0.fuel_id AS fuel_id_44, t0.condition_vehicle_id AS condition_vehicle_id_45, t0.part_kind_id AS part_kind_id_46, t0.manufacturer_id AS manufacturer_id_47, t48.id AS id_49, t48.create_at AS create_at_50, t48.end_at AS end_at_51, t48.vehicle_id AS vehicle_id_52, t0.dealer_id AS dealer_id_53 FROM vehicle t0 LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id WHERE t0.id = ?
Parameters:
[
  25932
]
74 14.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  25932
]
75 10.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = ?
Parameters:
[
  109
]
76 12.74 ms
SELECT t0.id AS id_1, t0.id_import AS id_import_2, t0.visible AS visible_3, t0.create_at AS create_at_4, t0.hidden_at AS hidden_at_5, t0.seo_slug AS seo_slug_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_h1 AS seo_h1_9, t0.url_generated_at AS url_generated_at_10, t0.vin AS vin_11, t0.places AS places_12, t0.doors AS doors_13, t0.load_capacity AS load_capacity_14, t0.total_weight AS total_weight_15, t0.state AS state_16, t0.mileage AS mileage_17, t0.mileage_unit AS mileage_unit_18, t0.made_date AS made_date_19, t0.price AS price_20, t0.vat AS vat_21, t0.price_before AS price_before_22, t0.price_leasing AS price_leasing_23, t0.payment_leasing_count AS payment_leasing_count_24, t0.eco_vat AS eco_vat_25, t0.engine_volume AS engine_volume_26, t0.stk_to AS stk_to_27, t0.first_owner AS first_owner_28, t0.service_book AS service_book_29, t0.tuning AS tuning_30, t0.note AS note_31, t0.engine_power AS engine_power_32, t0.type AS type_33, t0.not_crashed AS not_crashed_34, t0.financial_info AS financial_info_35, t0.payment_leasing AS payment_leasing_36, t0.gearbox AS gearbox_37, t0.category_id AS category_id_38, t0.kind_id AS kind_id_39, t0.sub_kind_id AS sub_kind_id_40, t0.model_id AS model_id_41, t0.body_id AS body_id_42, t0.color_id AS color_id_43, t0.fuel_id AS fuel_id_44, t0.condition_vehicle_id AS condition_vehicle_id_45, t0.part_kind_id AS part_kind_id_46, t0.manufacturer_id AS manufacturer_id_47, t48.id AS id_49, t48.create_at AS create_at_50, t48.end_at AS end_at_51, t48.vehicle_id AS vehicle_id_52, t0.dealer_id AS dealer_id_53 FROM vehicle t0 LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id WHERE t0.id = ?
Parameters:
[
  10722
]
77 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  10722
]
78 8.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = ?
Parameters:
[
  331
]
79 7.71 ms
SELECT t0.id AS id_1, t0.id_import AS id_import_2, t0.visible AS visible_3, t0.create_at AS create_at_4, t0.hidden_at AS hidden_at_5, t0.seo_slug AS seo_slug_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_h1 AS seo_h1_9, t0.url_generated_at AS url_generated_at_10, t0.vin AS vin_11, t0.places AS places_12, t0.doors AS doors_13, t0.load_capacity AS load_capacity_14, t0.total_weight AS total_weight_15, t0.state AS state_16, t0.mileage AS mileage_17, t0.mileage_unit AS mileage_unit_18, t0.made_date AS made_date_19, t0.price AS price_20, t0.vat AS vat_21, t0.price_before AS price_before_22, t0.price_leasing AS price_leasing_23, t0.payment_leasing_count AS payment_leasing_count_24, t0.eco_vat AS eco_vat_25, t0.engine_volume AS engine_volume_26, t0.stk_to AS stk_to_27, t0.first_owner AS first_owner_28, t0.service_book AS service_book_29, t0.tuning AS tuning_30, t0.note AS note_31, t0.engine_power AS engine_power_32, t0.type AS type_33, t0.not_crashed AS not_crashed_34, t0.financial_info AS financial_info_35, t0.payment_leasing AS payment_leasing_36, t0.gearbox AS gearbox_37, t0.category_id AS category_id_38, t0.kind_id AS kind_id_39, t0.sub_kind_id AS sub_kind_id_40, t0.model_id AS model_id_41, t0.body_id AS body_id_42, t0.color_id AS color_id_43, t0.fuel_id AS fuel_id_44, t0.condition_vehicle_id AS condition_vehicle_id_45, t0.part_kind_id AS part_kind_id_46, t0.manufacturer_id AS manufacturer_id_47, t48.id AS id_49, t48.create_at AS create_at_50, t48.end_at AS end_at_51, t48.vehicle_id AS vehicle_id_52, t0.dealer_id AS dealer_id_53 FROM vehicle t0 LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id WHERE t0.id = ?
Parameters:
[
  47157
]
80 8.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
  47157
]
81 11.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = ?
Parameters:
[
  1162
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.