PUBLICACIONES DEL BLOG

PUBLICACIONES ARCHIVADAS

Case 360 Funda Protector

Filtros activos

Case 360 G50 5G Motorola Transparente Reforzado Funda...

Ordenados: 100
Load Time 1274 ms
Querying Time 754 ms
Queries 554
Memory Peak Usage 78.2 Mb
Included Files 1394 files - 16.82 Mb
PrestaShop Cache - Mb
Global vars 0.82 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 33 ms 33 ms 21.23 Mb 21.6 Mb
__construct 0 ms 33 ms - Mb 21.6 Mb
init 67 ms 100 ms 11.64 Mb 34.0 Mb
checkAccess 0 ms 100 ms - Mb 34.0 Mb
setMedia 5 ms 106 ms 0.83 Mb 34.0 Mb
postProcess 0 ms 106 ms - Mb 34.0 Mb
initHeader 0 ms 106 ms - Mb 34.0 Mb
initContent 692 ms 798 ms 18.97 Mb 52.7 Mb
initFooter 0 ms 798 ms - Mb 52.7 Mb
display 476 ms 1274 ms 24.56 Mb 78.2 Mb
Hook Time Memory Usage
displayLeftColumn 336 ms 15.94 Mb
displayProductListReviews 63 ms 2.96 Mb
DisplayProductListReviews 44 ms 2.88 Mb
DisplayHeader 25 ms 0.84 Mb
DisplayBeforeBodyClosingTag 18 ms 0.66 Mb
displayFooter 13 ms 0.33 Mb
Header 13 ms 0.63 Mb
DisplayLeftColumn 12 ms 0.55 Mb
displayTop 11 ms 0.94 Mb
displayBanner 9 ms 0.05 Mb
displayNav2 6 ms 0.22 Mb
DisplayATCButton 4 ms 0.23 Mb
ProductSearchProvider 4 ms 0.22 Mb
DisplayFooter 3 ms 0.10 Mb
displayFooterBefore 3 ms 0.07 Mb
displayNav1 2 ms 0.14 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
DisplayNavFullWidth 1 ms 0.04 Mb
Footer 0 ms 0.04 Mb
displayFooterAfter 0 ms 0.02 Mb
ActionBuildFrontEndObject 0 ms - Mb
DisplayOverrideTemplate 0 ms - Mb
ModuleRoutes 0 ms 0.02 Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayWrapperTop 0 ms - Mb
ActionDispatcherBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
DisplayNav2 0 ms - Mb
DisplayNav1 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayBanner 0 ms - Mb
31 hook(s) 568 ms 27.03 Mb
Module Time Memory Usage
codisto 8 ms 2.08 Mb
jmarketplace 14 ms 2.15 Mb
auction 6 ms 0.92 Mb
ets_savemycart 3 ms 0.92 Mb
ets_blog 17 ms 1.52 Mb
ps_mbo 2 ms 0.41 Mb
ets_delete_order 1 ms 0.20 Mb
ps_emailsubscription 6 ms 0.56 Mb
blockreassurance 1 ms 0.09 Mb
ps_emailalerts 2 ms 0.25 Mb
loyaltyeditpoints 12 ms 0.50 Mb
productcomments 64 ms 3.14 Mb
ps_imageslider 1 ms 0.27 Mb
ps_searchbar 5 ms 0.09 Mb
psxmarketingwithgoogle 2 ms 0.17 Mb
ps_googleanalytics 4 ms 0.20 Mb
rg_coppelpay 7 ms 0.52 Mb
oneclickcheckout 1 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 2 ms 0.13 Mb
ets_hotdeals 5 ms 0.23 Mb
ets_productnote 6 ms 0.37 Mb
ets_countdown 2 ms 0.13 Mb
ets_totalproduct_sold 23 ms 1.30 Mb
ph_social_links 2 ms 0.19 Mb
ets_securitycertification 10 ms 0.22 Mb
ets_recaptcha_free 1 ms 0.21 Mb
ybc_productimagehover 10 ms 0.07 Mb
ybc_nivoslider 2 ms 0.37 Mb
ets_testimonial 4 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 150 ms 9.32 Mb
ets_mostpopular 156 ms 6.10 Mb
creativepopup 11 ms 0.60 Mb
ets_cookie_banner 1 ms 0.13 Mb
ets_ageverification 3 ms 0.25 Mb
ets_saleticker 8 ms 0.47 Mb
rg_einvoicemx 2 ms 0.23 Mb
paypal 15 ms 1.02 Mb
mercadopago 3 ms 0.68 Mb
megapayment 12 ms 0.50 Mb
jsellerproductquestions 1 ms 0.11 Mb
jwishlist 24 ms 2.06 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 16 ms 0.91 Mb
skydropx 2 ms 0.21 Mb
ph_scrolltotop 4 ms 0.16 Mb
ets_addtocart_fromlist 8 ms 0.42 Mb
ph_sendproduct_tofriend 2 ms 0.22 Mb
ps_facetedsearch 15 ms 0.59 Mb
ps_contactinfo 4 ms 0.25 Mb
ps_languageselector 2 ms 0.10 Mb
ps_currencyselector 2 ms 0.07 Mb
ps_customersignin 1 ms 0.08 Mb
ps_mainmenu 11 ms 1.14 Mb
ps_categorytree 31 ms 0.95 Mb
ps_brandlist 4 ms 0.05 Mb
ps_supplierlist 7 ms 0.10 Mb
ps_linklist 31 ms 3.67 Mb
ps_customeraccountlinks 3 ms 0.16 Mb
statsdata 13 ms 0.52 Mb
69 module(s) 775 ms 49.91 Mb

Stopwatch SQL - 554 queries

Query Time (ms) Rows Filesort Group By Location
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>=1212 AND c.nright<=1213 GROUP BY p.id_product) p
208052 ms 273632 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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>=1212 AND c.nright<=1213 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_upd DESC, p.id_product DESC LIMIT 0, 60
197367 ms 273632 Yes /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
38923 ms 286557184 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_linklist" LIMIT 1
7672 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `pr_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
6595 ms 1 /src/Adapter/EntityMapper.php:76
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
6405 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`)
6329 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
6133 ms 764 Yes /modules/ps_categorytree/ps_categorytree.php:166
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
5848 ms 85 Yes /classes/order/OrderState.php:132
SELECT SQL_NO_CACHE *
FROM `pr_state` a
WHERE (a.`id_state` = 72) LIMIT 1
5058 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `pr_lang` l
LEFT JOIN `pr_lang_shop` ls ON (l.id_lang = ls.id_lang)
5012 ms 5 /classes/Language.php:1049
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` = 4081) AND (b.`id_shop` = 1) LIMIT 1
4787 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_searchbar" LIMIT 1
4150 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_configuration`
FROM `pr_configuration`
WHERE name = 'megapayment_HOME'
AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1
3862 ms 1 /classes/Configuration.php:121
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pr_image` i
INNER JOIN pr_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 30941
AND image_shop.`cover` = 1 LIMIT 1
3318 ms 1 /classes/Product.php:3542
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
3149 ms 997 /classes/Hook.php:504
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
3091 ms 0 /classes/Hook.php:1243
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
2977 ms 1 Yes /classes/SpecificPrice.php:561
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`
2878 ms 7760 Yes Yes /classes/Hook.php:1183
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pr_image` i
INNER JOIN pr_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 34317
ORDER BY `position`
2841 ms 4 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE 1 FROM `pr_specific_price` WHERE `from` BETWEEN '2023-12-04 00:00:00' AND '2023-12-04 23:59:59' LIMIT 1
2692 ms 1 /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_lang` FROM `pr_lang` WHERE `iso_code` = 'mx' LIMIT 1
2657 ms 5 /classes/Language.php:824
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
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_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4129)
2576 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE data FROM pr_layered_filter_block WHERE hash="4f284255fec169683dabc6897bf820e1" LIMIT 1
2348 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
SELECT SQL_NO_CACHE SUM(product_quantity) FROM `pr_order_detail` od
INNER JOIN `pr_orders` o ON (o.id_order=od.id_order)
WHERE od.product_id="34319" AND o.current_state IN (2,3,4,5,9,11,54,88,60,20,26,27,53,74) LIMIT 1
2327 ms 1 /modules/ets_totalproduct_sold/classes/ets_tps_defines.php:96
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 pr_shop_group gs
LEFT JOIN pr_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pr_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
2313 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
2274 ms 1 /classes/module/Module.php:2840
REPLACE INTO pr_layered_filter_block (hash, data) VALUES ("4f284255fec169683dabc6897bf820e1", "a:1:{s:7:\"filters\";a:0:{}}")
2267 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pr_product_attribute` pa
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (34321) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2211 ms 1 Yes Yes /classes/Product.php:4487
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_supplierlist" LIMIT 1
2108 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pr_product_attribute` pa
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (34317) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2054 ms 1 Yes Yes /classes/Product.php:4487
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pr_image` i
INNER JOIN pr_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 32846
AND image_shop.`cover` = 1 LIMIT 1
1981 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pr_product_attribute` pa
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4081) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1869 ms 1 Yes Yes /classes/Product.php:4487
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_mainmenu" LIMIT 1
1841 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_brandlist" LIMIT 1
1827 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `pr_country` a
LEFT JOIN `pr_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 3
LEFT JOIN `pr_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 144) LIMIT 1
1767 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pr_product_attribute` pa
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (27245) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1689 ms 1 Yes Yes /classes/Product.php:4487
SELECT SQL_NO_CACHE SUM(product_quantity) FROM `pr_order_detail` od
INNER JOIN `pr_orders` o ON (o.id_order=od.id_order)
WHERE od.product_id="34323" AND o.current_state IN (2,3,4,5,9,11,54,88,60,20,26,27,53,74) LIMIT 1
1669 ms 1 /modules/ets_totalproduct_sold/classes/ets_tps_defines.php:96
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pr_product_attribute` pa
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4091) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1663 ms 1 Yes Yes /classes/Product.php:4487
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
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_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 34319)
1626 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pr_feature_product pf
LEFT JOIN pr_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN pr_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN pr_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN pr_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4129
ORDER BY f.position ASC
1604 ms 1 Yes /classes/Product.php:5905
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_currencyselector" LIMIT 1
1553 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_categorytree" LIMIT 1
1522 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_languageselector" LIMIT 1
1503 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pr_feature_product pf
LEFT JOIN pr_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN pr_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN pr_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN pr_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 31195
ORDER BY f.position ASC
1403 ms 1 Yes /classes/Product.php:5905
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pr_feature_product pf
LEFT JOIN pr_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN pr_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN pr_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN pr_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 32846
ORDER BY f.position ASC
1399 ms 1 Yes /classes/Product.php:5905
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` = 34328 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` = 34328 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1382 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pr_feature_product pf
LEFT JOIN pr_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN pr_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN pr_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN pr_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 32830
ORDER BY f.position ASC
1380 ms 1 Yes /classes/Product.php:5905
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ets_ageverification" LIMIT 1
1329 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `pr_ets_blog_post` a
LEFT JOIN `pr_ets_blog_post_lang` `b` ON a.`id_post` = b.`id_post` AND b.`id_lang` = 3
WHERE (a.`id_post` = 3) LIMIT 1
1291 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pr_specific_price_priority`
WHERE `id_product` = 31195
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1285 ms 0 /classes/SpecificPrice.php:250
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ets_seo" LIMIT 1
1266 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM pr_shop_url su
LEFT JOIN pr_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.araysa.mx' OR su.domain_ssl = 'www.araysa.mx')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
1247 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE SUM(product_quantity) FROM `pr_order_detail` od
INNER JOIN `pr_orders` o ON (o.id_order=od.id_order)
WHERE od.product_id="32830" AND o.current_state IN (2,3,4,5,9,11,54,88,60,20,26,27,53,74) LIMIT 1
1234 ms 1 /modules/ets_totalproduct_sold/classes/ets_tps_defines.php:96
SELECT SQL_NO_CACHE SUM(product_quantity) FROM `pr_order_detail` od
INNER JOIN `pr_orders` o ON (o.id_order=od.id_order)
WHERE od.product_id="4091" AND o.current_state IN (2,3,4,5,9,11,54,88,60,20,26,27,53,74) LIMIT 1
1225 ms 1 /modules/ets_totalproduct_sold/classes/ets_tps_defines.php:96
SELECT SQL_NO_CACHE SUM(product_quantity) FROM `pr_order_detail` od
INNER JOIN `pr_orders` o ON (o.id_order=od.id_order)
WHERE od.product_id="34320" AND o.current_state IN (2,3,4,5,9,11,54,88,60,20,26,27,53,74) LIMIT 1
1195 ms 1 /modules/ets_totalproduct_sold/classes/ets_tps_defines.php:96
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pr_product_shop`
WHERE `id_product` = 34322 AND id_shop=1 LIMIT 1
1194 ms 1 /classes/Product.php:6759
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
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_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 28970)
1193 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ets_newproducts" LIMIT 1
1190 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE name FROM pr_customer_wishlist cw
LEFT JOIN `pr_customer_wishlist_product` cwp ON (cwp.`id_customer_wishlist` = cw.`id_customer_wishlist`) 
WHERE id_product = 32830 
AND id_customer != 0 
GROUP BY name
ORDER BY name DESC
1176 ms 2 Yes Yes /modules/jwishlist/classes/CustomerWishlist.php:341
SELECT SQL_NO_CACHE *
FROM `pr_ets_blog_post` a
LEFT JOIN `pr_ets_blog_post_lang` `b` ON a.`id_post` = b.`id_post` AND b.`id_lang` = 3
WHERE (a.`id_post` = 1) LIMIT 1
1170 ms 1 /src/Adapter/EntityMapper.php:76
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')
1162 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pr_product_attribute` pa
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (32830) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1160 ms 1 Yes Yes /classes/Product.php:4487
SELECT SQL_NO_CACHE count(*) as total_post,YEAR(p.date_add) as year_add 
FROM `pr_ets_blog_post` p
WHERE p.id_shop= "1" AND p.enabled=1 GROUP BY year_add ORDER BY year_add DESC
1127 ms 3 Yes /modules/ets_blog/classes/Ets_blog_post.php:331
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pr_product_attribute` pa
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (31195) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1109 ms 1 Yes Yes /classes/Product.php:4487
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` = 4081 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
1094 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *
FROM `pr_lang` a
LEFT JOIN `pr_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 3) LIMIT 1
1074 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pr_image` i
INNER JOIN pr_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 34322
AND image_shop.`cover` = 1 LIMIT 1
1073 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pr_image` i
INNER JOIN pr_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 34319
AND image_shop.`cover` = 1 LIMIT 1
1057 ms 4 /classes/Product.php:3542
SELECT SQL_NO_CACHE 1 FROM `pr_specific_price` WHERE id_product = 34328 LIMIT 1
1056 ms 1 /classes/SpecificPrice.php:420