Symfony Profiler

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;

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;

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 03:42:21' 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 <= ?
  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
OFFSET
  168

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 03:42:21' 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 OFFSET 168;

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;

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;

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 = 1202 AND t0.cover = 1 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 = ?
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 = 1202 LIMIT 1;