Query Metrics
34
Database Queries
11
Different statements
17.84 ms
Query time
0
Invalid entities
1600
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.24 ms (34.98%) |
20 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.photo AS photo_5, t0.photo_real_name AS photo_real_name_6, t0.auto_id AS auto_id_7 FROM foto t0 WHERE t0.auto_id = ?
Parameters:
[
289
]
|
|
3.00 ms (16.80%) |
1 |
SELECT a0_.id AS id_0, a0_.save_date AS save_date_1, a0_.title AS title_2, a0_.number_of_visit AS number_of_visit_3, a0_.updated_at AS updated_at_4, a0_.vin AS vin_5, a0_.id_advert AS id_advert_6, a0_.price AS price_7, a0_.year AS year_8, a0_.power AS power_9, a0_.gearbox AS gearbox_10, a0_.first_owner AS first_owner_11, a0_.no_crash AS no_crash_12, a0_.service_aso AS service_aso_13, a0_.tuning AS tuning_14, a0_.invoice_vatmargin AS invoice_vatmargin_15, a0_.invoice_vat AS invoice_vat_16, a0_.auto_demo AS auto_demo_17, a0_.warranty_factory AS warranty_factory_18, a0_.warranty_dealer AS warranty_dealer_19, a0_.color AS color_20, a0_.mileage AS mileage_21, a0_.engine_capacity AS engine_capacity_22, a0_.fuel AS fuel_23, a0_.new AS new_24, a0_.price_currency AS price_currency_25, a0_.origin_country AS origin_country_26, a0_.polish_register AS polish_register_27, a0_.description AS description_28, a0_.video1 AS video1_29, a0_.video2 AS video2_30, a0_.video3 AS video3_31, a0_.video4 AS video4_32, a0_.fotom AS fotom_33, a0_.eq_abs AS eq_abs_34, a0_.eq_cd AS eq_cd_35, a0_.eq_central_lock AS eq_central_lock_36, a0_.eq_front_electric_windows AS eq_front_electric_windows_37, a0_.eq_electronic_rear_view_mirrors AS eq_electronic_rear_view_mirrors_38, a0_.eq_immobiliser AS eq_immobiliser_39, a0_.eq_front_airbags AS eq_front_airbags_40, a0_.eq_front_passenger_airbags AS eq_front_passenger_airbags_41, a0_.eq_original_radio AS eq_original_radio_42, a0_.eq_assisted_steering AS eq_assisted_steering_43, a0_.eq_alarm AS eq_alarm_44, a0_.eq_alloy_wheels AS eq_alloy_wheels_45, a0_.eq_asr AS eq_asr_46, a0_.eq_park_assist AS eq_park_assist_47, a0_.eq_lane_assist AS eq_lane_assist_48, a0_.eq_bluetooth AS eq_bluetooth_49, a0_.eq_automatic_wipers AS eq_automatic_wipers_50, a0_.eq_blind_spot_sensor AS eq_blind_spot_sensor_51, a0_.eq_automatic_lights AS eq_automatic_lights_52, a0_.eq_both_parking_sensors AS eq_both_parking_sensors_53, a0_.eq_rear_parking_sensors AS eq_rear_parking_sensors_54, a0_.eq_panoramic_sunroof AS eq_panoramic_sunroof_55, a0_.eq_electric_exterior_mirror AS eq_electric_exterior_mirror_56, a0_.eq_electric_interior_mirror AS eq_electric_interior_mirror_57, a0_.eq_rear_electric_windows AS eq_rear_electric_windows_58, a0_.eq_electric_adjustable_seats AS eq_electric_adjustable_seats_59, a0_.eq_esp AS eq_esp_60, a0_.eq_aux_in AS eq_aux_in_61, a0_.eq_sdsocket AS eq_sdsocket_62, a0_.eq_usbsocket AS eq_usbsocket_63, a0_.eq_towing_hook AS eq_towing_hook_64, a0_.eq_head_display AS eq_head_display_65, a0_.eq_isofix AS eq_isofix_66, a0_.eq_rearview_camera AS eq_rearview_camera_67, a0_.eq_automatic_air_conditioning AS eq_automatic_air_conditioning_68, a0_.eq_onboard_computer AS eq_onboard_computer_69, a0_.eq_side_window_airbags AS eq_side_window_airbags_70, a0_.eq_shift_paddles AS eq_shift_paddles_71, a0_.eq_mp3 AS eq_mp3_72, a0_.eq_gps AS eq_gps_73, a0_.eq_dvd AS eq_dvd_74, a0_.eq_speed_limiter AS eq_speed_limiter_75, a0_.eq_auxiliary_heating AS eq_auxiliary_heating_76, a0_.eq_heated_windshield AS eq_heated_windshield_77, a0_.eq_heated_rearview_mirrors AS eq_heated_rearview_mirrors_78, a0_.eq_front_heated_seats AS eq_front_heated_seats_79, a0_.eq_rear_heated_seats AS eq_rear_heated_seats_80, a0_.eq_driver_knee_airbag AS eq_driver_knee_airbag_81, a0_.eq_front_side_airbags AS eq_front_side_airbags_82, a0_.eq_rear_passenger_airbags AS eq_rear_passenger_airbags_83, a0_.eq_tinted_windows AS eq_tinted_windows_84, a0_.eq_radio AS eq_radio_85, a0_.eq_adjustable_suspension AS eq_adjustable_suspension_86, a0_.eq_roof_bars AS eq_roof_bars_87, a0_.eq_system_start_stop AS eq_system_start_stop_88, a0_.eq_sunroof AS eq_sunroof_89, a0_.eq_daytime_lights AS eq_daytime_lights_90, a0_.eq_leds AS eq_leds_91, a0_.eq_fog_lights AS eq_fog_lights_92, a0_.eq_xenon_lights AS eq_xenon_lights_93, a0_.eq_leather_interior AS eq_leather_interior_94, a0_.eq_velour_interior AS eq_velour_interior_95, a0_.eq_cruise_control AS eq_cruise_control_96, a0_.eq_active_cruise_control AS eq_active_cruise_control_97, a0_.eq_tv AS eq_tv_98, a0_.eq_steering_whell_commands AS eq_steering_whell_commands_99, a0_.eq_virtual_cocpit AS eq_virtual_cocpit_100, a0_.photo AS photo_101, a0_.photo_real_name AS photo_real_name_102, a0_.dealer_id AS dealer_id_103, a0_.make_id AS make_id_104, a0_.model_id AS model_id_105 FROM auto a0_ INNER JOIN dealer d1_ ON a0_.dealer_id = d1_.id INNER JOIN district d2_ ON d1_.district_id = d2_.id WHERE d1_.active = ? ORDER BY a0_.id DESC
Parameters:
[
1
]
|
|
2.84 ms (15.94%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.make_id AS make_id_3 FROM model t0 ORDER BY t0.name ASC
Parameters:
[] |
|
1.52 ms (8.49%) |
5 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.city AS city_4, t0.postal_code AS postal_code_5, t0.phone AS phone_6, t0.open_time AS open_time_7, t0.whole_poland AS whole_poland_8, t0.email AS email_9, t0.url AS url_10, t0.foto AS foto_11, t0.nip AS nip_12, t0.description AS description_13, t0.facebook AS facebook_14, t0.active AS active_15, t0.group_id AS group_id_16, t0.district_id AS district_id_17 FROM dealer t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.81 ms (4.52%) |
1 |
SELECT t0.id AS id_1, t0.save_date AS save_date_2, t0.title AS title_3, t0.number_of_visit AS number_of_visit_4, t0.updated_at AS updated_at_5, t0.vin AS vin_6, t0.id_advert AS id_advert_7, t0.price AS price_8, t0.year AS year_9, t0.power AS power_10, t0.gearbox AS gearbox_11, t0.first_owner AS first_owner_12, t0.no_crash AS no_crash_13, t0.service_aso AS service_aso_14, t0.tuning AS tuning_15, t0.invoice_vatmargin AS invoice_vatmargin_16, t0.invoice_vat AS invoice_vat_17, t0.auto_demo AS auto_demo_18, t0.warranty_factory AS warranty_factory_19, t0.warranty_dealer AS warranty_dealer_20, t0.color AS color_21, t0.mileage AS mileage_22, t0.engine_capacity AS engine_capacity_23, t0.fuel AS fuel_24, t0.new AS new_25, t0.price_currency AS price_currency_26, t0.origin_country AS origin_country_27, t0.polish_register AS polish_register_28, t0.description AS description_29, t0.video1 AS video1_30, t0.video2 AS video2_31, t0.video3 AS video3_32, t0.video4 AS video4_33, t0.fotom AS fotom_34, t0.eq_abs AS eq_abs_35, t0.eq_cd AS eq_cd_36, t0.eq_central_lock AS eq_central_lock_37, t0.eq_front_electric_windows AS eq_front_electric_windows_38, t0.eq_electronic_rear_view_mirrors AS eq_electronic_rear_view_mirrors_39, t0.eq_immobiliser AS eq_immobiliser_40, t0.eq_front_airbags AS eq_front_airbags_41, t0.eq_front_passenger_airbags AS eq_front_passenger_airbags_42, t0.eq_original_radio AS eq_original_radio_43, t0.eq_assisted_steering AS eq_assisted_steering_44, t0.eq_alarm AS eq_alarm_45, t0.eq_alloy_wheels AS eq_alloy_wheels_46, t0.eq_asr AS eq_asr_47, t0.eq_park_assist AS eq_park_assist_48, t0.eq_lane_assist AS eq_lane_assist_49, t0.eq_bluetooth AS eq_bluetooth_50, t0.eq_automatic_wipers AS eq_automatic_wipers_51, t0.eq_blind_spot_sensor AS eq_blind_spot_sensor_52, t0.eq_automatic_lights AS eq_automatic_lights_53, t0.eq_both_parking_sensors AS eq_both_parking_sensors_54, t0.eq_rear_parking_sensors AS eq_rear_parking_sensors_55, t0.eq_panoramic_sunroof AS eq_panoramic_sunroof_56, t0.eq_electric_exterior_mirror AS eq_electric_exterior_mirror_57, t0.eq_electric_interior_mirror AS eq_electric_interior_mirror_58, t0.eq_rear_electric_windows AS eq_rear_electric_windows_59, t0.eq_electric_adjustable_seats AS eq_electric_adjustable_seats_60, t0.eq_esp AS eq_esp_61, t0.eq_aux_in AS eq_aux_in_62, t0.eq_sdsocket AS eq_sdsocket_63, t0.eq_usbsocket AS eq_usbsocket_64, t0.eq_towing_hook AS eq_towing_hook_65, t0.eq_head_display AS eq_head_display_66, t0.eq_isofix AS eq_isofix_67, t0.eq_rearview_camera AS eq_rearview_camera_68, t0.eq_automatic_air_conditioning AS eq_automatic_air_conditioning_69, t0.eq_onboard_computer AS eq_onboard_computer_70, t0.eq_side_window_airbags AS eq_side_window_airbags_71, t0.eq_shift_paddles AS eq_shift_paddles_72, t0.eq_mp3 AS eq_mp3_73, t0.eq_gps AS eq_gps_74, t0.eq_dvd AS eq_dvd_75, t0.eq_speed_limiter AS eq_speed_limiter_76, t0.eq_auxiliary_heating AS eq_auxiliary_heating_77, t0.eq_heated_windshield AS eq_heated_windshield_78, t0.eq_heated_rearview_mirrors AS eq_heated_rearview_mirrors_79, t0.eq_front_heated_seats AS eq_front_heated_seats_80, t0.eq_rear_heated_seats AS eq_rear_heated_seats_81, t0.eq_driver_knee_airbag AS eq_driver_knee_airbag_82, t0.eq_front_side_airbags AS eq_front_side_airbags_83, t0.eq_rear_passenger_airbags AS eq_rear_passenger_airbags_84, t0.eq_tinted_windows AS eq_tinted_windows_85, t0.eq_radio AS eq_radio_86, t0.eq_adjustable_suspension AS eq_adjustable_suspension_87, t0.eq_roof_bars AS eq_roof_bars_88, t0.eq_system_start_stop AS eq_system_start_stop_89, t0.eq_sunroof AS eq_sunroof_90, t0.eq_daytime_lights AS eq_daytime_lights_91, t0.eq_leds AS eq_leds_92, t0.eq_fog_lights AS eq_fog_lights_93, t0.eq_xenon_lights AS eq_xenon_lights_94, t0.eq_leather_interior AS eq_leather_interior_95, t0.eq_velour_interior AS eq_velour_interior_96, t0.eq_cruise_control AS eq_cruise_control_97, t0.eq_active_cruise_control AS eq_active_cruise_control_98, t0.eq_tv AS eq_tv_99, t0.eq_steering_whell_commands AS eq_steering_whell_commands_100, t0.eq_virtual_cocpit AS eq_virtual_cocpit_101, t0.photo AS photo_102, t0.photo_real_name AS photo_real_name_103, t0.dealer_id AS dealer_id_104, t0.make_id AS make_id_105, t0.model_id AS model_id_106 FROM auto t0 ORDER BY t0.id DESC LIMIT 5
Parameters:
[] |
|
0.79 ms (4.41%) |
1 |
SELECT t0.id AS id_1, t0.save_date AS save_date_2, t0.title AS title_3, t0.number_of_visit AS number_of_visit_4, t0.updated_at AS updated_at_5, t0.vin AS vin_6, t0.id_advert AS id_advert_7, t0.price AS price_8, t0.year AS year_9, t0.power AS power_10, t0.gearbox AS gearbox_11, t0.first_owner AS first_owner_12, t0.no_crash AS no_crash_13, t0.service_aso AS service_aso_14, t0.tuning AS tuning_15, t0.invoice_vatmargin AS invoice_vatmargin_16, t0.invoice_vat AS invoice_vat_17, t0.auto_demo AS auto_demo_18, t0.warranty_factory AS warranty_factory_19, t0.warranty_dealer AS warranty_dealer_20, t0.color AS color_21, t0.mileage AS mileage_22, t0.engine_capacity AS engine_capacity_23, t0.fuel AS fuel_24, t0.new AS new_25, t0.price_currency AS price_currency_26, t0.origin_country AS origin_country_27, t0.polish_register AS polish_register_28, t0.description AS description_29, t0.video1 AS video1_30, t0.video2 AS video2_31, t0.video3 AS video3_32, t0.video4 AS video4_33, t0.fotom AS fotom_34, t0.eq_abs AS eq_abs_35, t0.eq_cd AS eq_cd_36, t0.eq_central_lock AS eq_central_lock_37, t0.eq_front_electric_windows AS eq_front_electric_windows_38, t0.eq_electronic_rear_view_mirrors AS eq_electronic_rear_view_mirrors_39, t0.eq_immobiliser AS eq_immobiliser_40, t0.eq_front_airbags AS eq_front_airbags_41, t0.eq_front_passenger_airbags AS eq_front_passenger_airbags_42, t0.eq_original_radio AS eq_original_radio_43, t0.eq_assisted_steering AS eq_assisted_steering_44, t0.eq_alarm AS eq_alarm_45, t0.eq_alloy_wheels AS eq_alloy_wheels_46, t0.eq_asr AS eq_asr_47, t0.eq_park_assist AS eq_park_assist_48, t0.eq_lane_assist AS eq_lane_assist_49, t0.eq_bluetooth AS eq_bluetooth_50, t0.eq_automatic_wipers AS eq_automatic_wipers_51, t0.eq_blind_spot_sensor AS eq_blind_spot_sensor_52, t0.eq_automatic_lights AS eq_automatic_lights_53, t0.eq_both_parking_sensors AS eq_both_parking_sensors_54, t0.eq_rear_parking_sensors AS eq_rear_parking_sensors_55, t0.eq_panoramic_sunroof AS eq_panoramic_sunroof_56, t0.eq_electric_exterior_mirror AS eq_electric_exterior_mirror_57, t0.eq_electric_interior_mirror AS eq_electric_interior_mirror_58, t0.eq_rear_electric_windows AS eq_rear_electric_windows_59, t0.eq_electric_adjustable_seats AS eq_electric_adjustable_seats_60, t0.eq_esp AS eq_esp_61, t0.eq_aux_in AS eq_aux_in_62, t0.eq_sdsocket AS eq_sdsocket_63, t0.eq_usbsocket AS eq_usbsocket_64, t0.eq_towing_hook AS eq_towing_hook_65, t0.eq_head_display AS eq_head_display_66, t0.eq_isofix AS eq_isofix_67, t0.eq_rearview_camera AS eq_rearview_camera_68, t0.eq_automatic_air_conditioning AS eq_automatic_air_conditioning_69, t0.eq_onboard_computer AS eq_onboard_computer_70, t0.eq_side_window_airbags AS eq_side_window_airbags_71, t0.eq_shift_paddles AS eq_shift_paddles_72, t0.eq_mp3 AS eq_mp3_73, t0.eq_gps AS eq_gps_74, t0.eq_dvd AS eq_dvd_75, t0.eq_speed_limiter AS eq_speed_limiter_76, t0.eq_auxiliary_heating AS eq_auxiliary_heating_77, t0.eq_heated_windshield AS eq_heated_windshield_78, t0.eq_heated_rearview_mirrors AS eq_heated_rearview_mirrors_79, t0.eq_front_heated_seats AS eq_front_heated_seats_80, t0.eq_rear_heated_seats AS eq_rear_heated_seats_81, t0.eq_driver_knee_airbag AS eq_driver_knee_airbag_82, t0.eq_front_side_airbags AS eq_front_side_airbags_83, t0.eq_rear_passenger_airbags AS eq_rear_passenger_airbags_84, t0.eq_tinted_windows AS eq_tinted_windows_85, t0.eq_radio AS eq_radio_86, t0.eq_adjustable_suspension AS eq_adjustable_suspension_87, t0.eq_roof_bars AS eq_roof_bars_88, t0.eq_system_start_stop AS eq_system_start_stop_89, t0.eq_sunroof AS eq_sunroof_90, t0.eq_daytime_lights AS eq_daytime_lights_91, t0.eq_leds AS eq_leds_92, t0.eq_fog_lights AS eq_fog_lights_93, t0.eq_xenon_lights AS eq_xenon_lights_94, t0.eq_leather_interior AS eq_leather_interior_95, t0.eq_velour_interior AS eq_velour_interior_96, t0.eq_cruise_control AS eq_cruise_control_97, t0.eq_active_cruise_control AS eq_active_cruise_control_98, t0.eq_tv AS eq_tv_99, t0.eq_steering_whell_commands AS eq_steering_whell_commands_100, t0.eq_virtual_cocpit AS eq_virtual_cocpit_101, t0.photo AS photo_102, t0.photo_real_name AS photo_real_name_103, t0.dealer_id AS dealer_id_104, t0.make_id AS make_id_105, t0.model_id AS model_id_106 FROM auto t0 ORDER BY t0.number_of_visit DESC LIMIT 5
Parameters:
[] |
|
0.75 ms (4.20%) |
1 |
INSERT INTO log (id, created_at, event_name, user_id) VALUES (?, ?, ?, ?)
Parameters:
[ b"\x01-23P{"\x1EZ‰] \v=" "2026-03-27 02:49:17" "WIDOK (odwiedziny podstrony): /page-autos [GET]" null ] |
|
0.68 ms (3.82%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.52 ms (2.93%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM district t0 ORDER BY t0.name ASC
Parameters:
[] |
|
0.48 ms (2.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM make t0 ORDER BY t0.name ASC
Parameters:
[] |
|
0.21 ms (1.19%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Model | 1064 |
| App\Entity\Auto | 252 |
| App\Entity\Foto | 167 |
| App\Entity\Make | 90 |
| App\Entity\District | 16 |
| App\Entity\Dealer | 5 |
| App\Entity\Group | 5 |
| App\Entity\Log | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Log | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Make | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Auto | No errors. |
| App\Entity\Dealer | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Foto | No errors. |
| App\Entity\Group | No errors. |