| 0.0004 | SELECT *
FROM (`ra_sessions`)
WHERE `session_id` = 'c435e1af5c9ea509c61cba085536c0e8' |
| 0.0008 | 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 < 1716113994 AND p.special_price_end > 1716113994) 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 < 1716113994 AND p.special_price_end > 1716113994) 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 ('542')
GROUP BY `p`.`product_id`
ORDER BY `p`.`product_order` ASC, `p`.`product_id` DESC |
| 0.0006 | SELECT p.*, pt.pack_type_name AS pack_type, pt.pack_type_id, b.brand_name, b.brand_image, b.brand_site, b.seo_url, CONCAT_WS("/", c.category_id, c.seo_url) AS category_slug, 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, TRUNCATE((
IF( p.attr_set_id = 0, (IF((p.init_special_price = 1 AND ((p.special_price_begin < 1716113994 AND p.special_price_end > 1716113994) 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 < 1716113994 AND p.special_price_end > 1716113994) 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, p.seo_url AS slug, cn.ru AS country, cn.flag, cr.abbr AS priceCurrency, pasv.attr_name_id AS main_param
FROM (`ra_shop_products` AS p)
JOIN `ra_shop_categories` AS c ON `c`.`category_id` = `p`.`category_id`
JOIN `ra_shop_currency` AS cr ON `cr`.`currency_id` = `p`.`currency_id`
LEFT JOIN `ra_shop_packs_type` AS pt ON `pt`.`pack_type_id` = `p`.`unit_id`
LEFT JOIN `ra_shop_brands` AS b ON `b`.`brand_id` = `p`.`brand_id`
LEFT JOIN `ra_shop_countries` AS cn ON `cn`.`country_id` = `b`.`country_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` = '542'
AND `p`.`parent_product_id` = 0
AND `p`.`is_delete` = 0 |
| 0.0002 | SELECT `l_1`.`category_id` AS cat_0, `l_1`.`seo_url` AS url_0, `l_1`.`title` AS name_0, `l_2`.`category_id` AS cat_1, `l_2`.`seo_url` AS url_1, `l_2`.`title` AS name_1, `l_3`.`category_id` AS cat_2, `l_3`.`seo_url` AS url_2, `l_3`.`title` AS name_2, `l_4`.`category_id` AS cat_3, `l_4`.`seo_url` AS url_3, `l_4`.`title` AS name_3
FROM (`ra_shop_categories` AS l_4)
LEFT JOIN `ra_shop_categories` AS l_3 ON `l_3`.`category_id` = `l_4`.`parent`
LEFT JOIN `ra_shop_categories` AS l_2 ON `l_2`.`category_id` = `l_3`.`parent`
LEFT JOIN `ra_shop_categories` AS l_1 ON `l_1`.`category_id` = `l_2`.`parent`
WHERE `l_4`.`category_id` = '84' |
| 0.0001 | SELECT `def_img_alt`, `def_img_title`
FROM (`ra_shop_seo_settings`)
WHERE `seo_config_id` = 1 |
| 0.0026 | SELECT pav.*, pan.*, (IF(pan.attr_label="", pan.attr_name, pan.attr_label)) AS label
FROM (`ra_shop_products_attr_values` AS pav)
JOIN `ra_shop_products_attr_name` AS pan ON `pan`.`attr_name_id` = `pav`.`attr_name_id`
WHERE `pan`.`attr_name_id` NOT IN (0)
AND `pav`.`product_id` = '542'
AND `pan`.`active` = 1
AND `pav`.`active` = 1
GROUP BY `pav`.`attr_name_id`
ORDER BY `label` ASC |
| 0.0026 | SELECT *
FROM (`ra_shop_products_files`)
WHERE `product_id` = '542' |
| 0.0002 | UPDATE `ra_sessions` SET `last_activity` = 1716113989, `user_data` = 'YTozOntzOjk6InVzZXJfZGF0YSI7czowOiIiO3M6ODoiY3VzdG9tZXIiO2E6MTA6e3M6OToiY2xpZW50X2lkIjtpOjA7czo3OiJpc19hdXRoIjtiOjA7czoxMzoicHJpY2VfdHlwZV9pZCI7aTowO3M6ODoiaXNfbGVnYWwiO2k6MDtzOjExOiJoYXNfY2FiaW5ldCI7aTowO3M6ODoiZGlzY291bnQiO2k6MTtzOjg6InVzZXJuYW1lIjtzOjIzOiLQndC+0LLRi9C5INC60LvQuNC10L3RgiI7czo3OiJjaXR5X2lkIjtpOjA7czo0OiJjaXR5IjtzOjA6IiI7czoxNzoiY3VzdG9tZXJfcHJvZHVjdHMiO2E6Mzp7czoxNToidmlld2VkX3Byb2R1Y3RzIjtzOjIxOiI1NDIsNzQzLDIxOTMsNzU4LDE3NzIiO3M6MTY6ImNvbXBhcmVfcHJvZHVjdHMiO2I6MDtzOjE3OiJ3aXNobGlzdF9wcm9kdWN0cyI7YjowO319czo5OiJiYW5jaG1hcmsiO2E6Mjp7czo4OiJmcm9udGVuZCI7czoxOiIxIjtzOjc6ImJhY2tlbmQiO3M6MToiMCI7fX0=' WHERE `session_id` = 'c435e1af5c9ea509c61cba085536c0e8' |
| 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.0030 | 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 < 1716113994 AND p.special_price_end > 1716113994) 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 < 1716113994 AND p.special_price_end > 1716113994) 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 (84)) AND c.active = 1 )
AND (p.qty > 0)
AND `p`.`product_id` NOT IN ('542')
AND `p`.`active` = 1
AND `p`.`is_delete` = 0
GROUP BY `collectionPointer`
HAVING `p`.`parent_product_id` = 0
ORDER BY RAND() |
| 0.0006 | 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 < 1716113994 AND p.special_price_end > 1716113994) 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 < 1716113994 AND p.special_price_end > 1716113994) 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 ('743', '2193', '758', '1772')
AND `p`.`active` = 1
AND `p`.`is_delete` = 0
GROUP BY `collectionPointer`
HAVING `p`.`parent_product_id` = 0 |
| 0.0010 | 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 < 1716113994 AND p.special_price_end > 1716113994) 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 < 1716113994 AND p.special_price_end > 1716113994) 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 ('743', '758', '1772', '2193')
GROUP BY `p`.`product_id` |
| 0.0127 | Total Query Execution Time |
