Query Metrics
3
Database Queries
3
Different statements
3.69 ms
Query time
0
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.91 ms (51.86%) |
1 |
SELECT d0_.moto_condition AS moto_condition_0, d0_.chassis_number AS chassis_number_1, d0_.plate AS plate_2, d0_.registration_year AS registration_year_3, d0_.mileage AS mileage_4, d0_.stock_arrival_date AS stock_arrival_date_5, d0_.notes AS notes_6, d0_.cost AS cost_7, d0_.price AS price_8, d0_.description AS description_9, d0_.displacement AS displacement_10, d0_.power AS power_11, d0_.transmission AS transmission_12, d0_.tank_capacity AS tank_capacity_13, d0_.height AS height_14, d0_.weight AS weight_15, d0_.tyres AS tyres_16, d0_.brakes AS brakes_17, d0_.id AS id_18, d1_.name AS name_19, d1_.logo AS logo_20, d1_.is_active_moto AS is_active_moto_21, d1_.is_active_products AS is_active_products_22, d1_.id AS id_23, d2_.name AS name_24, d2_.description AS description_25, d2_.displacement AS displacement_26, d2_.power AS power_27, d2_.transmission AS transmission_28, d2_.tank_capacity AS tank_capacity_29, d2_.height AS height_30, d2_.weight AS weight_31, d2_.tyres AS tyres_32, d2_.brakes AS brakes_33, d2_.id AS id_34, d2_.is_active AS is_active_35, d3_.value AS value_36, d3_.hex_code AS hex_code_37, d3_.id AS id_38, d3_.is_active AS is_active_39, d4_.filename AS filename_40, d4_.position AS position_41, d4_.is_main AS is_main_42, d4_.id AS id_43, d0_.brand_id AS brand_id_44, d0_.model_id AS model_id_45, d0_.color_id AS color_id_46, d0_.owner_id AS owner_id_47, d2_.brand_id AS brand_id_48, d4_.motorcycle_id AS motorcycle_id_49 FROM dm_motorcycle d0_ LEFT JOIN dm_brand d1_ ON d0_.brand_id = d1_.id LEFT JOIN dm_model d2_ ON d0_.model_id = d2_.id LEFT JOIN dm_motorcycle_color d3_ ON d0_.color_id = d3_.id LEFT JOIN dm_motorcycle_image d4_ ON d0_.id = d4_.motorcycle_id WHERE d0_.owner_id IS NULL AND d0_.chassis_number IS NOT NULL AND d0_.chassis_number <> '' AND d0_.price IS NOT NULL ORDER BY d1_.name ASC, d2_.name ASC, d4_.position ASC
Parameters:
[]
|
||||||||||||||||||||||||||
|
1.05 ms (28.55%) |
1 |
SELECT d0_.name AS name_0, d0_.description AS description_1, d0_.displacement AS displacement_2, d0_.power AS power_3, d0_.transmission AS transmission_4, d0_.tank_capacity AS tank_capacity_5, d0_.height AS height_6, d0_.weight AS weight_7, d0_.tyres AS tyres_8, d0_.brakes AS brakes_9, d0_.id AS id_10, d0_.is_active AS is_active_11, d1_.name AS name_12, d1_.logo AS logo_13, d1_.is_active_moto AS is_active_moto_14, d1_.is_active_products AS is_active_products_15, d1_.id AS id_16, d0_.brand_id AS brand_id_17 FROM dm_model d0_ INNER JOIN dm_motorcycle d2_ ON (d2_.model_id = d0_.id AND d2_.owner_id IS NULL) LEFT JOIN dm_brand d1_ ON d0_.brand_id = d1_.id GROUP BY d0_.id ORDER BY d0_.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.72 ms (19.59%) |
1 |
SELECT d0_.name AS name_0, d0_.logo AS logo_1, d0_.is_active_moto AS is_active_moto_2, d0_.is_active_products AS is_active_products_3, d0_.id AS id_4 FROM dm_brand d0_ INNER JOIN dm_motorcycle d1_ ON (d1_.brand_id = d0_.id AND d1_.owner_id IS NULL) GROUP BY d0_.id ORDER BY d0_.name ASC
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\Brand | 1 |
| App\Entity\MotorcycleModel | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Motorcycle | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\MotorcycleModel | No errors. |
| App\Entity\MotorcycleColor | No errors. |
| App\Entity\MotorcycleImage | No errors. |
| App\Entity\Customer | No errors. |