Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.26 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	2.26 ms	SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.vehicle_id = ? LIMIT 1 Parameters: [`"19422"`] View formatted query View runnable query Explain query SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.vehicle_id = ? LIMIT 1 SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.vehicle_id = '19422' LIMIT 1;

#▲

Time

Info

2.26 ms

SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.vehicle_id = ? LIMIT 1

Parameters:

[
  "19422"
]

View formatted query View runnable query Explain query

SELECT
  t0.vin_number AS vin_number_1,
  t0.panel_numbers AS panel_numbers_2,
  t0.weight AS weight_3,
  t0.vehicle_load AS vehicle_load_4,
  t0.manufacturing_year AS manufacturing_year_5,
  t0.serial_number AS serial_number_6,
  t0.license_expiry_date AS license_expiry_date_7,
  t0.license_expiry_date_hijri AS license_expiry_date_hijri_8,
  t0.vehicle_id AS vehicle_id_9,
  t0.color_id AS color_id_10,
  t0.registration_doc_id AS registration_doc_id_11,
  t0.panel_letter1 AS panel_letter1_12,
  t0.panel_letter2 AS panel_letter2_13,
  t0.panel_letter3 AS panel_letter3_14,
  t0.model_id AS model_id_15,
  t0.registration_type_id AS registration_type_id_16,
  t0.vehicle_id AS vehicle_id_17,
  t0.vehicle_owner_id AS vehicle_owner_id_18,
  t0.vehicle_user_id AS vehicle_user_id_19
FROM
  vehicle_registrations t0
WHERE
  t0.vehicle_id = ?
LIMIT
  1

SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.vehicle_id = '19422' LIMIT 1;

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\VehicleRegistrations	No errors.
App\Entity\VehicleColors	No errors.
App\Entity\VehicleDocs	No errors.
App\Entity\PanelLetters	No errors.
App\Entity\VehicleModels	No errors.
App\Entity\VehicleRegistrationTypes	No errors.
App\Entity\Vehicles	The field App\Entity\Vehicles#vehicleSales is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VehicleSales#vehicle does not contain the required 'inversedBy="vehicleSales"' attribute.
App\Entity\VehicleClients	No errors.

Symfony Profiler

GET https://auction.sa/ar/vehicles/19422/edit

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping