Query Metrics
1
Database Queries
1
Different statements
0.56 ms
Query time
0
Invalid entities
17
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.56 ms |
SELECT f0_.id AS id_0, f0_.main_image AS main_image_1, f0_.prefecture AS prefecture_2, f0_.region AS region_3, f0_.genre AS genre_4, f0_.name AS name_5, f0_.catchphrase AS catchphrase_6, f0_.description AS description_7, f0_.producer_name AS producer_name_8, f0_.introduced_at AS introduced_at_9, f0_.is_year_round AS is_year_round_10, f0_.season_from AS season_from_11, f0_.season_to AS season_to_12, f0_.is_published AS is_published_13, f0_.created_at AS created_at_14, f0_.updated_at AS updated_at_15, f0_.is_featured AS is_featured_16, f1_.id AS id_17, f1_.image_path AS image_path_18, f1_.display_order AS display_order_19, f1_.fruit_id AS fruit_id_20 FROM fruit f0_ LEFT JOIN fruit_image f1_ ON f0_.id = f1_.fruit_id WHERE f0_.is_published = ? ORDER BY f0_.is_featured DESC, f0_.introduced_at DESC LIMIT 12
Parameters:
[
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\FruitImage | 12 |
| App\Entity\Fruit | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Fruit | No errors. |
| App\Entity\FruitImage | No errors. |