Queries list
Queries count !
Queries parse


SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev2.mpdev.finleo.ru' OR storefronts.url = 'www.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev2.mpdev.finleo.ru' DESC, storefronts.url = 'www.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%' desc 
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
SET time_zone = '+03:00'
SELECT url FROM cscart_bitrix
SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'oborudovanie-i-instrumenty'
SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'oborudovanie-i-instrumenty'
SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'professionalnoe-kliningovoe-oborudovanie'
SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'professionalnoe-kliningovoe-oborudovanie'
SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'polomoechnye-mashiny'
SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'polomoechnye-mashiny'
SELECT type FROM cscart_seo_names WHERE name = 'polomoechnye-mashiny' 
SELECT `hash` FROM `hash_filters` WHERE `link` = 'polomoechnye-mashiny'
SELECT `link`, `company_id` FROM `price_list` WHERE `link` = 'polomoechnye-mashiny'
SELECT * FROM cscart_seo_names WHERE name = 'polomoechnye-mashiny'  
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('oborudovanie-i-instrumenty', 'professionalnoe-kliningovoe-oborudovanie') AND type = 'c' AND lang_code = 'ru' 
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 343 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 293 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 298 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' 
SELECT localization_id, custom_weight_settings, weight_symbol, weight_unit FROM cscart_localizations WHERE status = 'A'
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
SELECT a.localization_id, a.status, b.localization, a.is_default FROM cscart_localizations AS a LEFT JOIN cscart_localization_descriptions AS b ON a.localization_id = b.localization_id AND b.lang_code = 'ru' LEFT JOIN cscart_localization_elements AS c ON a.localization_id = c.localization_id AND c.element_type = 'L' RIGHT JOIN cscart_languages AS d ON c.element = d.lang_code AND d.status = 'A'  WHERE a.status = 'A' ORDER BY localization
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'ru' AND storefront_id = 1
SELECT * FROM cscart_abt__ut2_less_settings WHERE style = 'Cobalt.less'
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 3
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ru'  LEFT JOIN cscart_tilda_locations ON l.location_id = cscart_tilda_locations.inner_location_id WHERE l.layout_id = 3  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(343, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
SELECT robots FROM cscart_category_descriptions WHERE category_id = 343
SELECT `timestamp` FROM `cscart_currencies` WHERE `currency_code` = 'USD'
SELECT category_id FROM cscart_categories WHERE category_id = 343  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'ru'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 343  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE cscart_categories.category_id = 343 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '343' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '343' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT id_path FROM cscart_categories WHERE category_id = 343
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_category_descriptions.products_count,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'ru'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (343) AND cscart_categories.id_path LIKE '293/298/343/%' AND cscart_categories.storefront_id IN (0, 1)   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
SELECT `L`.`location_id`, `LD`.`tilda_link` FROM cscart_bm_locations AS L
                     LEFT JOIN cscart_bm_locations_descriptions AS LD
                                            ON L.location_id = LD.location_id
                     WHERE `L`.`object_ids` LIKE '%343%' AND `LD`.`is_tilda_page` = 'Y'
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.tabs, cscart_banners.status, cscart_banners.timestamp, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.mini FROM cscart_banners  LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ru' LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ru'WHERE 1  AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.category_id = 343 AND cscart_banners.status = 'A' AND IF (cscart_banners.type not like 'abt__ut2', 'available', IF ( cscart_banners.type like 'abt__ut2' AND ( cscart_banners.abt__ut2_use_avail_period = 'N'
OR
(
cscart_banners.abt__ut2_use_avail_period = 'Y'
AND (cscart_banners.abt__ut2_avail_from = 0 OR cscart_banners.abt__ut2_avail_from <= 1745020837)
AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1745020837)
)
), 'available', 'not available') ) = 'available'  AND (cscart_banners.abt__ut2_usergroup_ids = '' OR FIND_IN_SET(0, cscart_banners.abt__ut2_usergroup_ids) OR FIND_IN_SET(1, cscart_banners.abt__ut2_usergroup_ids))  ORDER BY cscart_banner_descriptions.banner asc 
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IS NULL ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT * FROM faqs WHERE object_id = 343 AND object_type = 'category' ORDER BY `id` ASC

                SELECT * FROM `advantage`
                         WHERE `object_id` = 343
                           AND `object_type` = 'category'
                           AND `status` = 'A'
                         ORDER BY `pos` ASC
SELECT `c`.`category_id`, `d`.`category`, `d`.`products_count` 
                            FROM `cscart_categories` AS `c` 
                                LEFT JOIN `cscart_category_descriptions` AS `d` ON `c`.`category_id` = `d`.`category_id` 
                            WHERE `c`.`parent_id` = 343 AND `c`.`status` = 'A'
SELECT pc.product_id
                        FROM cscart_products_categories AS pc
                            WHERE pc.category_id IN (
                        SELECT c.category_id
                        FROM cscart_categories AS c
                            LEFT JOIN cscart_products AS p
                        ON p.product_id = pc.product_id
                        WHERE c.parent_id = 298
                            AND p.status = 'A'
                    )
SELECT DISTINCT `PF`.`filter_id`, `PF`.`feature_id`, `PD`.`range_input`, `PFD`.`description` FROM `cscart_product_filters` AS `PF` LEFT JOIN `cscart_product_filter_descriptions` AS `PD` ON `PD`.`filter_id` = `PF`.`filter_id` LEFT JOIN `cscart_product_features` AS `PFV` ON `PFV`.`feature_id` = `PF`.`feature_id` LEFT JOIN `cscart_product_features_descriptions` AS `PFD` ON `PFD`.`feature_id` = `PF`.`feature_id` WHERE FIND_IN_SET(343, `PF`.`categories_path`) AND `PFV`.`status` = 'A'
SELECT DISTINCT csc.* FROM cscart_product_stocks AS cps 
             JOIN  cscart_company_stocks AS ccs 
                 ON cps.stock_id = ccs.stock_id 
             JOIN cscart_custom_city AS csc
                 ON ccs.fias_id = csc.fias_id
                 ORDER BY csc.`position` ASC, csc.`city` ASC
SELECT brand_id FROM cscart_category_brands WHERE `category_id` = 343
SELECT a.category_id
                         FROM cscart_categories as a
                         LEFT JOIN cscart_categories as b
                         ON b.category_id IN (343)
                         WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
SELECT `B`.`brand_id`,`B`.`brand`,`B`.`status`,`BR`.`current_position`,COALESCE(F.path, "") AS image,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` AND `FI`.`object_type` = "brand" LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `brands_rating` AS `BR` ON `BR`.`brand_id` = `B`.`brand_id` AND `BR`.`category_id` = 343 AND `BR`.`current_position` > 0 LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `PC`.`category_id` IN (343) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY BR.current_position DESC,`B`.`brand` ASC 
SELECT a.category_id
                         FROM cscart_categories as a
                         LEFT JOIN cscart_categories as b
                         ON b.category_id IN (343)
                         WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
SELECT SQL_CALC_FOUND_ROWS `B`.`brand_id`,`B`.`brand`,`B`.`status`,F.path AS logo,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `FI`.`object_type` = "brand" AND `PC`.`category_id` IN (343) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY `B`.`brand` ASC LIMIT 0,20
SELECT FOUND_ROWS()
SELECT a.category_id
                         FROM cscart_categories as a
                         LEFT JOIN cscart_categories as b
                         ON b.category_id IN (343)
                         WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
SELECT SQL_CALC_FOUND_ROWS DISTINCT `C`.`services`,`C`.`category_id`,`CD`.`category`,`COM`.`company`,`CUR`.`price` AS `currency_rate`,IF(`HP`.`created_at`, MAX(`HP`.`created_at`), `P`.`timestamp`) AS `price_update_time`,`P`.`amount`,`P`.`city_id`,`P`.`brand_id`,`P`.`company_id`,`P`.`city_place`,`P`.`conditions`,`P`.`guarantee_id`,`P`.`type_of_sale`,`P`.`product_code`,`P`.`product_id`,`P`.`status`,`P`.`year`,`P`.`uniqueSale`,`P`.`is_confiscated`,`P`.`updated_timestamp`,`PC`.`category_id` AS `main_category`,`PD`.`full_description`,`PD`.`short_description`,`PD`.`leasingCount`,`PD`.`leasingPrice`,`PD`.`product`,`PP`.`currency`,`PP`.`discount_percent`,`PP`.`price`,`PP`.`recycling_price_rub`,((PP.price * COALESCE(CUR.price, 1)) * (1 - PP.discount_percent / 100) + PP.recycling_price_rub) AS total_price,CASE WHEN `GC`.`compare_id` IS NOT NULL THEN "Y" ELSE "N" END AS `compare`,CASE WHEN `GW`.`wishlist_id` IS NOT NULL THEN "Y" ELSE "N" END AS `wish`,IF(`CITY`.`city_id` IS NULL, 0, 1) as city_priority,CITY.address,(select count(*) from `cscart_product_stocks` where product_id = P.product_id) as stockCount,`B`.`brand`,`B`.`has_subsidy`,COALESCE(FILE.path, "") AS image,COALESCE(IMG.alt, "") AS image_alt FROM `cscart_products` AS `P` LEFT JOIN `cscart_guest__wishlist` AS `GW` ON `P`.`product_id` = `GW`.`product_id` AND `GW`.`guest_id` = 0 LEFT JOIN `cscart_guest__compare` AS `GC` ON `P`.`product_id` = `GC`.`product_id` AND `GC`.`guest_id` = 0 LEFT JOIN `cscart_product_stocks` AS `PST` ON `P`.`product_id` = `PST`.`product_id` LEFT JOIN `cscart_company_stocks` AS `CST` ON `PST`.`stock_id` = `CST`.`stock_id` LEFT JOIN `cscart_custom_city` AS `CITY` ON `CITY`.`fias_id` = `CST`.`fias_id` LEFT JOIN `cscart_product_prices_history` AS `HP` ON `HP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_products__images` AS `IMG` ON `P`.`product_id` = `IMG`.`product_id` LEFT JOIN `files` AS `FILE` ON `FILE`.`id` = `IMG`.`watermark_small_file_id` LEFT JOIN `cscart_companies` AS `COM` ON `COM`.`company_id` = `P`.`company_id` INNER JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' INNER JOIN `cscart_categories` AS `C` ON `C`.`category_id` = `PC`.`category_id` INNER JOIN `cscart_category_descriptions` AS `CD` ON `C`.`category_id` = `CD`.`category_id` LEFT JOIN `cscart_product_prices` AS `PP` ON `PP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_product_descriptions` AS `PD` ON `PD`.`product_id` = `P`.`product_id` AND `PD`.`lang_code` = 'ru' LEFT JOIN `cscart_currencies` AS `CUR` ON `PP`.`currency` = `CUR`.`currency_code` LEFT JOIN `cscart_brands` AS `B` ON `P`.`brand_id` = `B`.`brand_id` WHERE 1 AND `C`.`category_id` IN (343) AND `P`.`status` = 'A' AND `COM`.`status` = 'A' GROUP BY `P`.`product_id` ORDER BY city_priority DESC,sort_index DESC LIMIT 0, 11
SELECT FOUND_ROWS()
SELECT `F`.`path`, `PI`.`product_id`, `PI`.`alt` 
        FROM `cscart_products__images` AS `PI`
        LEFT JOIN `files` AS `F` 
            ON `PI`.`watermark_small_file_id` = `F`.`id`
        WHERE `PI`.`product_id` IN (NULL)
SELECT `category` FROM `cscart_category_descriptions` WHERE `category_id` = 343
SELECT city_id, city FROM `cscart_custom_city` WHERE `city_id` = '0'
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (293, 298) AND lang_code = 'ru'
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 554 AND c.company_id = 0
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 554
SELECT c.*, IF (c.location_id != 554, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 3 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (117, 118, 2215, 120) ORDER BY g.order, g.parent_id, g.grid_id ASC
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 343 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (2562, 2561, 2575, 2563, 2564, 2565, 2567, 2568, 2569, 2570, 2571, 816, 2572, 2573)  AND cscart_bm_blocks_descriptions.lang_code='ru'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'

Queries total time: 0.02204 s.
№	Query	Time	Actions
1	SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev2.mpdev.finleo.ru' OR storefronts.url = 'www.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev2.mpdev.finleo.ru' DESC, storefronts.url = 'www.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%' desc Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_redirect_to_regional_storefront()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Storefront\Repository::findByUrl()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1475 `Tygh\Storefront\Repository::find()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Storefront/Repository.php:125 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Storefront/Repository.php:361 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00028	Re-run Backtrace
2	`SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_http_params_by_storefront()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_allowed_for()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1631 `fn_get_storage_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:1120 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:1195 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00012	Re-run Backtrace
3	`SET time_zone = '+03:00'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_settings()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_init_time_zone()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1057 `db_query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1078 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:138	0.00031	Re-run Backtrace
4	`SELECT url FROM cscart_bitrix` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_addons()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_load_addon()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1134 `Tygh\Addons\AXmlScheme::loadAddon()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.addons.php:1561 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Addons/AXmlScheme.php:862 `db_get_field()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/bx24/config.php:5 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00025	Re-run Backtrace
5	`SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'oborudovanie-i-instrumenty'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Cities::getRouteCity()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:880 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Cities.php:269 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00085	Re-run Backtrace
6	SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'oborudovanie-i-instrumenty' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:897 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00095	Re-run Backtrace
7	`SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'professionalnoe-kliningovoe-oborudovanie'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Cities::getRouteCity()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:880 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Cities.php:269 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00049	Re-run Backtrace
8	SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'professionalnoe-kliningovoe-oborudovanie' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:897 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00087	Re-run Backtrace
9	`SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'polomoechnye-mashiny'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Cities::getRouteCity()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:880 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Cities.php:269 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00048	Re-run Backtrace
10	SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'polomoechnye-mashiny' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:897 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00092	Re-run Backtrace
11	`SELECT type FROM cscart_seo_names WHERE name = 'polomoechnye-mashiny'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `db_get_field()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:596 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00019	Re-run Backtrace
12	SELECT `hash` FROM `hash_filters` WHERE `link` = 'polomoechnye-mashiny' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:602 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00011	Re-run Backtrace
13	SELECT `link`, `company_id` FROM `price_list` WHERE `link` = 'polomoechnye-mashiny' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:613 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00008	Re-run Backtrace
14	`SELECT * FROM cscart_seo_names WHERE name = 'polomoechnye-mashiny'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `db_get_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:623 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00012	Re-run Backtrace
15	`SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages WHERE 1 AND cscart_languages.status = 'A'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_seo_validate_object()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:663 `Tygh\Languages\Languages::getSimpleLanguages()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1014 `db_get_hash_single_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Languages/Languages.php:517 `Tygh\Database\Connection::getSingleHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:599	0.00015	Re-run Backtrace
16	`SELECT object_id, name FROM cscart_seo_names WHERE name IN ('oborudovanie-i-instrumenty', 'professionalnoe-kliningovoe-oborudovanie') AND type = 'c' AND lang_code = 'ru'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_seo_validate_object()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:663 `fn_seo_validate_parents()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1034 `db_get_hash_single_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1069 `Tygh\Database\Connection::getSingleHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:599	0.00029	Re-run Backtrace
17	`SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_url()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:747 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.common.php:3927 `fn_seo_url_post()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_get_seo_settings()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1415 `Tygh\Application::offsetGet()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:2149 `Pimple\Container::offsetGet()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Application.php:135 `Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Storefront\Repository::findById()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Providers/StorefrontProvider.php:182 `Tygh\Storefront\Repository::find()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Storefront/Repository.php:164 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Storefront/Repository.php:364 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00017	Re-run Backtrace
18	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 343 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_url()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:747 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.common.php:3927 `fn_seo_url_post()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_seo_get_name()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1524 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1260 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00016	Re-run Backtrace
19	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 293 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_url()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:747 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.common.php:3927 `fn_seo_url_post()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_seo_get_parent_items_path()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1534 `fn_seo_get_name()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1120 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1260 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00014	Re-run Backtrace
20	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 298 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:965 `fn_seo_get_route()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_url()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:747 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.common.php:3927 `fn_seo_url_post()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_seo_get_parent_items_path()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1534 `fn_seo_get_name()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1120 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:1260 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00013	Re-run Backtrace
21	`SELECT localization_id, custom_weight_settings, weight_symbol, weight_unit FROM cscart_localizations WHERE status = 'A'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_localization()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `db_get_hash_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:843 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00011	Re-run Backtrace
22	`SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_layout()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\BlockManager\Layout::getDefault()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:673 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Layout.php:95 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00017	Re-run Backtrace
23	`SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_user()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_login_user()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:744 `fn_init_user()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.users.php:3413 `fn_is_expired_storage_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:776 `fn_get_storage_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:1213 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:1195 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00017	Re-run Backtrace
24	`SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_templater()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `Tygh\Development::isEnabled()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:124 `Tygh\Development::read()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Development.php:31 `fn_get_storage_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Development.php:84 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:1195 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00010	Re-run Backtrace
25	`SELECT a.localization_id, a.status, b.localization, a.is_default FROM cscart_localizations AS a LEFT JOIN cscart_localization_descriptions AS b ON a.localization_id = b.localization_id AND b.lang_code = 'ru' LEFT JOIN cscart_localization_elements AS c ON a.localization_id = c.localization_id AND c.element_type = 'L' RIGHT JOIN cscart_languages AS d ON c.element = d.lang_code AND d.status = 'A' WHERE a.status = 'A' ORDER BY localization` Backtrace `require()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:4 `fn_init()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/init.php:161 `fn_init_templater()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:1225 `fn_get_localizations()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.init.php:146 `db_get_hash_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.locations.php:597 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00034	Re-run Backtrace
26	`SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'ru' AND storefront_id = 1` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:419 `fn_abt__unitheme2_dispatch_assign_template()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_get_abt__ut2_settings()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:9 `db_get_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:117 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00016	Re-run Backtrace
27	`SELECT * FROM cscart_abt__ut2_less_settings WHERE style = 'Cobalt.less'` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:419 `fn_abt__unitheme2_dispatch_assign_template()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_get_abt__ut2_settings()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:10 `db_get_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:115 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00009	Re-run Backtrace
28	`SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 3` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\BlockManager\Location::instance()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/init.php:160 `Tygh\BlockManager\Layout::get()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Location.php:478 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Layout.php:62 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00012	Re-run Backtrace
29	`SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ru' LEFT JOIN cscart_tilda_locations ON l.location_id = cscart_tilda_locations.inner_location_id WHERE l.layout_id = 3 AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(343, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\BlockManager\Location::get()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/init.php:160 `Tygh\BlockManager\Location::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Location.php:166 `db_get_hash_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Location.php:106 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00058	Re-run Backtrace
30	`SELECT robots FROM cscart_category_descriptions WHERE category_id = 343` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `db_get_field()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/custom/controllers/frontend/categories.pre.php:15 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00018	Re-run Backtrace
31	SELECT `timestamp` FROM `cscart_currencies` WHERE `currency_code` = 'USD' Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Currency\Currency::checkAndUpdateCurrencyPrice()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:52 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Currency/Currency.php:105 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00016	Re-run Backtrace
32	`SELECT category_id FROM cscart_categories WHERE category_id = 343 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:73 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00017	Re-run Backtrace
33	`SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_category_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:88 `fn_set_hook()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:809 `fn_seo_get_category_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:122 `fn_get_seo_join_condition()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:2415 `fn_get_corrected_seo_lang_code()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:70 `fn_seo_get_default_storefront_lang_code()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:405 `Tygh\Storefront\Repository::findDefault()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/seo/func.php:424 `Tygh\Storefront\Repository::find()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Storefront/Repository.php:188 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Storefront/Repository.php:364 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00012	Re-run Backtrace
34	SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 343 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru' WHERE cscart_categories.category_id = 343 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_category_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:88 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:811 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00030	Re-run Backtrace
35	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '343' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '343' ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_category_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:88 `fn_get_image_pairs()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:829 `db_multi_query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.images.php:368 `Tygh\Database\Connection::multiQuery()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:168	0.00024	Re-run Backtrace
36	`SELECT id_path FROM cscart_categories WHERE category_id = 343` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_subcategories()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:101 `fn_get_categories()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:61 `db_get_field()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:353 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00011	Re-run Backtrace
37	SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_category_descriptions.products_count,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru' WHERE 1=1 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (343) AND cscart_categories.id_path LIKE '293/298/343/%' AND cscart_categories.storefront_id IN (0, 1) ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_subcategories()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:101 `fn_get_categories()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:61 `db_get_hash_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:438 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00029	Re-run Backtrace
38	SELECT `L`.`location_id`, `LD`.`tilda_link` FROM cscart_bm_locations AS L LEFT JOIN cscart_bm_locations_descriptions AS LD ON L.location_id = LD.location_id WHERE `L`.`object_ids` LIKE '%343%' AND `LD`.`is_tilda_page` = 'Y' Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:107 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00025	Re-run Backtrace
39	SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.tabs, cscart_banners.status, cscart_banners.timestamp, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.mini FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ru' LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ru'WHERE 1 AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.category_id = 343 AND cscart_banners.status = 'A' AND IF (cscart_banners.type not like 'abt__ut2', 'available', IF ( cscart_banners.type like 'abt__ut2' AND ( cscart_banners.abt__ut2_use_avail_period = 'N' OR ( cscart_banners.abt__ut2_use_avail_period = 'Y' AND (cscart_banners.abt__ut2_avail_from = 0 OR cscart_banners.abt__ut2_avail_from <= 1745020837) AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1745020837) ) ), 'available', 'not available') ) = 'available' AND (cscart_banners.abt__ut2_usergroup_ids = '' OR FIND_IN_SET(0, cscart_banners.abt__ut2_usergroup_ids) OR FIND_IN_SET(1, cscart_banners.abt__ut2_usergroup_ids)) ORDER BY cscart_banner_descriptions.banner asc Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_banners()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:118 `db_get_hash_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/banners/func.php:137 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00039	Re-run Backtrace
40	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IS NULL ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_banners()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:118 `fn_get_image_pairs()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/addons/banners/func.php:149 `db_multi_query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.images.php:368 `Tygh\Database\Connection::multiQuery()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:168	0.00016	Re-run Backtrace
41	SELECT * FROM faqs WHERE object_id = 343 AND object_type = 'category' ORDER BY `id` ASC Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Ui\Faqs::getFaqs()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:128 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Ui/Faqs.php:14 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00013	Re-run Backtrace
42	SELECT * FROM `advantage` WHERE `object_id` = 343 AND `object_type` = 'category' AND `status` = 'A' ORDER BY `pos` ASC Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:146 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00012	Re-run Backtrace
43	SELECT `c`.`category_id`, `d`.`category`, `d`.`products_count` FROM `cscart_categories` AS `c` LEFT JOIN `cscart_category_descriptions` AS `d` ON `c`.`category_id` = `d`.`category_id` WHERE `c`.`parent_id` = 343 AND `c`.`status` = 'A' Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Categories\Categories::getSubCategory()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:170 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Categories/Categories.php:128 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00014	Re-run Backtrace
44	`SELECT pc.product_id FROM cscart_products_categories AS pc WHERE pc.category_id IN ( SELECT c.category_id FROM cscart_categories AS c LEFT JOIN cscart_products AS p ON p.product_id = pc.product_id WHERE c.parent_id = 298 AND p.status = 'A' )` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Database\Connection::getColumn()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:173 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:499	0.00021	Re-run Backtrace
45	SELECT DISTINCT `PF`.`filter_id`, `PF`.`feature_id`, `PD`.`range_input`, `PFD`.`description` FROM `cscart_product_filters` AS `PF` LEFT JOIN `cscart_product_filter_descriptions` AS `PD` ON `PD`.`filter_id` = `PF`.`filter_id` LEFT JOIN `cscart_product_features` AS `PFV` ON `PFV`.`feature_id` = `PF`.`feature_id` LEFT JOIN `cscart_product_features_descriptions` AS `PFD` ON `PFD`.`feature_id` = `PF`.`feature_id` WHERE FIND_IN_SET(343, `PF`.`categories_path`) AND `PFV`.`status` = 'A' Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Categories\Categories::getFeaturesCategory()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:232 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Categories/Categories.php:245 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00040	Re-run Backtrace
46	SELECT DISTINCT csc.* FROM cscart_product_stocks AS cps JOIN cscart_company_stocks AS ccs ON cps.stock_id = ccs.stock_id JOIN cscart_custom_city AS csc ON ccs.fias_id = csc.fias_id ORDER BY csc.`position` ASC, csc.`city` ASC Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Cities::getActiveCity()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:254 `Tygh\Cities::getCityIdsInProducts()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Cities.php:184 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Cities.php:74 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00442	Re-run Backtrace
47	SELECT brand_id FROM cscart_category_brands WHERE `category_id` = 343 Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Database\Connection::getColumn()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:263 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:499	0.00013	Re-run Backtrace
48	`SELECT a.category_id FROM cscart_categories as a LEFT JOIN cscart_categories as b ON b.category_id IN (343) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Brands\ProductBrands::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:282 `Tygh\Database\Connection::getColumn()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Brands/ProductBrands.php:162 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:499	0.00022	Re-run Backtrace
49	SELECT `B`.`brand_id`,`B`.`brand`,`B`.`status`,`BR`.`current_position`,COALESCE(F.path, "") AS image,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` AND `FI`.`object_type` = "brand" LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `brands_rating` AS `BR` ON `BR`.`brand_id` = `B`.`brand_id` AND `BR`.`category_id` = 343 AND `BR`.`current_position` > 0 LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `PC`.`category_id` IN (343) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY BR.current_position DESC,`B`.`brand` ASC Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Brands\ProductBrands::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:282 `Tygh\Database\QueryBuilder::getResult()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Brands/ProductBrands.php:199 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/QueryBuilder.php:241 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00052	Re-run Backtrace
50	`SELECT a.category_id FROM cscart_categories as a LEFT JOIN cscart_categories as b ON b.category_id IN (343) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Brands\ProductBrands::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:310 `Tygh\Database\Connection::getColumn()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Brands/ProductBrands.php:162 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:499	0.00030	Re-run Backtrace
51	SELECT SQL_CALC_FOUND_ROWS `B`.`brand_id`,`B`.`brand`,`B`.`status`,F.path AS logo,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `FI`.`object_type` = "brand" AND `PC`.`category_id` IN (343) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY `B`.`brand` ASC LIMIT 0,20 Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Brands\ProductBrands::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:310 `Tygh\Database\QueryBuilder::getResult()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Brands/ProductBrands.php:197 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/QueryBuilder.php:241 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00028	Re-run Backtrace
52	`SELECT FOUND_ROWS()` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Brands\ProductBrands::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:310 `Tygh\Database\QueryBuilder::getResult()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Brands/ProductBrands.php:197 `Tygh\Database\Connection::getCalcRows()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/QueryBuilder.php:244 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:1812 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00006	Re-run Backtrace
53	`SELECT a.category_id FROM cscart_categories as a LEFT JOIN cscart_categories as b ON b.category_id IN (343) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Product::getProducts()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:368 `Tygh\Products\ProductCollections::getProducts()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Product.php:372 `Tygh\Products\ProductCollections::filterParams()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/ProductCollections.php:447 `Tygh\Database\Connection::getColumn()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/ProductCollections.php:206 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:499	0.00020	Re-run Backtrace
54	SELECT SQL_CALC_FOUND_ROWS DISTINCT `C`.`services`,`C`.`category_id`,`CD`.`category`,`COM`.`company`,`CUR`.`price` AS `currency_rate`,IF(`HP`.`created_at`, MAX(`HP`.`created_at`), `P`.`timestamp`) AS `price_update_time`,`P`.`amount`,`P`.`city_id`,`P`.`brand_id`,`P`.`company_id`,`P`.`city_place`,`P`.`conditions`,`P`.`guarantee_id`,`P`.`type_of_sale`,`P`.`product_code`,`P`.`product_id`,`P`.`status`,`P`.`year`,`P`.`uniqueSale`,`P`.`is_confiscated`,`P`.`updated_timestamp`,`PC`.`category_id` AS `main_category`,`PD`.`full_description`,`PD`.`short_description`,`PD`.`leasingCount`,`PD`.`leasingPrice`,`PD`.`product`,`PP`.`currency`,`PP`.`discount_percent`,`PP`.`price`,`PP`.`recycling_price_rub`,((PP.price * COALESCE(CUR.price, 1)) * (1 - PP.discount_percent / 100) + PP.recycling_price_rub) AS total_price,CASE WHEN `GC`.`compare_id` IS NOT NULL THEN "Y" ELSE "N" END AS `compare`,CASE WHEN `GW`.`wishlist_id` IS NOT NULL THEN "Y" ELSE "N" END AS `wish`,IF(`CITY`.`city_id` IS NULL, 0, 1) as city_priority,CITY.address,(select count(*) from `cscart_product_stocks` where product_id = P.product_id) as stockCount,`B`.`brand`,`B`.`has_subsidy`,COALESCE(FILE.path, "") AS image,COALESCE(IMG.alt, "") AS image_alt FROM `cscart_products` AS `P` LEFT JOIN `cscart_guest__wishlist` AS `GW` ON `P`.`product_id` = `GW`.`product_id` AND `GW`.`guest_id` = 0 LEFT JOIN `cscart_guest__compare` AS `GC` ON `P`.`product_id` = `GC`.`product_id` AND `GC`.`guest_id` = 0 LEFT JOIN `cscart_product_stocks` AS `PST` ON `P`.`product_id` = `PST`.`product_id` LEFT JOIN `cscart_company_stocks` AS `CST` ON `PST`.`stock_id` = `CST`.`stock_id` LEFT JOIN `cscart_custom_city` AS `CITY` ON `CITY`.`fias_id` = `CST`.`fias_id` LEFT JOIN `cscart_product_prices_history` AS `HP` ON `HP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_products__images` AS `IMG` ON `P`.`product_id` = `IMG`.`product_id` LEFT JOIN `files` AS `FILE` ON `FILE`.`id` = `IMG`.`watermark_small_file_id` LEFT JOIN `cscart_companies` AS `COM` ON `COM`.`company_id` = `P`.`company_id` INNER JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' INNER JOIN `cscart_categories` AS `C` ON `C`.`category_id` = `PC`.`category_id` INNER JOIN `cscart_category_descriptions` AS `CD` ON `C`.`category_id` = `CD`.`category_id` LEFT JOIN `cscart_product_prices` AS `PP` ON `PP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_product_descriptions` AS `PD` ON `PD`.`product_id` = `P`.`product_id` AND `PD`.`lang_code` = 'ru' LEFT JOIN `cscart_currencies` AS `CUR` ON `PP`.`currency` = `CUR`.`currency_code` LEFT JOIN `cscart_brands` AS `B` ON `P`.`brand_id` = `B`.`brand_id` WHERE 1 AND `C`.`category_id` IN (343) AND `P`.`status` = 'A' AND `COM`.`status` = 'A' GROUP BY `P`.`product_id` ORDER BY city_priority DESC,sort_index DESC LIMIT 0, 11 Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Product::getProducts()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:368 `Tygh\Products\ProductCollections::getProducts()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Product.php:372 `Tygh\Database\QueryBuilder::getResult()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/ProductCollections.php:483 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/QueryBuilder.php:241 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00084	Re-run Backtrace
55	`SELECT FOUND_ROWS()` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Products\Product::getProducts()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:368 `Tygh\Products\ProductCollections::getProducts()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/Product.php:372 `Tygh\Database\QueryBuilder::getResult()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Products/ProductCollections.php:483 `Tygh\Database\Connection::getCalcRows()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/QueryBuilder.php:244 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:1812 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00006	Re-run Backtrace
56	SELECT `F`.`path`, `PI`.`product_id`, `PI`.`alt` FROM `cscart_products__images` AS `PI` LEFT JOIN `files` AS `F` ON `PI`.`watermark_small_file_id` = `F`.`id` WHERE `PI`.`product_id` IN (NULL) Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_products_images()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:373 `Tygh\Database\Connection::getArray()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.products.php:4482 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:335	0.00011	Re-run Backtrace
57	SELECT `category` FROM `cscart_category_descriptions` WHERE `category_id` = 343 Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Seo\Seo::createSeoText()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:444 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Seo/Seo.php:175 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00010	Re-run Backtrace
58	SELECT city_id, city FROM `cscart_custom_city` WHERE `city_id` = '0' Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `Tygh\Seo\Seo::createSeoText()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:444 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Seo/Seo.php:196 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00008	Re-run Backtrace
59	`SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (293, 298) AND lang_code = 'ru'` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_run_controller()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:440 `require_once()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:744 `fn_get_category_name()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/controllers/frontend/categories.php:494 `db_get_hash_single_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.categories.php:909 `Tygh\Database\Connection::getSingleHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:599	0.00013	Re-run Backtrace
60	`SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `fn_check_permissions()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:497 `fn_check_admin_permissions()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.common.php:2531 `db_get_fields()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.common.php:2714 `Tygh\Database\Connection::getColumn()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:85 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:499	0.00010	Re-run Backtrace
61	`SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `Tygh\SmartyEngine\Core::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:611 `Smarty_Internal_TemplateBase::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_68007288aebd85_90521916()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `Smarty_Internal_Template::_subTemplateRender()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/var/cache/templates/abt__unitheme2/c2288a33f9179586098daefbdb1f1f40dc1d1577_2.tygh.index.tpl.php:100 `Smarty_Internal_Template::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 `Smarty_Template_Compiled::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_67ff21abd9d1a2_69887260()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_block_styles()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/var/cache/templates/abt__unitheme2/843f14e49535714a1b1da37f7b3e71c376abbba2_2.tygh.styles.tpl.php:259 `fn_get_storage_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/smarty_plugins/block.styles.php:126 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:1195 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00014	Re-run Backtrace
62	`SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 554 AND c.company_id = 0` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `Tygh\SmartyEngine\Core::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:611 `Smarty_Internal_TemplateBase::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_68007288aebd85_90521916()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/var/cache/templates/abt__unitheme2/c2288a33f9179586098daefbdb1f1f40dc1d1577_2.tygh.index.tpl.php:233 `Tygh\BlockManager\RenderManager::__construct()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/RenderManager.php:128 `Tygh\BlockManager\Container::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Container.php:113 `db_get_hash_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Container.php:73 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00020	Re-run Backtrace
63	`SELECT layout_id FROM cscart_bm_locations WHERE location_id = 554` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `Tygh\SmartyEngine\Core::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:611 `Smarty_Internal_TemplateBase::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_68007288aebd85_90521916()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/var/cache/templates/abt__unitheme2/c2288a33f9179586098daefbdb1f1f40dc1d1577_2.tygh.index.tpl.php:233 `Tygh\BlockManager\RenderManager::__construct()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/RenderManager.php:128 `Tygh\BlockManager\Container::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Container.php:114 `db_get_field()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Container.php:62 `Tygh\Database\Connection::getField()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:463	0.00008	Re-run Backtrace
64	SELECT c.*, IF (c.location_id != 554, 0, 1) as `default` FROM cscart_bm_containers as c INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 3 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0 Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `Tygh\SmartyEngine\Core::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:611 `Smarty_Internal_TemplateBase::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_68007288aebd85_90521916()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/var/cache/templates/abt__unitheme2/c2288a33f9179586098daefbdb1f1f40dc1d1577_2.tygh.index.tpl.php:233 `Tygh\BlockManager\RenderManager::__construct()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/RenderManager.php:128 `Tygh\BlockManager\Container::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Container.php:114 `db_get_hash_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Container.php:73 `Tygh\Database\Connection::getHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:377	0.00024	Re-run Backtrace
65	`SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (117, 118, 2215, 120) ORDER BY g.order, g.parent_id, g.grid_id ASC` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `Tygh\SmartyEngine\Core::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:611 `Smarty_Internal_TemplateBase::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_68007288aebd85_90521916()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/var/cache/templates/abt__unitheme2/c2288a33f9179586098daefbdb1f1f40dc1d1577_2.tygh.index.tpl.php:233 `Tygh\BlockManager\RenderManager::__construct()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Grid::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/RenderManager.php:133 `db_get_hash_multi_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Grid.php:62 `Tygh\Database\Connection::getMultiHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:549	0.00042	Re-run Backtrace
66	SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.,cscart_bm_blocks.,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 343 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (2562, 2561, 2575, 2563, 2564, 2565, 2567, 2568, 2569, 2570, 2571, 816, 2572, 2573) AND cscart_bm_blocks_descriptions.lang_code='ru' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `Tygh\SmartyEngine\Core::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:611 `Smarty_Internal_TemplateBase::fetch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_68007288aebd85_90521916()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/var/cache/templates/abt__unitheme2/c2288a33f9179586098daefbdb1f1f40dc1d1577_2.tygh.index.tpl.php:233 `Tygh\BlockManager\RenderManager::__construct()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Block::getList()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/RenderManager.php:137 `db_get_hash_multi_array()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/BlockManager/Block.php:251 `Tygh\Database\Connection::getMultiHash()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:549	0.00089	Re-run Backtrace
67	`SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'` Backtrace `fn_dispatch()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/index.php:7 `Tygh\Application::offsetGet()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:627 `Pimple\Container::offsetGet()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `fn_get_storage_data()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Providers/CommonProvider.php:77 `db_get_row()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.control.php:1195 `Tygh\Database\Connection::getRow()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /var/www/ildar/data/www/dev2.mpdev.finleo.ru/app/Tygh/Database/Connection.php:424	0.00026	Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 3
Query	Count	Min time	Max time	Average time
`SELECT a.category_id FROM cscart_categories as a LEFT JOIN cscart_categories as b ON b.category_id IN (343) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')`	3	0.00020	0.00030	0.00024
`SELECT FOUND_ROWS()`	2	0.00006	0.00006	0.00006
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev2.mpdev.finleo.ru' OR storefronts.url = 'www.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev2.mpdev.finleo.ru' DESC, storefronts.url = 'www.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%' desc	1	0.00028	0.00028	0.00028
`SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'`	1	0.00012	0.00012	0.00012
`SET time_zone = '+03:00'`	1	0.00031	0.00031	0.00031
`SELECT url FROM cscart_bitrix`	1	0.00025	0.00025	0.00025
`SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'oborudovanie-i-instrumenty'`	1	0.00085	0.00085	0.00085
SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'oborudovanie-i-instrumenty'	1	0.00095	0.00095	0.00095
`SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'professionalnoe-kliningovoe-oborudovanie'`	1	0.00049	0.00049	0.00049
SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'professionalnoe-kliningovoe-oborudovanie'	1	0.00087	0.00087	0.00087
`SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'polomoechnye-mashiny'`	1	0.00048	0.00048	0.00048
SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'polomoechnye-mashiny'	1	0.00092	0.00092	0.00092
`SELECT type FROM cscart_seo_names WHERE name = 'polomoechnye-mashiny'`	1	0.00019	0.00019	0.00019
SELECT `hash` FROM `hash_filters` WHERE `link` = 'polomoechnye-mashiny'	1	0.00011	0.00011	0.00011
SELECT `link`, `company_id` FROM `price_list` WHERE `link` = 'polomoechnye-mashiny'	1	0.00008	0.00008	0.00008
`SELECT * FROM cscart_seo_names WHERE name = 'polomoechnye-mashiny'`	1	0.00012	0.00012	0.00012
`SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages WHERE 1 AND cscart_languages.status = 'A'`	1	0.00015	0.00015	0.00015
`SELECT object_id, name FROM cscart_seo_names WHERE name IN ('oborudovanie-i-instrumenty', 'professionalnoe-kliningovoe-oborudovanie') AND type = 'c' AND lang_code = 'ru'`	1	0.00029	0.00029	0.00029
`SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc`	1	0.00017	0.00017	0.00017
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 343 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'	1	0.00016	0.00016	0.00016
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 293 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'	1	0.00014	0.00014	0.00014
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 298 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'	1	0.00013	0.00013	0.00013
`SELECT localization_id, custom_weight_settings, weight_symbol, weight_unit FROM cscart_localizations WHERE status = 'A'`	1	0.00011	0.00011	0.00011
`SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1`	1	0.00017	0.00017	0.00017
`SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'`	1	0.00017	0.00017	0.00017
`SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'`	1	0.00010	0.00010	0.00010
`SELECT a.localization_id, a.status, b.localization, a.is_default FROM cscart_localizations AS a LEFT JOIN cscart_localization_descriptions AS b ON a.localization_id = b.localization_id AND b.lang_code = 'ru' LEFT JOIN cscart_localization_elements AS c ON a.localization_id = c.localization_id AND c.element_type = 'L' RIGHT JOIN cscart_languages AS d ON c.element = d.lang_code AND d.status = 'A' WHERE a.status = 'A' ORDER BY localization`	1	0.00034	0.00034	0.00034
`SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'ru' AND storefront_id = 1`	1	0.00016	0.00016	0.00016
`SELECT * FROM cscart_abt__ut2_less_settings WHERE style = 'Cobalt.less'`	1	0.00009	0.00009	0.00009
`SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 3`	1	0.00012	0.00012	0.00012
`SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ru' LEFT JOIN cscart_tilda_locations ON l.location_id = cscart_tilda_locations.inner_location_id WHERE l.layout_id = 3 AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(343, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1`	1	0.00058	0.00058	0.00058
`SELECT robots FROM cscart_category_descriptions WHERE category_id = 343`	1	0.00018	0.00018	0.00018
SELECT `timestamp` FROM `cscart_currencies` WHERE `currency_code` = 'USD'	1	0.00016	0.00016	0.00016
`SELECT category_id FROM cscart_categories WHERE category_id = 343 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)`	1	0.00017	0.00017	0.00017
`SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc`	1	0.00012	0.00012	0.00012
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 343 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru' WHERE cscart_categories.category_id = 343 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))	1	0.00030	0.00030	0.00030
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '343' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '343' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00024	0.00024	0.00024
`SELECT id_path FROM cscart_categories WHERE category_id = 343`	1	0.00011	0.00011	0.00011
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_category_descriptions.products_count,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru' WHERE 1=1 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (343) AND cscart_categories.id_path LIKE '293/298/343/%' AND cscart_categories.storefront_id IN (0, 1) ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc	1	0.00029	0.00029	0.00029
SELECT `L`.`location_id`, `LD`.`tilda_link` FROM cscart_bm_locations AS L LEFT JOIN cscart_bm_locations_descriptions AS LD ON L.location_id = LD.location_id WHERE `L`.`object_ids` LIKE '%343%' AND `LD`.`is_tilda_page` = 'Y'	1	0.00025	0.00025	0.00025
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.tabs, cscart_banners.status, cscart_banners.timestamp, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.mini FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ru' LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ru'WHERE 1 AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.category_id = 343 AND cscart_banners.status = 'A' AND IF (cscart_banners.type not like 'abt__ut2', 'available', IF ( cscart_banners.type like 'abt__ut2' AND ( cscart_banners.abt__ut2_use_avail_period = 'N' OR ( cscart_banners.abt__ut2_use_avail_period = 'Y' AND (cscart_banners.abt__ut2_avail_from = 0 OR cscart_banners.abt__ut2_avail_from <= 1745020837) AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1745020837) ) ), 'available', 'not available') ) = 'available' AND (cscart_banners.abt__ut2_usergroup_ids = '' OR FIND_IN_SET(0, cscart_banners.abt__ut2_usergroup_ids) OR FIND_IN_SET(1, cscart_banners.abt__ut2_usergroup_ids)) ORDER BY cscart_banner_descriptions.banner asc	1	0.00039	0.00039	0.00039
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ru' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IS NULL ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00016	0.00016	0.00016
SELECT * FROM faqs WHERE object_id = 343 AND object_type = 'category' ORDER BY `id` ASC	1	0.00013	0.00013	0.00013
SELECT * FROM `advantage` WHERE `object_id` = 343 AND `object_type` = 'category' AND `status` = 'A' ORDER BY `pos` ASC	1	0.00012	0.00012	0.00012
SELECT `c`.`category_id`, `d`.`category`, `d`.`products_count` FROM `cscart_categories` AS `c` LEFT JOIN `cscart_category_descriptions` AS `d` ON `c`.`category_id` = `d`.`category_id` WHERE `c`.`parent_id` = 343 AND `c`.`status` = 'A'	1	0.00014	0.00014	0.00014
`SELECT pc.product_id FROM cscart_products_categories AS pc WHERE pc.category_id IN ( SELECT c.category_id FROM cscart_categories AS c LEFT JOIN cscart_products AS p ON p.product_id = pc.product_id WHERE c.parent_id = 298 AND p.status = 'A' )`	1	0.00021	0.00021	0.00021
SELECT DISTINCT `PF`.`filter_id`, `PF`.`feature_id`, `PD`.`range_input`, `PFD`.`description` FROM `cscart_product_filters` AS `PF` LEFT JOIN `cscart_product_filter_descriptions` AS `PD` ON `PD`.`filter_id` = `PF`.`filter_id` LEFT JOIN `cscart_product_features` AS `PFV` ON `PFV`.`feature_id` = `PF`.`feature_id` LEFT JOIN `cscart_product_features_descriptions` AS `PFD` ON `PFD`.`feature_id` = `PF`.`feature_id` WHERE FIND_IN_SET(343, `PF`.`categories_path`) AND `PFV`.`status` = 'A'	1	0.00040	0.00040	0.00040
SELECT DISTINCT csc.* FROM cscart_product_stocks AS cps JOIN cscart_company_stocks AS ccs ON cps.stock_id = ccs.stock_id JOIN cscart_custom_city AS csc ON ccs.fias_id = csc.fias_id ORDER BY csc.`position` ASC, csc.`city` ASC	1	0.00442	0.00442	0.00442
SELECT brand_id FROM cscart_category_brands WHERE `category_id` = 343	1	0.00013	0.00013	0.00013
SELECT `B`.`brand_id`,`B`.`brand`,`B`.`status`,`BR`.`current_position`,COALESCE(F.path, "") AS image,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` AND `FI`.`object_type` = "brand" LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `brands_rating` AS `BR` ON `BR`.`brand_id` = `B`.`brand_id` AND `BR`.`category_id` = 343 AND `BR`.`current_position` > 0 LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `PC`.`category_id` IN (343) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY BR.current_position DESC,`B`.`brand` ASC	1	0.00052	0.00052	0.00052
SELECT SQL_CALC_FOUND_ROWS `B`.`brand_id`,`B`.`brand`,`B`.`status`,F.path AS logo,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `FI`.`object_type` = "brand" AND `PC`.`category_id` IN (343) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY `B`.`brand` ASC LIMIT 0,20	1	0.00028	0.00028	0.00028
SELECT SQL_CALC_FOUND_ROWS DISTINCT `C`.`services`,`C`.`category_id`,`CD`.`category`,`COM`.`company`,`CUR`.`price` AS `currency_rate`,IF(`HP`.`created_at`, MAX(`HP`.`created_at`), `P`.`timestamp`) AS `price_update_time`,`P`.`amount`,`P`.`city_id`,`P`.`brand_id`,`P`.`company_id`,`P`.`city_place`,`P`.`conditions`,`P`.`guarantee_id`,`P`.`type_of_sale`,`P`.`product_code`,`P`.`product_id`,`P`.`status`,`P`.`year`,`P`.`uniqueSale`,`P`.`is_confiscated`,`P`.`updated_timestamp`,`PC`.`category_id` AS `main_category`,`PD`.`full_description`,`PD`.`short_description`,`PD`.`leasingCount`,`PD`.`leasingPrice`,`PD`.`product`,`PP`.`currency`,`PP`.`discount_percent`,`PP`.`price`,`PP`.`recycling_price_rub`,((PP.price * COALESCE(CUR.price, 1)) * (1 - PP.discount_percent / 100) + PP.recycling_price_rub) AS total_price,CASE WHEN `GC`.`compare_id` IS NOT NULL THEN "Y" ELSE "N" END AS `compare`,CASE WHEN `GW`.`wishlist_id` IS NOT NULL THEN "Y" ELSE "N" END AS `wish`,IF(`CITY`.`city_id` IS NULL, 0, 1) as city_priority,CITY.address,(select count(*) from `cscart_product_stocks` where product_id = P.product_id) as stockCount,`B`.`brand`,`B`.`has_subsidy`,COALESCE(FILE.path, "") AS image,COALESCE(IMG.alt, "") AS image_alt FROM `cscart_products` AS `P` LEFT JOIN `cscart_guest__wishlist` AS `GW` ON `P`.`product_id` = `GW`.`product_id` AND `GW`.`guest_id` = 0 LEFT JOIN `cscart_guest__compare` AS `GC` ON `P`.`product_id` = `GC`.`product_id` AND `GC`.`guest_id` = 0 LEFT JOIN `cscart_product_stocks` AS `PST` ON `P`.`product_id` = `PST`.`product_id` LEFT JOIN `cscart_company_stocks` AS `CST` ON `PST`.`stock_id` = `CST`.`stock_id` LEFT JOIN `cscart_custom_city` AS `CITY` ON `CITY`.`fias_id` = `CST`.`fias_id` LEFT JOIN `cscart_product_prices_history` AS `HP` ON `HP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_products__images` AS `IMG` ON `P`.`product_id` = `IMG`.`product_id` LEFT JOIN `files` AS `FILE` ON `FILE`.`id` = `IMG`.`watermark_small_file_id` LEFT JOIN `cscart_companies` AS `COM` ON `COM`.`company_id` = `P`.`company_id` INNER JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' INNER JOIN `cscart_categories` AS `C` ON `C`.`category_id` = `PC`.`category_id` INNER JOIN `cscart_category_descriptions` AS `CD` ON `C`.`category_id` = `CD`.`category_id` LEFT JOIN `cscart_product_prices` AS `PP` ON `PP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_product_descriptions` AS `PD` ON `PD`.`product_id` = `P`.`product_id` AND `PD`.`lang_code` = 'ru' LEFT JOIN `cscart_currencies` AS `CUR` ON `PP`.`currency` = `CUR`.`currency_code` LEFT JOIN `cscart_brands` AS `B` ON `P`.`brand_id` = `B`.`brand_id` WHERE 1 AND `C`.`category_id` IN (343) AND `P`.`status` = 'A' AND `COM`.`status` = 'A' GROUP BY `P`.`product_id` ORDER BY city_priority DESC,sort_index DESC LIMIT 0, 11	1	0.00084	0.00084	0.00084
SELECT `F`.`path`, `PI`.`product_id`, `PI`.`alt` FROM `cscart_products__images` AS `PI` LEFT JOIN `files` AS `F` ON `PI`.`watermark_small_file_id` = `F`.`id` WHERE `PI`.`product_id` IN (NULL)	1	0.00011	0.00011	0.00011
SELECT `category` FROM `cscart_category_descriptions` WHERE `category_id` = 343	1	0.00010	0.00010	0.00010
SELECT city_id, city FROM `cscart_custom_city` WHERE `city_id` = '0'	1	0.00008	0.00008	0.00008
`SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (293, 298) AND lang_code = 'ru'`	1	0.00013	0.00013	0.00013
`SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)`	1	0.00010	0.00010	0.00010
`SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'`	1	0.00014	0.00014	0.00014
`SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 554 AND c.company_id = 0`	1	0.00020	0.00020	0.00020
`SELECT layout_id FROM cscart_bm_locations WHERE location_id = 554`	1	0.00008	0.00008	0.00008
SELECT c.*, IF (c.location_id != 554, 0, 1) as `default` FROM cscart_bm_containers as c INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 3 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0	1	0.00024	0.00024	0.00024
`SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (117, 118, 2215, 120) ORDER BY g.order, g.parent_id, g.grid_id ASC`	1	0.00042	0.00042	0.00042
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.,cscart_bm_blocks.,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 343 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (2562, 2561, 2575, 2563, 2564, 2565, 2567, 2568, 2569, 2570, 2571, 816, 2572, 2573) AND cscart_bm_blocks_descriptions.lang_code='ru' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id	1	0.00089	0.00089	0.00089
`SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'`	1	0.00026	0.00026	0.00026


	Sandbox

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace