Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.page_name AS page_name_1,
  s0_.route AS route_2,
  s0_.h1_enabled AS h1_enabled_3,
  s0_.translation_en_id AS translation_en_id_4,
  s0_.translation_fr_id AS translation_fr_id_5
FROM
  seopage_global s0_
WHERE
  s0_.route = ?

SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5 FROM seopage_global s0_ WHERE s0_.route = 'app_products_index';

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0;

SELECT
  p0_.id AS id_0,
  p0_.translation_en_id AS translation_en_id_1,
  p0_.translation_fr_id AS translation_fr_id_2
FROM
  product_page_global p0_
LIMIT
  1

SELECT p0_.id AS id_0, p0_.translation_en_id AS translation_en_id_1, p0_.translation_fr_id AS translation_fr_id_2 FROM product_page_global p0_ LIMIT 1;

SELECT
  p0_.product_name AS product_name_0,
  p0_.product_size AS product_size_1,
  p0_.product_updated_at AS product_updated_at_2,
  p0_.product_alt AS product_alt_3,
  p0_.cover_name AS cover_name_4,
  p0_.cover_size AS cover_size_5,
  p0_.cover_updated_at AS cover_updated_at_6,
  p0_.cover_alt AS cover_alt_7,
  p0_.logo_name AS logo_name_8,
  p0_.logo_size AS logo_size_9,
  p0_.logo_updated_at AS logo_updated_at_10,
  p0_.logo_alt AS logo_alt_11,
  p0_.display_hp AS display_hp_12,
  p0_.id AS id_13,
  p0_.position AS position_14,
  p0_.is_published AS is_published_15,
  p0_.category_id AS category_id_16,
  p0_.translation_en_id AS translation_en_id_17,
  p0_.translation_fr_id AS translation_fr_id_18
FROM
  product_global p0_
WHERE
  p0_.is_published = ?

SELECT p0_.product_name AS product_name_0, p0_.product_size AS product_size_1, p0_.product_updated_at AS product_updated_at_2, p0_.product_alt AS product_alt_3, p0_.cover_name AS cover_name_4, p0_.cover_size AS cover_size_5, p0_.cover_updated_at AS cover_updated_at_6, p0_.cover_alt AS cover_alt_7, p0_.logo_name AS logo_name_8, p0_.logo_size AS logo_size_9, p0_.logo_updated_at AS logo_updated_at_10, p0_.logo_alt AS logo_alt_11, p0_.display_hp AS display_hp_12, p0_.id AS id_13, p0_.position AS position_14, p0_.is_published AS is_published_15, p0_.category_id AS category_id_16, p0_.translation_en_id AS translation_en_id_17, p0_.translation_fr_id AS translation_fr_id_18 FROM product_global p0_ WHERE p0_.is_published = 1;

SELECT
  p0_.product_name AS product_name_0,
  p0_.product_size AS product_size_1,
  p0_.product_updated_at AS product_updated_at_2,
  p0_.product_alt AS product_alt_3,
  p0_.cover_name AS cover_name_4,
  p0_.cover_size AS cover_size_5,
  p0_.cover_updated_at AS cover_updated_at_6,
  p0_.cover_alt AS cover_alt_7,
  p0_.logo_name AS logo_name_8,
  p0_.logo_size AS logo_size_9,
  p0_.logo_updated_at AS logo_updated_at_10,
  p0_.logo_alt AS logo_alt_11,
  p0_.display_hp AS display_hp_12,
  p0_.id AS id_13,
  p0_.position AS position_14,
  p0_.is_published AS is_published_15,
  p0_.category_id AS category_id_16,
  p0_.translation_en_id AS translation_en_id_17,
  p0_.translation_fr_id AS translation_fr_id_18
FROM
  product_global p0_
WHERE
  p0_.is_published = ?

SELECT p0_.product_name AS product_name_0, p0_.product_size AS product_size_1, p0_.product_updated_at AS product_updated_at_2, p0_.product_alt AS product_alt_3, p0_.cover_name AS cover_name_4, p0_.cover_size AS cover_size_5, p0_.cover_updated_at AS cover_updated_at_6, p0_.cover_alt AS cover_alt_7, p0_.logo_name AS logo_name_8, p0_.logo_size AS logo_size_9, p0_.logo_updated_at AS logo_updated_at_10, p0_.logo_alt AS logo_alt_11, p0_.display_hp AS display_hp_12, p0_.id AS id_13, p0_.position AS position_14, p0_.is_published AS is_published_15, p0_.category_id AS category_id_16, p0_.translation_en_id AS translation_en_id_17, p0_.translation_fr_id AS translation_fr_id_18 FROM product_global p0_ WHERE p0_.is_published = 1;

SELECT
  t0.image_name AS image_name_1,
  t0.image_size AS image_size_2,
  t0.image_updated_at AS image_updated_at_3,
  t0.image_alt AS image_alt_4,
  t0.id AS id_5,
  t0.translation_en_id AS translation_en_id_6,
  t0.translation_fr_id AS translation_fr_id_7
FROM
  product_category_global t0
WHERE
  t0.id = ?

SELECT t0.image_name AS image_name_1, t0.image_size AS image_size_2, t0.image_updated_at AS image_updated_at_3, t0.image_alt AS image_alt_4, t0.id AS id_5, t0.translation_en_id AS translation_en_id_6, t0.translation_fr_id AS translation_fr_id_7 FROM product_category_global t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t9.image_name AS image_name_10,
  t9.image_size AS image_size_11,
  t9.image_updated_at AS image_updated_at_12,
  t9.image_alt AS image_alt_13,
  t9.id AS id_14,
  t9.translation_en_id AS translation_en_id_15,
  t9.translation_fr_id AS translation_fr_id_16,
  t17.image_name AS image_name_18,
  t17.image_size AS image_size_19,
  t17.image_updated_at AS image_updated_at_20,
  t17.image_alt AS image_alt_21,
  t17.id AS id_22,
  t17.translation_en_id AS translation_en_id_23,
  t17.translation_fr_id AS translation_fr_id_24
FROM
  product_category t0
  LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id
  LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t9.image_name AS image_name_10, t9.image_size AS image_size_11, t9.image_updated_at AS image_updated_at_12, t9.image_alt AS image_alt_13, t9.id AS id_14, t9.translation_en_id AS translation_en_id_15, t9.translation_fr_id AS translation_fr_id_16, t17.image_name AS image_name_18, t17.image_size AS image_size_19, t17.image_updated_at AS image_updated_at_20, t17.image_alt AS image_alt_21, t17.id AS id_22, t17.translation_en_id AS translation_en_id_23, t17.translation_fr_id AS translation_fr_id_24 FROM product_category t0 LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id WHERE t0.id = 6;

SELECT
  t0.product_name AS product_name_1,
  t0.product_size AS product_size_2,
  t0.product_updated_at AS product_updated_at_3,
  t0.product_alt AS product_alt_4,
  t0.cover_name AS cover_name_5,
  t0.cover_size AS cover_size_6,
  t0.cover_updated_at AS cover_updated_at_7,
  t0.cover_alt AS cover_alt_8,
  t0.logo_name AS logo_name_9,
  t0.logo_size AS logo_size_10,
  t0.logo_updated_at AS logo_updated_at_11,
  t0.logo_alt AS logo_alt_12,
  t0.display_hp AS display_hp_13,
  t0.id AS id_14,
  t0.position AS position_15,
  t0.is_published AS is_published_16,
  t0.category_id AS category_id_17,
  t0.translation_en_id AS translation_en_id_18,
  t0.translation_fr_id AS translation_fr_id_19
FROM
  product_global t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.product_name AS product_name_1, t0.product_size AS product_size_2, t0.product_updated_at AS product_updated_at_3, t0.product_alt AS product_alt_4, t0.cover_name AS cover_name_5, t0.cover_size AS cover_size_6, t0.cover_updated_at AS cover_updated_at_7, t0.cover_alt AS cover_alt_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt AS logo_alt_12, t0.display_hp AS display_hp_13, t0.id AS id_14, t0.position AS position_15, t0.is_published AS is_published_16, t0.category_id AS category_id_17, t0.translation_en_id AS translation_en_id_18, t0.translation_fr_id AS translation_fr_id_19 FROM product_global t0 WHERE t0.category_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.banner_name AS banner_name_4,
  t0.banner_size AS banner_size_5,
  t0.banner_updated_at AS banner_updated_at_6,
  t0.banner_alt AS banner_alt_7,
  t0.banner_youtube_url_original AS banner_youtube_url_original_8,
  t0.banner_youtube_url_embed AS banner_youtube_url_embed_9,
  t0.advantage_title AS advantage_title_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.slug AS slug_13,
  t14.product_name AS product_name_15,
  t14.product_size AS product_size_16,
  t14.product_updated_at AS product_updated_at_17,
  t14.product_alt AS product_alt_18,
  t14.cover_name AS cover_name_19,
  t14.cover_size AS cover_size_20,
  t14.cover_updated_at AS cover_updated_at_21,
  t14.cover_alt AS cover_alt_22,
  t14.logo_name AS logo_name_23,
  t14.logo_size AS logo_size_24,
  t14.logo_updated_at AS logo_updated_at_25,
  t14.logo_alt AS logo_alt_26,
  t14.display_hp AS display_hp_27,
  t14.id AS id_28,
  t14.position AS position_29,
  t14.is_published AS is_published_30,
  t14.category_id AS category_id_31,
  t14.translation_en_id AS translation_en_id_32,
  t14.translation_fr_id AS translation_fr_id_33,
  t34.product_name AS product_name_35,
  t34.product_size AS product_size_36,
  t34.product_updated_at AS product_updated_at_37,
  t34.product_alt AS product_alt_38,
  t34.cover_name AS cover_name_39,
  t34.cover_size AS cover_size_40,
  t34.cover_updated_at AS cover_updated_at_41,
  t34.cover_alt AS cover_alt_42,
  t34.logo_name AS logo_name_43,
  t34.logo_size AS logo_size_44,
  t34.logo_updated_at AS logo_updated_at_45,
  t34.logo_alt AS logo_alt_46,
  t34.display_hp AS display_hp_47,
  t34.id AS id_48,
  t34.position AS position_49,
  t34.is_published AS is_published_50,
  t34.category_id AS category_id_51,
  t34.translation_en_id AS translation_en_id_52,
  t34.translation_fr_id AS translation_fr_id_53
FROM
  product t0
  LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id
  LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.banner_name AS banner_name_4,
  t0.banner_size AS banner_size_5,
  t0.banner_updated_at AS banner_updated_at_6,
  t0.banner_alt AS banner_alt_7,
  t0.banner_youtube_url_original AS banner_youtube_url_original_8,
  t0.banner_youtube_url_embed AS banner_youtube_url_embed_9,
  t0.advantage_title AS advantage_title_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.slug AS slug_13,
  t14.product_name AS product_name_15,
  t14.product_size AS product_size_16,
  t14.product_updated_at AS product_updated_at_17,
  t14.product_alt AS product_alt_18,
  t14.cover_name AS cover_name_19,
  t14.cover_size AS cover_size_20,
  t14.cover_updated_at AS cover_updated_at_21,
  t14.cover_alt AS cover_alt_22,
  t14.logo_name AS logo_name_23,
  t14.logo_size AS logo_size_24,
  t14.logo_updated_at AS logo_updated_at_25,
  t14.logo_alt AS logo_alt_26,
  t14.display_hp AS display_hp_27,
  t14.id AS id_28,
  t14.position AS position_29,
  t14.is_published AS is_published_30,
  t14.category_id AS category_id_31,
  t14.translation_en_id AS translation_en_id_32,
  t14.translation_fr_id AS translation_fr_id_33,
  t34.product_name AS product_name_35,
  t34.product_size AS product_size_36,
  t34.product_updated_at AS product_updated_at_37,
  t34.product_alt AS product_alt_38,
  t34.cover_name AS cover_name_39,
  t34.cover_size AS cover_size_40,
  t34.cover_updated_at AS cover_updated_at_41,
  t34.cover_alt AS cover_alt_42,
  t34.logo_name AS logo_name_43,
  t34.logo_size AS logo_size_44,
  t34.logo_updated_at AS logo_updated_at_45,
  t34.logo_alt AS logo_alt_46,
  t34.display_hp AS display_hp_47,
  t34.id AS id_48,
  t34.position AS position_49,
  t34.is_published AS is_published_50,
  t34.category_id AS category_id_51,
  t34.translation_en_id AS translation_en_id_52,
  t34.translation_fr_id AS translation_fr_id_53
FROM
  product t0
  LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id
  LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = 6;

SELECT
  t0.image_name AS image_name_1,
  t0.image_size AS image_size_2,
  t0.image_updated_at AS image_updated_at_3,
  t0.image_alt AS image_alt_4,
  t0.id AS id_5,
  t0.translation_en_id AS translation_en_id_6,
  t0.translation_fr_id AS translation_fr_id_7
FROM
  product_category_global t0
WHERE
  t0.id = ?

SELECT t0.image_name AS image_name_1, t0.image_size AS image_size_2, t0.image_updated_at AS image_updated_at_3, t0.image_alt AS image_alt_4, t0.id AS id_5, t0.translation_en_id AS translation_en_id_6, t0.translation_fr_id AS translation_fr_id_7 FROM product_category_global t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t9.image_name AS image_name_10,
  t9.image_size AS image_size_11,
  t9.image_updated_at AS image_updated_at_12,
  t9.image_alt AS image_alt_13,
  t9.id AS id_14,
  t9.translation_en_id AS translation_en_id_15,
  t9.translation_fr_id AS translation_fr_id_16,
  t17.image_name AS image_name_18,
  t17.image_size AS image_size_19,
  t17.image_updated_at AS image_updated_at_20,
  t17.image_alt AS image_alt_21,
  t17.id AS id_22,
  t17.translation_en_id AS translation_en_id_23,
  t17.translation_fr_id AS translation_fr_id_24
FROM
  product_category t0
  LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id
  LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t9.image_name AS image_name_10, t9.image_size AS image_size_11, t9.image_updated_at AS image_updated_at_12, t9.image_alt AS image_alt_13, t9.id AS id_14, t9.translation_en_id AS translation_en_id_15, t9.translation_fr_id AS translation_fr_id_16, t17.image_name AS image_name_18, t17.image_size AS image_size_19, t17.image_updated_at AS image_updated_at_20, t17.image_alt AS image_alt_21, t17.id AS id_22, t17.translation_en_id AS translation_en_id_23, t17.translation_fr_id AS translation_fr_id_24 FROM product_category t0 LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id WHERE t0.id = 8;

SELECT
  t0.product_name AS product_name_1,
  t0.product_size AS product_size_2,
  t0.product_updated_at AS product_updated_at_3,
  t0.product_alt AS product_alt_4,
  t0.cover_name AS cover_name_5,
  t0.cover_size AS cover_size_6,
  t0.cover_updated_at AS cover_updated_at_7,
  t0.cover_alt AS cover_alt_8,
  t0.logo_name AS logo_name_9,
  t0.logo_size AS logo_size_10,
  t0.logo_updated_at AS logo_updated_at_11,
  t0.logo_alt AS logo_alt_12,
  t0.display_hp AS display_hp_13,
  t0.id AS id_14,
  t0.position AS position_15,
  t0.is_published AS is_published_16,
  t0.category_id AS category_id_17,
  t0.translation_en_id AS translation_en_id_18,
  t0.translation_fr_id AS translation_fr_id_19
FROM
  product_global t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.product_name AS product_name_1, t0.product_size AS product_size_2, t0.product_updated_at AS product_updated_at_3, t0.product_alt AS product_alt_4, t0.cover_name AS cover_name_5, t0.cover_size AS cover_size_6, t0.cover_updated_at AS cover_updated_at_7, t0.cover_alt AS cover_alt_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt AS logo_alt_12, t0.display_hp AS display_hp_13, t0.id AS id_14, t0.position AS position_15, t0.is_published AS is_published_16, t0.category_id AS category_id_17, t0.translation_en_id AS translation_en_id_18, t0.translation_fr_id AS translation_fr_id_19 FROM product_global t0 WHERE t0.category_id = 2 ORDER BY t0.position ASC;