Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0;

SELECT
  t0.categories_id AS categories_id_1,
  t0.categories_image AS categories_image_2,
  t0.sort_order AS sort_order_3,
  t0.date_added AS date_added_4,
  t0.last_modified AS last_modified_5,
  t0.categories_best AS categories_best_6,
  t0.categories_affichage AS categories_affichage_7,
  t0.categories_sousmenu AS categories_sousmenu_8,
  t0.categories_index AS categories_index_9,
  t0.categories_hide_children AS categories_hide_children_10,
  t0.categories_position AS categories_position_11,
  t0.categories_menu_spacer AS categories_menu_spacer_12,
  t0.categories_code AS categories_code_13,
  t0.parent_id AS parent_id_14
FROM
  categories t0
WHERE
  t0.categories_id = ?

SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = '2322';

SELECT
  t0.id AS id_1,
  t0.redirect_url AS redirect_url_2,
  t0.target_path AS target_path_3,
  t0.target_url AS target_url_4,
  t0.redirect_product_id AS redirect_product_id_5,
  t0.redirect_category_id AS redirect_category_id_6,
  t0.target_product_id AS target_product_id_7,
  t0.target_category_id AS target_category_id_8
FROM
  redirections t0
WHERE
  t0.redirect_category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.redirect_url AS redirect_url_2, t0.target_path AS target_path_3, t0.target_url AS target_url_4, t0.redirect_product_id AS redirect_product_id_5, t0.redirect_category_id AS redirect_category_id_6, t0.target_product_id AS target_product_id_7, t0.target_category_id AS target_category_id_8 FROM redirections t0 WHERE t0.redirect_category_id = 2322 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.categories_name AS categories_name_2,
  t0.categories_short_name AS categories_short_name_3,
  t0.categories_heading_title AS categories_heading_title_4,
  t0.categories_description AS categories_description_5,
  t0.categories_head_title_tag AS categories_head_title_tag_6,
  t0.categories_head_desc_tag AS categories_head_desc_tag_7,
  t0.categories_head_keywords_tag AS categories_head_keywords_tag_8,
  t0.categories_htc_title_tag AS categories_htc_title_tag_9,
  t0.categories_htc_desc_tag AS categories_htc_desc_tag_10,
  t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11,
  t0.categories_htc_description AS categories_htc_description_12,
  t0.categories_description_bas AS categories_description_bas_13,
  t0.categories_tags AS categories_tags_14,
  t0.categories_url AS categories_url_15,
  t0.categories_menu_prefix AS categories_menu_prefix_16,
  t0.categories_menu_suffix AS categories_menu_suffix_17,
  t0.categories_menu_banner AS categories_menu_banner_18,
  t0.categories_id AS categories_id_19,
  t0.language_id AS language_id_20
FROM
  categories_description t0
WHERE
  t0.categories_id = ?

SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = 2322;

SELECT
  p0_.id AS id_0,
  p0_.products_id AS products_id_1,
  p0_.categories_id AS categories_id_2
FROM
  products_to_categories p0_
  INNER JOIN products p1_ ON p0_.products_id = p1_.products_id
WHERE
  p0_.categories_id = ?
  AND p1_.products_status = 1
  AND (
    p1_.products_model_id IS NULL
    OR p1_.is_default_variant = 1
  )
LIMIT
  21

SELECT p0_.id AS id_0, p0_.products_id AS products_id_1, p0_.categories_id AS categories_id_2 FROM products_to_categories p0_ INNER JOIN products p1_ ON p0_.products_id = p1_.products_id WHERE p0_.categories_id = 2322 AND p1_.products_status = 1 AND (p1_.products_model_id IS NULL OR p1_.is_default_variant = 1) LIMIT 21;

SELECT
  count(p0_.products_id) AS sclr_0
FROM
  products_to_categories p0_
  INNER JOIN products p1_ ON p0_.products_id = p1_.products_id
WHERE
  p0_.categories_id = ?
  AND p1_.products_status = 1
  AND p1_.is_default_variant = 1

SELECT count(p0_.products_id) AS sclr_0 FROM products_to_categories p0_ INNER JOIN products p1_ ON p0_.products_id = p1_.products_id WHERE p0_.categories_id = 2322 AND p1_.products_status = 1 AND p1_.is_default_variant = 1;

SELECT
  t0.categories_id AS categories_id_1,
  t0.categories_image AS categories_image_2,
  t0.sort_order AS sort_order_3,
  t0.date_added AS date_added_4,
  t0.last_modified AS last_modified_5,
  t0.categories_best AS categories_best_6,
  t0.categories_affichage AS categories_affichage_7,
  t0.categories_sousmenu AS categories_sousmenu_8,
  t0.categories_index AS categories_index_9,
  t0.categories_hide_children AS categories_hide_children_10,
  t0.categories_position AS categories_position_11,
  t0.categories_menu_spacer AS categories_menu_spacer_12,
  t0.categories_code AS categories_code_13,
  t0.parent_id AS parent_id_14
FROM
  categories t0
WHERE
  t0.categories_id = ?

SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = 2318;

SELECT
  t0.categories_id AS categories_id_1,
  t0.categories_image AS categories_image_2,
  t0.sort_order AS sort_order_3,
  t0.date_added AS date_added_4,
  t0.last_modified AS last_modified_5,
  t0.categories_best AS categories_best_6,
  t0.categories_affichage AS categories_affichage_7,
  t0.categories_sousmenu AS categories_sousmenu_8,
  t0.categories_index AS categories_index_9,
  t0.categories_hide_children AS categories_hide_children_10,
  t0.categories_position AS categories_position_11,
  t0.categories_menu_spacer AS categories_menu_spacer_12,
  t0.categories_code AS categories_code_13,
  t0.parent_id AS parent_id_14
FROM
  categories t0
WHERE
  t0.categories_id = ?

SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = 2317;

SELECT
  t0.languages_id AS languages_id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.image AS image_4,
  t0.directory AS directory_5,
  t0.sort_order AS sort_order_6
FROM
  languages t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.code = 'en' LIMIT 1;

select
  pef.products_extra_fields_id,
  pef.products_extra_fields_name,
  ptpef.products_extra_fields_value,
  pef.products_extra_fields_order,
  ptpef.products_id
from
  products_extra_fields pef
  inner join products_to_products_extra_fields ptpef on ptpef.products_extra_fields_id = pef.products_extra_fields_id
  inner join products_to_categories ptc on ptc.products_id = ptpef.products_id
  inner join products p on p.products_id = ptpef.products_id
where
  p.products_status = 1
  and pef.products_extra_fields_status = 1
  and (
    ptc.categories_id in (2322)
  )
  and (
    pef.languages_id = 1
    or pef.languages_id = 0
  )
  and (
    pef.products_extra_fields_status = 1
  )
  and ptpef.products_extra_fields_value <> ''
group by
  ptpef.products_extra_fields_value
order by
  products_extra_fields_order,
  products_extra_fields_value

select
        pef.products_extra_fields_id, 
        pef.products_extra_fields_name, 
        ptpef.products_extra_fields_value, 
        pef.products_extra_fields_order, 
        ptpef.products_id
        from products_extra_fields pef  
        inner join products_to_products_extra_fields ptpef on ptpef.products_extra_fields_id = pef.products_extra_fields_id 
        inner join products_to_categories ptc on ptc.products_id = ptpef.products_id
        inner join products p on p.products_id = ptpef.products_id
        where
        p.products_status=1 and 
        pef.products_extra_fields_status=1 and
        
        
        (ptc.categories_id in (2322)) and
        (pef.languages_id=1 or pef.languages_id=0) and
        (pef.products_extra_fields_status=1) and
          ptpef.products_extra_fields_value <> ''
        group by ptpef.products_extra_fields_value 
        order by 
        products_extra_fields_order, 
        products_extra_fields_value;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = 'VV' LIMIT 1;

SELECT
  t0.languages_id AS languages_id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.image AS image_4,
  t0.directory AS directory_5,
  t0.sort_order AS sort_order_6
FROM
  languages t0
WHERE
  t0.languages_id = ?

SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.languages_id = 4;

SELECT
  t0.id AS id_1,
  t0.categories_name AS categories_name_2,
  t0.categories_short_name AS categories_short_name_3,
  t0.categories_heading_title AS categories_heading_title_4,
  t0.categories_description AS categories_description_5,
  t0.categories_head_title_tag AS categories_head_title_tag_6,
  t0.categories_head_desc_tag AS categories_head_desc_tag_7,
  t0.categories_head_keywords_tag AS categories_head_keywords_tag_8,
  t0.categories_htc_title_tag AS categories_htc_title_tag_9,
  t0.categories_htc_desc_tag AS categories_htc_desc_tag_10,
  t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11,
  t0.categories_htc_description AS categories_htc_description_12,
  t0.categories_description_bas AS categories_description_bas_13,
  t0.categories_tags AS categories_tags_14,
  t0.categories_url AS categories_url_15,
  t0.categories_menu_prefix AS categories_menu_prefix_16,
  t0.categories_menu_suffix AS categories_menu_suffix_17,
  t0.categories_menu_banner AS categories_menu_banner_18,
  t0.categories_id AS categories_id_19,
  t0.language_id AS language_id_20
FROM
  categories_description t0
WHERE
  t0.categories_id = ?

SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = 2317;

SELECT
  t0.id AS id_1,
  t0.categories_name AS categories_name_2,
  t0.categories_short_name AS categories_short_name_3,
  t0.categories_heading_title AS categories_heading_title_4,
  t0.categories_description AS categories_description_5,
  t0.categories_head_title_tag AS categories_head_title_tag_6,
  t0.categories_head_desc_tag AS categories_head_desc_tag_7,
  t0.categories_head_keywords_tag AS categories_head_keywords_tag_8,
  t0.categories_htc_title_tag AS categories_htc_title_tag_9,
  t0.categories_htc_desc_tag AS categories_htc_desc_tag_10,
  t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11,
  t0.categories_htc_description AS categories_htc_description_12,
  t0.categories_description_bas AS categories_description_bas_13,
  t0.categories_tags AS categories_tags_14,
  t0.categories_url AS categories_url_15,
  t0.categories_menu_prefix AS categories_menu_prefix_16,
  t0.categories_menu_suffix AS categories_menu_suffix_17,
  t0.categories_menu_banner AS categories_menu_banner_18,
  t0.categories_id AS categories_id_19,
  t0.language_id AS language_id_20
FROM
  categories_description t0
WHERE
  t0.categories_id = ?

SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = 2318;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = 'VV' LIMIT 1;