GET https://winesclub.site-vitrine.be/shop

Query Metrics

3 Database Queries
3 Different statements
1.81 ms Query time
0 Invalid entities
72 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 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_.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:
[]
2 0.55 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 0.42 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_.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.