Query Metrics
2
Database Queries
2
Different statements
42.60 ms
Query time
0
Invalid entities
81
Managed entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 31.82 ms |
SELECT v0_.id AS id_0, v0_.construction_year AS construction_year_1, v0_.labeling AS labeling_2, v0_.article_number AS article_number_3, v0_.purchased_at AS purchased_at_4, v0_.storage_location AS storage_location_5, v0_.condition_rating AS condition_rating_6, v0_.approved AS approved_7, v0_.visible AS visible_8, v0_.status AS status_9, v0_.description AS description_10, v0_.brand_id AS brand_id_11, v0_.design_type_id AS design_type_id_12, v0_.bottom_embossing_id AS bottom_embossing_id_13, v0_.type_id AS type_id_14, v0_.tire_type_id AS tire_type_id_15, v0_.scale_id AS scale_id_16, v0_.series_id AS series_id_17, v0_.manufacturer_id AS manufacturer_id_18, v0_.category_id AS category_id_19 FROM vehicle v0_ LEFT JOIN type t1_ ON v0_.type_id = t1_.id WHERE v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY t1_.name ASC LIMIT 20 OFFSET 960
Parameters:
[ 1 "collection" 1 ]
|
||||||||||||||||||||||||||||||
2 | 10.78 ms |
SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN type t1_ ON v0_.type_id = t1_.id WHERE v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY t1_.name ASC
Parameters:
[ 1 "collection" 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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Vehicle | 20 |
App\Entity\Type | 13 |
App\Entity\TireType | 12 |
App\Entity\Brand | 9 |
App\Entity\DesignType | 8 |
App\Entity\Series | 6 |
App\Entity\BottomEmbossing | 4 |
App\Entity\Scale | 4 |
App\Entity\Manufacturer | 3 |
App\Entity\Category | 2 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Vehicle | No errors. |
App\Entity\Type | No errors. |
App\Entity\Brand | No errors. |
App\Entity\DesignType | No errors. |
App\Entity\BottomEmbossing | No errors. |
App\Entity\TireType | No errors. |
App\Entity\Scale | No errors. |
App\Entity\Series | No errors. |
App\Entity\Manufacturer | No errors. |
App\Entity\Category | No errors. |
App\Entity\Color | No errors. |
App\Entity\File | No errors. |