Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.type AS type_3,
  t0.value_string AS value_string_4,
  t0.value_int AS value_int_5,
  t0.value_float AS value_float_6,
  t0.value_bool AS value_bool_7,
  t0.value_json AS value_json_8,
  t0.value_text AS value_text_9,
  t0.description AS description_10,
  t0.updated_at AS updated_at_11,
  t0.section AS section_12
FROM
  website_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.type AS type_3, t0.value_string AS value_string_4, t0.value_int AS value_int_5, t0.value_float AS value_float_6, t0.value_bool AS value_bool_7, t0.value_json AS value_json_8, t0.value_text AS value_text_9, t0.description AS description_10, t0.updated_at AS updated_at_11, t0.section AS section_12 FROM website_setting t0 WHERE t0.setting_key = 'site_maintenance' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.show_in_homepage = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.show_in_homepage = 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.type AS type_3,
  t0.value_string AS value_string_4,
  t0.value_int AS value_int_5,
  t0.value_float AS value_float_6,
  t0.value_bool AS value_bool_7,
  t0.value_json AS value_json_8,
  t0.value_text AS value_text_9,
  t0.description AS description_10,
  t0.updated_at AS updated_at_11,
  t0.section AS section_12
FROM
  website_setting t0

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.type AS type_3, t0.value_string AS value_string_4, t0.value_int AS value_int_5, t0.value_float AS value_float_6, t0.value_bool AS value_bool_7, t0.value_json AS value_json_8, t0.value_text AS value_text_9, t0.description AS description_10, t0.updated_at AS updated_at_11, t0.section AS section_12 FROM website_setting t0;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.url AS url_5,
  t0.cta_label AS cta_label_6,
  t0.is_active AS is_active_7,
  t0.`order` AS order_8,
  t0.display_mode AS display_mode_9
FROM
  slider t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.`order` ASC
LIMIT
  3

SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.description AS description_4, t0.url AS url_5, t0.cta_label AS cta_label_6, t0.is_active AS is_active_7, t0.`order` AS order_8, t0.display_mode AS display_mode_9 FROM slider t0 WHERE t0.is_active = 1 ORDER BY t0.`order` ASC LIMIT 3;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.barcode AS barcode_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.usual_quantity AS usual_quantity_5,
  p0_.buying_price_ht AS buying_price_ht_6,
  p0_.buying_price_ttc AS buying_price_ttc_7,
  p0_.real_unit_value AS real_unit_value_8,
  p0_.price_ht AS price_ht_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.reseller_price_ttc AS reseller_price_ttc_11,
  p0_.unit AS unit_12,
  p0_.is_stock AS is_stock_13,
  p0_.is_declination AS is_declination_14,
  p0_.created_at AS created_at_15,
  p0_.uuid AS uuid_16,
  p0_.information AS information_17,
  p0_.is_archived AS is_archived_18,
  p0_.deleted_at AS deleted_at_19,
  p0_.reason_of_delete AS reason_of_delete_20,
  p0_.best_selection AS best_selection_21,
  p0_.rating_score AS rating_score_22,
  p0_.rating_count AS rating_count_23,
  p0_.material AS material_24,
  p0_.supplier_reference AS supplier_reference_25,
  p0_.meta_description AS meta_description_26,
  p0_.video_url AS video_url_27,
  p0_.show_in_web_site AS show_in_web_site_28,
  p0_.show_in_pos_default AS show_in_pos_default_29,
  p0_.can_be_restocked AS can_be_restocked_30,
  p0_.categories_id AS categories_id_31,
  p0_.tva_id AS tva_id_32,
  p0_.buy_tva_id AS buy_tva_id_33,
  p0_.promotion_id AS promotion_id_34,
  p0_.supplier_id AS supplier_id_35
FROM
  produit p0_
WHERE
  p0_.created_at >= ?
  AND p0_.deleted_at IS NULL
  AND p0_.show_in_web_site = 1
ORDER BY
  p0_.created_at DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.barcode AS barcode_2, p0_.name AS name_3, p0_.description AS description_4, p0_.usual_quantity AS usual_quantity_5, p0_.buying_price_ht AS buying_price_ht_6, p0_.buying_price_ttc AS buying_price_ttc_7, p0_.real_unit_value AS real_unit_value_8, p0_.price_ht AS price_ht_9, p0_.price_ttc AS price_ttc_10, p0_.reseller_price_ttc AS reseller_price_ttc_11, p0_.unit AS unit_12, p0_.is_stock AS is_stock_13, p0_.is_declination AS is_declination_14, p0_.created_at AS created_at_15, p0_.uuid AS uuid_16, p0_.information AS information_17, p0_.is_archived AS is_archived_18, p0_.deleted_at AS deleted_at_19, p0_.reason_of_delete AS reason_of_delete_20, p0_.best_selection AS best_selection_21, p0_.rating_score AS rating_score_22, p0_.rating_count AS rating_count_23, p0_.material AS material_24, p0_.supplier_reference AS supplier_reference_25, p0_.meta_description AS meta_description_26, p0_.video_url AS video_url_27, p0_.show_in_web_site AS show_in_web_site_28, p0_.show_in_pos_default AS show_in_pos_default_29, p0_.can_be_restocked AS can_be_restocked_30, p0_.categories_id AS categories_id_31, p0_.tva_id AS tva_id_32, p0_.buy_tva_id AS buy_tva_id_33, p0_.promotion_id AS promotion_id_34, p0_.supplier_id AS supplier_id_35 FROM produit p0_ WHERE p0_.created_at >= '2025-12-30 11:59:14' AND p0_.deleted_at IS NULL AND p0_.show_in_web_site = 1 ORDER BY p0_.created_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1362;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1361;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1360;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1359;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1358;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1357;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1356;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1355;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1354;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1353;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.barcode AS barcode_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.usual_quantity AS usual_quantity_5,
  p0_.buying_price_ht AS buying_price_ht_6,
  p0_.buying_price_ttc AS buying_price_ttc_7,
  p0_.real_unit_value AS real_unit_value_8,
  p0_.price_ht AS price_ht_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.reseller_price_ttc AS reseller_price_ttc_11,
  p0_.unit AS unit_12,
  p0_.is_stock AS is_stock_13,
  p0_.is_declination AS is_declination_14,
  p0_.created_at AS created_at_15,
  p0_.uuid AS uuid_16,
  p0_.information AS information_17,
  p0_.is_archived AS is_archived_18,
  p0_.deleted_at AS deleted_at_19,
  p0_.reason_of_delete AS reason_of_delete_20,
  p0_.best_selection AS best_selection_21,
  p0_.rating_score AS rating_score_22,
  p0_.rating_count AS rating_count_23,
  p0_.material AS material_24,
  p0_.supplier_reference AS supplier_reference_25,
  p0_.meta_description AS meta_description_26,
  p0_.video_url AS video_url_27,
  p0_.show_in_web_site AS show_in_web_site_28,
  p0_.show_in_pos_default AS show_in_pos_default_29,
  p0_.can_be_restocked AS can_be_restocked_30,
  p0_.categories_id AS categories_id_31,
  p0_.tva_id AS tva_id_32,
  p0_.buy_tva_id AS buy_tva_id_33,
  p0_.promotion_id AS promotion_id_34,
  p0_.supplier_id AS supplier_id_35
FROM
  produit p0_
  INNER JOIN produit_declination_value p1_ ON (p1_.produit_id = p0_.id)
  INNER JOIN document_declination_produit d2_ ON (
    d2_.produit_declination_value_id = p1_.id
  )
WHERE
  p0_.deleted_at IS NULL
  AND d2_.created_at >= ?
  AND p0_.show_in_web_site = 1
GROUP BY
  p0_.id
ORDER BY
  count(p0_.id) DESC
LIMIT
  50

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.barcode AS barcode_2, p0_.name AS name_3, p0_.description AS description_4, p0_.usual_quantity AS usual_quantity_5, p0_.buying_price_ht AS buying_price_ht_6, p0_.buying_price_ttc AS buying_price_ttc_7, p0_.real_unit_value AS real_unit_value_8, p0_.price_ht AS price_ht_9, p0_.price_ttc AS price_ttc_10, p0_.reseller_price_ttc AS reseller_price_ttc_11, p0_.unit AS unit_12, p0_.is_stock AS is_stock_13, p0_.is_declination AS is_declination_14, p0_.created_at AS created_at_15, p0_.uuid AS uuid_16, p0_.information AS information_17, p0_.is_archived AS is_archived_18, p0_.deleted_at AS deleted_at_19, p0_.reason_of_delete AS reason_of_delete_20, p0_.best_selection AS best_selection_21, p0_.rating_score AS rating_score_22, p0_.rating_count AS rating_count_23, p0_.material AS material_24, p0_.supplier_reference AS supplier_reference_25, p0_.meta_description AS meta_description_26, p0_.video_url AS video_url_27, p0_.show_in_web_site AS show_in_web_site_28, p0_.show_in_pos_default AS show_in_pos_default_29, p0_.can_be_restocked AS can_be_restocked_30, p0_.categories_id AS categories_id_31, p0_.tva_id AS tva_id_32, p0_.buy_tva_id AS buy_tva_id_33, p0_.promotion_id AS promotion_id_34, p0_.supplier_id AS supplier_id_35 FROM produit p0_ INNER JOIN produit_declination_value p1_ ON (p1_.produit_id = p0_.id) INNER JOIN document_declination_produit d2_ ON (d2_.produit_declination_value_id = p1_.id) WHERE p0_.deleted_at IS NULL AND d2_.created_at >= '2026-02-28 11:59:14' AND p0_.show_in_web_site = 1 GROUP BY p0_.id ORDER BY count(p0_.id) DESC LIMIT 50;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1338;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1351;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1230;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.type AS type_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.is_active AS is_active_7,
  t0.is_default AS is_default_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  warehouse t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.is_default DESC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.type AS type_4, t0.address AS address_5, t0.city AS city_6, t0.is_active AS is_active_7, t0.is_default AS is_default_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM warehouse t0 WHERE t0.is_active = 1 ORDER BY t0.is_default DESC, t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.type AS type_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.is_active AS is_active_7,
  t0.is_default AS is_default_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  warehouse t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.is_default DESC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.type AS type_4, t0.address AS address_5, t0.city AS city_6, t0.is_active AS is_active_7, t0.is_default AS is_default_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM warehouse t0 WHERE t0.is_active = 1 ORDER BY t0.is_default DESC, t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.type AS type_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.is_active AS is_active_7,
  t0.is_default AS is_default_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  warehouse t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.is_default DESC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.type AS type_4, t0.address AS address_5, t0.city AS city_6, t0.is_active AS is_active_7, t0.is_default AS is_default_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM warehouse t0 WHERE t0.is_active = 1 ORDER BY t0.is_default DESC, t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.footer_logo AS footer_logo_4,
  t0.address AS address_5,
  t0.region AS region_6,
  t0.zip AS zip_7,
  t0.tva_code AS tva_code_8,
  t0.mail AS mail_9,
  t0.website AS website_10,
  t0.phone AS phone_11,
  t0.mobile AS mobile_12,
  t0.social_links AS social_links_13,
  t0.updated_at AS updated_at_14,
  t0.tva_rate_buy_id AS tva_rate_buy_id_15,
  t0.tva_rate_sale_id AS tva_rate_sale_id_16
FROM
  company t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.footer_logo AS footer_logo_4, t0.address AS address_5, t0.region AS region_6, t0.zip AS zip_7, t0.tva_code AS tva_code_8, t0.mail AS mail_9, t0.website AS website_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.social_links AS social_links_13, t0.updated_at AS updated_at_14, t0.tva_rate_buy_id AS tva_rate_buy_id_15, t0.tva_rate_sale_id AS tva_rate_sale_id_16 FROM company t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.footer_logo AS footer_logo_4,
  t0.address AS address_5,
  t0.region AS region_6,
  t0.zip AS zip_7,
  t0.tva_code AS tva_code_8,
  t0.mail AS mail_9,
  t0.website AS website_10,
  t0.phone AS phone_11,
  t0.mobile AS mobile_12,
  t0.social_links AS social_links_13,
  t0.updated_at AS updated_at_14,
  t0.tva_rate_buy_id AS tva_rate_buy_id_15,
  t0.tva_rate_sale_id AS tva_rate_sale_id_16
FROM
  company t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.footer_logo AS footer_logo_4, t0.address AS address_5, t0.region AS region_6, t0.zip AS zip_7, t0.tva_code AS tva_code_8, t0.mail AS mail_9, t0.website AS website_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.social_links AS social_links_13, t0.updated_at AS updated_at_14, t0.tva_rate_buy_id AS tva_rate_buy_id_15, t0.tva_rate_sale_id AS tva_rate_sale_id_16 FROM company t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.parent_id IS NULL
  AND t0.is_active = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id IS NULL AND t0.is_active = '1' ORDER BY t0.`order` ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.parent_id IS NULL
  AND t0.is_active = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id IS NULL AND t0.is_active = '1' ORDER BY t0.`order` ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = 93 ORDER BY t0.`order` ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = 12 ORDER BY t0.`order` ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = 7 ORDER BY t0.`order` ASC;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.barcode AS barcode_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.buying_price_ht AS buying_price_ht_6,
  t0.buying_price_ttc AS buying_price_ttc_7,
  t0.price_ht AS price_ht_8,
  t0.created_at AS created_at_9,
  t0.alert_stock_min AS alert_stock_min_10,
  t0.uuid AS uuid_11,
  t0.produit_id AS produit_id_12
FROM
  produit_declination_value t0
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.barcode AS barcode_3, t0.name AS name_4, t0.description AS description_5, t0.buying_price_ht AS buying_price_ht_6, t0.buying_price_ttc AS buying_price_ttc_7, t0.price_ht AS price_ht_8, t0.created_at AS created_at_9, t0.alert_stock_min AS alert_stock_min_10, t0.uuid AS uuid_11, t0.produit_id AS produit_id_12 FROM produit_declination_value t0 WHERE t0.produit_id = 1362;