Фильтр товаров

Цена

No choice available on this group

Размер

No choice available on this group

Цвет

No choice available on this group

Бренд

No choice available on this group

Материал

No choice available on this group

Стиль

No choice available on this group

Сезон

No choice available on this group

Скидка

Нет снижения цен.

Load time: 1218 ms
You'd better run your shop on a toaster
ExecutionLoad time (ms)
config980
constructor0
init31
checkAccess0
setMedia9
postProcess0
initHeader0
initContent141
initFooter6
display50
Hook processing: 188 ms / 16.31 Mb
54 methods called in 33 modules
HookProcessing
displayHeader6.45 Mb in 64 ms
displayLeftColumn2.33 Mb in 47 ms
moduleRoutes5.08 Mb in 38 ms
displayTop1.49 Mb in 23 ms
actionFrontControllerSetMedia0.45 Mb in 6 ms
displayFooter0.43 Mb in 6 ms
displayNav0.05 Mb in 2 ms
displayBanner0.03 Mb in 1 ms
DisplayOverrideTemplate0.00 Mb in 0 ms
actionDispatcher0.00 Mb in 0 ms
displayTopColumn0.00 Mb in 0 ms
Memory peak usage: 30.1 Mb
ExecutionMemory (Mb)Total (Mb)
config13.2313.3
constructor0.0013.3
init3.4816.8
checkAccess0.0016.8
setMedia0.6718.1
postProcess0.0018.1
initHeader0.0118.1
initContent10.8328.4
initFooter0.4429.1
display0.5430.1
Total cache size (in Cache class): 0.00 Mb
DB type: DbPDO
SQL Queries: 67 queries
Time spent querying: 32 ms
Included files: 235
Size of included files: 3.86 Mb
Globals (> 1 Ko only): 1091 Ko
  • _MODULES ≈ 692.8 Ko
  • _LANG ≈ 209.9 Ko
  • context ≈ 164.8 Ko
  • _MODULE ≈ 10 Ko
  • _SERVER ≈ 9.5 Ko
Stopwatch (with SQL_NO_CACHE) (total = 67)
Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.409984YesYesin /home/a0341107/domains/apavi.ru/public_html/classes/Hook.php:346

from /classes/tools/profiling/Hook.php:50
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1.872619in /home/a0341107/domains/apavi.ru/public_html/classes/Configuration.php:134

from /config/config.inc.php:116
from /index.php:28
SELECT SQL_NO_CACHE acp.id_product, (app.is_specific + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`), 1, 0) +  IF (app.`id_country` IN (0, 177), 4, 0) +  IF (app.`id_currency` IN (0, 1), 8, 0) +  IF (app.`id_shop` IN (0, 1), 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_5` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 177 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 177)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` - 
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
* IF(grc.`reduction` > 0, 1 - grc.`reduction`, 1) ASC LIMIT 1
1.8030in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:46

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:70
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1281
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1330
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook` h
INNER JOIN `ps_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
INNER JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.594293in /home/a0341107/domains/apavi.ru/public_html/classes/Hook.php:228

from /classes/Hook.php:266
from /classes/tax/TaxManagerFactory.php:67
from /classes/tax/TaxManagerFactory.php:47
from /classes/tax/Tax.php:262
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1350
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`,
MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,
DATEDIFF(
p.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa ON (pa.id_product = p.id_product)
LEFT JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.default_on=1)
LEFT 
JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND p.`visibility` IN ("both", "catalog")
AND p.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1
)
GROUP BY product_shop.id_product
ORDER BY p.date_upd desc
LIMIT 0, 12
1.2160in /home/a0341107/domains/apavi.ru/public_html/classes/Product.php:2341

from /controllers/front/PricesDropController.php:49
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.0210in /home/a0341107/domains/apavi.ru/public_html/classes/Hook.php:131

from /classes/Hook.php:417
from /classes/tools/profiling/Hook.php:60
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.01312Yesin /home/a0341107/domains/apavi.ru/public_html/classes/Country.php:136

from /modules/scheckout/scheckout.php:775
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:787
from /controllers/front/PricesDropController.php:33
from /classes/tools/profiling/Controller.php:207
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.938312Yesin /home/a0341107/domains/apavi.ru/public_html/classes/Country.php:136

from /modules/scheckout/scheckout.php:712
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_5` ac
JOIN `ps_pm_advancedsearch_criterion_5_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_5_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_5_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_5` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 18
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
0.9080in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1057
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3037
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1
LIMIT 1
0.861in /home/a0341107/domains/apavi.ru/public_html/classes/Language.php:819

from /classes/Language.php:918
from /classes/Dispatcher.php:397
from /override/classes/Dispatcher.php:405
from /classes/Dispatcher.php:221
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.74143Yesin /home/a0341107/domains/apavi.ru/public_html/classes/Dispatcher.php:461

from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_5` ac
JOIN `ps_pm_advancedsearch_criterion_5_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_5_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_5_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_5` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 6
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
0.7210in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1057
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3037
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE app.price_wt as max_price, app.`reduction_amount`, app.`reduction_type`, app.`reduction_tax`, acp.id_product, app.id_currency, app.id_country, (app.is_specific + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`), 1, 0) +  IF (app.`id_group` = 1, 2, 0) +  IF (app.`id_country` = 177, 4, 0) +  IF (app.`id_currency` = 1, 8, 0) +  IF (app.`id_shop` = 1, 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_5` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 177 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE acp.`id_product` = 0 AND  ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 177)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` - 
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
DESC LIMIT 1
0.7160in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:46

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:70
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1391
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
0.715244Yesin /home/a0341107/domains/apavi.ru/public_html/classes/Country.php:130

from /modules/scheckout/scheckout.php:775
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:787
from /controllers/front/PricesDropController.php:33
from /classes/tools/profiling/Controller.php:207
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE acp.id_product, (app.is_specific + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`), 1, 0) +  IF (app.`id_country` IN (0, 177), 4, 0) +  IF (app.`id_currency` IN (0, 1), 8, 0) +  IF (app.`id_shop` IN (0, 1), 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_5` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 177 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 177)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` - 
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
* IF(grc.`reduction` > 0, 1 - grc.`reduction`, 1) DESC LIMIT 1
0.7010in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:46

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:70
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1312
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1377
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
0.668244Yesin /home/a0341107/domains/apavi.ru/public_html/classes/Country.php:130

from /modules/scheckout/scheckout.php:712
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.66582in /home/a0341107/domains/apavi.ru/public_html/classes/module/Module.php:217

from /modules/pm_advancedsearch4/AdvancedSearchCoreClass.php:47
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:131
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /classes/tools/profiling/Hook.php:60
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE app.price_wt as min_price, app.`reduction_amount`, app.`reduction_type`, app.`reduction_tax`, app.id_currency, acp.id_product, app.id_country, (app.is_specific + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`), 1, 0) +  IF (app.`id_group` = 1, 2, 0) +  IF (app.`id_country` = 177, 4, 0) +  IF (app.`id_currency` = 1, 8, 0) +  IF (app.`id_shop` = 1, 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_5` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 177 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE acp.`id_product` = 0 AND  ((app.`from` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-05-27 17:29:47' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 177)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` - 
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
ASC LIMIT 1
0.6220in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:46

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:70
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1349
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_5` ac
JOIN `ps_pm_advancedsearch_criterion_5_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_5_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_5_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_5` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 5
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
0.580in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1057
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3037
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'apavi.ru' OR su.domain_ssl = 'apavi.ru')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.5771Yesin /home/a0341107/domains/apavi.ru/public_html/classes/shop/Shop.php:329

from /config/config.inc.php:97
from /index.php:28
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_5` ac
JOIN `ps_pm_advancedsearch_criterion_5_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_5_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_5_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_5` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 8
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
0.5670in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1057
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3037
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.5291Yesin /home/a0341107/domains/apavi.ru/public_html/classes/shop/Shop.php:639

from /classes/shop/Shop.php:789
from /classes/shop/Shop.php:936
from /modules/sekeywords/sekeywords.php:49
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_5` ac
JOIN `ps_pm_advancedsearch_criterion_5_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_5_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_5_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_5` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_5` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.`id_product` IN (
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.`id_product` IN (0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` AND cg.`id_group` = 1
)) AND 
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 15
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
0.5210in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1057
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3037
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE acg.*, acgl.*
FROM `ps_pm_advancedsearch_criterion_group_5` acg
LEFT JOIN `ps_pm_advancedsearch_criterion_group_5_lang` acgl ON (acg.`id_criterion_group` = acgl.`id_criterion_group` AND acgl.`id_lang` = 1 )
WHERE acg.`id_search` = 5
ORDER BY `position`
0.4698Yesin /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/AdvancedSearchCriterionGroupClass.php:230
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2795
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.4661Yesin /home/a0341107/domains/apavi.ru/public_html/classes/Currency.php:220

from /classes/controller/FrontController.php:342
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1  LIMIT 1
0.4222in /home/a0341107/domains/apavi.ru/public_html/classes/Meta.php:142

from /classes/Meta.php:225
from /classes/Meta.php:212
from /classes/controller/FrontController.php:290
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE COUNT(DISTINCT p.`id_product`)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND p.`id_product` IN(0)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1
) LIMIT 1
0.4170in /home/a0341107/domains/apavi.ru/public_html/classes/Product.php:2297

from /controllers/front/PricesDropController.php:46
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `name` ASC
0.4099Yesin /home/a0341107/domains/apavi.ru/public_html/classes/ImageType.php:101

from /modules/prestaspeed/prestaspeed.php:71
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE GROUP_CONCAT(`id_criterion_group`) AS `id_criterion_group_list`
FROM `ps_pm_advancedsearch_criterion_group_5`
WHERE `criterion_group_type` = "category" AND `only_children` = 1 LIMIT 1
0.3299in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:46

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:70
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1732
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:987
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3037
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3251in /home/a0341107/domains/apavi.ru/public_html/classes/Language.php:712

from /config/config.inc.php:122
from /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1
LIMIT 1
0.3241in /home/a0341107/domains/apavi.ru/public_html/classes/Currency.php:444

from /classes/Currency.php:450
from /classes/module/Module.php:2008
from /modules/blocksearch/blocksearch.php:105
from /classes/Hook.php:509
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "prices-drop" LIMIT 1
0.321in /home/a0341107/domains/apavi.ru/public_html/classes/Theme.php:181

from /classes/controller/FrontController.php:78
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:366
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1
WHERE (a.id_group = 1)
LIMIT 1
0.2951in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:217

from /classes/tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search`
FROM `ps_pm_advancedsearch` ads
JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1)  WHERE 1  AND ads.`active`=1  ORDER BY ads.`position`
0.2871in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:327
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:306
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:159
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3386
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3463
from /classes/Hook.php:509
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.28586in /home/a0341107/domains/apavi.ru/public_html/classes/Hook.php:183

from /classes/Hook.php:202
from /classes/Hook.php:373
from /classes/tools/profiling/Hook.php:50
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE ads.* , adsl.*, ads.`id_search`
FROM `ps_pm_advancedsearch` ads
LEFT JOIN `ps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 1 )
WHERE ads.`id_search` IN (5)
ORDER BY ads.`position`
0.2821in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:275
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:265
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.287in /home/a0341107/domains/apavi.ru/public_html/classes/module/Module.php:1889

from /classes/Hook.php:469
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:787
from /controllers/front/PricesDropController.php:33
from /classes/tools/profiling/Controller.php:207
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_tax_rule`
WHERE `id_country` = 177
AND `id_tax_rules_group` = 0
AND `id_state` IN (0, 0)
AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0')))
ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
0.2731Yesin /home/a0341107/domains/apavi.ru/public_html/classes/tax/TaxRulesTaxManager.php:90

from /classes/tax/Tax.php:263
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1350
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1
WHERE (a.id_lang = 1)
LIMIT 1
0.2611in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:217

from /classes/tools/profiling/ObjectModel.php:37
from /classes/Language.php:90
from /config/config.inc.php:177
from /index.php:28
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.2561in /home/a0341107/domains/apavi.ru/public_html/classes/shop/ShopUrl.php:163

from /classes/shop/ShopUrl.php:177
from /classes/Tools.php:200
from /classes/Link.php:52
from /config/config.inc.php:214
from /index.php:28
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.2471in /home/a0341107/domains/apavi.ru/public_html/classes/shop/Shop.php:199

from /classes/shop/Shop.php:133
from /classes/shop/Shop.php:372
from /config/config.inc.php:97
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1
WHERE (a.id_currency = 1)
LIMIT 1
0.2441in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:217

from /classes/tools/profiling/ObjectModel.php:37
from /classes/Currency.php:103
from /classes/Currency.php:430
from /classes/Tools.php:433
from /classes/controller/FrontController.php:182
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 0 AND `id_group` = 1 LIMIT 1
0.2280in /home/a0341107/domains/apavi.ru/public_html/classes/GroupReduction.php:142

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1248
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1376
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1
LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1
WHERE (a.id_country = 177)
LIMIT 1
0.2281in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:217

from /classes/tools/profiling/ObjectModel.php:37
from /config/config.inc.php:125
from /index.php:28
SELECT SQL_NO_CACHE `id_attribute_group` FROM `ps_attribute_group` WHERE `is_color_group`=1
0.2269in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineIndexation.php:1463
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2833
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_module_currency`
WHERE `id_module` = 104
AND `id_shop` = 1
0.2091in /home/a0341107/domains/apavi.ru/public_html/classes/Currency.php:278

from /modules/yandexmodule/yandexmodule.php:108
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /classes/tools/profiling/Hook.php:60
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.id_shop_group = 1)
LIMIT 1
0.2061in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:217

from /classes/tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:500
from /config/config.inc.php:148
from /index.php:28
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "yandexmodule" LIMIT 1
0.2031in /home/a0341107/domains/apavi.ru/public_html/classes/module/Module.php:2229

from /classes/module/Module.php:1929
from /override/classes/Dispatcher.php:406
from /classes/Dispatcher.php:221
from /classes/Dispatcher.php:193
from /index.php:29
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'home_default-bootstrap' LIMIT 1
0.1991in /home/a0341107/domains/apavi.ru/public_html/classes/ImageType.php:141

from /classes/ImageType.php:154
from /controllers/front/PricesDropController.php:56
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.id_shop = 1)
LIMIT 1
0.1951in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:217

from /classes/tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:131
from /classes/shop/Shop.php:372
from /config/config.inc.php:97
from /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_group_lang`
WHERE `id_group` = 1
0.1872in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:224

from /classes/tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_category FROM `ps_pm_advancedsearch_category` WHERE id_search=5
0.1830in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:79
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:138
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:192
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang` 
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.1811Yesin /home/a0341107/domains/apavi.ru/public_html/classes/Language.php:656

from /classes/Tools.php:358
from /classes/controller/FrontController.php:160
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.1741in /home/a0341107/domains/apavi.ru/public_html/classes/Group.php:132

from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:527
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1265
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1330
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.1641in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:1259

from /classes/Tools.php:346
from /classes/controller/FrontController.php:160
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default'
LIMIT 1
0.1621in /home/a0341107/domains/apavi.ru/public_html/classes/Image.php:377

from /controllers/front/PricesDropController.php:56
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.id_theme = 1)
LIMIT 1
0.1441in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:217

from /classes/tools/profiling/ObjectModel.php:37
from /config/config.inc.php:98
from /index.php:28
SELECT SQL_NO_CACHE id_category FROM `ps_pm_advancedsearch_products_cat` WHERE id_search=5
0.1331in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:79
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:139
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:192
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'default-bootstrap_home' LIMIT 1
0.1271in /home/a0341107/domains/apavi.ru/public_html/classes/ImageType.php:141

from /classes/ImageType.php:156
from /controllers/front/PricesDropController.php:56
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.1231in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:1259

from /classes/Group.php:314
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 0 AND id_shop=1 LIMIT 1
0.1220in /home/a0341107/domains/apavi.ru/public_html/classes/Product.php:4562

from /classes/tax/Tax.php:260
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:1350
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:2915
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3372
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_manufacturer FROM `ps_pm_advancedsearch_manufacturers` WHERE id_search=5
0.1140in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:79
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:142
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:192
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.1121in /home/a0341107/domains/apavi.ru/public_html/classes/ObjectModel.php:1259

from /classes/Tools.php:436
from /classes/controller/FrontController.php:182
from /classes/tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_cms FROM `ps_pm_advancedsearch_cms` WHERE id_search=5
0.0870in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:79
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:140
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:192
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_supplier FROM `ps_pm_advancedsearch_suppliers` WHERE id_search=5
0.0850in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:79
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:141
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:192
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE id_product FROM `ps_pm_advancedsearch_products` WHERE id_search=5
0.0830in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:79
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:143
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:192
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
SELECT SQL_NO_CACHE page FROM `ps_pm_advancedsearch_special_pages` WHERE id_search=5
0.0770in /home/a0341107/domains/apavi.ru/public_html/modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:44

from /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:79
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:144
from /modules/pm_advancedsearch4/classes/As4SearchEngine.php:192
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3358
from /modules/pm_advancedsearch4/pm_advancedsearch4.php:3548
from /classes/Hook.php:507
from /classes/tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/PricesDropController.php:43
from /classes/tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:29
Doubles (IDs replaced by "XX") (total = 3)
5 SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_XX` ac JOIN `ps_pm_advancedsearch_criterion_XX_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_XX_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_XX_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = XX)JOIN `ps_pm_advancedsearch_cache_product_criterion_XX` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_XX` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.`id_product` IN ( SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE product_shop.`active` = XX AND product_shop.`show_price` = XX AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`id_product` IN (XX) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` AND cg.`id_group` = XX )) AND ps.id_shop IN (XX) AND ps.`id_product` = acp.`id_product` ) WHERE ps.`active` = XX AND ps.`visibility` IN ("both", "search") AND ac.`id_criterion_group` = XX AND ac.`visible` = XX GROUP BY ac.`id_criterion` ORDER BY `position` ASC
2 SELECT cl.*,c.*, cl.`name` country, z.`name` zone FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = XX) LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = XX) LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`) WHERE XX AND c.active = XX ORDER BY cl.name ASC
2 SELECT * FROM `ps_state` ORDER BY `name` ASC
Tables stress
21 product_shop
11 category_product
11 product
11 category_group
9 pm_advancedsearch_cache_product_5
5 pm_advancedsearch_criterion_5
5 tax_rule
5 pm_advancedsearch_criterion_5_link
5 pm_advancedsearch_criterion_5_list
5 pm_advancedsearch_cache_product_criterion_5
5 pm_advancedsearch_criterion_5_lang
4 tax
4 image_type
4 currency_shop
4 group_reduction
4 hook
4 lang_shop
4 lang
4 shop
4 pm_advancedsearch_product_price_5
4 module
4 shop_url
3 meta
3 theme
3 currency
3 country
3 module_shop
3 country_shop
3 country_lang
2 pm_advancedsearch_criterion_group_5
2 group
2 hook_alias
2 group_shop
2 shop_group
2 meta_lang
2 zone
2 pm_advancedsearch
2 state
2 hook_module
1 image_shop
1 image_lang
1 manufacturer
1 product_lang
1 product_attribute_shop
1 stock_available
1 product_group_reduction_cache
1 product_attribute
1 image
1 pm_advancedsearch_category
1 theme_meta
1 group_lang
1 hook_module_exceptions
1 module_currency
1 module_group
1 configuration
1 configuration_lang
1 pm_advancedsearch_shop
1 pm_advancedsearch_products_cat
1 pm_advancedsearch_special_pages
1 pm_advancedsearch_lang
1 pm_advancedsearch_criterion_group_5_lang
1 pm_advancedsearch_products
1 pm_advancedsearch_manufacturers
1 pm_advancedsearch_cms
1 pm_advancedsearch_suppliers
1 attribute_group
ObjectModel instances
NameInstanceSource
Address2
classes/tax/Tax.php [259]
classes/tax/Tax.php [259]
Language2
config/config.inc.php [177]
classes/Tools.php [345]
Cart1
classes/controller/FrontController.php [243]
Group1
classes/Cart.php [173]
Theme1
config/config.inc.php [98]
Currency1
classes/Tools.php [433]
Customer1
config/config.inc.php [202]
ShopGroup1
classes/shop/Shop.php [500]
Shop1
config/config.inc.php [97]
Country1
config/config.inc.php [125]
Included files
#Filename
1./index.php
2config/config.inc.php
3config/defines.inc.php
4config/settings.inc.php
5config/autoload.php
6config/alias.php
7classes/PrestaShopAutoload.php
8classes/Tools.php
9classes/tools/profiling/Tools.php
10classes/Context.php
11classes/shop/Shop.php
12classes/ObjectModel.php
13classes/tools/profiling/ObjectModel.php
14classes/db/Db.php
15classes/tools/profiling/Db.php
16config/db_slave_server.inc.php
17classes/db/DbPDO.php
18classes/cache/Cache.php
19classes/Validate.php
20classes/db/DbQuery.php
21classes/Theme.php
22config/defines_uri.inc.php
23classes/Configuration.php
24classes/Language.php
25classes/Country.php
26classes/PrestaShopCollection.php
27classes/shop/ShopGroup.php
28classes/Cookie.php
29classes/Blowfish.php
30classes/Customer.php
31classes/Group.php
32classes/Link.php
33override/classes/Link.php
34classes/shop/ShopUrl.php
35config/smarty.config.inc.php
36tools/smarty/Smarty.class.php
37tools/smarty/sysplugins/smarty_internal_data.php
38tools/smarty/sysplugins/smarty_internal_templatebase.php
39tools/smarty/sysplugins/smarty_internal_template.php
40tools/smarty/sysplugins/smarty_resource.php
41tools/smarty/sysplugins/smarty_internal_resource_file.php
42tools/smarty/sysplugins/smarty_cacheresource.php
43tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
44config/smartyfront.config.inc.php
45classes/Dispatcher.php
46override/classes/Dispatcher.php
47classes/module/Module.php
48classes/Hook.php
49classes/tools/profiling/Hook.php
50tools/mobile_Detect/Mobile_Detect.php
51modules/pm_advancedsearch4/pm_advancedsearch4.php
52modules/pm_advancedsearch4/classes/LinkPM.php
53modules/pm_advancedsearch4/classes/As4SearchEngineLogger.php
54modules/pm_advancedsearch4/classes/As4SearchEngineDb.php
55modules/pm_advancedsearch4/classes/As4SearchEngine.php
56modules/pm_advancedsearch4/classes/As4SearchEngineIndexation.php
57modules/pm_advancedsearch4/classes/As4SearchEngineSeo.php
58modules/pm_advancedsearch4/classes/AdvancedSearchClass.php
59modules/pm_advancedsearch4/classes/AdvancedSearchCriterionGroupClass.php
60modules/pm_advancedsearch4/classes/AdvancedSearchCriterionClass.php
61modules/pm_advancedsearch4/classes/AdvancedSearchSeoClass.php
62modules/pm_advancedsearch4/AdvancedSearchCoreClass.php
63modules/yandexmodule/yandexmodule.php
64classes/PaymentModule.php
65modules/yandexmodule/lib/autoload.php
66modules/yandexmodule/lib/YandexModuleApi.php
67modules/yandexmodule/lib/YandexModuleBaseApi.php
68modules/yandexmodule/lib/YandexModuleRequests.php
69modules/yandexmodule/lib/YandexModuleExternalPayment.php
70modules/yandexmodule/lib/helpers.php
71classes/Translate.php
72modules/yandexmodule/translations/ru.php
73classes/Currency.php
74classes/controller/Controller.php
75classes/tools/profiling/Controller.php
76controllers/front/PricesDropController.php
77classes/controller/FrontController.php
78themes/default-bootstrap/lang/ru.php
79classes/Cart.php
80classes/CartRule.php
81classes/Meta.php
82classes/Product.php
83classes/webservice/WebserviceRequest.php
84classes/Media.php
85modules/scheckout/scheckout.php
86modules/scheckout/Classes/TypeForm.php
87modules/scheckout/Classes/TransModSC.php
88modules/scheckout/translations/ru.php
89modules/blockbanner/blockbanner.php
90themes/default-bootstrap/modules/blockbanner/translations/ru.php
91modules/blockbanner/translations/ru.php
92modules/blockcart/blockcart.php
93themes/default-bootstrap/modules/blockcart/translations/ru.php
94modules/blockcart/translations/ru.php
95modules/blockcategories/blockcategories.php
96themes/default-bootstrap/modules/blockcategories/translations/ru.php
97modules/blockcategories/translations/ru.php
98modules/blockcurrencies/blockcurrencies.php
99themes/default-bootstrap/modules/blockcurrencies/translations/ru.php
100modules/blockcurrencies/translations/ru.php
101modules/blocklanguages/blocklanguages.php
102themes/default-bootstrap/modules/blocklanguages/translations/ru.php
103modules/blocklanguages/translations/ru.php
104modules/blockcms/blockcms.php
105modules/blockcms/BlockCMSModel.php
106themes/default-bootstrap/modules/blockcms/translations/ru.php
107modules/blockcms/translations/ru.php
108modules/blockcontact/blockcontact.php
109themes/default-bootstrap/modules/blockcontact/translations/ru.php
110modules/blockcontact/translations/ru.php
111modules/blockcontactinfos/blockcontactinfos.php
112themes/default-bootstrap/modules/blockcontactinfos/translations/ru.php
113modules/blockcontactinfos/translations/ru.php
114modules/blockmyaccount/blockmyaccount.php
115themes/default-bootstrap/modules/blockmyaccount/translations/ru.php
116modules/blockmyaccount/translations/ru.php
117modules/blockmyaccountfooter/blockmyaccountfooter.php
118themes/default-bootstrap/modules/blockmyaccountfooter/translations/ru.php
119modules/blockmyaccountfooter/translations/ru.php
120modules/blocknewproducts/blocknewproducts.php
121themes/default-bootstrap/modules/blocknewproducts/translations/ru.php
122modules/blocknewproducts/translations/ru.php
123modules/blocknewsletter/blocknewsletter.php
124themes/default-bootstrap/modules/blocknewsletter/translations/ru.php
125modules/blocknewsletter/translations/ru.php
126modules/blockpaymentlogo/blockpaymentlogo.php
127themes/default-bootstrap/modules/blockpaymentlogo/translations/ru.php
128modules/blockpaymentlogo/translations/ru.php
129modules/blocksearch/blocksearch.php
130themes/default-bootstrap/modules/blocksearch/translations/ru.php
131modules/blocksearch/translations/ru.php
132modules/blockspecials/blockspecials.php
133themes/default-bootstrap/modules/blockspecials/translations/ru.php
134modules/blockspecials/translations/ru.php
135modules/blockviewed/blockviewed.php
136themes/default-bootstrap/modules/blockviewed/translations/ru.php
137modules/blockviewed/translations/ru.php
138modules/homeslider/homeslider.php
139modules/homeslider/HomeSlide.php
140themes/default-bootstrap/modules/homeslider/translations/ru.php
141modules/homeslider/translations/ru.php
142modules/homefeatured/homefeatured.php
143themes/default-bootstrap/modules/homefeatured/translations/ru.php
144modules/homefeatured/translations/ru.php
145modules/productpaymentlogos/productpaymentlogos.php
146themes/default-bootstrap/modules/productpaymentlogos/translations/ru.php
147modules/productpaymentlogos/translations/ru.php
148modules/themeconfigurator/themeconfigurator.php
149themes/default-bootstrap/modules/themeconfigurator/translations/ru.php
150modules/themeconfigurator/translations/ru.php
151modules/blockwishlist/blockwishlist.php
152modules/blockwishlist/WishList.php
153themes/default-bootstrap/modules/blockwishlist/translations/ru.php
154modules/blockwishlist/translations/ru.php
155modules/productcomments/productcomments.php
156themes/default-bootstrap/modules/productcomments/translations/ru.php
157modules/productcomments/translations/ru.php
158modules/blockuserinfo/blockuserinfo.php
159themes/default-bootstrap/modules/blockuserinfo/translations/ru.php
160modules/blockuserinfo/translations/ru.php
161modules/advancedtags/advancedtags.php
162modules/advancedtags/AdvancedTagsCore.php
163modules/advancedtags/classes/AdvancedTag.php
164themes/default-bootstrap/modules/advancedtags/translations/ru.php
165modules/advancedtags/translations/ru.php
166modules/canonicalurlpro/canonicalurlpro.php
167themes/default-bootstrap/modules/canonicalurlpro/translations/ru.php
168modules/canonicalurlpro/translations/ru.php
169modules/prestaspeed/prestaspeed.php
170modules/prestaspeed/smush2.php
171classes/ImageType.php
172themes/default-bootstrap/modules/prestaspeed/translations/ru.php
173modules/prestaspeed/ru.php
174cache/smarty/compile/67/84/2e/67842ee63c39c780f1d0d52ccc64faa9628b54df.file.header.tpl.php
175classes/tools/smarty/sysplugins/smarty_internal_filter_handler.php
176tools/minify_html/minify_html.class.php
177cache/smarty/cache/blocksearch_top/1/1/177/f8/3a/c6/f83ac64ac3aa8cddac18e730cf890cc4d557077f.blocksearch-top.tpl.php
178classes/Customization.php
179cache/smarty/compile/b0/f4/bc/b0f4bc2f0adb97e9d851d283041d9c6060c0fe00.file.blockcart.tpl.php
180tools/smarty/plugins/modifier.replace.php
181tools/smarty/plugins/function.counter.php
182modules/blocktopmenu/blocktopmenu.php
183modules/blocktopmenu/menutoplinks.class.php
184themes/default-bootstrap/modules/blocktopmenu/translations/ru.php
185modules/blocktopmenu/translations/ru.php
186cache/smarty/cache/blocktopmenu/1/1/177/index/ae/81/a8/ae81a8ec99a0aa0d128973b87131fcac7130401f.blocktopmenu.tpl.php
187modules/pagesnotfound/pagesnotfound.php
188themes/default-bootstrap/modules/pagesnotfound/translations/ru.php
189modules/pagesnotfound/translations/ru.php
190modules/sekeywords/sekeywords.php
191classes/module/ModuleGraph.php
192themes/default-bootstrap/modules/sekeywords/translations/ru.php
193modules/sekeywords/translations/ru.php
194cache/smarty/compile/fd/74/ff/fd74ffaf65a96749ae5a74da2afdf84a17f1ea1d.file.blockwishlist_top.tpl.php
195cache/smarty/compile/d4/7a/91/d47a91e86de95a176b476e71a25780a285e655e5.file.blockuserinfo.tpl.php
196themes/default-bootstrap/modules/pm_advancedsearch4/translations/ru.php
197classes/Address.php
198classes/SpecificPrice.php
199classes/tax/Tax.php
200classes/tax/TaxManagerFactory.php
201classes/tax/TaxRulesTaxManager.php
202classes/tax/TaxManagerInterface.php
203classes/tax/TaxCalculator.php
204classes/GroupReduction.php
205cache/smarty/compile/b0/2d/d6/b02dd61c47d65030d28e2a85393b6936a8fb818e.file.cache.tpl.cache.php
206classes/tools/smarty/sysplugins/smarty_internal_write_file.php
207cache/smarty/cache/pm_advancedsearch/5/customCache/getCriterionsForSearchBloc/16/020a4c55501022c0764d8a182a4cfb1034e444cb/1/1/177/d540a18d5ec640e6cda8bbc18476664a80c8cbbf/b0/2d/d6/b02dd61c47d65030d28e2a85393b6936a8fb818e.cache.tpl.php
208cache/smarty/compile/d3/d4/b9/d3d4b9e7213dfc9b6600e3c13a6349bc143bc247.file.pm_advancedsearch.tpl.php
209cache/smarty/compile/6e/bb/c2/6ebbc292f64be1bf4ca3883b6b23c3587953c084.file.pm_advancedsearch_header_block.tpl.php
210cache/smarty/compile/f6/7b/a3/f67ba3e35a2f69b8fc6bbf7a2e752fd35e162cac.file.pm_advancedsearch_selection_block.tpl.php
211cache/smarty/compile/b2/0d/7b/b20d7b1a3304cbe4a2dab7385b168fcf389b9140.file.pm_advancedsearch_criterions.tpl.php
212cache/smarty/compile/6f/5a/d7/6f5ad7777a9b4a5e036af635c287e207764e408e.file.pm_advancedsearch_criterions_slider.tpl.php
213cache/smarty/compile/65/e6/b0/65e6b04d8ef02ddb9af7afed6c9b6df8d6f6f9ad.file.pm_advancedsearch_criterions_select.tpl.php
214cache/smarty/compile/b2/0c/f3/b20cf30755fb4d152322aad62968ebf52d1ca4a0.file.pm_advancedsearch_criterions_colorsquare.tpl.php
215cache/smarty/compile/72/51/e1/7251e1b4a4674cf59eded590c2535fb322bf2d10.file.pm_advancedsearch_criterions_checkbox.tpl.php
216cache/smarty/compile/6a/fb/2d/6afb2d42ce6960d2a9cb821aba8efb2436a41f22.file.pm_advancedsearch_footer_block.tpl.php
217classes/Combination.php
218classes/stock/StockAvailable.php
219classes/Image.php
220cache/smarty/compile/36/7c/39/367c390933b1c9c75b9385ff06d2d901645acedc.file.blocknewsletter.tpl.php
221cache/smarty/cache/blockcategories/1/1/177/1/50/2a/cb/502acb34069bc0e1c88b2f5bb6759e056175b793.blockcategories_footer.tpl.php
222cache/smarty/cache/blockmyaccountfooter/1/1/177/57/34/3e/57343e560325890301880888603da67811bb1ff2.blockmyaccountfooter.tpl.php
223cache/smarty/cache/blockcms/2/1/1/177/07/81/e1/0781e1887cd2615ba605c0c586efed04f3c4c499.blockcms.tpl.php
224cache/smarty/cache/blockcontactinfos/1/1/177/f9/fd/02/f9fd024bb6d1178f0c5cd5c16070984b1b419488.blockcontactinfos.tpl.php
225cache/smarty/compile/ba/ff/01/baff01b6b0c5d62d75803a14342963b7a0d35db6.file.prices-drop.tpl.php
226cache/smarty/compile/87/8a/bd/878abdc3af40965895f24a09d2e23fe47a812f54.file.layout.tpl.php
227cache/smarty/compile/9d/d9/08/9dd908a6b18f62b13a84d68733f1652d3ca9e4e9.file.header.tpl.php
228tools/smarty/plugins/function.implode.php
229cache/smarty/cache/blockbanner/1/1/177/46/2d/b3/462db343cf7e23dbc5d12436a383eec5b5596009.blockbanner.tpl.php
230cache/smarty/cache/blockcontact/1/1/177/26/99/94/269994790792003c155f45c140b363a4af4a5270.nav.tpl.php
231cache/smarty/compile/13/7a/30/137a30c56610d31b889067239c4548670f65ceb9.file.nav.tpl.php
232cache/smarty/compile/49/35/41/4935411a915ac6443a2d23d5a61aa42f370b5629.file.breadcrumb.tpl.php
233cache/smarty/compile/e5/cb/95/e5cb953679f532c6942ba4858a3733ac10f0f271.file.footer.tpl.php
234cache/smarty/compile/14/b1/fa/14b1faff2aa5104e3809a8321fef7f9374ee1b36.file.global.tpl.php
235cache/smarty/compile/c6/d2/ed/c6d2edf129a023df4e6b8d33fdba3f40aff63041.file.javascript.tpl.php