PUBLICACIONES DEL BLOG

PUBLICACIONES ARCHIVADAS

Controles y Mandos

Controles y Mandos

Filtros activos

Control Xbox 360 Original Inalambrico

Ordenados: 100

Control Xbox One Alambrico

Ordenados: 100

Control Xbox 360 Inalambrico Original

Ordenados: 100

Control Xbox 360 Clasico Alambrico

Ordenados: 100

Control Xbox 360 Alambrico

Ordenados: 100

Control Inalambrico Xbox 360 Azul

Ordenados: 100

Control Inalambrico Xbox One

Ordenados: 100

Control Inalambrico Xbox 360 Rojo

Ordenados: 100

Control Inalambrico Xbox 360 Azul

Ordenados: 100

Control Inalambrico Xbox 360 Negro

Ordenados: 100

Control Alambrico Xbox 360 Rojo

Ordenados: 100

Control Alambrico Xbox 360 Azul

Ordenados: 100

Control PS4 100% Original Mando Genuino

Ordenados: 100

Control Xbox One Camuflaje Original

Ordenados: 100

Control Xbox 360 Microsoft Inalambrico Original

Ordenados: 100
Load Time 848 ms
Querying Time 463 ms
Queries 872
Memory Peak Usage 84.8 Mb
Included Files 1394 files - 16.82 Mb
PrestaShop Cache - Mb
Global vars 0.86 Mb
PrestaShop Version 1.7.8.10
PHP Version 7.4.33
MySQL Version 5.7.44
Memory Limit -1
Max Execution Time 60s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 32 ms 32 ms 21.23 Mb 21.6 Mb
__construct 0 ms 32 ms - Mb 21.6 Mb
init 65 ms 97 ms 11.69 Mb 34.0 Mb
checkAccess 0 ms 97 ms - Mb 34.0 Mb
setMedia 5 ms 102 ms 0.83 Mb 34.0 Mb
postProcess 0 ms 102 ms - Mb 34.0 Mb
initHeader 0 ms 102 ms - Mb 34.0 Mb
initContent 477 ms 578 ms 22.24 Mb 56.0 Mb
initFooter 0 ms 578 ms - Mb 56.0 Mb
display 270 ms 848 ms 27.68 Mb 84.8 Mb
Hook Time Memory Usage
displayLeftColumn 174 ms 15.87 Mb
DisplayProductListReviews 45 ms 5.08 Mb
displayProductListReviews 38 ms 2.92 Mb
DisplayBeforeBodyClosingTag 11 ms 0.70 Mb
DisplayHeader 8 ms 0.84 Mb
DisplayATCButton 7 ms 0.39 Mb
DisplayLeftColumn 6 ms 0.54 Mb
Header 5 ms 0.63 Mb
displayTop 4 ms 0.94 Mb
displayFooter 3 ms 0.33 Mb
displayNav2 2 ms 0.22 Mb
ProductSearchProvider 1 ms 0.22 Mb
DisplayFooter 1 ms 0.10 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
displayNav1 1 ms 0.08 Mb
DisplayNavFullWidth 1 ms 0.04 Mb
displayFooterBefore 1 ms 0.07 Mb
displayBanner 0 ms 0.05 Mb
Footer 0 ms 0.04 Mb
displayFooterAfter 0 ms 0.02 Mb
DisplayOverrideTemplate 0 ms 0.06 Mb
ModuleRoutes 0 ms 0.02 Mb
ActionBuildFrontEndObject 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayWrapperTop 0 ms - Mb
ActionDispatcherBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
DisplayNav2 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayNav1 0 ms - Mb
DisplayBanner 0 ms - Mb
31 hook(s) 308 ms 29.31 Mb
Module Time Memory Usage
codisto 8 ms 2.08 Mb
jmarketplace 12 ms 2.17 Mb
auction 6 ms 0.92 Mb
ets_savemycart 3 ms 0.92 Mb
ets_blog 11 ms 1.51 Mb
ps_mbo 2 ms 0.41 Mb
ets_delete_order 1 ms 0.20 Mb
ps_emailsubscription 3 ms 0.56 Mb
blockreassurance 1 ms 0.09 Mb
ps_emailalerts 2 ms 0.25 Mb
loyaltyeditpoints 4 ms 0.50 Mb
productcomments 39 ms 3.11 Mb
ps_imageslider 1 ms 0.27 Mb
ps_searchbar 1 ms 0.09 Mb
psxmarketingwithgoogle 1 ms 0.17 Mb
ps_googleanalytics 2 ms 0.26 Mb
rg_coppelpay 3 ms 0.52 Mb
oneclickcheckout 0 ms 0.05 Mb
bonorder 1 ms 0.07 Mb
homeproductscatab 1 ms 0.10 Mb
ps_shoppingcart 1 ms 0.09 Mb
ets_productlistpagination 1 ms 0.19 Mb
ets_hotdeals 2 ms 0.23 Mb
ets_productnote 2 ms 0.37 Mb
ets_countdown 1 ms 0.13 Mb
ets_totalproduct_sold 18 ms 2.18 Mb
ph_social_links 1 ms 0.19 Mb
ets_securitycertification 2 ms 0.21 Mb
ets_recaptcha_free 1 ms 0.21 Mb
ybc_productimagehover 1 ms 0.07 Mb
ybc_nivoslider 2 ms 0.37 Mb
ets_testimonial 2 ms 0.34 Mb
ets_manufacturerslider 1 ms 0.11 Mb
ph_recommendbycategories 1 ms 0.09 Mb
ets_integrategooglemarketing 1 ms 0.18 Mb
ph_viewedproducts 1 ms 0.11 Mb
ets_newproducts 88 ms 9.23 Mb
ets_mostpopular 72 ms 6.11 Mb
creativepopup 4 ms 0.60 Mb
ets_cookie_banner 1 ms 0.13 Mb
ets_ageverification 1 ms 0.25 Mb
ets_saleticker 2 ms 0.47 Mb
rg_einvoicemx 1 ms 0.23 Mb
paypal 7 ms 1.02 Mb
mercadopago 3 ms 0.68 Mb
megapayment 4 ms 0.50 Mb
jsellerproductquestions 1 ms 0.11 Mb
jwishlist 30 ms 3.39 Mb
whatsapp 1 ms 0.07 Mb
uecookie 1 ms 0.16 Mb
solditems 0 ms 0.06 Mb
bonslick 1 ms 0.18 Mb
referralbyphone 5 ms 0.91 Mb
skydropx 1 ms 0.21 Mb
ph_scrolltotop 1 ms 0.16 Mb
ets_addtocart_fromlist 8 ms 0.59 Mb
ph_sendproduct_tofriend 1 ms 0.22 Mb
ps_facetedsearch 4 ms 0.59 Mb
ps_contactinfo 2 ms 0.19 Mb
ps_languageselector 1 ms 0.09 Mb
ps_currencyselector 0 ms 0.07 Mb
ps_customersignin 1 ms 0.08 Mb
ps_mainmenu 5 ms 1.14 Mb
ps_categorytree 15 ms 0.95 Mb
ps_brandlist 2 ms - Mb
ps_supplierlist 1 ms 0.10 Mb
ps_linklist 12 ms 3.73 Mb
ps_customeraccountlinks 1 ms 0.10 Mb
statsdata 8 ms 0.50 Mb
69 module(s) 425 ms 52.16 Mb

Stopwatch SQL - 872 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.date_upd FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=550 AND c.nright<=551 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_upd DESC, p.id_product DESC LIMIT 0, 60
154841 ms 342040 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.date_upd FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=550 AND c.nright<=551 GROUP BY p.id_product) p
110082 ms 342040 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `pr_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
16334 ms 286557184 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2023-12-04 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `pr_category_product` cp
LEFT JOIN `pr_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN pr_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pr_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN pr_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 `pr_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = 1 )
LEFT JOIN `pr_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 )
LEFT JOIN `pr_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `pr_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 3)
LEFT JOIN `pr_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 44 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 8
7827 ms 227 Yes /modules/ets_mostpopular/classes/ets_mostpopular_defines.php:432
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 `pr_configuration` c
LEFT JOIN `pr_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
7808 ms 11900 /classes/Configuration.php:160
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `pr_category` c
INNER JOIN `pr_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 3 AND cl.id_shop = 1 )
INNER JOIN `pr_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND nleft >= 2 AND nright <= 1543
AND c.id_category IN (
SELECT id_category
FROM `pr_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cl.`name` ASC
6740 ms 764 Yes /modules/ps_categorytree/ps_categorytree.php:166
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `pr_hook_module` hm
STRAIGHT_JOIN `pr_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `pr_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3261 ms 997 /classes/Hook.php:504
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pr_module` m
INNER JOIN pr_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 `pr_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `pr_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pr_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") 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`
2895 ms 7760 Yes Yes /classes/Hook.php:1183
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `pr_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `pr_hook_alias` ha
INNER JOIN `pr_hook` h ON ha.name = h.name
1860 ms 0 /classes/Hook.php:1243
INSERT INTO `pr_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
1393 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
(DATEDIFF(product_shop.`date_add`,
DATE_SUB(
"2023-12-04 00:00:00",
INTERVAL 20 DAY
)
) > 0) as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
FROM `pr_product` p
INNER JOIN pr_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pr_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 
LEFT JOIN `pr_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1
LEFT JOIN `pr_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3
LEFT JOIN `pr_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `pr_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1
LEFT JOIN pr_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  )
WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2023-11-14") AND (EXISTS(SELECT 1 FROM `pr_category_product` cp
JOIN `pr_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1)
WHERE cp.`id_product` = p.`id_product`))
ORDER BY product_shop.`date_add` DESC
LIMIT 8
947 ms 390 /modules/ets_newproducts/classes/ets_newproducts_defines.php:401
UPDATE `pr_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 118
AND `id_page` = 10081
AND `id_shop` = 1
853 ms 1 /classes/Page.php:131
SELECT SQL_NO_CACHE lower(name) as name
FROM `pr_hook` h
WHERE (h.active = 1)
757 ms 979 /classes/Hook.php:1283
INSERT INTO `pr_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('4460275', '10081', '55575699', '', '1', '1', '2023-12-04 19:39:38')
716 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `pr_meta` m
LEFT JOIN `pr_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
683 ms 335 Yes /classes/Dispatcher.php:650
SELECT SQL_NO_CACHE `id_product`
FROM `pr_megapayment_product`
WHERE type!=0
676 ms 2539 /override/classes/Cart.php:91
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pr_hook`
586 ms 979 /classes/Hook.php:1243
SELECT SQL_NO_CACHE p.*,pc.id_category, pl.image,pl.thumb, pl.title, pl.description, pl.short_description, pl.meta_keywords, pl.meta_description,pc.position,CONCAT(e.firstname,' ',e.lastname) as name_author
FROM `pr_ets_blog_post` p
LEFT JOIN `pr_ets_blog_post_lang` pl ON (p.id_post = pl.id_post AND pl.id_lang='3')
LEFT JOIN `pr_ets_blog_post_category` pc ON (p.id_post = pc.id_post  AND pc.id_category="616") 
LEFT JOIN `pr_employee` e ON (e.id_employee=p.added_by AND p.is_customer=0)
WHERE p.id_shop='1' AND p.enabled=1  
GROUP BY p.id_post
ORDER BY p.date_add DESC, p.id_post DESC  LIMIT 0, 10
562 ms 3 Yes Yes /modules/ets_blog/classes/Ets_blog_post.php:257
INSERT INTO `pr_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('3546886', '', 'www.araysa.mx/mx/616-controles-y-mandos', '', '2023-12-04 19:39:38')
551 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE *
FROM `pr_order_state` os
LEFT JOIN `pr_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 3) WHERE deleted = 0 ORDER BY `name` ASC
545 ms 85 Yes /classes/order/OrderState.php:132
SELECT SQL_NO_CACHE *
FROM `pr_category` a0
LEFT JOIN `pr_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 550) AND (a0.`nright` > 551) AND (a1.`id_lang` = 3)
ORDER BY a0.`nleft` asc
531 ms 3860 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-04 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM pr_product p
LEFT JOIN pr_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN pr_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN pr_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 34328
LIMIT 1
498 ms 1 /classes/ProductAssembler.php:106
INSERT IGNORE INTO `pr_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('3546886', '10081', '2023-12-04 19:39:38')
460 ms 1 /classes/Connection.php:122
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
458 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 3992 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
452 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 31227 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
447 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
441 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
440 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-04 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM pr_product p
LEFT JOIN pr_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN pr_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN pr_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 32886
LIMIT 1
438 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 8014 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
436 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 31107 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
434 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 34321 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
428 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-04 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM pr_product p
LEFT JOIN pr_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN pr_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN pr_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 3992
LIMIT 1
427 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
425 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
423 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 31229 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
421 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
417 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
416 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 34317 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
402 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-04 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM pr_product p
LEFT JOIN pr_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN pr_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN pr_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 3993
LIMIT 1
397 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 31298 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
396 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 32544 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
396 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 34319 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
395 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 3993 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
395 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 4100 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
393 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
392 ms 178 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 31146 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
390 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 34318 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
390 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 3995 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
387 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `pr_category` c
INNER JOIN pr_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pr_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3  AND cl.id_shop = 1 )
LEFT JOIN `pr_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 616
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
386 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 34320 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
386 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1) AND `id_product` = 31231 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
384 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 144, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 144) AND
`id_group` IN (0, 1)