Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

1.42 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.48 ms
(33.66%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40, w1_.wine_id AS wine_id_41 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = ? ORDER BY w0_.created_at DESC, w1_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.brand_line AS brand_line_2,
  w0_.slug AS slug_3,
  w0_.appellation AS appellation_4,
  w0_.vintage AS vintage_5,
  w0_.type AS type_6,
  w0_.sweetness AS sweetness_7,
  w0_.volume_ml AS volume_ml_8,
  w0_.country_short AS country_short_9,
  w0_.origin_full AS origin_full_10,
  w0_.grape AS grape_11,
  w0_.color_desc AS color_desc_12,
  w0_.aroma AS aroma_13,
  w0_.taste AS taste_14,
  w0_.aging AS aging_15,
  w0_.abv AS abv_16,
  w0_.serving_temp AS serving_temp_17,
  w0_.food_pairing AS food_pairing_18,
  w0_.short_description AS short_description_19,
  w0_.stock AS stock_20,
  w0_.production_steps AS production_steps_21,
  w0_.subscription_eligible AS subscription_eligible_22,
  w0_.is_new AS is_new_23,
  w0_.is_featured AS is_featured_24,
  w0_.rating AS rating_25,
  w0_.seo_text AS seo_text_26,
  w0_.position AS position_27,
  w0_.is_active AS is_active_28,
  w0_.created_at AS created_at_29,
  w0_.updated_at AS updated_at_30,
  w0_.price_amount_cents AS price_amount_cents_31,
  w0_.price_currency AS price_currency_32,
  w0_.old_price_amount_cents AS old_price_amount_cents_33,
  w0_.old_price_currency AS old_price_currency_34,
  w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35,
  w0_.taste_days_price_currency AS taste_days_price_currency_36,
  w1_.id AS id_37,
  w1_.path AS path_38,
  w1_.alt AS alt_39,
  w1_.position AS position_40,
  w1_.wine_id AS wine_id_41
FROM
  wine w0_
  LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id
WHERE
  w0_.is_active = ?
ORDER BY
  w0_.created_at DESC,
  w1_.position ASC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40, w1_.wine_id AS wine_id_41 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = 1 ORDER BY w0_.created_at DESC, w1_.position ASC;

#	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->findActiveFiltered (line 49)
7	App\Controller\GiftController->sets (line 58)
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 34)
12	require_once (line 32)
13	require_once (line 7)

0.39 ms
(27.32%)

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.slug AS slug_2, g0_.description AS description_3, g0_.image_path AS image_path_4, g0_.bottle_capacity AS bottle_capacity_5, g0_.is_active AS is_active_6, g0_.position AS position_7, g0_.price_amount_cents AS price_amount_cents_8, g0_.price_currency AS price_currency_9, g0_.old_price_amount_cents AS old_price_amount_cents_10, g0_.old_price_currency AS old_price_currency_11 FROM gift_set g0_ WHERE g0_.is_active = ? ORDER BY g0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.slug AS slug_2,
  g0_.description AS description_3,
  g0_.image_path AS image_path_4,
  g0_.bottle_capacity AS bottle_capacity_5,
  g0_.is_active AS is_active_6,
  g0_.position AS position_7,
  g0_.price_amount_cents AS price_amount_cents_8,
  g0_.price_currency AS price_currency_9,
  g0_.old_price_amount_cents AS old_price_amount_cents_10,
  g0_.old_price_currency AS old_price_currency_11
FROM
  gift_set g0_
WHERE
  g0_.is_active = ?
ORDER BY
  g0_.position ASC

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.slug AS slug_2, g0_.description AS description_3, g0_.image_path AS image_path_4, g0_.bottle_capacity AS bottle_capacity_5, g0_.is_active AS is_active_6, g0_.position AS position_7, g0_.price_amount_cents AS price_amount_cents_8, g0_.price_currency AS price_currency_9, g0_.old_price_amount_cents AS old_price_amount_cents_10, g0_.old_price_currency AS old_price_currency_11 FROM gift_set g0_ WHERE g0_.is_active = 1 ORDER BY g0_.position ASC;

#	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\GiftSetRepository->findActive (line 32)
7	App\Controller\GiftController->sets (line 53)
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 34)
12	require_once (line 32)
13	require_once (line 7)

0.38 ms
(26.41%)

SELECT t0_.trans_key AS trans_key_0, t0_.value AS value_1 FROM translation_override t0_ WHERE t0_.domain = ? AND t0_.locale = ?

Parameters:

[
  "gifts"
  "lt"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.trans_key AS trans_key_0,
  t0_.value AS value_1
FROM
  translation_override t0_
WHERE
  t0_.domain = ?
  AND t0_.locale = ?

SELECT t0_.trans_key AS trans_key_0, t0_.value AS value_1 FROM translation_override t0_ WHERE t0_.domain = 'gifts' AND t0_.locale = 'lt';

#	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->getArrayResult (line 700)
6	App\Repository\TranslationOverrideRepository->overridesFor (line 33)
7	App\Translation\TranslatorDecorator->overridesFor (line 59)
8	App\Translation\TranslatorDecorator->trans (line 43)
9	Symfony\Component\Translation\DataCollectorTranslator->trans (line 44)
10	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 122)
11	__TwigTemplate_2651aa74688df3bb6dfe675831d74776->block_title (line 77)
12	Twig\Template->yieldBlock (line 458)
13	__TwigTemplate_4c817238d931e0e68a3f64f43fa12722->doDisplay (line 74)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_2651aa74688df3bb6dfe675831d74776->doDisplay (line 55)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\GiftController->sets (line 52)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	require_once (line 7)

0.18 ms
(12.61%)

SELECT s0_.setting_key AS setting_key_0, s0_.value AS value_1 FROM site_setting s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.setting_key AS setting_key_0,
  s0_.value AS value_1
FROM
  site_setting s0_

SELECT s0_.setting_key AS setting_key_0, s0_.value AS value_1 FROM site_setting s0_;

#	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->getArrayResult (line 700)
6	App\Repository\SiteSettingRepository->findAllAsMap (line 30)
7	App\Service\SettingsProvider->get (line 24)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_0bcb5a8c3a677f886b501d4c91893f27::doDisplay (line 165)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1527)
15	__TwigTemplate_4c817238d931e0e68a3f64f43fa12722::block_header (line 318)
16	Twig\Template->yieldBlock (line 458)
17	__TwigTemplate_4c817238d931e0e68a3f64f43fa12722->doDisplay (line 120)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_2651aa74688df3bb6dfe675831d74776->doDisplay (line 55)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\GiftController->sets (line 52)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 7)

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	4
App\Entity\WineImage	4
App\Entity\GiftSet	2

Entities Mapping

Class	Mapping errors
App\Entity\Embeddable\Money	No errors.
App\Entity\GiftSet	No errors.
App\Entity\Wine	No errors.
App\Entity\WineImage	No errors.
App\Entity\TranslationOverride	No errors.
App\Entity\SiteSetting	No errors.

Symfony Profiler

GET https://primo-vino.codity-dev.lt/dovanu-rinkiniai

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping