Query Metrics
24
Database Queries
12
Different statements
193.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
37.65 ms (19.42%) |
7 |
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:
[
3230
]
|
|
27.50 ms (14.18%) |
3 |
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:
[
52372
]
|
|
26.25 ms (13.54%) |
1 |
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 = 1 AND b0_.visible_homepage = 1 AND b0_.create_at <= ? ORDER BY b0_.create_at DESC LIMIT 3
Parameters:
[
"2026-07-15 01:15:08"
]
|
|
25.77 ms (13.29%) |
3 |
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:
[
52372
]
|
|
22.81 ms (11.76%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM blog_kind t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
17.70 ms (9.13%) |
1 |
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:
[] |
|
11.57 ms (5.97%) |
1 |
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_.create_at >= ? AND b0_.id <> ? AND b0_.create_at <= ? AND b0_.vehicle_manufacturer_id = ? AND b0_.vehicle_model_id = ? ORDER BY RAND() ASC LIMIT 3
Parameters:
[ "2021-07-15 01:15:08" 3230 "2026-07-15 01:15:08" 161 1019 ] |
|
10.61 ms (5.47%) |
1 |
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 = 1 AND b0_.create_at <= ? AND b0_.url = ?
Parameters:
[ "2026-07-15 01:15:08" "autonews-video-k-testu-mini-cooper-s-5d-3327" ] |
|
6.94 ms (3.58%) |
1 |
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_ WHERE v0_.visible <> 0 AND v0_.manufacturer_id = ? AND v0_.model_id = ? ORDER BY RAND() ASC LIMIT 3
Parameters:
[ 161 1019 ] |
|
4.01 ms (2.07%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = ?
Parameters:
[
161
]
|
|
2.71 ms (1.40%) |
1 |
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:
[
"autonews-video-k-testu-mini-cooper-s-5d-3327"
]
|
|
0.36 ms (0.19%) |
1 |
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:
[
1019
]
|
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\Blog | No errors. |
| App\Entity\BlogKind | No errors. |
| App\Entity\VehicleManufacturer | No errors. |
| App\Entity\VehicleModel | No errors. |
| App\Entity\BlogImage | No errors. |
| App\Entity\Vehicle | No errors. |
| App\Entity\VehicleCategory | 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\VehicleTip | No errors. |
| App\Entity\VehicleForm | No errors. |