Symfony Profiler

Query Metrics

31 Database Queries

4 Different statements

11.76 ms Query time

0 Invalid entities

61 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.94 ms
(76.06%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.label_nl AS label_nl_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM cepage t0 INNER JOIN wine_cepage ON t0.id = wine_cepage.cepage_id WHERE wine_cepage.wine_id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.label_nl AS label_nl_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  cepage t0
  INNER JOIN wine_cepage ON t0.id = wine_cepage.cepage_id
WHERE
  wine_cepage.wine_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.label_nl AS label_nl_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM cepage t0 INNER JOIN wine_cepage ON t0.id = wine_cepage.cepage_id WHERE wine_cepage.wine_id = 8;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_ea9cceba0ef76f1c7115830d7969d613::block_pro_content (line 276)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_1127e2ec3974cbd690091bc0ce3dd6fe->block_body (line 193)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_6d8496cf017b3e4c322aba11475c72c5->doDisplay (line 615)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_1127e2ec3974cbd690091bc0ce3dd6fe->doDisplay (line 56)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_ea9cceba0ef76f1c7115830d7969d613->doDisplay (line 55)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\Pro\ProCatalogController->index (line 51)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

1.04 ms
(8.87%)

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_pro_catalog = 1 ORDER BY w0_.name ASC LIMIT 200

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_pro_catalog = 1
ORDER BY
  w0_.name ASC
LIMIT
  200

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_pro_catalog = 1 ORDER BY w0_.name ASC LIMIT 200;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\WineRepository->searchProCatalog (line 168)
7	App\Controller\Pro\ProCatalogController->index (line 43)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.00 ms
(8.50%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.locale AS locale_8, t0.type AS type_9, t0.company_name AS company_name_10, t0.vat_number AS vat_number_11, t0.pro_validated_at AS pro_validated_at_12, t0.pro_payment_terms AS pro_payment_terms_13, t0.pro_discount_percent AS pro_discount_percent_14, t0.manual_discount_percent AS manual_discount_percent_15, t0.disable_discount_stacking AS disable_discount_stacking_16, t0.oauth_ids AS oauth_ids_17, t0.last_login_at AS last_login_at_18, t0.stripe_customer_id AS stripe_customer_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.shipping_street AS shipping_street_22, t0.shipping_zip_code AS shipping_zip_code_23, t0.shipping_city AS shipping_city_24, t0.shipping_country AS shipping_country_25, t0.billing_street AS billing_street_26, t0.billing_zip_code AS billing_zip_code_27, t0.billing_city AS billing_city_28, t0.billing_country AS billing_country_29 FROM app_user t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.locale AS locale_8,
  t0.type AS type_9,
  t0.company_name AS company_name_10,
  t0.vat_number AS vat_number_11,
  t0.pro_validated_at AS pro_validated_at_12,
  t0.pro_payment_terms AS pro_payment_terms_13,
  t0.pro_discount_percent AS pro_discount_percent_14,
  t0.manual_discount_percent AS manual_discount_percent_15,
  t0.disable_discount_stacking AS disable_discount_stacking_16,
  t0.oauth_ids AS oauth_ids_17,
  t0.last_login_at AS last_login_at_18,
  t0.stripe_customer_id AS stripe_customer_id_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.shipping_street AS shipping_street_22,
  t0.shipping_zip_code AS shipping_zip_code_23,
  t0.shipping_city AS shipping_city_24,
  t0.shipping_country AS shipping_country_25,
  t0.billing_street AS billing_street_26,
  t0.billing_zip_code AS billing_zip_code_27,
  t0.billing_city AS billing_city_28,
  t0.billing_country AS billing_country_29
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.locale AS locale_8, t0.type AS type_9, t0.company_name AS company_name_10, t0.vat_number AS vat_number_11, t0.pro_validated_at AS pro_validated_at_12, t0.pro_payment_terms AS pro_payment_terms_13, t0.pro_discount_percent AS pro_discount_percent_14, t0.manual_discount_percent AS manual_discount_percent_15, t0.disable_discount_stacking AS disable_discount_stacking_16, t0.oauth_ids AS oauth_ids_17, t0.last_login_at AS last_login_at_18, t0.stripe_customer_id AS stripe_customer_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.shipping_street AS shipping_street_22, t0.shipping_zip_code AS shipping_zip_code_23, t0.shipping_city AS shipping_city_24, t0.shipping_country AS shipping_country_25, t0.billing_street AS billing_street_26, t0.billing_zip_code AS billing_zip_code_27, t0.billing_city AS billing_city_28, t0.billing_country AS billing_country_29 FROM app_user t0 WHERE t0.id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.77 ms
(6.57%)

SELECT t0.id AS id_1, t0.tier AS tier_2, t0.status AS status_3, t0.stripe_payment_method_id AS stripe_payment_method_id_4, t0.stripe_subscription_id AS stripe_subscription_id_5, t0.nb_boxes_received AS nb_boxes_received_6, t0.discount_tier AS discount_tier_7, t0.started_at AS started_at_8, t0.paused_at AS paused_at_9, t0.cancelled_at AS cancelled_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.gift_card_id AS gift_card_id_14 FROM subscription t0 WHERE t0.user_id = ? AND t0.status = ? LIMIT 1

Parameters:

[
  9
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tier AS tier_2,
  t0.status AS status_3,
  t0.stripe_payment_method_id AS stripe_payment_method_id_4,
  t0.stripe_subscription_id AS stripe_subscription_id_5,
  t0.nb_boxes_received AS nb_boxes_received_6,
  t0.discount_tier AS discount_tier_7,
  t0.started_at AS started_at_8,
  t0.paused_at AS paused_at_9,
  t0.cancelled_at AS cancelled_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.user_id AS user_id_13,
  t0.gift_card_id AS gift_card_id_14
FROM
  subscription t0
WHERE
  t0.user_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tier AS tier_2, t0.status AS status_3, t0.stripe_payment_method_id AS stripe_payment_method_id_4, t0.stripe_subscription_id AS stripe_subscription_id_5, t0.nb_boxes_received AS nb_boxes_received_6, t0.discount_tier AS discount_tier_7, t0.started_at AS started_at_8, t0.paused_at AS paused_at_9, t0.cancelled_at AS cancelled_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.gift_card_id AS gift_card_id_14 FROM subscription t0 WHERE t0.user_id = 9 AND t0.status = 'active' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Twig\HeaderExtension->hasActiveSubscription (line 51)
5	__TwigTemplate_6d8496cf017b3e4c322aba11475c72c5->doDisplay (line 544)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_1127e2ec3974cbd690091bc0ce3dd6fe->doDisplay (line 56)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_ea9cceba0ef76f1c7115830d7969d613->doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\Pro\ProCatalogController->index (line 51)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

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\Wine	28
App\Entity\Cepage	16
App\Entity\Region	15
App\Entity\User	1
App\Entity\Subscription	1

Entities Mapping

Class	Mapping errors
App\Entity\Embeddable\Address	No errors.
App\Entity\User	No errors.
App\Entity\Wine	No errors.
App\Entity\Region	No errors.
App\Entity\Aromatic	No errors.
App\Entity\Cepage	No errors.
App\Entity\Subscription	No errors.
App\Entity\GiftCard	No errors.

Symfony Profiler

GET https://winesclub.site-vitrine.be/pro/catalogue

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping