Query Metrics
69
Database Queries
17
Different statements
2482.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.32 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 | 8.13 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 = ?
Parameters:
[
1
]
|
| 3 | 1840.32 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 = ? 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 OFFSET 13240
Parameters:
[
1
]
|
| 4 | 46.26 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_.first_seen_at AS first_seen_at_5, v0_.last_seen_at AS last_seen_at_6, v0_.seo_slug AS seo_slug_7, v0_.seo_title AS seo_title_8, v0_.seo_description AS seo_description_9, v0_.seo_h1 AS seo_h1_10, v0_.url_generated_at AS url_generated_at_11, v0_.vin AS vin_12, v0_.places AS places_13, v0_.doors AS doors_14, v0_.load_capacity AS load_capacity_15, v0_.total_weight AS total_weight_16, v0_.state AS state_17, v0_.mileage AS mileage_18, v0_.mileage_unit AS mileage_unit_19, v0_.made_date AS made_date_20, v0_.price AS price_21, v0_.vat AS vat_22, v0_.price_before AS price_before_23, v0_.price_leasing AS price_leasing_24, v0_.payment_leasing_count AS payment_leasing_count_25, v0_.eco_vat AS eco_vat_26, v0_.engine_volume AS engine_volume_27, v0_.stk_to AS stk_to_28, v0_.first_owner AS first_owner_29, v0_.service_book AS service_book_30, v0_.tuning AS tuning_31, v0_.note AS note_32, v0_.engine_power AS engine_power_33, v0_.type AS type_34, v0_.not_crashed AS not_crashed_35, v0_.financial_info AS financial_info_36, v0_.payment_leasing AS payment_leasing_37, v0_.gearbox AS gearbox_38, v0_.category_id AS category_id_39, v0_.kind_id AS kind_id_40, v0_.sub_kind_id AS sub_kind_id_41, v0_.model_id AS model_id_42, v0_.body_id AS body_id_43, v0_.color_id AS color_id_44, v0_.fuel_id AS fuel_id_45, v0_.condition_vehicle_id AS condition_vehicle_id_46, v0_.part_kind_id AS part_kind_id_47, v0_.manufacturer_id AS manufacturer_id_48, v0_.dealer_id AS dealer_id_49 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_.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 29927 10872 25845 27829 10875 31833 55283 47805 52265 26441 53996 10812 50288 53994 48786 39019 17065 30298 55277 39768 ] |
| 5 | 13.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
29927
]
|
| 6 | 3.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
10872
]
|
| 7 | 3.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
25845
]
|
| 8 | 0.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
10875
]
|
| 9 | 6.10 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
27829
]
|
| 10 | 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
31833
]
|
| 11 | 9.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
55283
]
|
| 12 | 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
47805
]
|
| 13 | 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
26441
]
|
| 14 | 2.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
52265
]
|
| 15 | 20.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
53996
]
|
| 16 | 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
10812
]
|
| 17 | 3.73 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
50288
]
|
| 18 | 4.67 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
53994
]
|
| 19 | 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
48786
]
|
| 20 | 3.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
39019
]
|
| 21 | 7.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
17065
]
|
| 22 | 9.01 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
30298
]
|
| 23 | 0.40 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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
55277
]
|
| 24 | 0.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, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
39768
]
|
| 25 | 6.15 ms |
SELECT a0_.id AS id_0, a0_.valid_from AS valid_from_1, a0_.valid_to AS valid_to_2, a0_.created_at AS created_at_3, a0_.dealer_id AS dealer_id_4 FROM autanet_partner a0_ WHERE a0_.dealer_id = ? AND a0_.valid_from <= ? AND a0_.valid_to >= ? ORDER BY a0_.valid_from DESC LIMIT 1
Parameters:
[ 297 "2026-09-17 12:07:20" "2026-09-17 12:07:20" ] |
| 26 | 134.73 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:
[] |
| 27 | 6.09 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
]
|
| 28 | 27.36 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 = ? ORDER BY v0_.name ASC
Parameters:
[
1
]
|
| 29 | 5.29 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:
[] |
| 30 | 19.83 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:
[] |
| 31 | 4.49 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:
[] |
| 32 | 2.54 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:
[] |
| 33 | 6.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:
[
29927
]
|
| 34 | 17.98 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:
[
1428
]
|
| 35 | 3.31 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:
[
297
]
|
| 36 | 6.58 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:
[
10872
]
|
| 37 | 4.34 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:
[
1508
]
|
| 38 | 3.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:
[
25845
]
|
| 39 | 23.30 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:
[
1171
]
|
| 40 | 0.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:
[
10875
]
|
| 41 | 9.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:
[
27829
]
|
| 42 | 4.08 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:
[
368
]
|
| 43 | 3.44 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:
[
31833
]
|
| 44 | 5.99 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:
[
55283
]
|
| 45 | 9.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:
[
534
]
|
| 46 | 8.85 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:
[
47805
]
|
| 47 | 8.94 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:
[
26441
]
|
| 48 | 2.82 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:
[
1437
]
|
| 49 | 0.75 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:
[
52265
]
|
| 50 | 1.64 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:
[
1155
]
|
| 51 | 2.79 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:
[
53996
]
|
| 52 | 9.85 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:
[
1510
]
|
| 53 | 4.65 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:
[
10812
]
|
| 54 | 3.77 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:
[
530
]
|
| 55 | 9.53 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:
[
50288
]
|
| 56 | 8.23 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:
[
110
]
|
| 57 | 9.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:
[
53994
]
|
| 58 | 4.64 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:
[
1514
]
|
| 59 | 4.34 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:
[
48786
]
|
| 60 | 3.82 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:
[
39019
]
|
| 61 | 10.27 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:
[
528
]
|
| 62 | 4.28 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:
[
17065
]
|
| 63 | 17.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:
[
30298
]
|
| 64 | 11.96 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
]
|
| 65 | 6.47 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:
[
55277
]
|
| 66 | 9.24 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:
[
541
]
|
| 67 | 2.58 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:
[
39768
]
|
| 68 | 2.39 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:
[
120
]
|
| 69 | 28.30 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, v0_.autanet_partner_id AS autanet_partner_id_4 FROM vehicle_tip v0_ INNER JOIN vehicle v1_ ON v0_.vehicle_id = v1_.id LEFT JOIN autanet_partner a2_ ON v0_.autanet_partner_id = a2_.id WHERE v1_.visible = 1 AND v0_.end_at >= ? AND ((a2_.id IS NULL OR (a2_.valid_from <= ? AND a2_.valid_to >= ?)))
Parameters:
[ "2026-09-17 12:07:23" "2026-09-17 12:07:23" "2026-09-17 12:07:23" ] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\VehicleKind | No errors. |
| App\Entity\Vehicle | No errors. |
| App\Entity\Dealer | No errors. |
| App\Entity\VehicleManufacturer | No errors. |
| App\Entity\VehicleCategory | No errors. |
| App\Entity\VehicleSubKind | No errors. |
| App\Entity\VehicleModel | No errors. |
| App\Entity\VehicleBody | No errors. |
| App\Entity\VehicleColor | No errors. |
| App\Entity\VehicleFuel | No errors. |
| App\Entity\VehicleCondition | No errors. |
| App\Entity\VehiclePartKind | No errors. |
| App\Entity\VehicleFinancial | No errors. |
| App\Entity\VehicleEquipment | No errors. |
| App\Entity\VehicleImage | No errors. |
| App\Entity\VehicleTip | No errors. |
| App\Entity\AutanetPartner | No errors. |
| App\Entity\VehicleForm | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\District | No errors. |
| App\Entity\DealerImage | No errors. |
| App\Entity\DealerPhone | No errors. |
| App\Entity\DealerOpenHour | No errors. |
| App\Entity\DealerImport | No errors. |