Query Metrics
3
Database Queries
3
Different statements
8.69 ms
Query time
0
Invalid entities
10
Managed entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"162-moving-parts-21"
]
|
||||||||||||||||||||||||||||||
2 | 1.94 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 series s1_ ON v0_.series_id = s1_.id LEFT JOIN type t2_ ON v0_.type_id = t2_.id WHERE s1_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY t2_.name ASC LIMIT 20
Parameters:
[ "162-moving-parts-21" 1 "collection" 1 ]
|
||||||||||||||||||||||||||||||
3 | 4.17 ms |
SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN series s1_ ON v0_.series_id = s1_.id LEFT JOIN type t2_ ON v0_.type_id = t2_.id WHERE s1_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY t2_.name ASC
Parameters:
[ "162-moving-parts-21" 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\Series | 1 |
App\Entity\Vehicle | 1 |
App\Entity\Brand | 1 |
App\Entity\DesignType | 1 |
App\Entity\BottomEmbossing | 1 |
App\Entity\Type | 1 |
App\Entity\TireType | 1 |
App\Entity\Scale | 1 |
App\Entity\Manufacturer | 1 |
App\Entity\Category | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Vehicle | No errors. |
App\Entity\Series | 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\Manufacturer | No errors. |
App\Entity\Category | No errors. |
App\Entity\Color | No errors. |
App\Entity\File | No errors. |