Symfony Profiler

Query Metrics

646 Database Queries

14 Different statements

240.83 ms Query time

0 Invalid entities

556 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

162.26 ms
(67.38%)

531

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 = ? LIMIT 1

Parameters:

[
  14
]

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 = ?
LIMIT
  1

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 = 14 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\ProductsController->catalog (line 49)
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)

24.30 ms
(10.09%)

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_ LEFT 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_.id IN (51, 60, 75, 76, 103, 104, 111, 145, 149, 417, 418, 461, 462, 658, 659, 661, 662, 663, 672, 673, 674, 711, 712, 713, 714, 715, 718, 721, 722, 723, 726, 727, 729, 730, 731, 732, 733, 734, 735, 736, 738, 739, 821, 1073, 1078, 1091, 1171, 1172, 1175, 1176, 1177, 1178, 1179, 1180, 1183, 1184, 1185, 1195, 1196, 1197, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1278, 1279, 1329, 1332, 1333, 1335, 1339, 1340, 1341, 1342, 1343, 1344, 1350, 1352, 1353, 1360, 1361, 1363, 1364, 1365, 1366, 1367, 1368, 1374, 1376, 1379, 1383, 1384, 1386, 1387, 1388, 1390, 1392, 1395, 1396, 1398, 1399, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1411, 1414, 1415, 1416, 1417, 1429, 1430, 1431, 1432, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1458, 1483, 1697, 1730, 1731, 1732, 1733, 1734, 1735, 1747, 1748, 1749, 1768, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1779, 1780, 1781, 1782, 1783, 1790, 1791, 1792, 1793, 1794, 1796, 1797, 1798, 1799, 1801, 1829, 1866, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1950, 1951, 1952, 1953, 1954, 1980, 1983, 1988, 1991, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2026, 2027, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2058, 2059, 2060, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2078) ORDER BY m0_.selling_price_all_taxes ASC

Parameters:

[
  "2025-12-15 01:37:04"
]

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_
  LEFT 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_.id IN (
    51,
    60,
    75,
    76,
    103,
    104,
    111,
    145,
    149,
    417,
    418,
    461,
    462,
    658,
    659,
    661,
    662,
    663,
    672,
    673,
    674,
    711,
    712,
    713,
    714,
    715,
    718,
    721,
    722,
    723,
    726,
    727,
    729,
    730,
    731,
    732,
    733,
    734,
    735,
    736,
    738,
    739,
    821,
    1073,
    1078,
    1091,
    1171,
    1172,
    1175,
    1176,
    1177,
    1178,
    1179,
    1180,
    1183,
    1184,
    1185,
    1195,
    1196,
    1197,
    1202,
    1203,
    1204,
    1205,
    1206,
    1207,
    1208,
    1209,
    1278,
    1279,
    1329,
    1332,
    1333,
    1335,
    1339,
    1340,
    1341,
    1342,
    1343,
    1344,
    1350,
    1352,
    1353,
    1360,
    1361,
    1363,
    1364,
    1365,
    1366,
    1367,
    1368,
    1374,
    1376,
    1379,
    1383,
    1384,
    1386,
    1387,
    1388,
    1390,
    1392,
    1395,
    1396,
    1398,
    1399,
    1401,
    1402,
    1403,
    1404,
    1405,
    1406,
    1407,
    1409,
    1410,
    1411,
    1414,
    1415,
    1416,
    1417,
    1429,
    1430,
    1431,
    1432,
    1433,
    1434,
    1435,
    1436,
    1437,
    1438,
    1439,
    1440,
    1458,
    1483,
    1697,
    1730,
    1731,
    1732,
    1733,
    1734,
    1735,
    1747,
    1748,
    1749,
    1768,
    1769,
    1770,
    1771,
    1772,
    1773,
    1774,
    1775,
    1776,
    1777,
    1779,
    1780,
    1781,
    1782,
    1783,
    1790,
    1791,
    1792,
    1793,
    1794,
    1796,
    1797,
    1798,
    1799,
    1801,
    1829,
    1866,
    1883,
    1884,
    1885,
    1886,
    1887,
    1888,
    1889,
    1890,
    1950,
    1951,
    1952,
    1953,
    1954,
    1980,
    1983,
    1988,
    1991,
    2014,
    2015,
    2016,
    2017,
    2018,
    2019,
    2020,
    2021,
    2022,
    2023,
    2024,
    2026,
    2027,
    2030,
    2031,
    2032,
    2033,
    2034,
    2035,
    2036,
    2058,
    2059,
    2060,
    2064,
    2065,
    2066,
    2067,
    2068,
    2069,
    2070,
    2071,
    2072,
    2073,
    2074,
    2075,
    2076,
    2077,
    2078
  )
ORDER BY
  m0_.selling_price_all_taxes ASC

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_ LEFT 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:37:04' AND m0_.id IN (51, 60, 75, 76, 103, 104, 111, 145, 149, 417, 418, 461, 462, 658, 659, 661, 662, 663, 672, 673, 674, 711, 712, 713, 714, 715, 718, 721, 722, 723, 726, 727, 729, 730, 731, 732, 733, 734, 735, 736, 738, 739, 821, 1073, 1078, 1091, 1171, 1172, 1175, 1176, 1177, 1178, 1179, 1180, 1183, 1184, 1185, 1195, 1196, 1197, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1278, 1279, 1329, 1332, 1333, 1335, 1339, 1340, 1341, 1342, 1343, 1344, 1350, 1352, 1353, 1360, 1361, 1363, 1364, 1365, 1366, 1367, 1368, 1374, 1376, 1379, 1383, 1384, 1386, 1387, 1388, 1390, 1392, 1395, 1396, 1398, 1399, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1411, 1414, 1415, 1416, 1417, 1429, 1430, 1431, 1432, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1458, 1483, 1697, 1730, 1731, 1732, 1733, 1734, 1735, 1747, 1748, 1749, 1768, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1779, 1780, 1781, 1782, 1783, 1790, 1791, 1792, 1793, 1794, 1796, 1797, 1798, 1799, 1801, 1829, 1866, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1950, 1951, 1952, 1953, 1954, 1980, 1983, 1988, 1991, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2026, 2027, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2058, 2059, 2060, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2078) ORDER BY m0_.selling_price_all_taxes 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	App\Repository\MgProductsRepository->getProductByIds (line 88)
6	App\Controller\ProductsController->catalog (line 42)
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)

23.79 ms
(9.88%)

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_7e76ebccaefecfd2c6a18a1504ccd83c->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\ProductsController->catalog (line 118)
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)

9.47 ms
(3.93%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.parent_id = ? LIMIT 1

Parameters:

[
  1171
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.purshasing_price AS purshasing_price_3,
  t0.selling_price AS selling_price_4,
  t0.selling_price_all_taxes AS selling_price_all_taxes_5,
  t0.sales_unit AS sales_unit_6,
  t0.min_quantity AS min_quantity_7,
  t0.max_quantity AS max_quantity_8,
  t0.bulk_quantity AS bulk_quantity_9,
  t0.discount AS discount_10,
  t0.discount_type AS discount_type_11,
  t0.discount_on_taxe AS discount_on_taxe_12,
  t0.stock_management AS stock_management_13,
  t0.quantity AS quantity_14,
  t0.sell_out_of_stock AS sell_out_of_stock_15,
  t0.stock_alert AS stock_alert_16,
  t0.pre_order AS pre_order_17,
  t0.available_date AS available_date_18,
  t0.date_publish AS date_publish_19,
  t0.offline AS offline_20,
  t0.type AS type_21,
  t0.date_add AS date_add_22,
  t0.date_up AS date_up_23,
  t0.additionnal_shipping_cost AS additionnal_shipping_cost_24,
  t0.width AS width_25,
  t0.height AS height_26,
  t0.depth AS depth_27,
  t0.weight AS weight_28,
  t0.name AS name_29,
  t0.summary AS summary_30,
  t0.slug AS slug_31,
  t0.description AS description_32,
  t0.supplier_id AS supplier_id_33,
  t0.gamme_id AS gamme_id_34,
  t0.carrier_id AS carrier_id_35,
  t0.parent_id AS parent_id_36,
  t0.taxe_id AS taxe_id_37
FROM
  mg_products t0
WHERE
  t0.parent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.parent_id = 1171 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Controller\ProductsController->catalog (line 85)
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)

6.23 ms
(2.59%)

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 = 1171 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\ProductsController->catalog (line 78)
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)

5.51 ms
(2.29%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 INNER JOIN mg_products_mg_categories ON t0.id = mg_products_mg_categories.mg_products_id WHERE mg_products_mg_categories.mg_categories_id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.purshasing_price AS purshasing_price_3,
  t0.selling_price AS selling_price_4,
  t0.selling_price_all_taxes AS selling_price_all_taxes_5,
  t0.sales_unit AS sales_unit_6,
  t0.min_quantity AS min_quantity_7,
  t0.max_quantity AS max_quantity_8,
  t0.bulk_quantity AS bulk_quantity_9,
  t0.discount AS discount_10,
  t0.discount_type AS discount_type_11,
  t0.discount_on_taxe AS discount_on_taxe_12,
  t0.stock_management AS stock_management_13,
  t0.quantity AS quantity_14,
  t0.sell_out_of_stock AS sell_out_of_stock_15,
  t0.stock_alert AS stock_alert_16,
  t0.pre_order AS pre_order_17,
  t0.available_date AS available_date_18,
  t0.date_publish AS date_publish_19,
  t0.offline AS offline_20,
  t0.type AS type_21,
  t0.date_add AS date_add_22,
  t0.date_up AS date_up_23,
  t0.additionnal_shipping_cost AS additionnal_shipping_cost_24,
  t0.width AS width_25,
  t0.height AS height_26,
  t0.depth AS depth_27,
  t0.weight AS weight_28,
  t0.name AS name_29,
  t0.summary AS summary_30,
  t0.slug AS slug_31,
  t0.description AS description_32,
  t0.supplier_id AS supplier_id_33,
  t0.gamme_id AS gamme_id_34,
  t0.carrier_id AS carrier_id_35,
  t0.parent_id AS parent_id_36,
  t0.taxe_id AS taxe_id_37
FROM
  mg_products t0
  INNER JOIN mg_products_mg_categories ON t0.id = mg_products_mg_categories.mg_products_id
WHERE
  mg_products_mg_categories.mg_categories_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 INNER JOIN mg_products_mg_categories ON t0.id = mg_products_mg_categories.mg_products_id WHERE mg_products_mg_categories.mg_categories_id = 14;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\ProductsController->catalog (line 35)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

2.58 ms
(1.07%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.position AS position_3, t0.name AS name_4, t0.slug AS slug_5 FROM mg_properties t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.position AS position_3,
  t0.name AS name_4,
  t0.slug AS slug_5
FROM
  mg_properties t0

SELECT t0.id AS id_1, t0.type AS type_2, t0.position AS position_3, t0.name AS name_4, t0.slug AS slug_5 FROM mg_properties 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\Controller\ProductsController->catalog (line 96)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

2.27 ms
(0.94%)

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_ LEFT 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_.id IN (51, 60, 75, 76, 103, 104, 111, 145, 149, 417, 418, 461, 462, 658, 659, 661, 662, 663, 672, 673, 674, 711, 712, 713, 714, 715, 718, 721, 722, 723, 726, 727, 729, 730, 731, 732, 733, 734, 735, 736, 738, 739, 821, 1073, 1078, 1091, 1171, 1172, 1175, 1176, 1177, 1178, 1179, 1180, 1183, 1184, 1185, 1195, 1196, 1197, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1278, 1279, 1329, 1332, 1333, 1335, 1339, 1340, 1341, 1342, 1343, 1344, 1350, 1352, 1353, 1360, 1361, 1363, 1364, 1365, 1366, 1367, 1368, 1374, 1376, 1379, 1383, 1384, 1386, 1387, 1388, 1390, 1392, 1395, 1396, 1398, 1399, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1411, 1414, 1415, 1416, 1417, 1429, 1430, 1431, 1432, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1458, 1483, 1697, 1730, 1731, 1732, 1733, 1734, 1735, 1747, 1748, 1749, 1768, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1779, 1780, 1781, 1782, 1783, 1790, 1791, 1792, 1793, 1794, 1796, 1797, 1798, 1799, 1801, 1829, 1866, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1950, 1951, 1952, 1953, 1954, 1980, 1983, 1988, 1991, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2026, 2027, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2058, 2059, 2060, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2078) ORDER BY m0_.selling_price_all_taxes ASC LIMIT 12

Parameters:

[
  "2025-12-15 01:37:04"
]

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_
  LEFT 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_.id IN (
    51,
    60,
    75,
    76,
    103,
    104,
    111,
    145,
    149,
    417,
    418,
    461,
    462,
    658,
    659,
    661,
    662,
    663,
    672,
    673,
    674,
    711,
    712,
    713,
    714,
    715,
    718,
    721,
    722,
    723,
    726,
    727,
    729,
    730,
    731,
    732,
    733,
    734,
    735,
    736,
    738,
    739,
    821,
    1073,
    1078,
    1091,
    1171,
    1172,
    1175,
    1176,
    1177,
    1178,
    1179,
    1180,
    1183,
    1184,
    1185,
    1195,
    1196,
    1197,
    1202,
    1203,
    1204,
    1205,
    1206,
    1207,
    1208,
    1209,
    1278,
    1279,
    1329,
    1332,
    1333,
    1335,
    1339,
    1340,
    1341,
    1342,
    1343,
    1344,
    1350,
    1352,
    1353,
    1360,
    1361,
    1363,
    1364,
    1365,
    1366,
    1367,
    1368,
    1374,
    1376,
    1379,
    1383,
    1384,
    1386,
    1387,
    1388,
    1390,
    1392,
    1395,
    1396,
    1398,
    1399,
    1401,
    1402,
    1403,
    1404,
    1405,
    1406,
    1407,
    1409,
    1410,
    1411,
    1414,
    1415,
    1416,
    1417,
    1429,
    1430,
    1431,
    1432,
    1433,
    1434,
    1435,
    1436,
    1437,
    1438,
    1439,
    1440,
    1458,
    1483,
    1697,
    1730,
    1731,
    1732,
    1733,
    1734,
    1735,
    1747,
    1748,
    1749,
    1768,
    1769,
    1770,
    1771,
    1772,
    1773,
    1774,
    1775,
    1776,
    1777,
    1779,
    1780,
    1781,
    1782,
    1783,
    1790,
    1791,
    1792,
    1793,
    1794,
    1796,
    1797,
    1798,
    1799,
    1801,
    1829,
    1866,
    1883,
    1884,
    1885,
    1886,
    1887,
    1888,
    1889,
    1890,
    1950,
    1951,
    1952,
    1953,
    1954,
    1980,
    1983,
    1988,
    1991,
    2014,
    2015,
    2016,
    2017,
    2018,
    2019,
    2020,
    2021,
    2022,
    2023,
    2024,
    2026,
    2027,
    2030,
    2031,
    2032,
    2033,
    2034,
    2035,
    2036,
    2058,
    2059,
    2060,
    2064,
    2065,
    2066,
    2067,
    2068,
    2069,
    2070,
    2071,
    2072,
    2073,
    2074,
    2075,
    2076,
    2077,
    2078
  )
ORDER BY
  m0_.selling_price_all_taxes ASC
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_ LEFT 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:37:04' AND m0_.id IN (51, 60, 75, 76, 103, 104, 111, 145, 149, 417, 418, 461, 462, 658, 659, 661, 662, 663, 672, 673, 674, 711, 712, 713, 714, 715, 718, 721, 722, 723, 726, 727, 729, 730, 731, 732, 733, 734, 735, 736, 738, 739, 821, 1073, 1078, 1091, 1171, 1172, 1175, 1176, 1177, 1178, 1179, 1180, 1183, 1184, 1185, 1195, 1196, 1197, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1278, 1279, 1329, 1332, 1333, 1335, 1339, 1340, 1341, 1342, 1343, 1344, 1350, 1352, 1353, 1360, 1361, 1363, 1364, 1365, 1366, 1367, 1368, 1374, 1376, 1379, 1383, 1384, 1386, 1387, 1388, 1390, 1392, 1395, 1396, 1398, 1399, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1411, 1414, 1415, 1416, 1417, 1429, 1430, 1431, 1432, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1458, 1483, 1697, 1730, 1731, 1732, 1733, 1734, 1735, 1747, 1748, 1749, 1768, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1779, 1780, 1781, 1782, 1783, 1790, 1791, 1792, 1793, 1794, 1796, 1797, 1798, 1799, 1801, 1829, 1866, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1950, 1951, 1952, 1953, 1954, 1980, 1983, 1988, 1991, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2026, 2027, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2058, 2059, 2060, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2078) ORDER BY m0_.selling_price_all_taxes ASC 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->getProductByIds (line 88)
6	App\Controller\ProductsController->catalog (line 44)
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)

1.13 ms
(0.47%)

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.slug = ? LIMIT 1

Parameters:

[
  "DJ-SHOP"
]

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.slug = ?
LIMIT
  1

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.slug = 'DJ-SHOP' 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\ProductsController->catalog (line 29)
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)

1.08 ms
(0.45%)

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.type = ?

Parameters:

[
  "product"
]

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.type = ?

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.type = 'product';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 154)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Controller\ProductsController->catalog (line 102)
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)

0.65 ms
(0.27%)

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.type = ? AND t0.parent_id = ? ORDER BY t0.position ASC

Parameters:

[
  "product"
  14
]

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.type = ?
  AND t0.parent_id = ?
ORDER BY
  t0.position ASC

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.type = 'product' AND t0.parent_id = 14 ORDER BY t0.position ASC;

#	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\ProductsController->catalog (line 60)
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)

0.64 ms
(0.26%)

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_7e76ebccaefecfd2c6a18a1504ccd83c->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\ProductsController->catalog (line 118)
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.54 ms
(0.23%)

SELECT t0.id AS id_1, t0.supplier_name AS supplier_name_2, t0.supplier_address AS supplier_address_3, t0.supplier_zipcode AS supplier_zipcode_4, t0.supplier_town AS supplier_town_5, t0.supplier_phone AS supplier_phone_6, t0.supplier_email AS supplier_email_7, t0.supplier_web AS supplier_web_8, t0.supplier_logo AS supplier_logo_9, t0.suppliers_notes AS suppliers_notes_10 FROM mg_suppliers t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.supplier_name AS supplier_name_2,
  t0.supplier_address AS supplier_address_3,
  t0.supplier_zipcode AS supplier_zipcode_4,
  t0.supplier_town AS supplier_town_5,
  t0.supplier_phone AS supplier_phone_6,
  t0.supplier_email AS supplier_email_7,
  t0.supplier_web AS supplier_web_8,
  t0.supplier_logo AS supplier_logo_9,
  t0.suppliers_notes AS suppliers_notes_10
FROM
  mg_suppliers t0

SELECT t0.id AS id_1, t0.supplier_name AS supplier_name_2, t0.supplier_address AS supplier_address_3, t0.supplier_zipcode AS supplier_zipcode_4, t0.supplier_town AS supplier_town_5, t0.supplier_phone AS supplier_phone_6, t0.supplier_email AS supplier_email_7, t0.supplier_web AS supplier_web_8, t0.supplier_logo AS supplier_logo_9, t0.suppliers_notes AS suppliers_notes_10 FROM mg_suppliers 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\Controller\ProductsController->catalog (line 99)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.38 ms
(0.16%)

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::doDisplay (line 64)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_7e76ebccaefecfd2c6a18a1504ccd83c->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\ProductsController->catalog (line 118)
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)

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	266
App\Entity\MgProducts	225
App\Entity\MgSuppliers	47
App\Entity\MgProductsImages	12
App\Entity\MgProperties	2
App\Entity\MgCarriers	1
App\Entity\MgTaxes	1
App\Entity\MgGammes	1
App\Entity\MgParameters	1

Entities Mapping

Class	Mapping errors
App\Entity\MgCategories	No errors.
App\Entity\MgPosts	No errors.
App\Entity\MgProducts	No errors.
App\Entity\MgSuppliers	No errors.
App\Entity\MgGammes	No errors.
App\Entity\MgCarriers	No errors.
App\Entity\MgTaxes	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\MgTaxesLang	No errors.
App\Entity\MgCarriersConfig	No errors.
App\Entity\MgOrdersTaxes	No errors.
App\Entity\MgProperties	No errors.
App\Entity\MgParameters	No errors.
App\Entity\MgPostsLang	No errors.
App\Entity\MgOrdersCarriers	No errors.
App\Entity\MgOrders	No errors.
App\Entity\MgGenders	No errors.
App\Entity\MgCustomers	No errors.
App\Entity\MgLanguages	No errors.
App\Entity\MgCarriersSteps	No errors.
App\Entity\MgCarriersAmount	No errors.

Symfony Profiler

GET https://www.cms-morgane.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CMenusController%253A%253AdisplayMenuCat

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping