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

Query Metrics

3 Database Queries
3 Different statements
5.88 ms Query time
0 Invalid entities
70 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.44 ms
(58.47%)
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_.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:
[]
1.32 ms
(22.42%)
1
SELECT DISTINCT w0_.country AS country_0 FROM wine w0_ WHERE w0_.is_available_in_shop = 1 ORDER BY w0_.country ASC
Parameters:
[]
1.12 ms
(19.11%)
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_.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.