Symfony Profiler

Query Metrics

102 Database Queries

8 Different statements

54.65 ms Query time

0 Invalid entities

124 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

36.26 ms
(66.35%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.id = ? AND t0.active = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.active AS active_3,
  t0.force_display AS force_display_4,
  t0.type AS type_5,
  t0.date_add AS date_add_6,
  t0.date_up AS date_up_7,
  t0.level AS level_8,
  t0.name AS name_9,
  t0.description AS description_10,
  t0.slug AS slug_11,
  t0.parent_id AS parent_id_12
FROM
  mg_categories t0
WHERE
  t0.id = ?
  AND t0.active = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.id = 2 AND t0.active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\MenusController->displayMenuCat (line 77)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 248)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_9f186687f3ab82e0ceebf71b132ac702->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 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\HomeController->index (line 30)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

7.88 ms
(14.41%)

SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = ? AND t0.cover = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.position AS position_3,
  t0.cover AS cover_4,
  t0.mime_type AS mime_type_5,
  t0.product_id AS product_id_6
FROM
  mg_products_images t0
WHERE
  t0.product_id = ?
  AND t0.cover = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = 1994 AND t0.cover = 1 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\HomeController->index (line 19)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

3.12 ms
(5.71%)

SELECT m0_.id AS id_0, m0_.reference AS reference_1, m0_.purshasing_price AS purshasing_price_2, m0_.selling_price AS selling_price_3, m0_.selling_price_all_taxes AS selling_price_all_taxes_4, m0_.sales_unit AS sales_unit_5, m0_.min_quantity AS min_quantity_6, m0_.max_quantity AS max_quantity_7, m0_.bulk_quantity AS bulk_quantity_8, m0_.discount AS discount_9, m0_.discount_type AS discount_type_10, m0_.discount_on_taxe AS discount_on_taxe_11, m0_.stock_management AS stock_management_12, m0_.quantity AS quantity_13, m0_.sell_out_of_stock AS sell_out_of_stock_14, m0_.stock_alert AS stock_alert_15, m0_.pre_order AS pre_order_16, m0_.available_date AS available_date_17, m0_.date_publish AS date_publish_18, m0_.offline AS offline_19, m0_.type AS type_20, m0_.date_add AS date_add_21, m0_.date_up AS date_up_22, m0_.additionnal_shipping_cost AS additionnal_shipping_cost_23, m0_.width AS width_24, m0_.height AS height_25, m0_.depth AS depth_26, m0_.weight AS weight_27, m0_.name AS name_28, m0_.summary AS summary_29, m0_.slug AS slug_30, m0_.description AS description_31, m1_.id AS id_32, m1_.supplier_name AS supplier_name_33, m1_.supplier_address AS supplier_address_34, m1_.supplier_zipcode AS supplier_zipcode_35, m1_.supplier_town AS supplier_town_36, m1_.supplier_phone AS supplier_phone_37, m1_.supplier_email AS supplier_email_38, m1_.supplier_web AS supplier_web_39, m1_.supplier_logo AS supplier_logo_40, m1_.suppliers_notes AS suppliers_notes_41, m2_.id AS id_42, m2_.taxe_rate AS taxe_rate_43, m2_.taxe_active AS taxe_active_44, m0_.supplier_id AS supplier_id_45, m0_.gamme_id AS gamme_id_46, m0_.carrier_id AS carrier_id_47, m0_.parent_id AS parent_id_48, m0_.taxe_id AS taxe_id_49 FROM mg_products m0_ INNER JOIN mg_suppliers m1_ ON m0_.supplier_id = m1_.id INNER JOIN mg_taxes m2_ ON m0_.taxe_id = m2_.id WHERE m0_.offline = 0 AND m0_.date_publish <= ? AND m0_.type = ? AND m0_.gamme_id IS NOT NULL ORDER BY m0_.date_publish DESC LIMIT 12

Parameters:

[
  "2025-12-15 01:33:40"
  "master"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.reference AS reference_1,
  m0_.purshasing_price AS purshasing_price_2,
  m0_.selling_price AS selling_price_3,
  m0_.selling_price_all_taxes AS selling_price_all_taxes_4,
  m0_.sales_unit AS sales_unit_5,
  m0_.min_quantity AS min_quantity_6,
  m0_.max_quantity AS max_quantity_7,
  m0_.bulk_quantity AS bulk_quantity_8,
  m0_.discount AS discount_9,
  m0_.discount_type AS discount_type_10,
  m0_.discount_on_taxe AS discount_on_taxe_11,
  m0_.stock_management AS stock_management_12,
  m0_.quantity AS quantity_13,
  m0_.sell_out_of_stock AS sell_out_of_stock_14,
  m0_.stock_alert AS stock_alert_15,
  m0_.pre_order AS pre_order_16,
  m0_.available_date AS available_date_17,
  m0_.date_publish AS date_publish_18,
  m0_.offline AS offline_19,
  m0_.type AS type_20,
  m0_.date_add AS date_add_21,
  m0_.date_up AS date_up_22,
  m0_.additionnal_shipping_cost AS additionnal_shipping_cost_23,
  m0_.width AS width_24,
  m0_.height AS height_25,
  m0_.depth AS depth_26,
  m0_.weight AS weight_27,
  m0_.name AS name_28,
  m0_.summary AS summary_29,
  m0_.slug AS slug_30,
  m0_.description AS description_31,
  m1_.id AS id_32,
  m1_.supplier_name AS supplier_name_33,
  m1_.supplier_address AS supplier_address_34,
  m1_.supplier_zipcode AS supplier_zipcode_35,
  m1_.supplier_town AS supplier_town_36,
  m1_.supplier_phone AS supplier_phone_37,
  m1_.supplier_email AS supplier_email_38,
  m1_.supplier_web AS supplier_web_39,
  m1_.supplier_logo AS supplier_logo_40,
  m1_.suppliers_notes AS suppliers_notes_41,
  m2_.id AS id_42,
  m2_.taxe_rate AS taxe_rate_43,
  m2_.taxe_active AS taxe_active_44,
  m0_.supplier_id AS supplier_id_45,
  m0_.gamme_id AS gamme_id_46,
  m0_.carrier_id AS carrier_id_47,
  m0_.parent_id AS parent_id_48,
  m0_.taxe_id AS taxe_id_49
FROM
  mg_products m0_
  INNER JOIN mg_suppliers m1_ ON m0_.supplier_id = m1_.id
  INNER JOIN mg_taxes m2_ ON m0_.taxe_id = m2_.id
WHERE
  m0_.offline = 0
  AND m0_.date_publish <= ?
  AND m0_.type = ?
  AND m0_.gamme_id IS NOT NULL
ORDER BY
  m0_.date_publish DESC
LIMIT
  12

SELECT m0_.id AS id_0, m0_.reference AS reference_1, m0_.purshasing_price AS purshasing_price_2, m0_.selling_price AS selling_price_3, m0_.selling_price_all_taxes AS selling_price_all_taxes_4, m0_.sales_unit AS sales_unit_5, m0_.min_quantity AS min_quantity_6, m0_.max_quantity AS max_quantity_7, m0_.bulk_quantity AS bulk_quantity_8, m0_.discount AS discount_9, m0_.discount_type AS discount_type_10, m0_.discount_on_taxe AS discount_on_taxe_11, m0_.stock_management AS stock_management_12, m0_.quantity AS quantity_13, m0_.sell_out_of_stock AS sell_out_of_stock_14, m0_.stock_alert AS stock_alert_15, m0_.pre_order AS pre_order_16, m0_.available_date AS available_date_17, m0_.date_publish AS date_publish_18, m0_.offline AS offline_19, m0_.type AS type_20, m0_.date_add AS date_add_21, m0_.date_up AS date_up_22, m0_.additionnal_shipping_cost AS additionnal_shipping_cost_23, m0_.width AS width_24, m0_.height AS height_25, m0_.depth AS depth_26, m0_.weight AS weight_27, m0_.name AS name_28, m0_.summary AS summary_29, m0_.slug AS slug_30, m0_.description AS description_31, m1_.id AS id_32, m1_.supplier_name AS supplier_name_33, m1_.supplier_address AS supplier_address_34, m1_.supplier_zipcode AS supplier_zipcode_35, m1_.supplier_town AS supplier_town_36, m1_.supplier_phone AS supplier_phone_37, m1_.supplier_email AS supplier_email_38, m1_.supplier_web AS supplier_web_39, m1_.supplier_logo AS supplier_logo_40, m1_.suppliers_notes AS suppliers_notes_41, m2_.id AS id_42, m2_.taxe_rate AS taxe_rate_43, m2_.taxe_active AS taxe_active_44, m0_.supplier_id AS supplier_id_45, m0_.gamme_id AS gamme_id_46, m0_.carrier_id AS carrier_id_47, m0_.parent_id AS parent_id_48, m0_.taxe_id AS taxe_id_49 FROM mg_products m0_ INNER JOIN mg_suppliers m1_ ON m0_.supplier_id = m1_.id INNER JOIN mg_taxes m2_ ON m0_.taxe_id = m2_.id WHERE m0_.offline = 0 AND m0_.date_publish <= '2025-12-15 01:33:40' AND m0_.type = 'master' AND m0_.gamme_id IS NOT NULL ORDER BY m0_.date_publish DESC LIMIT 12;

#	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	App\Repository\MgProductsRepository->catalogFront (line 46)
6	App\Controller\HomeController->index (line 16)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

2.66 ms
(4.86%)

SELECT t0.id AS id_1, t0.address_title AS address_title_2, t0.parameter_address_id AS parameter_address_id_3, t0.lang_id AS lang_id_4 FROM mg_parameters_addresses_title t0 WHERE t0.parameter_address_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address_title AS address_title_2,
  t0.parameter_address_id AS parameter_address_id_3,
  t0.lang_id AS lang_id_4
FROM
  mg_parameters_addresses_title t0
WHERE
  t0.parameter_address_id = ?

SELECT t0.id AS id_1, t0.address_title AS address_title_2, t0.parameter_address_id AS parameter_address_id_3, t0.lang_id AS lang_id_4 FROM mg_parameters_addresses_title t0 WHERE t0.parameter_address_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 282)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_9f186687f3ab82e0ceebf71b132ac702->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\HomeController->index (line 30)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

2.27 ms
(4.15%)

SELECT t0.id AS id_1, t0.lang_name AS lang_name_2, t0.lang_iso_code AS lang_iso_code_3, t0.lang_code AS lang_code_4, t0.lang_default AS lang_default_5, t0.lang_active AS lang_active_6, t0.lang_img AS lang_img_7 FROM mg_languages t0 WHERE t0.lang_default = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang_name AS lang_name_2,
  t0.lang_iso_code AS lang_iso_code_3,
  t0.lang_code AS lang_code_4,
  t0.lang_default AS lang_default_5,
  t0.lang_active AS lang_active_6,
  t0.lang_img AS lang_img_7
FROM
  mg_languages t0
WHERE
  t0.lang_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lang_name AS lang_name_2, t0.lang_iso_code AS lang_iso_code_3, t0.lang_code AS lang_code_4, t0.lang_default AS lang_default_5, t0.lang_active AS lang_active_6, t0.lang_img AS lang_img_7 FROM mg_languages t0 WHERE t0.lang_default = 1 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Services\Languages->languageDefault (line 27)
5	Twig\Extension\CoreExtension->getAttribute (line 1913)
6	__TwigTemplate_9f186687f3ab82e0ceebf71b132ac702::block_main (line 106)
7	Twig\Template->yieldBlock (line 446)
8	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 255)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_9f186687f3ab82e0ceebf71b132ac702->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 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
19	App\Controller\HomeController->index (line 30)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.32 ms
(2.41%)

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.active AS active_2, m0_.force_display AS force_display_3, m0_.type AS type_4, m0_.date_add AS date_add_5, m0_.date_up AS date_up_6, m0_.level AS level_7, m0_.name AS name_8, m0_.description AS description_9, m0_.slug AS slug_10, m0_.parent_id AS parent_id_11 FROM mg_categories m0_ WHERE m0_.active = 1 AND m0_.id <> 1 AND m0_.level < 3 ORDER BY m0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.position AS position_1,
  m0_.active AS active_2,
  m0_.force_display AS force_display_3,
  m0_.type AS type_4,
  m0_.date_add AS date_add_5,
  m0_.date_up AS date_up_6,
  m0_.level AS level_7,
  m0_.name AS name_8,
  m0_.description AS description_9,
  m0_.slug AS slug_10,
  m0_.parent_id AS parent_id_11
FROM
  mg_categories m0_
WHERE
  m0_.active = 1
  AND m0_.id <> 1
  AND m0_.level < 3
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.active AS active_2, m0_.force_display AS force_display_3, m0_.type AS type_4, m0_.date_add AS date_add_5, m0_.date_up AS date_up_6, m0_.level AS level_7, m0_.name AS name_8, m0_.description AS description_9, m0_.slug AS slug_10, m0_.parent_id AS parent_id_11 FROM mg_categories m0_ WHERE m0_.active = 1 AND m0_.id <> 1 AND m0_.level < 3 ORDER BY m0_.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\MgCategoriesRepository->buildMenuCat (line 33)
7	App\Controller\MenusController->displayMenuCat (line 66)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 248)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_9f186687f3ab82e0ceebf71b132ac702->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
26	App\Controller\HomeController->index (line 30)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.64 ms
(1.17%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slogan AS slogan_3,
  t0.seo_description AS seo_description_4,
  t0.email_contact AS email_contact_5,
  t0.email_order AS email_order_6,
  t0.logo AS logo_7,
  t0.nb_posts AS nb_posts_8
FROM
  mg_parameters t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = 1;

#	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\ServiceEntityRepositoryProxy->find (line 61)
6	App\Services\AppService->getParams (line 20)
7	Twig\Extension\CoreExtension->getAttribute (line 1913)
8	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544::block_title (line 374)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 60)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_9f186687f3ab82e0ceebf71b132ac702->doDisplay (line 54)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
21	App\Controller\HomeController->index (line 30)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.51 ms
(0.94%)

SELECT t0.id AS id_1, t0.address AS address_2, t0.zipcode AS zipcode_3, t0.town AS town_4, t0.phone AS phone_5, t0.mobile AS mobile_6, t0.email AS email_7, t0.map AS map_8, t0.opening_time AS opening_time_9 FROM mg_parameters_addresses t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.zipcode AS zipcode_3,
  t0.town AS town_4,
  t0.phone AS phone_5,
  t0.mobile AS mobile_6,
  t0.email AS email_7,
  t0.map AS map_8,
  t0.opening_time AS opening_time_9
FROM
  mg_parameters_addresses t0

SELECT t0.id AS id_1, t0.address AS address_2, t0.zipcode AS zipcode_3, t0.town AS town_4, t0.phone AS phone_5, t0.mobile AS mobile_6, t0.email AS email_7, t0.map AS map_8, t0.opening_time AS opening_time_9 FROM mg_parameters_addresses t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Services\AppService->getAddressesSite (line 29)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544::doDisplay (line 273)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_9f186687f3ab82e0ceebf71b132ac702->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\HomeController->index (line 30)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\MgCategories	82
App\Entity\MgProducts	12
App\Entity\MgProductsImages	12
App\Entity\MgSuppliers	7
App\Entity\MgGammes	3
App\Entity\MgParametersAddresses	2
App\Entity\MgParametersAddressesTitle	2
App\Entity\MgCarriers	1
App\Entity\MgTaxes	1
App\Entity\MgParameters	1
App\Entity\MgLanguages	1

Entities Mapping

Class	Mapping errors
App\Entity\MgProducts	No errors.
App\Entity\MgSuppliers	No errors.
App\Entity\MgTaxes	No errors.
App\Entity\MgGammes	No errors.
App\Entity\MgCarriers	No errors.
App\Entity\MgProductsImages	No errors.
App\Entity\MgProductsNumerical	No errors.
App\Entity\MgPropertiesContents	No errors.
App\Entity\MgMovementsStocks	No errors.
App\Entity\MgAuthors	No errors.
App\Entity\MgOrdersContent	No errors.
App\Entity\MgUsers	No errors.
App\Entity\MgCategories	No errors.
App\Entity\MgTaxesLang	No errors.
App\Entity\MgCarriersConfig	No errors.
App\Entity\MgOrdersTaxes	No errors.
App\Entity\MgParameters	No errors.
App\Entity\MgOrdersCarriers	No errors.
App\Entity\MgProperties	No errors.
App\Entity\MgOrders	No errors.
App\Entity\MgGenders	No errors.
App\Entity\MgCustomers	No errors.
App\Entity\MgPosts	No errors.
App\Entity\MgPostsLang	No errors.
App\Entity\MgLanguages	No errors.
App\Entity\MgCarriersSteps	No errors.
App\Entity\MgCarriersAmount	No errors.
App\Entity\MgOrdersStatusLang	No errors.
App\Entity\MgOrdersPayments	No errors.
App\Entity\MgOrdersStatus	No errors.
App\Entity\MgCustomersAddresses	No errors.
App\Entity\MgCustomersGroups	No errors.
App\Entity\MgParametersAddresses	No errors.
App\Entity\MgParametersAddressesTitle	No errors.

Symfony Profiler

GET https://www.cms-morgane.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping