GET https://test.autanet.cz/autobazar/abb-auto-3231/vozidla?page=4

Query Metrics

95 Database Queries
9 Different statements
329.32 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 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.url = ? LIMIT 1
Parameters:
[
  "abb-auto-3231"
]
2 22.02 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_.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
Parameters:
[
  "340"
]
3 10.45 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:
[
  24133
]
4 0.53 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:
[
  51871
]
5 0.32 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:
[
  41737
]
6 7.28 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:
[
  6561
]
7 0.62 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
]
8 0.29 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:
[
  52802
]
9 0.28 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:
[
  16537
]
10 6.03 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:
[
  54758
]
11 0.57 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:
[
  6517
]
12 3.06 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:
[
  6519
]
13 0.38 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:
[
  52479
]
14 0.93 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:
[
  32066
]
15 0.28 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:
[
  42311
]
16 17.88 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:
[
  50215
]
17 4.28 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:
[
  54606
]
18 0.33 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:
[
  56376
]
19 2.61 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:
[
  44118
]
20 0.14 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:
[
  45007
]
21 0.12 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:
[
  54570
]
22 0.27 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:
[
  49547
]
23 3.03 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:
[
  8808
]
24 7.35 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:
[
  48407
]
25 0.85 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:
[
  48842
]
26 0.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:
[
  55080
]
27 3.27 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:
[
  6551
]
28 2.24 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:
[
  6541
]
29 2.11 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:
[
  53531
]
30 0.50 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:
[
  32234
]
31 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:
[
  32354
]
32 3.45 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:
[
  6554
]
33 0.31 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:
[
  41964
]
34 0.14 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:
[
  49010
]
35 5.11 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:
[
  36865
]
36 7.13 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:
[
  54254
]
37 16.68 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:
[
  54853
]
38 1.54 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:
[
  32248
]
39 0.50 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:
[
  6529
]
40 0.33 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:
[
  25835
]
41 3.49 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:
[
  34540
]
42 4.28 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:
[
  6522
]
43 1.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:
[
  8123
]
44 0.59 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:
[
  48818
]
45 0.36 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:
[
  30585
]
46 9.06 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:
[
  52846
]
47 0.66 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:
[
  47489
]
48 0.46 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:
[
  53017
]
49 0.32 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:
[
  53407
]
50 1.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:
[
  6515
]
51 3.26 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:
[
  6511
]
52 0.83 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:
[
  27255
]
53 2.13 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:
[
  54904
]
54 0.77 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:
[
  56119
]
55 1.07 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:
[
  31575
]
56 0.35 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:
[
  50746
]
57 5.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:
[
  6520
]
58 0.15 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:
[
  43680
]
59 0.48 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:
[
  6531
]
60 0.38 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:
[
  46071
]
61 10.37 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:
[
  52387
]
62 9.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:
[
  25257
]
63 2.87 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:
[
  54410
]
64 3.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:
[
  6534
]
65 7.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:
[
  55260
]
66 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:
[
  35424
]
67 0.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:
[
  53574
]
68 0.41 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:
[
  6546
]
69 0.31 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:
[
  6524
]
70 0.33 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:
[
  8013
]
71 0.14 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:
[
  15857
]
72 1.53 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:
[
  52245
]
73 3.59 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:
[
  6559
]
74 6.38 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:
[
  35385
]
75 12.77 ms
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
Parameters:
[
  340
]
76 0.70 ms
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
Parameters:
[
  340
]
77 11.97 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 WHERE v1_.dealer_id = ? AND v1_.visible = 1 ORDER BY v0_.name ASC
Parameters:
[
  340
]
78 0.32 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:
[
  41964
]
79 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_fuel t0 WHERE t0.id = ?
Parameters:
[
  1
]
80 2.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_body t0 WHERE t0.id = ?
Parameters:
[
  86
]
81 19.73 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:
[
  49010
]
82 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_fuel t0 WHERE t0.id = ?
Parameters:
[
  3
]
83 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_body t0 WHERE t0.id = ?
Parameters:
[
  7
]
84 0.46 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:
[
  36865
]
85 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_body t0 WHERE t0.id = ?
Parameters:
[
  8
]
86 8.90 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:
[
  54254
]
87 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_body t0 WHERE t0.id = ?
Parameters:
[
  3
]
88 0.14 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:
[
  54853
]
89 0.61 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:
[
  32248
]
90 0.39 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:
[
  6529
]
91 15.35 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:
[
  25835
]
92 0.55 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:
[
  34540
]
93 0.42 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:
[
  6522
]
94 30.77 ms
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
Parameters:
[
  1
  1
]
95 0.22 ms
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
Parameters:
[
  1
  0
]

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.