GET https://test.autanet.cz/autobazar/motortec-spol-s-r-o-3184

Query Metrics

30 Database Queries
14 Different statements
111.90 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.23 ms
(18.08%)
4
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
]
17.27 ms
(15.43%)
2
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
]
15.98 ms
(14.28%)
1
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:
[
  314
  "2026-09-17 15:38:36"
  "2026-09-17 15:38:36"
]
12.31 ms
(11.00%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = ?
Parameters:
[
  76
]
11.54 ms
(10.32%)
5
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:
[
  55928
]
10.58 ms
(9.46%)
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 = ? LIMIT 1
Parameters:
[
  "motortec-spol-s-r-o-3184"
]
8.82 ms
(7.88%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  12
]
7.22 ms
(6.45%)
1
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 WHERE t0.id = ?
Parameters:
[
  54
]
1.91 ms
(1.71%)
3
SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_fuel t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.75 ms
(1.56%)
1
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.first_seen_at AS first_seen_at_6, t0.last_seen_at AS last_seen_at_7, t0.seo_slug AS seo_slug_8, t0.seo_title AS seo_title_9, t0.seo_description AS seo_description_10, t0.seo_h1 AS seo_h1_11, t0.url_generated_at AS url_generated_at_12, t0.vin AS vin_13, t0.places AS places_14, t0.doors AS doors_15, t0.load_capacity AS load_capacity_16, t0.total_weight AS total_weight_17, t0.state AS state_18, t0.mileage AS mileage_19, t0.mileage_unit AS mileage_unit_20, t0.made_date AS made_date_21, t0.price AS price_22, t0.vat AS vat_23, t0.price_before AS price_before_24, t0.price_leasing AS price_leasing_25, t0.payment_leasing_count AS payment_leasing_count_26, t0.eco_vat AS eco_vat_27, t0.engine_volume AS engine_volume_28, t0.stk_to AS stk_to_29, t0.first_owner AS first_owner_30, t0.service_book AS service_book_31, t0.tuning AS tuning_32, t0.note AS note_33, t0.engine_power AS engine_power_34, t0.type AS type_35, t0.not_crashed AS not_crashed_36, t0.financial_info AS financial_info_37, t0.payment_leasing AS payment_leasing_38, t0.gearbox AS gearbox_39, t0.category_id AS category_id_40, t0.kind_id AS kind_id_41, t0.sub_kind_id AS sub_kind_id_42, t0.model_id AS model_id_43, t0.body_id AS body_id_44, t0.color_id AS color_id_45, t0.fuel_id AS fuel_id_46, t0.condition_vehicle_id AS condition_vehicle_id_47, t0.part_kind_id AS part_kind_id_48, t0.manufacturer_id AS manufacturer_id_49, t50.id AS id_51, t50.create_at AS create_at_52, t50.end_at AS end_at_53, t50.vehicle_id AS vehicle_id_54, t50.autanet_partner_id AS autanet_partner_id_55, t0.dealer_id AS dealer_id_56 FROM vehicle t0 LEFT JOIN vehicle_tip t50 ON t50.vehicle_id = t0.id WHERE t0.dealer_id = ? AND t0.visible = ? ORDER BY t0.create_at DESC LIMIT 5
Parameters:
[
  314
  1
]
1.69 ms
(1.51%)
1
SELECT t0.id AS id_1, t0.day AS day_2, t0.summer AS summer_3, t0.description AS description_4, t0.dealer_id AS dealer_id_5 FROM dealer_open_hour t0 WHERE t0.dealer_id = ? AND t0.summer = ?
Parameters:
[
  314
  "1"
]
1.22 ms
(1.09%)
4
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:
[
  14
]
0.95 ms
(0.84%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.dealer_id AS dealer_id_3 FROM dealer_phone t0 WHERE t0.dealer_id = ?
Parameters:
[
  314
]
0.43 ms
(0.38%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.dealer_id AS dealer_id_4 FROM dealer_image t0 WHERE t0.dealer_id = ? ORDER BY t0.main DESC
Parameters:
[
  314
]

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.