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.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 = 289 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 = ?
  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;

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

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.property_id AS property_id_3,
  t4.id AS id_5,
  t4.type AS type_6,
  t4.position AS position_7,
  t4.name AS name_8,
  t4.slug AS slug_9,
  t0.product_id AS product_id_10
FROM
  mg_properties_contents t0
  INNER JOIN mg_properties t4 ON t0.property_id = t4.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.property_id AS property_id_3, t4.id AS id_5, t4.type AS type_6, t4.position AS position_7, t4.name AS name_8, t4.slug AS slug_9, t0.product_id AS product_id_10 FROM mg_properties_contents t0 INNER JOIN mg_properties t4 ON t0.property_id = t4.id WHERE t0.product_id = 821;

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 (
    821, 1195, 1196, 1197, 1278, 1279, 1458,
    1829, 1980, 1983, 1988, 1991
  )
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:39:08' AND m0_.id IN (821, 1195, 1196, 1197, 1278, 1279, 1458, 1829, 1980, 1983, 1988, 1991) ORDER BY m0_.selling_price_all_taxes ASC;

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 = 289;

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 (
    821, 1195, 1196, 1197, 1278, 1279, 1458,
    1829, 1980, 1983, 1988, 1991
  )
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:39:08' AND m0_.id IN (821, 1195, 1196, 1197, 1278, 1279, 1458, 1829, 1980, 1983, 1988, 1991) ORDER BY m0_.selling_price_all_taxes ASC LIMIT 12;

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;

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';

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 = 'Casier-Rangement-Vinyle-et-CD' LIMIT 1;

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

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

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 = 289 ORDER BY t0.position ASC;

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;