| 0.0003 |
SELECT `new_uri`
FROM `ak_redirect_301`
WHERE `signature` = 'ed20b26c168481d7fb65b4f6c589d2ac'
|
| 0.0002 |
SELECT `price_type`
FROM `ak_users`
WHERE `user_id` =0
|
| 0.0002 |
SELECT `item_id`, `menu_id`, `module`, `method`
FROM `ak_site_links`
WHERE `hash_ua` IN('ed20b26c168481d7fb65b4f6c589d2ac', 'ed20b26c168481d7fb65b4f6c589d2ac')
|
| 0.0002 |
SELECT `level`, `menu_index`, `position`, `main`, `url_path_id`, `name_ua` as `name`
FROM `ak_menu`
WHERE `id` = 7871371
|
| 0.0002 |
SELECT `component_id`, `hidden`, `module`, `method`, `config`
FROM `ak_components`
WHERE `menu_id` = 7871371
ORDER BY `position`
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `ak_menu`
JOIN `ak_components` ON `ak_components`.`menu_id` = `ak_menu`.`id`
WHERE `ak_menu`.`hidden` =0
AND `ak_menu`.`parent_id` = 7871371
AND `ak_components`.`module` = 'catalog'
AND `ak_components`.`hidden` =0
|
| 0.0005 |
SELECT `ak_catalog`.`component_id`, `ak_catalog_filters`.`filter_id`, `ak_catalog_filters`.`parent_id`, `ak_catalog_filters`.`name_ua` as `value_name`, `ak_catalog_filters`.`url` as `value_url`, `catalog_parent_filters`.`name_ua` as `filter_name`, `catalog_parent_filters`.`url` as `filter_url`, (select count(*) from `ak_catalog_info` as ci where ci.menu_id = 7871371 and ci.brand_id = 0 and ci.filter_id = `ak_catalog_product_bind_filters`.`filter_id`) as has_info
FROM `ak_catalog_product_bind_filters`
JOIN `ak_catalog` ON `ak_catalog`.`product_id` = `ak_catalog_product_bind_filters`.`product_id`
JOIN `ak_catalog_filters` ON `ak_catalog_filters`.`filter_id` = `ak_catalog_product_bind_filters`.`value_id`
JOIN `ak_catalog_filters` as `catalog_parent_filters` ON `catalog_parent_filters`.`filter_id` = `ak_catalog_filters`.`parent_id`
WHERE `ak_catalog`.`component_id` = '922'
AND `ak_catalog_filters`.`hidden` =0
GROUP BY `ak_catalog_product_bind_filters`.`filter_id`, `ak_catalog_product_bind_filters`.`value_id`
ORDER BY `catalog_parent_filters`.`position` ASC, `ak_catalog_filters`.`position` ASC
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `ak_catalog_product_bind_filters`
JOIN `ak_catalog_product_bind_components` ON `ak_catalog_product_bind_components`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
JOIN `ak_catalog` ON `ak_catalog`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
WHERE `ak_catalog_product_bind_filters`.`value_id` = '6'
AND `ak_catalog_product_bind_components`.`component_id` = '922'
AND `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `ak_catalog_product_bind_filters`
JOIN `ak_catalog_product_bind_components` ON `ak_catalog_product_bind_components`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
JOIN `ak_catalog` ON `ak_catalog`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
WHERE `ak_catalog_product_bind_filters`.`value_id` = '60'
AND `ak_catalog_product_bind_components`.`component_id` = '922'
AND `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `ak_catalog_product_bind_filters`
JOIN `ak_catalog_product_bind_components` ON `ak_catalog_product_bind_components`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
JOIN `ak_catalog` ON `ak_catalog`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
WHERE `ak_catalog_product_bind_filters`.`value_id` = '49'
AND `ak_catalog_product_bind_components`.`component_id` = '922'
AND `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `ak_catalog_product_bind_filters`
JOIN `ak_catalog_product_bind_components` ON `ak_catalog_product_bind_components`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
JOIN `ak_catalog` ON `ak_catalog`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
WHERE `ak_catalog_product_bind_filters`.`value_id` = '45'
AND `ak_catalog_product_bind_components`.`component_id` = '922'
AND `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `ak_catalog_product_bind_filters`
JOIN `ak_catalog_product_bind_components` ON `ak_catalog_product_bind_components`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
JOIN `ak_catalog` ON `ak_catalog`.`product_id`=`ak_catalog_product_bind_filters`.`product_id`
WHERE `ak_catalog_product_bind_filters`.`value_id` = '46'
AND `ak_catalog_product_bind_components`.`component_id` = '922'
AND `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
|
| 0.0004 |
SELECT MIN(ak_catalog.screen_price) AS `min`, MAX(ak_catalog.screen_price) AS `max`
FROM `ak_catalog`
JOIN `ak_menu` ON `ak_menu`.`id` = `ak_catalog`.`menu_id`
JOIN `ak_components` ON `ak_catalog`.`component_id` = `ak_components`.`component_id`
WHERE `ak_catalog`.`product_id` IN (select `product_id` from `ak_catalog_product_bind_components` where `component_id` IN(922))
AND `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
AND `ak_menu`.`hidden` =0
AND `ak_components`.`hidden` =0
|
| 0.0002 |
SELECT `main`, `target`, `name_ua` as `name`, `url_ua` as `url`, `static_url_ua` as `static_url`
FROM `ak_menu`
WHERE `id` = 7871371
AND `hidden` =0
|
| 0.0003 |
SELECT `ak_catalog`.`product_id`
FROM `ak_catalog`
JOIN `ak_menu` ON `ak_catalog`.`menu_id` = `ak_menu`.`id`
JOIN `ak_components` ON `ak_catalog`.`component_id` = `ak_components`.`component_id`
JOIN `ak_catalog_product_bind_components` ON `ak_catalog_product_bind_components`.`product_id` = `ak_catalog`.`product_id`
WHERE `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
AND `ak_menu`.`hidden` =0
AND `ak_components`.`hidden` =0
AND `ak_catalog_product_bind_components`.`component_id` = '922'
GROUP BY `ak_catalog`.`product_id`
|
| 0.0011 |
SELECT `ak_catalog`.`product_id`, `ak_catalog`.`availability`, `ak_catalog`.`status`, `ak_catalog`.`title_ua` as `title`, `ak_catalog`.`url_ua` as `url`, `ak_catalog`.`screen_price`, `ak_catalog`.`screen_price_old`, `ak_catalog`.`sign_ua` as `sign`, `ak_menu`.`url_path_ua` as `path_url`, (select `ak_catalog_images`.`image` from `ak_catalog_images` where `ak_catalog_images`.`product_id` = `ak_catalog`.`product_id` order by `ak_catalog_images`.`position` limit 1) as image, (select count(*) from `ak_catalog_product_bind_options` where `ak_catalog_product_bind_options`.`product_id` = `ak_catalog`.`product_id`) as product_options, (select count(*) from `ak_catalog_comments` where `ak_catalog_comments`.`product_id` = `ak_catalog`.`product_id`) as comments, (select sum(`ak_catalog_comments`.`stars`) from `ak_catalog_comments` where `ak_catalog_comments`.`product_id` = `ak_catalog`.`product_id`) as stars
FROM `ak_catalog`
JOIN `ak_menu` ON `ak_menu`.`id` = `ak_catalog`.`menu_id`
JOIN `ak_components` ON `ak_catalog`.`component_id` = `ak_components`.`component_id`
WHERE `ak_catalog`.`product_id` IN (select `product_id` from `ak_catalog_product_bind_components` where `component_id` IN (922))
AND `ak_catalog`.`hidden` =0
AND `ak_catalog`.`availability` != 2
AND `ak_menu`.`hidden` =0
AND `ak_components`.`hidden` =0
GROUP BY `ak_catalog`.`product_id`
ORDER BY `ak_catalog`.`product_id` DESC
LIMIT 15
|
| 0.0002 |
SELECT `main`, `target`, `name_ua` as `name`, `url_ua` as `url`, `static_url_ua` as `static_url`
FROM `ak_menu`
WHERE `id` = 7871371
AND `hidden` =0
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `ak_seo_tags`
WHERE `menu_id` = 7871371
AND `item_id` =0
|
| 0.0003 |
SELECT `type_ua` as `type`, `title_ua` as `title`, `description_ua` as `description`, `keywords_ua` as `keywords`, `cache_title_ua` as `cache_title`, `cache_description_ua` as `cache_description`, `cache_keywords_ua` as `cache_keywords`, `cache_ua` as `cache`
FROM `ak_seo_tags`
WHERE `menu_id` = 7871371
AND `item_id` =0
|
| 0.0001 |
SELECT `hide_items`
FROM `ak_seo_link`
WHERE `menu_id` = 7871371
|
| 0.0001 |
SELECT `hide_items`
FROM `ak_seo_link`
WHERE `menu_id` = 7871371
|
| 0.0003 |
SELECT `main`, `name_ua` as `name`, `url_ua` as `url`, `static_url_ua` as `static_url`
FROM `ak_menu`
WHERE `id` IN(7871332, 7871364, 7871371)
OR `main` = 1
ORDER BY `main` ASC, `level` DESC
|
| 0.0002 |
SELECT `main`, `target`, `name_ua` as `name`, `url_ua` as `url`, `static_url_ua` as `static_url`
FROM `ak_menu`
WHERE `id` = 7871371
AND `hidden` =0
|
| 0.0002 |
SELECT `main`, `target`, `name_ru` as `name`, `url_ru` as `url`, `static_url_ru` as `static_url`
FROM `ak_menu`
WHERE `id` = 7871371
AND `hidden` =0
|
| 0.0002 |
SELECT `main`, `target`, `name_ua` as `name`, `url_ua` as `url`, `static_url_ua` as `static_url`
FROM `ak_menu`
WHERE `id` = 7871371
AND `hidden` =0
|
| 0.0002 |
SELECT `main`, `target`, `name_ru` as `name`, `url_ru` as `url`, `static_url_ru` as `static_url`
FROM `ak_menu`
WHERE `id` = 7871371
AND `hidden` =0
|
Інтернет-магазин футбольної екіпіровки
