Query Metrics
43
Database Queries
10
Different statements
606.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 11.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM blog_kind t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"novinky"
]
|
| 2 | 420.60 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.description AS description_3, b0_.text AS text_4, b0_.keyword AS keyword_5, b0_.text_source AS text_source_6, b0_.visible AS visible_7, b0_.visible_homepage AS visible_homepage_8, b0_.create_at AS create_at_9, b0_.import_id AS import_id_10, b0_.top AS top_11, b0_.redirect AS redirect_12, b0_.main_kind_id AS main_kind_id_13, b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14, b0_.vehicle_model_id AS vehicle_model_id_15 FROM blog b0_ LEFT JOIN blog_blog_kind b2_ ON b0_.id = b2_.blog_id LEFT JOIN blog_kind b1_ ON b1_.id = b2_.blog_kind_id WHERE b1_.url = ? AND b0_.visible = 1 AND b0_.create_at <= ? ORDER BY b0_.create_at DESC
Parameters:
[ "novinky" "2025-12-16 10:40:39" ] |
| 3 | 9.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4930
]
|
| 4 | 1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4929
]
|
| 5 | 0.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4926
]
|
| 6 | 5.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4923
]
|
| 7 | 3.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4922
]
|
| 8 | 1.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4917
]
|
| 9 | 0.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4916
]
|
| 10 | 1.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4910
]
|
| 11 | 1.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4908
]
|
| 12 | 0.82 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4907
]
|
| 13 | 0.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4903
]
|
| 14 | 1.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4899
]
|
| 15 | 4.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4898
]
|
| 16 | 0.93 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4897
]
|
| 17 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4894
]
|
| 18 | 0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4889
]
|
| 19 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4885
]
|
| 20 | 1.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4881
]
|
| 21 | 0.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4880
]
|
| 22 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4876
]
|
| 23 | 17.77 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.description AS description_3, b0_.text AS text_4, b0_.keyword AS keyword_5, b0_.text_source AS text_source_6, b0_.visible AS visible_7, b0_.visible_homepage AS visible_homepage_8, b0_.create_at AS create_at_9, b0_.import_id AS import_id_10, b0_.top AS top_11, b0_.redirect AS redirect_12, b0_.main_kind_id AS main_kind_id_13, b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14, b0_.vehicle_model_id AS vehicle_model_id_15 FROM blog b0_ WHERE b0_.visible <> 0 AND b0_.top = 1 ORDER BY b0_.create_at DESC
Parameters:
[] |
| 24 | 2.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4981
]
|
| 25 | 26.49 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:
[] |
| 26 | 18.41 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:
[
12805
]
|
| 27 | 1.02 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:
[
12805
]
|
| 28 | 6.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = ?
Parameters:
[
32
]
|
| 29 | 16.43 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:
[
200
]
|
| 30 | 0.44 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
]
|
| 31 | 0.38 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
]
|
| 32 | 1.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = ?
Parameters:
[
47
]
|
| 33 | 0.59 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
]
|
| 34 | 0.69 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
]
|
| 35 | 4.72 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
]
|
| 36 | 1.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = ?
Parameters:
[
182
]
|
| 37 | 0.50 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
]
|
| 38 | 0.63 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
]
|
| 39 | 1.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:
[
25932
]
|
| 40 | 13.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 41 | 0.52 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
]
|
| 42 | 6.37 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 ] |
| 43 | 14.95 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\BlogKind | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\VehicleManufacturer | No errors. |
| App\Entity\VehicleModel | No errors. |
| App\Entity\BlogImage | No errors. |
| App\Entity\Vehicle | No errors. |
| App\Entity\VehicleTip | No errors. |
| App\Entity\VehicleCategory | No errors. |
| App\Entity\VehicleKind | No errors. |
| App\Entity\VehicleSubKind | 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\Dealer | No errors. |
| App\Entity\VehicleFinancial | No errors. |
| App\Entity\VehicleEquipment | No errors. |
| App\Entity\VehicleImage | No errors. |
| App\Entity\VehicleForm | No errors. |
| App\Entity\DealerImage | No errors. |
| App\Entity\DealerPhone | No errors. |
| App\Entity\DealerOpenHour | No errors. |
| App\Entity\District | No errors. |
| App\Entity\DealerImport | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Region | No errors. |