https://test.vivog.fr/en/u/430/cat

Method
GET
HTTP Status
200
IP
216.73.216.101
Profiled on
Token
b9e523

Query Metrics

774 Database Queries
21 Different statements
1793.83 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
557.05 ms
(31.05%) 		1 
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 = 1 
            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 (893,701,703,702,462,909,631,1402,1026) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
366.80 ms
(20.45%) 		1 
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 = 1 
            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 (457,687,689,1333,1431,690,1370,1371,692,1325,1800,1014) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
232.86 ms
(12.98%) 		1 
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 = 1 
            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 (1735,460,1623,1691,1658,1709,901,1331,461,1636,1731) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
205.89 ms
(11.48%) 		1 
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 = 1 
            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 (459,948,1614,1708,1671,1068,1330,1428,1732,1584,557,1430,1733) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
118.63 ms
(6.61%) 		1 
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 = 1 
            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 (440,1008,994,466,910,912,683,759,1413,1734,1815,1817,1819) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
84.30 ms
(4.70%) 		1 
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 = 1 
            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 (1027,1028,674,1727) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
59.71 ms
(3.33%) 		1 
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 = 1 
            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 (458,1010,1038,1039,1040,1003,1042,1811) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
36.12 ms
(2.01%) 		1 
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 = 1 
            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 (1372,1369,1373,1368,1367,1025,924,1043) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
31.81 ms
(1.77%) 		119 
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_parent_id AS products_parent_id_66, t0.manufacturers_id AS manufacturers_id_67, t0.products_tax_class_id AS products_tax_class_id_68 FROM products t0 WHERE t0.products_id = ?
Parameters: 
[
  22705
]
View formatted query    View runnable query    Explain query
21.36 ms
(1.19%) 		119 
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters: 
[
  22705
]
View formatted query    View runnable query    Explain query
19.96 ms
(1.11%) 		119 
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters: 
[
  22705
]
View formatted query    View runnable query    Explain query
16.28 ms
(0.91%) 		118 
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters: 
[
  61517
]
View formatted query    View runnable query    Explain query
15.47 ms
(0.86%) 		125 
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
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
13.30 ms
(0.74%) 		80 
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
Parameters: 
[
  430
]
View formatted query    View runnable query    Explain query
5.92 ms
(0.33%) 		40 
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 = ?
Parameters: 
[
  "430"
]
View formatted query    View runnable query    Explain query
2.38 ms
(0.13%) 		16 
SELECT t0.id AS id_1, t0.manufacturers_title AS manufacturers_title_2, t0.manufacturers_url AS manufacturers_url_3, t0.manufacturers_description1 AS manufacturers_description1_4, t0.manufacturers_description2 AS manufacturers_description2_5, t0.url_clicked AS url_clicked_6, t0.date_last_click AS date_last_click_7, t0.manufacturers_id AS manufacturers_id_8, t0.languages_id AS languages_id_9 FROM manufacturers_info t0 WHERE t0.manufacturers_id = ?
Parameters: 
[
  52
]
View formatted query    View runnable query    Explain query
2.04 ms
(0.11%) 		16 
SELECT t0.manufacturers_id AS manufacturers_id_1, t0.manufacturers_name AS manufacturers_name_2, t0.manufacturers_image AS manufacturers_image_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.manufacturers_statuts AS manufacturers_statuts_6, t0.manufacturers_order AS manufacturers_order_7, t0.manufacturers_locked_price AS manufacturers_locked_price_8, t0.manufacturers_welcome AS manufacturers_welcome_9, t0.manufacturers_export AS manufacturers_export_10 FROM manufacturers t0 WHERE t0.manufacturers_id = ?
Parameters: 
[
  52
]
View formatted query    View runnable query    Explain query
1.93 ms
(0.11%) 		10 
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 = ?
Parameters: 
[
  430
]
View formatted query    View runnable query    Explain query
1.48 ms
(0.08%) 		1 
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 = 1 
            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 (1826) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.27 ms
(0.02%) 		2 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.01%) 		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 = ? LIMIT 1
Parameters: 
[
  430
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\CategoryDescription No errors.
App\Entity\CategoryToExtraField No errors.
App\Entity\Picture No errors.
App\Entity\PictureCategory No errors.
App\Entity\Redirection No errors.
App\Entity\Product No errors.
App\Entity\Language No errors.
App\Entity\ProductExtraField No errors.
App\Entity\PictureDescription No errors.
App\Entity\ProductAttribute No errors.
App\Entity\ProductDescription No errors.
App\Entity\PictureProduct No errors.
App\Entity\Manufacturer No errors.
App\Entity\ProductCountryRestriction No errors.
App\Entity\ProductToProductExtraField No errors.
App\Entity\ProductPrice No errors.
App\Entity\TaxClass No errors.
App\Entity\ProductOption No errors.
App\Entity\ProductOptionValue No errors.
App\Entity\ManufacturerDescription No errors.
App\Entity\ManufacturerCountry No errors.
App\Entity\Country No errors.
App\Entity\PriceGroup No errors.
App\Entity\TaxRate No errors.