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 = 'Enceintes-et-accessoires' 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 = 21;

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 (
    14,
    24,
    25,
    29,
    46,
    47,
    48,
    49,
    55,
    78,
    80,
    82,
    83,
    84,
    85,
    86,
    88,
    89,
    90,
    93,
    95,
    106,
    107,
    139,
    167,
    175,
    176,
    178,
    179,
    180,
    281,
    282,
    294,
    296,
    297,
    298,
    299,
    307,
    313,
    318,
    320,
    321,
    322,
    323,
    324,
    325,
    326,
    327,
    328,
    329,
    330,
    331,
    332,
    333,
    337,
    338,
    339,
    340,
    341,
    344,
    353,
    354,
    356,
    421,
    422,
    424,
    425,
    426,
    427,
    428,
    429,
    430,
    431,
    432,
    436,
    437,
    438,
    439,
    440,
    441,
    442,
    443,
    445,
    450,
    458,
    500,
    628,
    664,
    665,
    666,
    667,
    668,
    669,
    670,
    671,
    675,
    676,
    677,
    678,
    679,
    680,
    681,
    682,
    683,
    684,
    685,
    686,
    687,
    688,
    689,
    690,
    691,
    692,
    693,
    694,
    695,
    696,
    697,
    698,
    699,
    700,
    701,
    702,
    703,
    704,
    705,
    706,
    707,
    708,
    709,
    710,
    716,
    717,
    719,
    720,
    728,
    816,
    876,
    877,
    878,
    911,
    912,
    926,
    927,
    942,
    943,
    948,
    949,
    951,
    952,
    953,
    954,
    955,
    1072,
    1077,
    1084,
    1094,
    1160,
    1163,
    1164,
    1191,
    1212,
    1213,
    1214,
    1216,
    1217,
    1218,
    1220,
    1221,
    1227,
    1230,
    1231,
    1232,
    1233,
    1234,
    1237,
    1239,
    1242,
    1252,
    1253,
    1254,
    1264,
    1265,
    1269,
    1270,
    1310,
    1615,
    1618,
    1619,
    1620,
    1708,
    1709,
    1713,
    1736,
    1737,
    1738,
    1739,
    1740,
    1741,
    1742,
    1743,
    1744,
    1745,
    1746,
    1778,
    1806,
    1807,
    1811,
    1812,
    1813,
    1814,
    1815,
    1816,
    1820,
    1825,
    1826,
    1863,
    1864,
    1865,
    1896,
    1897,
    1898,
    1899,
    1900,
    1901,
    1902,
    1903,
    1904,
    1905,
    1906,
    1907,
    1908,
    1909,
    1910,
    1914,
    1915,
    1916,
    1917,
    1918,
    1919,
    1920,
    1921,
    1922,
    1923,
    1924,
    1925,
    1926,
    1927,
    1928,
    1929,
    1930,
    1931,
    1932,
    1933,
    1935,
    1936,
    1937,
    1938,
    1939,
    1940,
    1941,
    1942,
    1943,
    1947,
    1948,
    1949,
    1960,
    1961,
    1962,
    1963,
    1964,
    1965,
    1966,
    1967,
    1968,
    1969,
    1970,
    1971,
    1972,
    1973,
    1974,
    1976,
    1977,
    1978,
    2037,
    2038,
    2053,
    2054,
    2079,
    2080,
    2081,
    2082
  )
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-17 04:51:27' AND m0_.id IN (14, 24, 25, 29, 46, 47, 48, 49, 55, 78, 80, 82, 83, 84, 85, 86, 88, 89, 90, 93, 95, 106, 107, 139, 167, 175, 176, 178, 179, 180, 281, 282, 294, 296, 297, 298, 299, 307, 313, 318, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 337, 338, 339, 340, 341, 344, 353, 354, 356, 421, 422, 424, 425, 426, 427, 428, 429, 430, 431, 432, 436, 437, 438, 439, 440, 441, 442, 443, 445, 450, 458, 500, 628, 664, 665, 666, 667, 668, 669, 670, 671, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 716, 717, 719, 720, 728, 816, 876, 877, 878, 911, 912, 926, 927, 942, 943, 948, 949, 951, 952, 953, 954, 955, 1072, 1077, 1084, 1094, 1160, 1163, 1164, 1191, 1212, 1213, 1214, 1216, 1217, 1218, 1220, 1221, 1227, 1230, 1231, 1232, 1233, 1234, 1237, 1239, 1242, 1252, 1253, 1254, 1264, 1265, 1269, 1270, 1310, 1615, 1618, 1619, 1620, 1708, 1709, 1713, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1745, 1746, 1778, 1806, 1807, 1811, 1812, 1813, 1814, 1815, 1816, 1820, 1825, 1826, 1863, 1864, 1865, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1910, 1914, 1915, 1916, 1917, 1918, 1919, 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1947, 1948, 1949, 1960, 1961, 1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1976, 1977, 1978, 2037, 2038, 2053, 2054, 2079, 2080, 2081, 2082) 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 (
    14,
    24,
    25,
    29,
    46,
    47,
    48,
    49,
    55,
    78,
    80,
    82,
    83,
    84,
    85,
    86,
    88,
    89,
    90,
    93,
    95,
    106,
    107,
    139,
    167,
    175,
    176,
    178,
    179,
    180,
    281,
    282,
    294,
    296,
    297,
    298,
    299,
    307,
    313,
    318,
    320,
    321,
    322,
    323,
    324,
    325,
    326,
    327,
    328,
    329,
    330,
    331,
    332,
    333,
    337,
    338,
    339,
    340,
    341,
    344,
    353,
    354,
    356,
    421,
    422,
    424,
    425,
    426,
    427,
    428,
    429,
    430,
    431,
    432,
    436,
    437,
    438,
    439,
    440,
    441,
    442,
    443,
    445,
    450,
    458,
    500,
    628,
    664,
    665,
    666,
    667,
    668,
    669,
    670,
    671,
    675,
    676,
    677,
    678,
    679,
    680,
    681,
    682,
    683,
    684,
    685,
    686,
    687,
    688,
    689,
    690,
    691,
    692,
    693,
    694,
    695,
    696,
    697,
    698,
    699,
    700,
    701,
    702,
    703,
    704,
    705,
    706,
    707,
    708,
    709,
    710,
    716,
    717,
    719,
    720,
    728,
    816,
    876,
    877,
    878,
    911,
    912,
    926,
    927,
    942,
    943,
    948,
    949,
    951,
    952,
    953,
    954,
    955,
    1072,
    1077,
    1084,
    1094,
    1160,
    1163,
    1164,
    1191,
    1212,
    1213,
    1214,
    1216,
    1217,
    1218,
    1220,
    1221,
    1227,
    1230,
    1231,
    1232,
    1233,
    1234,
    1237,
    1239,
    1242,
    1252,
    1253,
    1254,
    1264,
    1265,
    1269,
    1270,
    1310,
    1615,
    1618,
    1619,
    1620,
    1708,
    1709,
    1713,
    1736,
    1737,
    1738,
    1739,
    1740,
    1741,
    1742,
    1743,
    1744,
    1745,
    1746,
    1778,
    1806,
    1807,
    1811,
    1812,
    1813,
    1814,
    1815,
    1816,
    1820,
    1825,
    1826,
    1863,
    1864,
    1865,
    1896,
    1897,
    1898,
    1899,
    1900,
    1901,
    1902,
    1903,
    1904,
    1905,
    1906,
    1907,
    1908,
    1909,
    1910,
    1914,
    1915,
    1916,
    1917,
    1918,
    1919,
    1920,
    1921,
    1922,
    1923,
    1924,
    1925,
    1926,
    1927,
    1928,
    1929,
    1930,
    1931,
    1932,
    1933,
    1935,
    1936,
    1937,
    1938,
    1939,
    1940,
    1941,
    1942,
    1943,
    1947,
    1948,
    1949,
    1960,
    1961,
    1962,
    1963,
    1964,
    1965,
    1966,
    1967,
    1968,
    1969,
    1970,
    1971,
    1972,
    1973,
    1974,
    1976,
    1977,
    1978,
    2037,
    2038,
    2053,
    2054,
    2079,
    2080,
    2081,
    2082
  )
ORDER BY
  m0_.selling_price_all_taxes ASC
LIMIT
  12
OFFSET
  156

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-17 04:51:27' AND m0_.id IN (14, 24, 25, 29, 46, 47, 48, 49, 55, 78, 80, 82, 83, 84, 85, 86, 88, 89, 90, 93, 95, 106, 107, 139, 167, 175, 176, 178, 179, 180, 281, 282, 294, 296, 297, 298, 299, 307, 313, 318, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 337, 338, 339, 340, 341, 344, 353, 354, 356, 421, 422, 424, 425, 426, 427, 428, 429, 430, 431, 432, 436, 437, 438, 439, 440, 441, 442, 443, 445, 450, 458, 500, 628, 664, 665, 666, 667, 668, 669, 670, 671, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 716, 717, 719, 720, 728, 816, 876, 877, 878, 911, 912, 926, 927, 942, 943, 948, 949, 951, 952, 953, 954, 955, 1072, 1077, 1084, 1094, 1160, 1163, 1164, 1191, 1212, 1213, 1214, 1216, 1217, 1218, 1220, 1221, 1227, 1230, 1231, 1232, 1233, 1234, 1237, 1239, 1242, 1252, 1253, 1254, 1264, 1265, 1269, 1270, 1310, 1615, 1618, 1619, 1620, 1708, 1709, 1713, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1745, 1746, 1778, 1806, 1807, 1811, 1812, 1813, 1814, 1815, 1816, 1820, 1825, 1826, 1863, 1864, 1865, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1910, 1914, 1915, 1916, 1917, 1918, 1919, 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1947, 1948, 1949, 1960, 1961, 1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1976, 1977, 1978, 2037, 2038, 2053, 2054, 2079, 2080, 2081, 2082) ORDER BY m0_.selling_price_all_taxes ASC LIMIT 12 OFFSET 156;

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