Query Metrics
3
Database Queries
3
Different statements
1.81 ms
Query time
0
Invalid entities
72
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.84 ms (46.35%) |
1 |
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_.country AS country_5, w0_.vintage AS vintage_6, w0_.description AS description_7, w0_.description_nl AS description_nl_8, w0_.image_url AS image_url_9, w0_.price_shop AS price_shop_10, w0_.price_pro AS price_pro_11, w0_.price_cost AS price_cost_12, w0_.supplier_reference AS supplier_reference_13, w0_.is_available_in_shop AS is_available_in_shop_14, w0_.is_available_in_pro_catalog AS is_available_in_pro_catalog_15, w0_.winevizer_data AS winevizer_data_16, w0_.created_at AS created_at_17, w0_.updated_at AS updated_at_18, r1_.id AS id_19, r1_.slug AS slug_20, r1_.label AS label_21, r1_.label_nl AS label_nl_22, r1_.country AS country_23, r1_.created_at AS created_at_24, r1_.updated_at AS updated_at_25, w0_.region_id AS region_id_26 FROM wine w0_ LEFT JOIN region r1_ ON w0_.region_id = r1_.id WHERE w0_.is_available_in_shop = 1 ORDER BY w0_.updated_at DESC LIMIT 120
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.55 ms (30.23%) |
1 |
SELECT DISTINCT w0_.country AS country_0 FROM wine w0_ WHERE w0_.is_available_in_shop = 1 ORDER BY w0_.country ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.42 ms (23.43%) |
1 |
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.label AS label_2, c0_.label_nl AS label_nl_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5 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 | 30 |
| App\Entity\Wine | 27 |
| App\Entity\Region | 15 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Wine | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Aromatic | No errors. |
| App\Entity\Cepage | No errors. |