https://dev-flotaabs.grupa-abs.pl/api/vehicles/437

Query Metrics

4 Database Queries
4 Different statements
11.37 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
8.19 ms
(72.01%)
1
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:
[
  "kriker.mazur@wp.pl"
]
1.97 ms
(17.29%)
1
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:
[
  437
  77
]
0.80 ms
(7.06%)
1
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:
[
  437
]
0.41 ms
(3.64%)
1
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:
[
  98
]

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
  • The field App\Entity\User#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#user does not contain the required 'inversedBy="invoices"' attribute.
  • The mappings App\Entity\User#createdBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\User#createdBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
  • The mappings App\Entity\User#updatedBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\User#updatedBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
App\Entity\Company
  • The mappings App\Entity\Company#createdBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Company#createdBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
  • The mappings App\Entity\Company#updatedBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Company#updatedBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
App\Entity\Event
  • The mappings App\Entity\Event#createdBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Event#createdBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
  • The mappings App\Entity\Event#updatedBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Event#updatedBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
App\Entity\Vehicle
  • The mappings App\Entity\Vehicle#createdBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Vehicle#createdBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
  • The mappings App\Entity\Vehicle#updatedBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Vehicle#updatedBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
App\Entity\Invoice
  • The mappings App\Entity\Invoice#createdBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Invoice#createdBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
  • The mappings App\Entity\Invoice#updatedBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\Invoice#updatedBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
App\Entity\CompanyGroup
  • The mappings App\Entity\CompanyGroup#createdBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\CompanyGroup#createdBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
  • The mappings App\Entity\CompanyGroup#updatedBy and App\Entity\User#vehicles are inconsistent with each other.
  • If association App\Entity\CompanyGroup#updatedBy is many-to-one, then the inversed side App\Entity\User#vehicles has to be one-to-many.
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.