Symfony Profiler

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

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

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 = 778 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 (778)
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 (778) group by p.products_id  order by available desc , products_id desc limit 21 OFFSET 0;

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 (778)

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 (778);

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

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

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 (778)
  )
  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 (778)) 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 = 1332;

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

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