Symfony Profiler

Query Metrics

8 Database Queries

5 Different statements

8.58 ms Query time

0 Invalid entities

40 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.04 ms
(47.13%)

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = ? LIMIT 1

Parameters:

[
  "public.locale_definitions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.updated_at AS updated_at_4
FROM
  marketplace_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = 'public.locale_definitions' 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\Repository\MarketplaceSettingRepository->getValue (line 25)
5	App\Core\Service\MarketplaceConfig->resolvePublicLocaleDefinitions (line 171)
6	App\Core\Service\MarketplaceConfig->getLocales (line 75)
7	App\Core\Service\MarketplaceConfig->isLocaleEnabled (line 236)
8	App\Core\EventSubscriber\DisabledPublicLocaleSubscriber->onKernelRequest (line 50)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

1.34 ms
(15.61%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.status AS status_3, t0.display AS display_4, t0.price AS price_5, t0.currency AS currency_6, t0.condition AS condition_7, t0.stock_qty AS stock_qty_8, t0.weight_kg AS weight_kg_9, t0.length_cm AS length_cm_10, t0.width_cm AS width_cm_11, t0.height_cm AS height_cm_12, t0.depth_cm AS depth_cm_13, t0.diameter_cm AS diameter_cm_14, t0.is_week_featured AS is_week_featured_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.published_at AS published_at_18, t0.sold_at AS sold_at_19, t0.seller_id AS seller_id_20 FROM product t0 WHERE t0.id = ?

Parameters:

[
  176333
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.status AS status_3,
  t0.display AS display_4,
  t0.price AS price_5,
  t0.currency AS currency_6,
  t0.condition AS condition_7,
  t0.stock_qty AS stock_qty_8,
  t0.weight_kg AS weight_kg_9,
  t0.length_cm AS length_cm_10,
  t0.width_cm AS width_cm_11,
  t0.height_cm AS height_cm_12,
  t0.depth_cm AS depth_cm_13,
  t0.diameter_cm AS diameter_cm_14,
  t0.is_week_featured AS is_week_featured_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.published_at AS published_at_18,
  t0.sold_at AS sold_at_19,
  t0.seller_id AS seller_id_20
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.status AS status_3, t0.display AS display_4, t0.price AS price_5, t0.currency AS currency_6, t0.condition AS condition_7, t0.stock_qty AS stock_qty_8, t0.weight_kg AS weight_kg_9, t0.length_cm AS length_cm_10, t0.width_cm AS width_cm_11, t0.height_cm AS height_cm_12, t0.depth_cm AS depth_cm_13, t0.diameter_cm AS diameter_cm_14, t0.is_week_featured AS is_week_featured_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.published_at AS published_at_18, t0.sold_at AS sold_at_19, t0.seller_id AS seller_id_20 FROM product t0 WHERE t0.id = 176333;

#	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	App\Core\Controller\QuoteController->new (line 73)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

1.13 ms
(13.16%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.status AS status_3, t0.stripe_account_id AS stripe_account_id_4, t0.stripe_customer_id AS stripe_customer_id_5, t0.stripe_kyc_complete AS stripe_kyc_complete_6, t0.paypal_email AS paypal_email_7, t0.paypal_merchant_id AS paypal_merchant_id_8, t0.paypal_account_status AS paypal_account_status_9, t0.paypal_permissions_granted AS paypal_permissions_granted_10, t0.created_at AS created_at_11, t0.activated_at AS activated_at_12, t0.suspended_at AS suspended_at_13, t0.commercial_status AS commercial_status_14, t0.subscribed_since AS subscribed_since_15, t0.subscription_ends_at AS subscription_ends_at_16, t0.crm_priority AS crm_priority_17, t0.next_reminder_at AS next_reminder_at_18, t0.next_reminder_note AS next_reminder_note_19, t0.prospect_source AS prospect_source_20, t0.prospect_collected_at AS prospect_collected_at_21, t0.crm_flag_for_human AS crm_flag_for_human_22, t0.user_id AS user_id_23, t24.id AS id_25, t24.business_name AS business_name_26, t24.description AS description_27, t24.siret AS siret_28, t24.vat_number AS vat_number_29, t24.phone AS phone_30, t24.website AS website_31, t24.logo_path AS logo_path_32, t24.banner_path AS banner_path_33, t24.opening_hours AS opening_hours_34, t24.filter_tag_category_keys AS filter_tag_category_keys_35, t24.updated_at AS updated_at_36, t24.seller_id AS seller_id_37, t38.id AS id_39, t38.street AS street_40, t38.zip AS zip_41, t38.country_code AS country_code_42, t38.lat AS lat_43, t38.lng AS lng_44, t38.street_view_heading AS street_view_heading_45, t38.street_view_pitch AS street_view_pitch_46, t38.street_view_zoom AS street_view_zoom_47, t38.seller_id AS seller_id_48, t38.geo_city_id AS geo_city_id_49 FROM seller t0 LEFT JOIN seller_profile t24 ON t24.seller_id = t0.id LEFT JOIN seller_address t38 ON t38.seller_id = t0.id WHERE t0.id = ?

Parameters:

[
  6240
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.status AS status_3,
  t0.stripe_account_id AS stripe_account_id_4,
  t0.stripe_customer_id AS stripe_customer_id_5,
  t0.stripe_kyc_complete AS stripe_kyc_complete_6,
  t0.paypal_email AS paypal_email_7,
  t0.paypal_merchant_id AS paypal_merchant_id_8,
  t0.paypal_account_status AS paypal_account_status_9,
  t0.paypal_permissions_granted AS paypal_permissions_granted_10,
  t0.created_at AS created_at_11,
  t0.activated_at AS activated_at_12,
  t0.suspended_at AS suspended_at_13,
  t0.commercial_status AS commercial_status_14,
  t0.subscribed_since AS subscribed_since_15,
  t0.subscription_ends_at AS subscription_ends_at_16,
  t0.crm_priority AS crm_priority_17,
  t0.next_reminder_at AS next_reminder_at_18,
  t0.next_reminder_note AS next_reminder_note_19,
  t0.prospect_source AS prospect_source_20,
  t0.prospect_collected_at AS prospect_collected_at_21,
  t0.crm_flag_for_human AS crm_flag_for_human_22,
  t0.user_id AS user_id_23,
  t24.id AS id_25,
  t24.business_name AS business_name_26,
  t24.description AS description_27,
  t24.siret AS siret_28,
  t24.vat_number AS vat_number_29,
  t24.phone AS phone_30,
  t24.website AS website_31,
  t24.logo_path AS logo_path_32,
  t24.banner_path AS banner_path_33,
  t24.opening_hours AS opening_hours_34,
  t24.filter_tag_category_keys AS filter_tag_category_keys_35,
  t24.updated_at AS updated_at_36,
  t24.seller_id AS seller_id_37,
  t38.id AS id_39,
  t38.street AS street_40,
  t38.zip AS zip_41,
  t38.country_code AS country_code_42,
  t38.lat AS lat_43,
  t38.lng AS lng_44,
  t38.street_view_heading AS street_view_heading_45,
  t38.street_view_pitch AS street_view_pitch_46,
  t38.street_view_zoom AS street_view_zoom_47,
  t38.seller_id AS seller_id_48,
  t38.geo_city_id AS geo_city_id_49
FROM
  seller t0
  LEFT JOIN seller_profile t24 ON t24.seller_id = t0.id
  LEFT JOIN seller_address t38 ON t38.seller_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.status AS status_3, t0.stripe_account_id AS stripe_account_id_4, t0.stripe_customer_id AS stripe_customer_id_5, t0.stripe_kyc_complete AS stripe_kyc_complete_6, t0.paypal_email AS paypal_email_7, t0.paypal_merchant_id AS paypal_merchant_id_8, t0.paypal_account_status AS paypal_account_status_9, t0.paypal_permissions_granted AS paypal_permissions_granted_10, t0.created_at AS created_at_11, t0.activated_at AS activated_at_12, t0.suspended_at AS suspended_at_13, t0.commercial_status AS commercial_status_14, t0.subscribed_since AS subscribed_since_15, t0.subscription_ends_at AS subscription_ends_at_16, t0.crm_priority AS crm_priority_17, t0.next_reminder_at AS next_reminder_at_18, t0.next_reminder_note AS next_reminder_note_19, t0.prospect_source AS prospect_source_20, t0.prospect_collected_at AS prospect_collected_at_21, t0.crm_flag_for_human AS crm_flag_for_human_22, t0.user_id AS user_id_23, t24.id AS id_25, t24.business_name AS business_name_26, t24.description AS description_27, t24.siret AS siret_28, t24.vat_number AS vat_number_29, t24.phone AS phone_30, t24.website AS website_31, t24.logo_path AS logo_path_32, t24.banner_path AS banner_path_33, t24.opening_hours AS opening_hours_34, t24.filter_tag_category_keys AS filter_tag_category_keys_35, t24.updated_at AS updated_at_36, t24.seller_id AS seller_id_37, t38.id AS id_39, t38.street AS street_40, t38.zip AS zip_41, t38.country_code AS country_code_42, t38.lat AS lat_43, t38.lng AS lng_44, t38.street_view_heading AS street_view_heading_45, t38.street_view_pitch AS street_view_pitch_46, t38.street_view_zoom AS street_view_zoom_47, t38.seller_id AS seller_id_48, t38.geo_city_id AS geo_city_id_49 FROM seller t0 LEFT JOIN seller_profile t24 ON t24.seller_id = t0.id LEFT JOIN seller_address t38 ON t38.seller_id = t0.id WHERE t0.id = 6240;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Seller::getDisplayName (line 351)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_ee1df8cdbd8496f00c051613dd1ef207::block_body (line 164)
7	Twig\Template->yieldBlock (line 446)
8	__TwigTemplate_fae6da18b939291a11836bf5e06f8697->doDisplay (line 648)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_ee1df8cdbd8496f00c051613dd1ef207->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
19	App\Core\Controller\QuoteController->new (line 127)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 191)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

1.13 ms
(13.16%)

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.thumb_path AS thumb_path_3, t0.detail_path AS detail_path_4, t0.alt_text AS alt_text_5, t0.position AS position_6, t0.is_primary AS is_primary_7, t0.width AS width_8, t0.height AS height_9, t0.created_at AS created_at_10, t0.product_id AS product_id_11 FROM product_image t0 WHERE t0.product_id = ?

Parameters:

[
  176333
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.thumb_path AS thumb_path_3,
  t0.detail_path AS detail_path_4,
  t0.alt_text AS alt_text_5,
  t0.position AS position_6,
  t0.is_primary AS is_primary_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.created_at AS created_at_10,
  t0.product_id AS product_id_11
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.thumb_path AS thumb_path_3, t0.detail_path AS detail_path_4, t0.alt_text AS alt_text_5, t0.position AS position_6, t0.is_primary AS is_primary_7, t0.width AS width_8, t0.height AS height_9, t0.created_at AS created_at_10, t0.product_id AS product_id_11 FROM product_image t0 WHERE t0.product_id = 176333;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
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->testEmpty (line 1423)
9	__TwigTemplate_ee1df8cdbd8496f00c051613dd1ef207::block_body (line 140)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_fae6da18b939291a11836bf5e06f8697->doDisplay (line 648)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_ee1df8cdbd8496f00c051613dd1ef207->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Core\Controller\QuoteController->new (line 127)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.94 ms
(10.94%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?

Parameters:

[
  176333
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 176333;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Product->getTranslation (line 258)
8	App\Entity\Product->getTitle (line 268)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_ee1df8cdbd8496f00c051613dd1ef207::block_title (line 77)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_fae6da18b939291a11836bf5e06f8697->doDisplay (line 81)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_ee1df8cdbd8496f00c051613dd1ef207->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
23	App\Core\Controller\QuoteController->new (line 127)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	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\ProductImage	22
App\Entity\ProductTranslation	9
App\Entity\MarketplaceSetting	3
App\Entity\Product	1
App\Entity\Seller	1
App\Entity\User	1
App\Entity\SellerProfile	1
App\Entity\SellerAddress	1
App\Entity\Geo\GeoCity	1

Entities Mapping

Class	Mapping errors
App\Entity\MarketplaceSetting	No errors.
App\Entity\Product	No errors.
App\Entity\Seller	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductView	No errors.
App\Entity\ProductShippingRule	No errors.
App\Entity\Tag	No errors.
App\Entity\User	No errors.
App\Entity\SellerProfile	No errors.
App\Entity\SellerAddress	No errors.
App\Entity\Geo\GeoCity	No errors.
App\Entity\SellerSubscription	No errors.
App\Entity\SellerInvoice	No errors.
App\Entity\SellerStat	No errors.
App\Entity\SellerProfileTranslation	No errors.

Symfony Profiler

GET http://www.nxt.antiquites-en-france.com/ru/devis/nouveau?productId=176333

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping