0.0002 | SELECT *
FROM (`ra_sessions`)
WHERE `session_id` = '92ec2bbaee2e103bec1c4d0b97df05d4' |
0.0034 | SELECT (FLOOR(MIN(IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR
(p.special_price_begin = 0 AND p.special_price_end = 0))), p.special_price, (IF((p.show_price = 1), p.price, 0))))*1)) AS min_price, (CEILING(MAX(IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR
(p.special_price_begin = 0 AND p.special_price_end = 0))), p.special_price, (IF((p.show_price = 1), p.price, 0))))*1)) AS max_price
FROM (`ra_shop_products` AS p)
WHERE `p`.`category_id` IN ('15', '257', '259', '26', '27', '29', '30', '33', '45', '50', '51', '53', '316', '62', '318', '63', '319', '320', '321', '322', '67', '323', '324', '325', '326', '71', '327', '328', '329', '330', '331', '76', '332', '77', '333', '336', '337', '82', '338', '83', '339', '340', '85', '341', '342', '343', '89', '347', '92', '348', '93', '349', '350', '95', '351', '352', '98', '354', '355', '356', '357', '358', '359', '360', '361', '362', '108', '364', '365', '110', '366', '111', '367', '368', '369', '370', '371', '372', '117', '373', '119', '120', '376', '121', '377', '122', '378', '379', '125', '126', '128', '129', '136', '139', '145', '147', '149', '160', '163', '164', '165', '168', '175', '186', '188', '193', '194', '195', '197', '198', '199', '200', '201', '202', '203', '206', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '232', '233', '243', '244', '245', '246', '248', '250', '251', '252', '253', '254', '255')
AND `p`.`active` = 1
AND `p`.`is_delete` = 0 |
0.0026 | SELECT `b`.`brand_id`, `b`.`brand_name`
FROM (`ra_shop_brands` AS b)
JOIN `ra_shop_categories` AS c ON `c`.`brand_id` = `b`.`brand_id`
WHERE `b`.`active` = 1
AND `c`.`active` = 1
AND `c`.`is_collection` = 1
AND `b`.`brand_id` > 1
ORDER BY `b`.`brand_name` ASC |
0.0034 | SELECT p.product_id, p.product_id AS id_product, p.category_id, p.parent_product_id, p.attr_set_id, p.collection_id, IF(p.collection_id>0, p.collection_id, p.product_id) AS collectionPointer, TRUNCATE((
IF( p.attr_set_id = 0, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0))), p.special_price, (IF((p.show_price = 1), p.price, 0)))), p.price
)
)*1, 2) AS price, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0)) AND p.special_price < p.price), p.price, (IF((p.show_price = 1 AND (p.old_price > p.price)), p.old_price, 0)))) AS old_price
FROM (`ra_shop_products` AS p)
LEFT JOIN `ra_shop_brands` AS b ON `b`.`brand_id` = `p`.`brand_id`
LEFT JOIN `ra_shop_categories` AS c ON `c`.`category_id` = `p`.`category_id`
LEFT JOIN `ra_shop_brands` AS bc ON `bc`.`brand_id` = `c`.`brand_id`
WHERE ( (p.category_id IN (15,257,259,26,27,29,30,33,45,50,51,53,316,62,318,63,319,320,321,322,67,323,324,325,326,71,327,328,329,330,331,76,332,77,333,336,337,82,338,83,339,340,85,341,342,343,89,347,92,348,93,349,350,95,351,352,98,354,355,356,357,358,359,360,361,362,108,364,365,110,366,111,367,368,369,370,371,372,117,373,119,120,376,121,377,122,378,379,125,126,128,129,136,139,145,147,149,160,163,164,165,168,175,186,188,193,194,195,197,198,199,200,201,202,203,206,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,243,244,245,246,248,250,251,252,253,254,255)) AND c.active = 1 )
AND `p`.`promo_sale` = 1
AND `p`.`active` = 1
AND `p`.`is_delete` = 0
GROUP BY `collectionPointer`
HAVING `p`.`parent_product_id` = 0 |
0.0012 | SELECT p.product_id, p.category_id, p.parent_product_id, p.image, p.title, p.seo_title, p.seo_description, p.seo_url, p.articul, p.sku, p.model, p.series, p.attr_set_id, p.rating, p.qty, p.float_qty, p.show_qty, p.in_stock, p.product_order, p.encrypt_qty, p.unit_id, pt.pack_type_name AS pack_name, pt.pack_type_id, p.promo_hit, p.promo_new, p.promo_action, p.promo_sale, p.promo_suggest, p.rating, p.show_rating, p.weight, p.lenght, p.width, p.height, b.brand_name, b.brand_image, c.is_collection, bc.brand_name AS brandCollectionName, bc.brand_image AS brandCollectionImage, p.attr_set_id, pasv.attr_name_id AS main_param, p.currency_id, p.show_price, p.show_old_price, p.init_special_price, p.show_economy, p.special_price_begin, p.special_price_end, p.collection_id, col.title AS colTitle, col.seo_url, col.promo_text AS colPromoText, col.icon AS colIcon, CONCAT_WS("/", p.product_id, p.seo_url) AS product_url, c.title AS category_name, CONCAT_WS("/", c.category_id, c.seo_url) AS category_url, CONCAT_WS("/", p.collection_id, col.seo_url) AS collection_url, TRUNCATE((
IF( p.attr_set_id = 0, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0))), p.special_price, (IF((p.show_price = 1), p.price, 0)))), p.price
)
)*1, 2) AS price, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0)) AND p.special_price < p.price), p.price, (IF((p.show_price = 1 AND (p.old_price > p.price)), p.old_price, 0)))) AS old_price
FROM (`ra_shop_products` AS p)
LEFT JOIN `ra_shop_brands` AS b ON `b`.`brand_id` = `p`.`brand_id`
JOIN `ra_shop_categories` AS c ON `c`.`category_id` = `p`.`category_id`
LEFT JOIN `ra_shop_brands` AS bc ON `bc`.`brand_id` = `c`.`brand_id` AND c.is_collection
LEFT JOIN `ra_shop_categories` AS col ON `col`.`category_id` = `p`.`collection_id`
LEFT JOIN `ra_shop_packs_type` AS pt ON `pt`.`pack_type_id` = `p`.`unit_id`
LEFT JOIN `ra_shop_products_attr_sets_values` AS pasv ON `pasv`.`attr_set_id` = `p`.`attr_set_id` AND pasv.attr_main = 1
WHERE `p`.`product_id` IN ('1119', '1673', '2317', '2327', '2328', '2622')
GROUP BY `p`.`product_id` |
0.0002 | SELECT *
FROM (`ra_site_profile`)
WHERE `profile_id` = 1 |
0.0001 | SELECT *
FROM (`ra_menu_groups`)
WHERE `active` = 1 |
0.0002 | SELECT *
FROM (`ra_menu`)
WHERE `active` = 1
ORDER BY `group_id` ASC, `menu_order` ASC |
0.0007 | SELECT p.product_id, p.product_id AS id_product, p.category_id, p.parent_product_id, p.attr_set_id, p.collection_id, IF(p.collection_id>0, p.collection_id, p.product_id) AS collectionPointer, TRUNCATE((
IF( p.attr_set_id = 0, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0))), p.special_price, (IF((p.show_price = 1), p.price, 0)))), p.price
)
)*1, 2) AS price, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0)) AND p.special_price < p.price), p.price, (IF((p.show_price = 1 AND (p.old_price > p.price)), p.old_price, 0)))) AS old_price
FROM (`ra_shop_products` AS p)
LEFT JOIN `ra_shop_brands` AS b ON `b`.`brand_id` = `p`.`brand_id`
LEFT JOIN `ra_shop_categories` AS c ON `c`.`category_id` = `p`.`category_id`
LEFT JOIN `ra_shop_brands` AS bc ON `bc`.`brand_id` = `c`.`brand_id`
WHERE `p`.`product_id` IN ('1090', '1749', '1481', '2316', '1690', '1658', '182', '181', '180', '1733', '1662', '1100')
AND `p`.`active` = 1
AND `p`.`is_delete` = 0
GROUP BY `collectionPointer`
HAVING `p`.`parent_product_id` = 0 |
0.0013 | SELECT p.product_id, p.category_id, p.parent_product_id, p.image, p.title, p.seo_title, p.seo_description, p.seo_url, p.articul, p.sku, p.model, p.series, p.attr_set_id, p.rating, p.qty, p.float_qty, p.show_qty, p.in_stock, p.product_order, p.encrypt_qty, p.unit_id, pt.pack_type_name AS pack_name, pt.pack_type_id, p.promo_hit, p.promo_new, p.promo_action, p.promo_sale, p.promo_suggest, p.rating, p.show_rating, p.weight, p.lenght, p.width, p.height, b.brand_name, b.brand_image, c.is_collection, bc.brand_name AS brandCollectionName, bc.brand_image AS brandCollectionImage, p.attr_set_id, pasv.attr_name_id AS main_param, p.currency_id, p.show_price, p.show_old_price, p.init_special_price, p.show_economy, p.special_price_begin, p.special_price_end, p.collection_id, col.title AS colTitle, col.seo_url, col.promo_text AS colPromoText, col.icon AS colIcon, CONCAT_WS("/", p.product_id, p.seo_url) AS product_url, c.title AS category_name, CONCAT_WS("/", c.category_id, c.seo_url) AS category_url, CONCAT_WS("/", p.collection_id, col.seo_url) AS collection_url, TRUNCATE((
IF( p.attr_set_id = 0, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0))), p.special_price, (IF((p.show_price = 1), p.price, 0)))), p.price
)
)*1, 2) AS price, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1730245693 AND p.special_price_end > 1730245693) OR (p.special_price_begin = 0 AND p.special_price_end = 0)) AND p.special_price < p.price), p.price, (IF((p.show_price = 1 AND (p.old_price > p.price)), p.old_price, 0)))) AS old_price
FROM (`ra_shop_products` AS p)
LEFT JOIN `ra_shop_brands` AS b ON `b`.`brand_id` = `p`.`brand_id`
JOIN `ra_shop_categories` AS c ON `c`.`category_id` = `p`.`category_id`
LEFT JOIN `ra_shop_brands` AS bc ON `bc`.`brand_id` = `c`.`brand_id` AND c.is_collection
LEFT JOIN `ra_shop_categories` AS col ON `col`.`category_id` = `p`.`collection_id`
LEFT JOIN `ra_shop_packs_type` AS pt ON `pt`.`pack_type_id` = `p`.`unit_id`
LEFT JOIN `ra_shop_products_attr_sets_values` AS pasv ON `pasv`.`attr_set_id` = `p`.`attr_set_id` AND pasv.attr_main = 1
WHERE `p`.`product_id` IN ('180', '1090', '1100', '1481', '1658', '1662', '1690', '1733', '1749', '2316')
GROUP BY `p`.`product_id` |
0.0133 | Total Query Execution Time |