Query Metrics
17
Database Queries
16
Different statements
15.13 ms
Query time
6
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.09 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.active AS active_7, t0.fcm AS fcm_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.company_id AS company_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"zbyszek@abspos.pl"
]
|
| 2 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.nip AS nip_3, t0.company_code AS company_code_4, t0.short_name AS short_name_5, t0.address AS address_6, t0.company_group_id AS company_group_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM company t0 WHERE t0.id = ?
Parameters:
[
19
]
|
| 3 | 2.96 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.make AS make_2, v0_.model AS model_3, v0_.registration_number AS registration_number_4, v0_.vin AS vin_5, v0_.review_date AS review_date_6, v0_.insurance_date AS insurance_date_7, v0_.engine AS engine_8, v0_.mileage AS mileage_9, v0_.fuel_card_id AS fuel_card_id_10, v0_.fuel_card_pin AS fuel_card_pin_11, v0_.lessee AS lessee_12, v0_.tire_pl_name AS tire_pl_name_13, v0_.tire_pp_name AS tire_pp_name_14, v0_.tire_ll_name AS tire_ll_name_15, v0_.tire_lp_name AS tire_lp_name_16, v0_.tire_pl_production AS tire_pl_production_17, v0_.tire_pp_production AS tire_pp_production_18, v0_.tire_ll_production AS tire_ll_production_19, v0_.tire_lp_production AS tire_lp_production_20, v0_.tire_pl_width AS tire_pl_width_21, v0_.tire_pl_ratio AS tire_pl_ratio_22, v0_.tire_pl_rim AS tire_pl_rim_23, v0_.tire_pp_width AS tire_pp_width_24, v0_.tire_pp_ratio AS tire_pp_ratio_25, v0_.tire_pp_rim AS tire_pp_rim_26, v0_.tire_ll_width AS tire_ll_width_27, v0_.tire_ll_ratio AS tire_ll_ratio_28, v0_.tire_ll_rim AS tire_ll_rim_29, v0_.tire_lp_width AS tire_lp_width_30, v0_.tire_lp_ratio AS tire_lp_ratio_31, v0_.tire_lp_rim AS tire_lp_rim_32, v0_.tire_pl_installation AS tire_pl_installation_33, v0_.tire_pp_installation AS tire_pp_installation_34, v0_.tire_ll_installation AS tire_ll_installation_35, v0_.tire_lp_installation AS tire_lp_installation_36, v0_.gas_expiry_date AS gas_expiry_date_37, v0_.created_at AS created_at_38, v0_.updated_at AS updated_at_39, e1_.id AS id_40, e1_.mileage AS mileage_41, e1_.exp_status AS exp_status_42, e1_.exp_estimated_price AS exp_estimated_price_43, e1_.exp_final_price AS exp_final_price_44, e1_.repair_date AS repair_date_45, e1_.refueled AS refueled_46, e1_.fuel_price AS fuel_price_47, e1_.description AS description_48, e1_.trip_start_point AS trip_start_point_49, e1_.trip_end_point AS trip_end_point_50, e1_.trip_distance AS trip_distance_51, e1_.location AS location_52, e1_.critical AS critical_53, e1_.insurance AS insurance_54, e1_.created_at AS created_at_55, e1_.updated_at AS updated_at_56, u2_.id AS id_57, u2_.email AS email_58, u2_.roles AS roles_59, u2_.password AS password_60, u2_.first_name AS first_name_61, u2_.last_name AS last_name_62, u2_.active AS active_63, u2_.fcm AS fcm_64, u2_.created_at AS created_at_65, u2_.updated_at AS updated_at_66, v3_.id AS id_67, v3_.name AS name_68, t4_.id AS id_69, t4_.name AS name_70, t5_.id AS id_71, t5_.name AS name_72, t6_.id AS id_73, t6_.name AS name_74, t7_.id AS id_75, t7_.name AS name_76, n8_.id AS id_77, n8_.notification_date AS notification_date_78, n8_.repeat_at AS repeat_at_79, n8_.remind AS remind_80, n8_.send_email AS send_email_81, n8_.mileage AS mileage_82, n8_.repeat_mileage AS repeat_mileage_83, n8_.content AS content_84, n9_.id AS id_85, n9_.name AS name_86, v0_.company_id AS company_id_87, v0_.vehicle_kind_id AS vehicle_kind_id_88, v0_.use_type_id AS use_type_id_89, v0_.status_id AS status_id_90, v0_.tire_pl_type_id AS tire_pl_type_id_91, v0_.tire_pp_type_id AS tire_pp_type_id_92, v0_.tire_ll_type_id AS tire_ll_type_id_93, v0_.tire_lp_type_id AS tire_lp_type_id_94, v0_.created_by_id AS created_by_id_95, v0_.updated_by_id AS updated_by_id_96, e1_.event_type_id AS event_type_id_97, e1_.vehicle_id AS vehicle_id_98, e1_.driver_id AS driver_id_99, e1_.invoice_id AS invoice_id_100, e1_.fuel_type_id AS fuel_type_id_101, e1_.created_by_id AS created_by_id_102, e1_.updated_by_id AS updated_by_id_103, u2_.company_id AS company_id_104, u2_.created_by_id AS created_by_id_105, u2_.updated_by_id AS updated_by_id_106, n8_.vehicle_id AS vehicle_id_107, n8_.category_id AS category_id_108 FROM vehicle v0_ INNER JOIN company c10_ ON v0_.company_id = c10_.id LEFT JOIN event e1_ ON v0_.id = e1_.vehicle_id LEFT JOIN vehicle_user v11_ ON v0_.id = v11_.vehicle_id LEFT JOIN user u2_ ON u2_.id = v11_.user_id LEFT JOIN vehicle_status v3_ ON v0_.status_id = v3_.id LEFT JOIN tyres t4_ ON v0_.tire_pl_type_id = t4_.id LEFT JOIN tyres t5_ ON v0_.tire_pp_type_id = t5_.id LEFT JOIN tyres t6_ ON v0_.tire_ll_type_id = t6_.id LEFT JOIN tyres t7_ ON v0_.tire_lp_type_id = t7_.id LEFT JOIN notification n8_ ON v0_.id = n8_.vehicle_id LEFT JOIN notification_category n9_ ON n8_.category_id = n9_.id WHERE v0_.id = ? AND c10_.company_group_id = ?
Parameters:
[ 40 7 ] |
| 4 | 0.69 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.nip AS nip_2, c0_.company_code AS company_code_3, c0_.short_name AS short_name_4, c0_.address AS address_5, c0_.company_group_id AS company_group_id_6, c0_.created_by_id AS created_by_id_7, c0_.updated_by_id AS updated_by_id_8 FROM company c0_ WHERE c0_.id = ? AND c0_.company_group_id = ?
Parameters:
[ 20 7 ] |
| 5 | 0.48 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1 FROM vehicle_kind v0_ WHERE v0_.id = ?
Parameters:
[
1
]
|
| 6 | 0.41 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1 FROM fuel_type f0_ WHERE f0_.id = ?
Parameters:
[
1
]
|
| 7 | 0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM fuel_type t0 INNER JOIN vehicle_fuel_type ON t0.id = vehicle_fuel_type.fuel_type_id WHERE vehicle_fuel_type.vehicle_id = ?
Parameters:
[
40
]
|
| 8 | 0.46 ms |
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM use_type u0_ WHERE u0_.id = ?
Parameters:
[
2
]
|
| 9 | 0.30 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1 FROM vehicle_status v0_ WHERE v0_.id = ?
Parameters:
[
2
]
|
| 10 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
| 11 | 0.56 ms |
UPDATE vehicle SET review_date = ?, insurance_date = ?, mileage = ?, created_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2025-04-19" "2025-01-08" 255348 "2022-06-09 10:34:19" "2026-10-01 10:29:02" 40 ] |
| 12 | 1.88 ms |
"COMMIT"
Parameters:
[] |
| 13 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.make AS make_3, t0.model AS model_4, t0.registration_number AS registration_number_5, t0.vin AS vin_6, t0.review_date AS review_date_7, t0.insurance_date AS insurance_date_8, t0.engine AS engine_9, t0.mileage AS mileage_10, t0.fuel_card_id AS fuel_card_id_11, t0.fuel_card_pin AS fuel_card_pin_12, t0.lessee AS lessee_13, t0.tire_pl_name AS tire_pl_name_14, t0.tire_pp_name AS tire_pp_name_15, t0.tire_ll_name AS tire_ll_name_16, t0.tire_lp_name AS tire_lp_name_17, t0.tire_pl_production AS tire_pl_production_18, t0.tire_pp_production AS tire_pp_production_19, t0.tire_ll_production AS tire_ll_production_20, t0.tire_lp_production AS tire_lp_production_21, t0.tire_pl_width AS tire_pl_width_22, t0.tire_pl_ratio AS tire_pl_ratio_23, t0.tire_pl_rim AS tire_pl_rim_24, t0.tire_pp_width AS tire_pp_width_25, t0.tire_pp_ratio AS tire_pp_ratio_26, t0.tire_pp_rim AS tire_pp_rim_27, t0.tire_ll_width AS tire_ll_width_28, t0.tire_ll_ratio AS tire_ll_ratio_29, t0.tire_ll_rim AS tire_ll_rim_30, t0.tire_lp_width AS tire_lp_width_31, t0.tire_lp_ratio AS tire_lp_ratio_32, t0.tire_lp_rim AS tire_lp_rim_33, t0.tire_pl_installation AS tire_pl_installation_34, t0.tire_pp_installation AS tire_pp_installation_35, t0.tire_ll_installation AS tire_ll_installation_36, t0.tire_lp_installation AS tire_lp_installation_37, t0.gas_expiry_date AS gas_expiry_date_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.company_id AS company_id_41, t0.vehicle_kind_id AS vehicle_kind_id_42, t0.use_type_id AS use_type_id_43, t0.status_id AS status_id_44, t0.tire_pl_type_id AS tire_pl_type_id_45, t0.tire_pp_type_id AS tire_pp_type_id_46, t0.tire_ll_type_id AS tire_ll_type_id_47, t0.tire_lp_type_id AS tire_lp_type_id_48, t0.created_by_id AS created_by_id_49, t0.updated_by_id AS updated_by_id_50 FROM vehicle t0 WHERE t0.id = ?
Parameters:
[
40
]
|
| 14 | 0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM fuel_type t0 INNER JOIN vehicle_fuel_type ON t0.id = vehicle_fuel_type.fuel_type_id WHERE vehicle_fuel_type.vehicle_id = ?
Parameters:
[
40
]
|
| 15 | 0.97 ms |
SELECT t0.id AS id_1, t0.mileage AS mileage_2, t0.exp_status AS exp_status_3, t0.exp_estimated_price AS exp_estimated_price_4, t0.exp_final_price AS exp_final_price_5, t0.repair_date AS repair_date_6, t0.refueled AS refueled_7, t0.fuel_price AS fuel_price_8, t0.description AS description_9, t0.trip_start_point AS trip_start_point_10, t0.trip_end_point AS trip_end_point_11, t0.trip_distance AS trip_distance_12, t0.location AS location_13, t0.critical AS critical_14, t0.insurance AS insurance_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.event_type_id AS event_type_id_18, t0.vehicle_id AS vehicle_id_19, t0.driver_id AS driver_id_20, t0.invoice_id AS invoice_id_21, t0.fuel_type_id AS fuel_type_id_22, t0.created_by_id AS created_by_id_23, t0.updated_by_id AS updated_by_id_24 FROM event t0 WHERE t0.vehicle_id = ?
Parameters:
[
40
]
|
| 16 | 0.48 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.active AS active_7, t0.fcm AS fcm_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.company_id AS company_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM user t0 INNER JOIN vehicle_user ON t0.id = vehicle_user.user_id WHERE vehicle_user.vehicle_id = ?
Parameters:
[
40
]
|
| 17 | 0.42 ms |
SELECT t0.id AS id_1, t0.notification_date AS notification_date_2, t0.repeat_at AS repeat_at_3, t0.remind AS remind_4, t0.send_email AS send_email_5, t0.mileage AS mileage_6, t0.repeat_mileage AS repeat_mileage_7, t0.content AS content_8, t0.vehicle_id AS vehicle_id_9, t0.category_id AS category_id_10 FROM notification t0 WHERE t0.vehicle_id = ?
Parameters:
[
40
]
|
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\User |
|
| App\Entity\Company |
|
| App\Entity\Event |
|
| App\Entity\Vehicle |
|
| App\Entity\Invoice |
|
| App\Entity\CompanyGroup |
|
| App\Entity\VehicleStatus | No errors. |
| App\Entity\Tyres | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\NotificationCategory | No errors. |
| App\Entity\VehicleKind | No errors. |
| App\Entity\UseType | No errors. |
| App\Entity\EventType | No errors. |
| App\Entity\FuelType | No errors. |