Symfony Profiler

Query Metrics

59 Database Queries

14 Different statements

22.93 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.52 ms
(32.80%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?

Parameters:

[
  173
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.mobile AS mobile_7,
  t0.avatar AS avatar_8,
  t0.token AS token_9,
  t0.token_date AS token_date_10,
  t0.last_login AS last_login_11,
  t0.email_verified AS email_verified_12,
  t0.mobile_verified AS mobile_verified_13,
  t0.enabled AS enabled_14,
  t0.date_of_birth AS date_of_birth_15,
  t0.gender AS gender_16,
  t0.zoho_id AS zoho_id_17,
  t0.display_name AS display_name_18,
  t0.company AS company_19,
  t0.location AS location_20,
  t0.type AS type_21,
  t0.phone AS phone_22,
  t0.pan AS pan_23,
  t0.gst_number AS gst_number_24,
  t0.gst_treatment AS gst_treatment_25,
  t0.place_of_contact AS place_of_contact_26,
  t0.imported AS imported_27,
  t0.additional_email AS additional_email_28,
  t0.offline_payment AS offline_payment_29,
  t0.logic_code AS logic_code_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.school_id AS school_id_33
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = 173;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 44)
14	Stof\DoctrineExtensionsBundle\EventListener\BlameListener->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

5.18 ms
(22.59%)

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.id = ?

Parameters:

[
  2767
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.item_code AS item_code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.sku AS sku_6,
  t0.hsn_code AS hsn_code_7,
  t0.description AS description_8,
  t0.size AS size_9,
  t0.unit AS unit_10,
  t0.rate AS rate_11,
  t0.purchase_rate AS purchase_rate_12,
  t0.combo_product AS combo_product_13,
  t0.taxable AS taxable_14,
  t0.stock_on_hand AS stock_on_hand_15,
  t0.available_stock AS available_stock_16,
  t0.actual_available_stock AS actual_available_stock_17,
  t0.committed_stock AS committed_stock_18,
  t0.actual_committed_stock AS actual_committed_stock_19,
  t0.available_for_sale_stock AS available_for_sale_stock_20,
  t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21,
  t0.active AS active_22,
  t0.imported AS imported_23,
  t0.meta_title AS meta_title_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.featured AS featured_27,
  t0.trending AS trending_28,
  t0.show_in_portal AS show_in_portal_29,
  t0.gender AS gender_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.category_id AS category_id_33,
  t0.group_id AS group_id_34,
  t0.grade_id AS grade_id_35,
  t0.intra_tax_id AS intra_tax_id_36,
  t0.inter_tax_id AS inter_tax_id_37,
  t0.created_by AS created_by_38,
  t0.updated_by AS updated_by_39
FROM
  item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.id = 2767;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Item::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Item->__get (line 367)
8	App\Entity\Item->getRate (line 173)
9	App\Entity\Item->getPrice (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 99)
11	__TwigTemplate_8c8515b83d35ed3e31881de506d9d5bf->doDisplay (line 388)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_c9ae907330dedafb2c0a66539aeefa1b->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 194)
22	App\Controller\CartController->cart (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
26	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
27	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
28	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
29	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 52)
30	__TwigTemplate_9958ea0b0d496d0164b1f2beaa9d2f66->doDisplay (line 388)
31	Twig\Template->yield (line 344)
32	Twig\Template->display (line 359)
33	Twig\Template->render (line 51)
34	Twig\TemplateWrapper->render (line 334)
35	Twig\Environment->render (line 431)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
39	App\Controller\DefaultController->header (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
42	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
43	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
44	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
45	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
46	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 262)
47	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_header (line 432)
48	Twig\Template->yieldBlock (line 100)
49	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
50	Twig\Template->yield (line 54)
51	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
52	Twig\Template->yield (line 344)
53	Twig\Template->display (line 359)
54	Twig\Template->render (line 51)
55	Twig\TemplateWrapper->render (line 334)
56	Twig\Environment->render (line 431)
57	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
58	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
59	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
60	App\Controller\DefaultController->productsDetails (line 183)
61	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
62	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
63	Symfony\Component\HttpKernel\Kernel->handle (line 35)
64	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
65	require_once (line 5)

4.07 ms
(17.73%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC

Parameters:

[
  3677
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.`position` AS position_3,
  t0.item_id AS item_id_4
FROM
  item_image t0
WHERE
  t0.item_id = ?
ORDER BY
  t0.`position` ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 3677 ORDER BY t0.`position` ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1)
9	count (line 182)
10	App\Entity\Item->getGroupImages (line 190)
11	App\Entity\Item->getImage (line 1882)
12	Twig\Extension\CoreExtension::getAttribute (line 81)
13	__TwigTemplate_8c8515b83d35ed3e31881de506d9d5bf->doDisplay (line 388)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_c9ae907330dedafb2c0a66539aeefa1b->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 194)
24	App\Controller\CartController->cart (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 52)
32	__TwigTemplate_9958ea0b0d496d0164b1f2beaa9d2f66->doDisplay (line 388)
33	Twig\Template->yield (line 344)
34	Twig\Template->display (line 359)
35	Twig\Template->render (line 51)
36	Twig\TemplateWrapper->render (line 334)
37	Twig\Environment->render (line 431)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
41	App\Controller\DefaultController->header (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
44	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
45	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
46	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
47	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
48	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 262)
49	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_header (line 432)
50	Twig\Template->yieldBlock (line 100)
51	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
52	Twig\Template->yield (line 54)
53	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
54	Twig\Template->yield (line 344)
55	Twig\Template->display (line 359)
56	Twig\Template->render (line 51)
57	Twig\TemplateWrapper->render (line 334)
58	Twig\Environment->render (line 431)
59	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
60	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
61	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
62	App\Controller\DefaultController->productsDetails (line 183)
63	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
64	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
65	Symfony\Component\HttpKernel\Kernel->handle (line 35)
66	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
67	require_once (line 5)

1.70 ms
(7.40%)

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.group_id = ? ORDER BY t0.size ASC

Parameters:

[
  191
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.item_code AS item_code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.sku AS sku_6,
  t0.hsn_code AS hsn_code_7,
  t0.description AS description_8,
  t0.size AS size_9,
  t0.unit AS unit_10,
  t0.rate AS rate_11,
  t0.purchase_rate AS purchase_rate_12,
  t0.combo_product AS combo_product_13,
  t0.taxable AS taxable_14,
  t0.stock_on_hand AS stock_on_hand_15,
  t0.available_stock AS available_stock_16,
  t0.actual_available_stock AS actual_available_stock_17,
  t0.committed_stock AS committed_stock_18,
  t0.actual_committed_stock AS actual_committed_stock_19,
  t0.available_for_sale_stock AS available_for_sale_stock_20,
  t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21,
  t0.active AS active_22,
  t0.imported AS imported_23,
  t0.meta_title AS meta_title_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.featured AS featured_27,
  t0.trending AS trending_28,
  t0.show_in_portal AS show_in_portal_29,
  t0.gender AS gender_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.category_id AS category_id_33,
  t0.group_id AS group_id_34,
  t0.grade_id AS grade_id_35,
  t0.intra_tax_id AS intra_tax_id_36,
  t0.inter_tax_id AS inter_tax_id_37,
  t0.created_by AS created_by_38,
  t0.updated_by AS updated_by_39
FROM
  item t0
WHERE
  t0.group_id = ?
ORDER BY
  t0.size ASC

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.group_id = 191 ORDER BY t0.size ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 53)
8	App\Entity\ItemGroup->getActiveVisibleItems (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 56)
10	__TwigTemplate_f2e0164c9e4ae3652e0dd2424700f32e->doDisplay (line 388)
11	Twig\Template->yield (line 375)
12	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->block_body (line 432)
13	Twig\Template->yieldBlock (line 142)
14	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
25	App\Controller\DefaultController->productsDetails (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.12 ms
(4.87%)

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.unit AS unit_5, t0.size_chart AS size_chart_6, t0.active AS active_7, t0.imported AS imported_8 FROM item_group t0 WHERE t0.id = ?

Parameters:

[
  191
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.unit AS unit_5,
  t0.size_chart AS size_chart_6,
  t0.active AS active_7,
  t0.imported AS imported_8
FROM
  item_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.unit AS unit_5, t0.size_chart AS size_chart_6, t0.active AS active_7, t0.imported AS imported_8 FROM item_group t0 WHERE t0.id = 191;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ItemGroup::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\ItemGroup->__get (line 53)
8	App\Entity\ItemGroup->getActiveVisibleItems (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 56)
10	__TwigTemplate_f2e0164c9e4ae3652e0dd2424700f32e->doDisplay (line 388)
11	Twig\Template->yield (line 375)
12	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->block_body (line 432)
13	Twig\Template->yieldBlock (line 142)
14	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
25	App\Controller\DefaultController->productsDetails (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.53 ms
(2.31%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4
FROM
  item_category t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 123)
4	App\Controller\DefaultController->header (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 262)
12	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_header (line 432)
13	Twig\Template->yieldBlock (line 100)
14	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
25	App\Controller\DefaultController->productsDetails (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.44 ms
(1.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM grade t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4
FROM
  grade t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM grade t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 124)
4	App\Controller\DefaultController->header (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 262)
12	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_header (line 432)
13	Twig\Template->yieldBlock (line 100)
14	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
25	App\Controller\DefaultController->productsDetails (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.41 ms
(1.79%)

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "boy-learning-year-1-kit-new"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.item_code AS item_code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.sku AS sku_6,
  t0.hsn_code AS hsn_code_7,
  t0.description AS description_8,
  t0.size AS size_9,
  t0.unit AS unit_10,
  t0.rate AS rate_11,
  t0.purchase_rate AS purchase_rate_12,
  t0.combo_product AS combo_product_13,
  t0.taxable AS taxable_14,
  t0.stock_on_hand AS stock_on_hand_15,
  t0.available_stock AS available_stock_16,
  t0.actual_available_stock AS actual_available_stock_17,
  t0.committed_stock AS committed_stock_18,
  t0.actual_committed_stock AS actual_committed_stock_19,
  t0.available_for_sale_stock AS available_for_sale_stock_20,
  t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21,
  t0.active AS active_22,
  t0.imported AS imported_23,
  t0.meta_title AS meta_title_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.featured AS featured_27,
  t0.trending AS trending_28,
  t0.show_in_portal AS show_in_portal_29,
  t0.gender AS gender_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.category_id AS category_id_33,
  t0.group_id AS group_id_34,
  t0.grade_id AS grade_id_35,
  t0.intra_tax_id AS intra_tax_id_36,
  t0.inter_tax_id AS inter_tax_id_37,
  t0.created_by AS created_by_38,
  t0.updated_by AS updated_by_39
FROM
  item t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.slug = 'boy-learning-year-1-kit-new' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 257)
4	App\Controller\DefaultController->productsDetails (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.39 ms
(1.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.publish = ? AND t0.footer_nav = ? ORDER BY t0.`position` ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.title AS title_4,
  t0.body AS body_5,
  t0.featured_image AS featured_image_6,
  t0.footer_nav AS footer_nav_7,
  t0.`position` AS position_8,
  t0.publish AS publish_9,
  t0.public AS public_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  page t0
WHERE
  t0.publish = ?
  AND t0.footer_nav = ?
ORDER BY
  t0.`position` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.publish = 1 AND t0.footer_nav = 1 ORDER BY t0.`position` ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 134)
4	App\Controller\DefaultController->footer (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 311)
12	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_footer (line 432)
13	Twig\Template->yieldBlock (line 147)
14	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
25	App\Controller\DefaultController->productsDetails (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.39 ms
(1.68%)

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.trending_products_title AS trending_products_title_18, t0.trending_products_description AS trending_products_description_19, t0.combined_kit_title AS combined_kit_title_20, t0.combined_kit_description AS combined_kit_description_21, t0.how_works_title AS how_works_title_22, t0.how_works_description AS how_works_description_23, t0.contact_us_image AS contact_us_image_24, t0.contact_us_title AS contact_us_title_25, t0.contact_us_description AS contact_us_description_26, t0.contact_us_map AS contact_us_map_27, t0.google_analytics_id AS google_analytics_id_28, t0.google_tag_manager_code AS google_tag_manager_code_29, t0.google_site_verification_code AS google_site_verification_code_30, t0.zoho_token AS zoho_token_31, t0.zoho_token_created_at AS zoho_token_created_at_32, t0.safex_token AS safex_token_33, t0.safex_token_created_at AS safex_token_created_at_34, t0.blue_dart_token AS blue_dart_token_35, t0.blue_dart_token_created_at AS blue_dart_token_created_at_36, t0.invoice_cc AS invoice_cc_37, t0.meta_title AS meta_title_38, t0.meta_description AS meta_description_39, t0.meta_keywords AS meta_keywords_40 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.tagline AS tagline_3,
  t0.logo_footer AS logo_footer_4,
  t0.footer_description AS footer_description_5,
  t0.facebook_link AS facebook_link_6,
  t0.x_link AS x_link_7,
  t0.instagram_link AS instagram_link_8,
  t0.linkedin_link AS linkedin_link_9,
  t0.whatsapp_link AS whatsapp_link_10,
  t0.contact_phone AS contact_phone_11,
  t0.contact_email AS contact_email_12,
  t0.address AS address_13,
  t0.map_link AS map_link_14,
  t0.home_banner_title AS home_banner_title_15,
  t0.home_banner_description AS home_banner_description_16,
  t0.home_banner_image AS home_banner_image_17,
  t0.trending_products_title AS trending_products_title_18,
  t0.trending_products_description AS trending_products_description_19,
  t0.combined_kit_title AS combined_kit_title_20,
  t0.combined_kit_description AS combined_kit_description_21,
  t0.how_works_title AS how_works_title_22,
  t0.how_works_description AS how_works_description_23,
  t0.contact_us_image AS contact_us_image_24,
  t0.contact_us_title AS contact_us_title_25,
  t0.contact_us_description AS contact_us_description_26,
  t0.contact_us_map AS contact_us_map_27,
  t0.google_analytics_id AS google_analytics_id_28,
  t0.google_tag_manager_code AS google_tag_manager_code_29,
  t0.google_site_verification_code AS google_site_verification_code_30,
  t0.zoho_token AS zoho_token_31,
  t0.zoho_token_created_at AS zoho_token_created_at_32,
  t0.safex_token AS safex_token_33,
  t0.safex_token_created_at AS safex_token_created_at_34,
  t0.blue_dart_token AS blue_dart_token_35,
  t0.blue_dart_token_created_at AS blue_dart_token_created_at_36,
  t0.invoice_cc AS invoice_cc_37,
  t0.meta_title AS meta_title_38,
  t0.meta_description AS meta_description_39,
  t0.meta_keywords AS meta_keywords_40
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.trending_products_title AS trending_products_title_18, t0.trending_products_description AS trending_products_description_19, t0.combined_kit_title AS combined_kit_title_20, t0.combined_kit_description AS combined_kit_description_21, t0.how_works_title AS how_works_title_22, t0.how_works_description AS how_works_description_23, t0.contact_us_image AS contact_us_image_24, t0.contact_us_title AS contact_us_title_25, t0.contact_us_description AS contact_us_description_26, t0.contact_us_map AS contact_us_map_27, t0.google_analytics_id AS google_analytics_id_28, t0.google_tag_manager_code AS google_tag_manager_code_29, t0.google_site_verification_code AS google_site_verification_code_30, t0.zoho_token AS zoho_token_31, t0.zoho_token_created_at AS zoho_token_created_at_32, t0.safex_token AS safex_token_33, t0.safex_token_created_at AS safex_token_created_at_34, t0.blue_dart_token AS blue_dart_token_35, t0.blue_dart_token_created_at AS blue_dart_token_created_at_36, t0.invoice_cc AS invoice_cc_37, t0.meta_title AS meta_title_38, t0.meta_description AS meta_description_39, t0.meta_keywords AS meta_keywords_40 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 71)
4	App\Controller\DefaultController->meta (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 65)
12	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
23	App\Controller\DefaultController->productsDetails (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.38 ms
(1.65%)

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.active = ? AND t0.slug = ? LIMIT 1

Parameters:

[
  1
  "boy-learning-year-1-kit-new"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.item_code AS item_code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.sku AS sku_6,
  t0.hsn_code AS hsn_code_7,
  t0.description AS description_8,
  t0.size AS size_9,
  t0.unit AS unit_10,
  t0.rate AS rate_11,
  t0.purchase_rate AS purchase_rate_12,
  t0.combo_product AS combo_product_13,
  t0.taxable AS taxable_14,
  t0.stock_on_hand AS stock_on_hand_15,
  t0.available_stock AS available_stock_16,
  t0.actual_available_stock AS actual_available_stock_17,
  t0.committed_stock AS committed_stock_18,
  t0.actual_committed_stock AS actual_committed_stock_19,
  t0.available_for_sale_stock AS available_for_sale_stock_20,
  t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21,
  t0.active AS active_22,
  t0.imported AS imported_23,
  t0.meta_title AS meta_title_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.featured AS featured_27,
  t0.trending AS trending_28,
  t0.show_in_portal AS show_in_portal_29,
  t0.gender AS gender_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.category_id AS category_id_33,
  t0.group_id AS group_id_34,
  t0.grade_id AS grade_id_35,
  t0.intra_tax_id AS intra_tax_id_36,
  t0.inter_tax_id AS inter_tax_id_37,
  t0.created_by AS created_by_38,
  t0.updated_by AS updated_by_39
FROM
  item t0
WHERE
  t0.active = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.active = 1 AND t0.slug = 'boy-learning-year-1-kit-new' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 78)
4	App\Controller\DefaultController->meta (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 65)
12	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
23	App\Controller\DefaultController->productsDetails (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.31 ms
(1.33%)

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5, t0.parent_id AS parent_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM cart t0 WHERE t0.created_by = ?

Parameters:

[
  173
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.item_id AS item_id_5,
  t0.parent_id AS parent_id_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  cart t0
WHERE
  t0.created_by = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5, t0.parent_id AS parent_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM cart t0 WHERE t0.created_by = 173;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 177)
4	App\Controller\CartController->cart (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 52)
12	__TwigTemplate_9958ea0b0d496d0164b1f2beaa9d2f66->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
21	App\Controller\DefaultController->header (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 262)
29	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_header (line 432)
30	Twig\Template->yieldBlock (line 100)
31	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
34	Twig\Template->yield (line 344)
35	Twig\Template->display (line 359)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 334)
38	Twig\Environment->render (line 431)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
42	App\Controller\DefaultController->productsDetails (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 5)

0.26 ms
(1.12%)

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = ?

Parameters:

[
  3677
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.composite_item_id AS composite_item_id_3,
  t0.item_id AS item_id_4
FROM
  composite_item t0
WHERE
  t0.composite_item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 3677;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 172)
8	App\Entity\Item->getPrice (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 99)
10	__TwigTemplate_8c8515b83d35ed3e31881de506d9d5bf->doDisplay (line 388)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_c9ae907330dedafb2c0a66539aeefa1b->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 194)
21	App\Controller\CartController->cart (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 52)
29	__TwigTemplate_9958ea0b0d496d0164b1f2beaa9d2f66->doDisplay (line 388)
30	Twig\Template->yield (line 344)
31	Twig\Template->display (line 359)
32	Twig\Template->render (line 51)
33	Twig\TemplateWrapper->render (line 334)
34	Twig\Environment->render (line 431)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
38	App\Controller\DefaultController->header (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
41	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
42	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
43	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
44	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
45	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 262)
46	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_header (line 432)
47	Twig\Template->yieldBlock (line 100)
48	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
49	Twig\Template->yield (line 54)
50	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
51	Twig\Template->yield (line 344)
52	Twig\Template->display (line 359)
53	Twig\Template->render (line 51)
54	Twig\TemplateWrapper->render (line 334)
55	Twig\Environment->render (line 431)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
57	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
58	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
59	App\Controller\DefaultController->productsDetails (line 183)
60	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
61	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
62	Symfony\Component\HttpKernel\Kernel->handle (line 35)
63	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
64	require_once (line 5)

0.25 ms
(1.09%)

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?

Parameters:

[
  3677
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.item_id AS item_id_3,
  t0.group_id AS group_id_4
FROM
  item_mandatory t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 3677;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 105)
10	__TwigTemplate_8c8515b83d35ed3e31881de506d9d5bf->doDisplay (line 388)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_c9ae907330dedafb2c0a66539aeefa1b->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 194)
21	App\Controller\CartController->cart (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 52)
29	__TwigTemplate_9958ea0b0d496d0164b1f2beaa9d2f66->doDisplay (line 388)
30	Twig\Template->yield (line 344)
31	Twig\Template->display (line 359)
32	Twig\Template->render (line 51)
33	Twig\TemplateWrapper->render (line 334)
34	Twig\Environment->render (line 431)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
38	App\Controller\DefaultController->header (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
41	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
42	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
43	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
44	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
45	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 262)
46	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->block_header (line 432)
47	Twig\Template->yieldBlock (line 100)
48	__TwigTemplate_bed424490114560d0ef783f7b2456b3e->doDisplay (line 388)
49	Twig\Template->yield (line 54)
50	__TwigTemplate_7ddb7858f6da403b4d372e06a2807d78->doDisplay (line 388)
51	Twig\Template->yield (line 344)
52	Twig\Template->display (line 359)
53	Twig\Template->render (line 51)
54	Twig\TemplateWrapper->render (line 334)
55	Twig\Environment->render (line 431)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
57	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
58	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 258)
59	App\Controller\DefaultController->productsDetails (line 183)
60	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
61	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
62	Symfony\Component\HttpKernel\Kernel->handle (line 35)
63	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
64	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\School	No errors.
App\Entity\Address	No errors.
App\Entity\Item	No errors.
App\Entity\ItemCategory	No errors.
App\Entity\ItemGroup	No errors.
App\Entity\Grade	No errors.
App\Entity\Tax	No errors.
App\Entity\CompositeItem	No errors.
App\Entity\ItemStock	No errors.
App\Entity\ItemImage	No errors.
App\Entity\ItemMandatory	No errors.
App\Entity\Setting	No errors.
App\Entity\KeyFeature	No errors.
App\Entity\HowWorks	No errors.
App\Entity\Warehouse	No errors.
App\Entity\Cart	No errors.
App\Entity\Page	No errors.
App\Entity\PageSection	No errors.

Symfony Profiler

GET https://innovineschoolshop.com/product/boy-learning-year-1-kit-new

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping