PUBLICACIONES DEL BLOG

VER TODAS LAS PUBLICACIONES

CATEGORÍAS DE BLOGS

VER TODAS LAS CATEGORÍAS

BUSCAR EN EL BLOG

PUBLICACIONES ARCHIVADAS

New products

Smartwatch T3 Pro
Vista rápida

Smartwatch T3 Pro

favorite_border
Ordenados: 100
  • Nuevo
Smartwatch GTS
Vista rápida

Smartwatch GTS

favorite_border
Ordenados: 100
  • Nuevo
Smartwatch 8 Ultra Max
Vista rápida

Smartwatch 8 Ultra Max

favorite_border
Ordenados: 100
  • Nuevo
Case iPhone 15 Pro Max Azul Marino Focus Funda Protector
Vista rápida

Case iPhone 15 Pro Max Azul Marino Focus Funda Protector

favorite_border
Ordenados: 100
  • Nuevo
Case iPhone 15 Pro Max Humo Focus Funda Protector
Vista rápida

Case iPhone 15 Pro Max Humo Focus Funda Protector

favorite_border
Ordenados: 100
  • Nuevo
Case iPhone 15 Pro Max Blanco Focus Funda Protector
Vista rápida

Case iPhone 15 Pro Max Blanco Focus Funda Protector

favorite_border
Ordenados: 100
  • Nuevo
Case iPhone 15 Pro Max Azul Focus Funda Protector
Vista rápida

Case iPhone 15 Pro Max Azul Focus Funda Protector

favorite_border
Ordenados: 100
  • Nuevo
Case iPhone 15 Pro Max Rosa Focus Funda Protector
Vista rápida

Case iPhone 15 Pro Max Rosa Focus Funda Protector

favorite_border
Ordenados: 100
  • Nuevo
Todos los productos nuevos

Popular products

Cargador Para Samsung S10 Tipo C
Vista rápida

Cargador Para Samsung S10 Tipo C

favorite_border
Ordenados: 100
Cargador V8 1 Hora Blanco Carga Rapida Puerto Usb Extra
Vista rápida

Cargador V8 1 Hora Blanco Carga Rapida Puerto Usb Extra

favorite_border
Ordenados: 100
Cargador 1 Hora 2.0Amp Con Cable Para Apple iPhone...
Vista rápida

Cargador 1 Hora 2.0Amp Con Cable Para Apple iPhone...

favorite_border
Ordenados: 100
Cargador Para LG V8 Micro Usb Blanco Bolsa
Vista rápida

Cargador Para LG V8 Micro Usb Blanco Bolsa

favorite_border
Ordenados: 100
Cargador Para Apple iPhone 5-14 20W Y Cable 2M Tipo C Caja
Vista rápida

Cargador Para Apple iPhone 5-14 20W Y Cable 2M Tipo C Caja

favorite_border
Ordenados: 100
Cargador Tipo C Para LG Carga Rapida Caja
Vista rápida

Cargador Tipo C Para LG Carga Rapida Caja

favorite_border
Ordenados: 100
Cargador Para Samsung S22 45W Ultra Super Carga Rapida...
Vista rápida

Cargador Para Samsung S22 45W Ultra Super Carga Rapida...

favorite_border
Ordenados: 100
Cargador Tipo C Para Samsung Carga Rapida Para Auto En...
Vista rápida

Cargador Tipo C Para Samsung Carga Rapida Para Auto En...

favorite_border
Ordenados: 100
Todos los productos

Case Clip V6 Uso Rudo Pro Funda Protector

Filtros activos

Vista rápida

Pro-Case Samsung S8 Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case Samsung S8 Gris White

favorite_border
Ordenados: 100
Vista rápida

Pro-Case Samsung S8 Plus Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case Samsung Note 8 Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case iPhone 6 Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case iPhone X Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case iPhone X Azul

favorite_border
Ordenados: 100
Vista rápida

Pro-Case Samsung S8 Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case iPhone X Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case iPhone 6 Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case Samsung S8 Plus Negro

favorite_border
Ordenados: 100
Vista rápida

Pro-Case iPhone X Azul

favorite_border
Ordenados: 100
Vista rápida

Pro-Case Samsung S8 Gris White

favorite_border
Ordenados: 100
Vista rápida

Pro-Case Samsung Note 8 Negro

favorite_border
Ordenados: 100
Volver arriba

Contáctanos

Utilizamos Cookies, Inteligencia Artificial, y otras tecnologías y algoritmos para Mejorar tu experiencia de navegación, Analizar el tráfico del sitio y Personalizar el contenido y los anuncios, Muchas Gracias México! 

Acepto No acepto
Load Time 788 ms
Querying Time 408 ms
Queries 829
Memory Peak Usage 84.2 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 34 ms 34 ms 21.23 Mb 21.6 Mb
__construct 0 ms 34 ms - Mb 21.6 Mb
init 70 ms 103 ms 11.64 Mb 34.0 Mb
checkAccess 0 ms 103 ms - Mb 34.0 Mb
setMedia 5 ms 109 ms 0.83 Mb 34.0 Mb
postProcess 0 ms 109 ms - Mb 34.0 Mb
initHeader 0 ms 109 ms - Mb 34.0 Mb
initContent 421 ms 530 ms 21.64 Mb 55.4 Mb
initFooter 0 ms 530 ms - Mb 55.4 Mb
display 258 ms 788 ms 27.66 Mb 84.2 Mb
Hook Time Memory Usage
displayLeftColumn 168 ms 15.99 Mb
DisplayProductListReviews 42 ms 4.99 Mb
displayProductListReviews 36 ms 2.98 Mb
DisplayBeforeBodyClosingTag 10 ms 0.72 Mb
DisplayHeader 8 ms 0.84 Mb
DisplayATCButton 6 ms 0.38 Mb
DisplayLeftColumn 6 ms 0.53 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 2 ms 0.22 Mb
DisplayFooter 1 ms 0.10 Mb
displayNav1 1 ms 0.14 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
displayBanner 1 ms 0.05 Mb
displayFooterBefore 1 ms 0.07 Mb
DisplayNavFullWidth 1 ms 0.04 Mb
Footer 0 ms 0.04 Mb
displayFooterAfter 0 ms 0.02 Mb
DisplayOverrideTemplate 0 ms - Mb
ModuleRoutes 0 ms 0.02 Mb
ActionBuildFrontEndObject 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
ActionDispatcherBefore 0 ms - Mb
DisplayWrapperTop 0 ms - Mb
DisplayNav1 0 ms - Mb
DisplayNav2 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayBanner 0 ms - Mb
31 hook(s) 296 ms 29.40 Mb
Module Time Memory Usage
codisto 8 ms 2.08 Mb
jmarketplace 12 ms 2.16 Mb
auction 6 ms 0.92 Mb
ets_savemycart 3 ms 0.92 Mb
ets_blog 12 ms 1.50 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 37 ms 3.17 Mb
ps_imageslider 1 ms 0.27 Mb
ps_searchbar 1 ms 0.09 Mb
psxmarketingwithgoogle 2 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.13 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 17 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 85 ms 9.34 Mb
ets_mostpopular 70 ms 6.13 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 28 ms 3.30 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 2 ms 0.16 Mb
ets_addtocart_fromlist 7 ms 0.58 Mb
ph_sendproduct_tofriend 1 ms 0.22 Mb
ps_facetedsearch 5 ms 0.59 Mb
ps_contactinfo 2 ms 0.25 Mb
ps_languageselector 1 ms 0.10 Mb
ps_currencyselector 1 ms 0.07 Mb
ps_customersignin 1 ms 0.08 Mb
ps_mainmenu 5 ms 1.14 Mb
ps_categorytree 14 ms 0.95 Mb
ps_brandlist 2 ms 0.05 Mb
ps_supplierlist 1 ms 0.10 Mb
ps_linklist 11 ms 3.73 Mb
ps_customeraccountlinks 1 ms 0.10 Mb
statsdata 8 ms 0.52 Mb
69 module(s) 417 ms 52.31 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 829 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>=737 AND c.nright<=738 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_upd DESC, p.id_product DESC LIMIT 0, 60
 110672 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>=737 AND c.nright<=738 GROUP BY p.id_product) p
 106312 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
 17146 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
 7978 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`)
 6216 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
 6116 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
 3802 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`
 2833 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
 2055 ms 0 /classes/Hook.php:1243 
REPLACE INTO pr_layered_filter_block (hash, data) VALUES ("ed3b31009a7e26f927fc7c3b1e484314", "a:1:{s:7:\"filters\";a:0:{}}")
 1440 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211 
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')
 1244 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
 1066 ms 390 /modules/ets_newproducts/classes/ets_newproducts_defines.php:401 
INSERT INTO `pr_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('4460161', '896', '55575699', '', '1', '1', '2023-12-04 19:23:47')
 805 ms 1 /classes/ObjectModel.php:578 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pr_hook` h
WHERE (h.active = 1)
 770 ms 979 /classes/Hook.php:1283 
INSERT INTO `pr_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('118', '896', '1', '1', '1')
 763 ms 1 /classes/Page.php:142 
SELECT SQL_NO_CACHE `id_product`
FROM `pr_megapayment_product`
WHERE type!=0
 737 ms 2539 /override/classes/Cart.php:91 
INSERT INTO `pr_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('3546781', '', 'www.araysa.mx/mx/331-case-clip-v6-uso-rudo-pro-funda-protector', '', '2023-12-04 19:23:47')
 730 ms 1 /classes/ObjectModel.php:578 
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 = 20555
LIMIT 1
 694 ms 1 /classes/ProductAssembler.php:106 
INSERT IGNORE INTO `pr_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('3546781', '896', '2023-12-04 19:23:47')
 676 ms 1 /classes/Connection.php:122 
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
 666 ms 335 Yes /classes/Dispatcher.php:650 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pr_hook`
 603 ms 979 /classes/Hook.php:1243 
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
 556 ms 178 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE *
FROM `pr_category` a0
LEFT JOIN `pr_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 737) AND (a0.`nright` > 738) AND (a1.`id_lang` = 3)
ORDER BY a0.`nleft` asc
 556 ms 3860 Yes /classes/PrestaShopCollection.php:381 
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 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="331") 
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
 522 ms 3 Yes Yes /modules/ets_blog/classes/Ets_blog_post.php:257 
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
 515 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` = 20555 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
 503 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
 485 ms 178 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE tr.*
FROM `pr_tax_rule` tr
JOIN `pr_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 144
AND tr.`id_tax_rules_group` = 7
AND tr.`id_state` IN (0, 72)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 443 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109 
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
 442 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` = 20556 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
 423 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
 422 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
 419 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 = 20556
LIMIT 1
 415 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
 413 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
 411 ms 178 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE data FROM pr_layered_filter_block WHERE hash="ed3b31009a7e26f927fc7c3b1e484314" LIMIT 1
 409 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186 
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
 408 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` = 28968 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
 406 ms 1 Yes /classes/SpecificPrice.php:561 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pr_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20555 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pr_cart_product` cp JOIN `pr_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pr_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 20555 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 402 ms 0 /classes/Cart.php:1429 
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` = 20706 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
 401 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 = 21651
LIMIT 1
 395 ms 1 /classes/ProductAssembler.php:106 
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` = 331
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 394 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` = 13789 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
 383 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 = 20706
LIMIT 1
 382 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` = 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
 379 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` = 11376 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
 376 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 = 7185
LIMIT 1
 375 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` = 16277 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
 372 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` = 18338 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
 365 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 = 16277
LIMIT 1
 365 ms 1 /classes/ProductAssembler.php:106 
SELECT SQL_NO_CACHE *
FROM `pr_product` a
LEFT JOIN `pr_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `pr_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20555) AND (b.`id_shop` = 1) LIMIT 1
 364 ms 1 /src/Adapter/EntityMapper.php:76 
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` = 16744 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
 363 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 = 18338
LIMIT 1
 361 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` = 10852 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
 358 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` = 5791 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
 357 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 = 5791
LIMIT 1
 357 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` = 13750 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
 357 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` = 14399 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
 356 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 = 34328
LIMIT 1
 355 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` = 4101 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
 355 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` = 29077 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
 354 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` = 31096 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