Query Metrics
3
Database Queries
3
Different statements
5.88 ms
Query time
0
Invalid entities
70
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3.44 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.domain AS domain_2, w0_.color AS color_3, w0_.family AS family_4, w0_.appellation AS appellation_5, w0_.country AS country_6, w0_.vintage AS vintage_7, w0_.description AS description_8, w0_.description_nl AS description_nl_9, w0_.description_domain AS description_domain_10, w0_.description_domain_nl AS description_domain_nl_11, w0_.image_url AS image_url_12, w0_.price_shop AS price_shop_13, w0_.price_pro AS price_pro_14, w0_.price_cost AS price_cost_15, w0_.supplier_reference AS supplier_reference_16, w0_.is_available_in_shop AS is_available_in_shop_17, w0_.is_available_in_pro_catalog AS is_available_in_pro_catalog_18, w0_.is_available_in_pro_premium_catalog AS is_available_in_pro_premium_catalog_19, w0_.winevizer_data AS winevizer_data_20, w0_.created_at AS created_at_21, w0_.updated_at AS updated_at_22, l1_.id AS id_23, l1_.level AS level_24, l1_.name AS name_25, l1_.name_nl AS name_nl_26, l1_.slug AS slug_27, l1_.description AS description_28, l1_.description_nl AS description_nl_29, w0_.region_id AS region_id_30, l1_.country_id AS country_id_31, l1_.parent_region_id AS parent_region_id_32 FROM wine w0_ LEFT JOIN location_region l1_ ON w0_.region_id = l1_.id WHERE w0_.is_available_in_shop = 1 ORDER BY w0_.updated_at DESC LIMIT 120
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 1.32 ms |
SELECT DISTINCT w0_.country AS country_0 FROM wine w0_ WHERE w0_.is_available_in_shop = 1 ORDER BY w0_.country ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 1.12 ms |
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.label AS label_2, c0_.label_nl AS label_nl_3, c0_.description AS description_4, c0_.description_nl AS description_nl_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7 FROM cepage c0_ ORDER BY c0_.label 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\Cepage | 33 |
| App\Entity\Wine | 27 |
| App\Entity\LocationRegion | 8 |
| App\Entity\LocationCountry | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Wine | No errors. |
| App\Entity\LocationRegion | No errors. |
| App\Entity\LocationCountry | No errors. |
| App\Entity\Aromatic | No errors. |
| App\Entity\Cepage | No errors. |