Symfony Profiler

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

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.parent_id AS parent_id_13
FROM
  categories t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.sort_order ASC

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.parent_id AS parent_id_13 FROM categories t0 WHERE t0.parent_id = 909 ORDER BY t0.sort_order ASC;

SELECT
  IF(
    (
      SELECT
        COUNT(*)
      FROM
        products pc
      WHERE
        pc.`products_parent_id` = p.products_id
    )> 0,
    IF(
      (
        SELECT
          SUM(pq.`products_quantity`)
        FROM
          products pq
        WHERE
          pq.`products_parent_id` = p.products_id
          AND pq.`products_quantity` >= 0
      )> 0,
      1,
      0
    ),
    IF(p.products_quantity > 0, 1, 0)
  ) AS available,
  (
    SELECT
      rate
    FROM
      avisverifies_products_average
    WHERE
      ref_product = p.products_id
  ) AS average,
  (
    SELECT
      nb_reviews
    FROM
      avisverifies_products_average
    WHERE
      ref_product = p.products_id
  ) AS nb_reviews,
  IF(
    (
      SELECT
        COUNT(*)
      FROM
        products pp
      WHERE
        pp.products_parent_id = p.products_id
    )> 0,
    LEAST(
      IFNULL(
        (
          SELECT
            MIN(sp.specials_new_products_price)
          FROM
            `specials` sp
          WHERE
            sp.`products_id` IN (
              SELECT
                pp.products_id
              FROM
                products pp
              WHERE
                pp.products_parent_id = p.`products_id`
                AND pp.products_status = 1
            )
            AND sp.expires_date > NOW()
            AND sp.status = 1
        ),
        10000
      ),
      (
        SELECT
          MIN(pp.products_price)
        FROM
          `products` pp
        WHERE
          pp.products_parent_id = p.`products_id`
          AND pp.products_status = 1
      )
    ),
    IFNULL(
      (
        SELECT
          MIN(sp.specials_new_products_price)
        FROM
          `specials` sp
        WHERE
          sp.`products_id` = p.`products_id`
          AND sp.expires_date > NOW()
          AND sp.status = 1
      ),
      p.products_price
    )
  ) AS reduced_price,
  p.products_id,
  p.products_price,
  IF(
    s.status, s.specials_new_products_price,
    NULL
  ) AS specials_new_products_price,
  IF(
    s.status, s.specials_new_products_price,
    p.products_price
  ) AS final_price,
  IFNULL(
    LEAST(
      p.products_price,
      (
        SELECT
          MIN(pp.products_price)
        FROM
          `products` pp
        WHERE
          pp.products_parent_id = p.`products_id`
          AND p.products_quantity >= 0
      )
    ),
    p.products_price
  ) AS lowest_regular_price
FROM
  (
    products p
    LEFT JOIN specials_retail_prices s USING(products_id)
  )
  INNER JOIN products_description pd ON pd.products_id = p.products_id
  AND pd.language_id = 4
  LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id,
  products_to_categories p2c
WHERE
  p.products_status = '1'
  AND p.products_parent_id IS NULL
  AND p.products_quantity >= 0
  AND p.products_id = p2c.products_id
  AND p2c.categories_id IN (909)
GROUP BY
  p.products_id
ORDER BY
  available DESC,
  products_id DESC
LIMIT
  21 OFFSET 0

SELECT 
            IF((SELECT COUNT(*) FROM products pc WHERE pc.`products_parent_id`=p.products_id)>0,IF((SELECT SUM(pq.`products_quantity`) FROM products pq WHERE pq.`products_parent_id`=p.products_id AND pq.`products_quantity`>=0)>0,1,0),IF(p.products_quantity>0,1,0)) AS available, 
            (SELECT rate FROM avisverifies_products_average WHERE ref_product = p.products_id) AS average,
            (SELECT nb_reviews FROM avisverifies_products_average WHERE ref_product = p.products_id) AS nb_reviews,
            IF(
                (SELECT COUNT(*) FROM products pp WHERE pp.products_parent_id = p.products_id)>0,
                LEAST(
                    IFNULL((SELECT MIN(sp.specials_new_products_price) FROM `specials` sp WHERE sp.`products_id` IN (SELECT pp.products_id FROM products pp WHERE pp.products_parent_id=p.`products_id` AND pp.products_status=1) AND sp.expires_date>NOW() AND sp.status=1),10000),
                    (SELECT MIN(pp.products_price) FROM `products` pp WHERE pp.products_parent_id=p.`products_id` AND pp.products_status=1)
                ), 
                IFNULL((SELECT MIN(sp.specials_new_products_price) FROM `specials` sp WHERE sp.`products_id` = p.`products_id` AND sp.expires_date>NOW() AND sp.status=1),p.products_price)
            ) AS reduced_price,
            p.products_id, 
            p.products_price, 
            IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, 
            IF(s.status, s.specials_new_products_price, p.products_price) AS final_price,
            IFNULL(
                LEAST(
                    p.products_price,
                    (SELECT MIN(pp.products_price) FROM `products` pp WHERE pp.products_parent_id=p.`products_id` AND p.products_quantity >= 0)
                ),
                p.products_price
            ) AS lowest_regular_price
            FROM (products p LEFT JOIN specials_retail_prices s USING(products_id)) 
            INNER JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 4 
            LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id, products_to_categories p2c WHERE p.products_status = '1' AND p.products_parent_id  IS NULL AND p.products_quantity >= 0 AND p.products_id = p2c.products_id AND p2c.categories_id IN (909) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 21 OFFSET 0;

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.parent_id AS parent_id_13
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.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = '909';

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
  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 (909)
  )
  AND (
    pef.languages_id = 4
    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 (909)) AND
        (pef.languages_id=4 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
  COUNT(
    DISTINCT(p.products_id)
  ) AS nb
FROM
  (
    products p
    LEFT JOIN specials_retail_prices s USING(products_id)
  )
  LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id,
  products_to_categories p2c
WHERE
  p.products_status = '1'
  AND p.products_parent_id IS NULL
  AND p.products_quantity >= 0
  AND p.products_id = p2c.products_id
  AND p2c.categories_id IN (909)

SELECT 
            COUNT(DISTINCT(p.products_id)) AS nb 
            FROM (products p LEFT JOIN specials_retail_prices s USING(products_id)) 
            LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id, products_to_categories p2c WHERE p.products_status = '1' AND p.products_parent_id  IS NULL AND p.products_quantity >= 0 AND p.products_id = p2c.products_id AND p2c.categories_id IN (909);

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 = 909 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 = ?
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 = 'fr' 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 = 1;