motherboard iPhone 12 PRO MAX main logic Without iCloud
motherboard iPhone 12 PRO MAX main logic Without iCloud
Close

motherboard iPhone 12 PRO MAX main logic Without iCloud

Iphone 12 PRO MAX motherboard tested 100% functional Face ID OK
 

Our offer includes :

1 x motherboard iPhone X 128 or 256 GB
 


Capacity  : 128 GB or 256 GB of memory
Face ID  : with FACE ID
Compatible with : Apple iPhone 12 PRO MAX

 

ICloud
Operation in all countries
No blacklisted
delivered alone and without FACE ID or with front camera and thus AVEC FACE functional ID (because the FACE ID is a parent card camera association that is not editable or substituteable).

 

 

Reconditioned motherboard -- Original QUALITY - Face ID FONCTIONNEL

 


 

you need one Screen Macbook pro quality of origin is here

 

 

More details

$ 349.00

20 Products

new - Guaranteed 12 months

To complete your order

  • Cheap Incell lcd iPhone 11 screen - Kit lcd screen + assembled touch screen
    Screen complete iPhone 11 LCD INCELL Envoy of France Free 24H Our offer includes : Repair kit Screen iPhone 11 Screen Oled + Touch glass assembled + Opening set + Protective glass Colour   : Black You have broken the'Screen iPhone 11 your device? You can no longer select your apps because the touch bug? TheScreen remains black despite your ignition attempts? This is the sign that you need a new Screen no more. To replace theScreen your smartphone, go to Discountmyobile and buy this Kit Screen iPhone 11 new, complete, assembled and easy to install. The Kit already contains the tools necessary to install your new Screen. Tournevis, suction cup, clamp, spatula, adhesive... As a gift, you will also receive a protective tempered glass glass that will provide better safety to your Screen. Theuse of your smartphone iPhone 11 will again be comfortable with a touch that works very well as a Screen without any crack.
    Cheap Incell lcd iPhone 11 screen - Kit lcd screen + assembled touch screen
    $ 24.00
  • iPhone 12/12 PRO screen - Incell sends from France + tools
    full screen iPhone 12 or 12 PRO Incell FRANCE SUB 24H Colour   : Black   Our offer includes : Repair Kit iPhone 12/12 PRO Incell LCD + Touch glass + Tool Set + Protective glass FRANCE SUB 24H   Your sublime iPhone 12 256 GO has been hit by a nightlife! , fallen on the ground with its scrambled screen ... You will remember this evening!You now have to change the screen and this is where we intervene with our NEUF Repair Kit offered here at the best price, so wait no longer and order today.OFFERS everywhere.  
    iPhone 12/12 PRO screen - Incell sends from France + tools
    $ 38.00
  • iphone 13 Mini HARD OLED + touchscreen iPhone 13 Mini original quality
    Switched to full screen iPhone 13 MINI Hard OLED Send by France Free 24H Our offer includes : Repair kit iPhone 13 MINI OLED Colormax display + Assembly touch glass + Opening set + Protective glass Colour : Black the iphone 13MINI offers a resolution of 1080 x 2340 Pixels and a size of 5.4 inches, screen and broken following a fall Replace it by this complete block glass + quality display identical to the official screen Apple iPhone 13 MINI HARD OLED . As a gift, you will also receive a protective tempered glass glass that will provide better security to your screen. Use of your iPhone smartphone 13 MINI will again be comfortable with a touch that works very well as a screen without any crack.
    iphone 13 Mini HARD OLED + touchscreen iPhone 13 Mini original quality
    $ 108.00
  • IPhone 7 Plus screen - Kit Screen LCD + touch glass assembly
    Screen complete iPhone 7 Plus   Repair your Screen broken iPhone 7 plus in the best possible conditions with our Repair Kit Screen 100% new available at the best price. Colour   : Black or white For models A1661 / A1784 / A1785   Our offer includes : Repair kit Screen iPhone 7 Plus LCD + Touch glass + Opening set + Protective glass   Your iPhone 7 Plus a very large Screen 5.5 inches, it can easily slip from your hand and fall on the ground.THEScreen broke.You want without delay, give a new look to your iPhone . Discountmymobile offers you this complete repair kit.
    IPhone 7 Plus screen - Kit Screen LCD + touch glass assembly
    $ 24.00
  • IPhone 7 screen display LCD + touch glass assembly
    full screen iPhone 7 cheap   Give back the look of his first days to your precious iPhone 7 with and screen 100% new and guaranteed.Optimum quality and delivery available! Colour : Black or white For models A1660 / A1778 / A1779   Our offer includes : Repair kit iPhone 7 screen LCD + Touch glass + Tools Kit dismantling + tempered glass glass    
    IPhone 7 screen display LCD + touch glass assembly
    $ 22.00
  • Ecran iPhone 6S Plus - Screen Kit LCD + touch glass assembly
    repair screen for iPhone 6SCheaper   Change your broken glass iphone 6S Plus is possible and easy thanks to our complete screen + new and guaranteed replacement touch. Colour   : Black or white For models A1634 / A1687 / A1699   Our offer includes : Repair kit iPhone 6S Plus screen LCD + Touch glass + Tools Kit + Tempered glass in Gift  
    Ecran iPhone 6S Plus - Screen Kit LCD + touch glass assembly
    $ 24.00
  • Screen iPhone 6S - Kit Screen LCD + touch glass assembly
    Screen complete iPhone 6s at discount prices   There's no need to spend some crazy money on a repairman.With this Screen all new, easy repair your smartphone Apple iPhone 6s .   Colour   : Black or white For models A1633 / A1688 / A1700   Our offer includes : Repair kit Screen iPhone 6S LCD + Touch glass + Gift dismantling tool kit   Our repair kit Screen iPhone 6s will be perfect for you!After repeated falls, theScreen your smartphone iPhone 6S don't end up breaking...Your small means do not allow you to spend a fortune at a repairer, so our kit Screen complete iPhone 6S, cheap is perfect for you!Free!
    Screen iPhone 6S - Kit Screen LCD + touch glass assembly
    $ 20.00
  • IPhone 6 Plus screen display LCD + touch glass assembly
    full screen iPhone 6 Plus   Superb screen to repair your broken window Apple iPhone 6 Plus for cheap.Enjoy the shipping costs offered throughout Europe. Colour   : Black or white For models A1522 / A1524 / A1593   Our offer includes : Repair kit iPhone 6 Plus screen LCD + Touch glass + tools 7 dismantling pieces + tempered glass  
    IPhone 6 Plus screen display LCD + touch glass assembly
    $ 24.00
  • Screen iPhone 6 - Kit Screen LCD + touch glass assembly
    iPhone 6 repair screen   repair of your iPhone 6 is now possible without going through Apple's services.Order this new screen to restore your iPhone 6 in good condition.   Colour   : Black or white For models A1549 / A1586 / A1589   Our offer includes : Repair kit iPhone 6 screen LCD + Touch glass + tools +Protective tempered glass Your smartphone Apple iPhone 6 fell out of your pocket.The glass is all broken and it is difficult for you to use it.It is time to order a new screen in our shop to give it its appearance of the first days.Our repair kit includes the assembled complete screen and its dismantling tools.
    Screen iPhone 6 - Kit Screen LCD + touch glass assembly
    $ 18.00
  • IPhone 5C screen display LCD + touch glass assembly
    full screen iPhone 5C cheap   Repair easily the broken glass of your iPhone 5C with this brand new and guaranteed screen.Tested before shipment!   Colour   : Black For models A1456 / A1507 / A1529 / A1532   Our offer includes : Repair kit iPhone 5C screen LCD + Touch glass + set tools and tempered glass Available  
    IPhone 5C screen display LCD + touch glass assembly
    $ 16.00
  • IPhone 5S screen display LCD + touch glass assembly
    full screen iPhone 5S cheap   Refill your iPhone 5s on the broken screen with this new and guaranteed screen.Needless to separate from yours iPhone 5S, just replace the screen.   Colour   : Black or white For models (A1453 / A1457 / A1518 / A1528 / A1530 / A1533)   Our offer includes : Repair kit iPhone 5S screen LCD + Touch glass + tools + tempered glass glass  
    IPhone 5S screen display LCD + touch glass assembly
    $ 16.00
  • IPhone 5 screen display LCD + touch glass assembly
    full screen iPhone 5   Superb brand new replacement screen to repair your screen iPhone 5 broken.   Colour   : Black or white For models A1428 / A1429 / A1442   Our offer includes : Repair kit iPhone 5 screen LCD + Touch glass + screwdriver + spatula + adhesive and tempered glass  
    IPhone 5 screen display LCD + touch glass assembly
    $ 16.00

 

Grade Reconditioned & tested
Brand Apple
Model iPhone 12 Pro Max
Type of device Mobile
Type of product Motherboard
Condition Reconditioned to new
Warranty 6 Months
Cart 0 Shopping Cart

No products

Free shipping! Shipping
$ 0.00 Total

Check out

Load Time3050 ms - You'd better run your shop on a toaster
Querying Time1699 ms
Queries497
Memory Peak Usage17.0 Mb
Included Files522 files - 10.55 Mb
PrestaShop Cache- Mb
Global vars0.84 Mb
PrestaShop Version1.6.1.24
PHP Version7.2.34 (OK)
MySQL Version11.4.2-MariaDB (OK)
Memory Limit512M
Max Execution Time300s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 350 ms 350 ms 4.88 Mb 8.77 Mb
__construct 0 ms 350 ms - Mb 8.77 Mb
init 65 ms 415 ms 2.41 Mb 8.77 Mb
checkAccess 0 ms 415 ms - Mb 8.77 Mb
setMedia 5 ms 420 ms 0.07 Mb 8.77 Mb
postProcess 0 ms 420 ms - Mb 8.77 Mb
initHeader 0 ms 420 ms - Mb 8.77 Mb
initContent 2540 ms 2960 ms 8.16 Mb 16.48 Mb
initFooter 10 ms 2970 ms 0.21 Mb 16.48 Mb
display 80 ms 3050 ms 0.91 Mb 16.98 Mb
Hook Time Memory Usage
hookdisplayProductButtons 1205 ms - Mb
__construct 650 ms - Mb
hookdisplayHeader 37 ms - Mb
hookproducttabcontent 30 ms - Mb
hookproducttab 21 ms - Mb
hookactionDispatcher 12 ms - Mb
hookHeader 8 ms - Mb
hookdisplayRightColumnProduct 7 ms - Mb
hookactionProductOutOfStock 5 ms - Mb
hookextraright 4 ms - Mb
hookdisplayFooter 3 ms - Mb
hookdisplayFooterTop 3 ms - Mb
hookfooter 3 ms - Mb
hookmoduleRoutes 2 ms - Mb
hookdisplayFooterProduct 2 ms - Mb
hookactionFrontControllerSetMedia 1 ms - Mb
hookdisplaySideMobile 1 ms - Mb
hookdisplayTopCart 1 ms - Mb
hookdisplayFooterBottom 1 ms - Mb
hookdisplayFooterLeft 1 ms - Mb
hooktop 1 ms - Mb
hookdisplayMenu 1 ms - Mb
hookdisplayFooterCopyright 1 ms - Mb
hookproductactions 1 ms - Mb
hookdisplayFooterRightNews 1 ms - Mb
hookdisplayMegaMenu 1 ms - Mb
hookdisplayAccount 1 ms - Mb
hookdisplayTop 0 ms - Mb
hookdisplayTopSearch 0 ms - Mb
hookdisplayLeftColumnProduct 0 ms - Mb
hookdisplayTopColumn - ms - Mb
hookdisplayLeftColumn - ms - Mb
32 hooks 2001 ms - Mb
Module Time Memory Usage
additionalproductsorder 1204 ms - Mb
mailalerts 605 ms - Mb
lgcomments 55 ms - Mb
ets_livechat 30 ms - Mb
ets_megamenu 16 ms - Mb
etseofriendlyurl 13 ms - Mb
med_blocklanguages 10 ms - Mb
ets_affiliatemarketing 7 ms - Mb
royblocknewsletter 5 ms - Mb
productpaymentlogos 5 ms - Mb
roybanners 5 ms - Mb
responsiveiframe 4 ms - Mb
ps_googleanalytics 4 ms - Mb
ybc_blocksearch 3 ms - Mb
colissimo 3 ms - Mb
lgcanonicalurls 3 ms - Mb
w4wfaq 2 ms - Mb
royblockcart 2 ms - Mb
smartblog 2 ms - Mb
mondialrelay 2 ms - Mb
royblockuserinfo 2 ms - Mb
blockwishlist 1 ms - Mb
oparteasyredirect 1 ms - Mb
jprestawebp 1 ms - Mb
blockcms 1 ms - Mb
stripe_official 1 ms - Mb
royblocksocial 1 ms - Mb
abandonedcart 1 ms - Mb
azmegamenu 1 ms - Mb
roypaymentlogo 1 ms - Mb
roythemescustomizer 1 ms - Mb
paypalwithfee 1 ms - Mb
ICodePSLibrary 1 ms - Mb
tinymcepro 0 ms - Mb
opartnoindex 0 ms - Mb
blocksupplier 0 ms - Mb
deliveryorderautoupdate 0 ms - Mb
blocksearch 0 ms - Mb
royblocklayered 0 ms - Mb
ets_multilayerslider 0 ms - Mb
roybrands 0 ms - Mb
pagesnotfound 0 ms - Mb
roylevibox 0 ms - Mb
royfeatured 0 ms - Mb
royspecials 0 ms - Mb
roynewproducts 0 ms - Mb
blockmyaccount 0 ms - Mb
royhomecategory3 0 ms - Mb
royhomecategory1 0 ms - Mb
blockmyaccountfooter 0 ms - Mb
blockuserinfo 0 ms - Mb
blockcart 0 ms - Mb
royhomecategory5 0 ms - Mb
royhomecategory4 0 ms - Mb
royhomecategory2 0 ms - Mb
royhomecategory6 0 ms - Mb
56 modules 2001 ms - Mb

Stopwatch SQL - 497 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9)
WHERE i.`id_product` = 1046
AND image_shop.`cover` = 1 LIMIT 1
483.3 5 /classes/Product.php:2747
SELECT SQL_NO_CACHE DISTINCT               
apo.`id`, `name`, `short_description`, 
`id_related_category`, `id_related_product`,
displayed_category_product.`id_product` as `displayed_category_id_product`,
displayed_products_list.`id_displayed_product` as `displayed_lists_id_product`,
`minimum_amount`, `maximum_amount`, `is_active_groups`
FROM `ps_lineven_apo` apo
LEFT JOIN `ps_category_product` related_category ON (related_category.`id_category` = apo.`id_related_category`)
LEFT JOIN `ps_category_shop` as related_category_shop ON (related_category.`id_category` = related_category_shop.`id_category` AND related_category_shop.`id_shop` = 9)
LEFT JOIN `ps_category_product` displayed_category_product ON (displayed_category_product.`id_category` = apo.`id_displayed_category`)
LEFT JOIN `ps_category_shop` as displayed_category_product_shop ON (displayed_category_product.`id_category` = displayed_category_product_shop.`id_category` AND displayed_category_product_shop.`id_shop` = 9) 
LEFT JOIN `ps_lineven_apo_displayed_products` displayed_products_list ON (apo.`id` = displayed_products_list.`id_association`)  LEFT JOIN `ps_lineven_apo_groups` apo_groups
ON (apo.`id` = apo_groups.`id_association`) WHERE ((apo.`id_shop_group` is null and apo.`id_shop` is null) or (apo.`id_shop_group` = 1 
and apo.`id_shop` is null) or (apo.`id_shop` = 9)) AND (apo.`is_active_groups` = 0 OR (apo.`is_active_groups` = 1 AND 
apo_groups.`id_group` in (1)))  AND ((apo.`minimum_amount` = 0 OR apo.`minimum_amount` <= 0)
AND (apo.`maximum_amount` = 0 OR apo.`maximum_amount` >= 0)) AND (NULLIF(apo.`hooks`, '') IS NULL OR apo.`hooks` LIKE ('%OEP%'))  
AND (
(
apo.`id_related_category` is null AND apo.`id_related_product` is null
)OR
(
apo.`id_related_category` is not null AND
related_category.`id_product` in (15627) 
) OR
(
apo.`id_related_product` is not null AND
apo.`id_related_product` in (15627)
)
) 
ORDER BY apo.`order_display` ASC, displayed_products_list.`order_display` ASC
454.3 42050 Yes /modules/additionalproductsorder/classes/product/CrossSellingProductsSearch.php:305
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
262.9 8705 /classes/Configuration.php:148
SELECT SQL_NO_CACHE DISTINCT               
apo.`id`, `name`, `short_description`, 
`id_related_category`, `id_related_product`,
displayed_category_product.`id_product` as `displayed_category_id_product`,
displayed_products_list.`id_displayed_product` as `displayed_lists_id_product`,
`minimum_amount`, `maximum_amount`, `is_active_groups`
FROM `ps_lineven_apo` apo
LEFT JOIN `ps_category_product` related_category ON (related_category.`id_category` = apo.`id_related_category`)
LEFT JOIN `ps_category_shop` as related_category_shop ON (related_category.`id_category` = related_category_shop.`id_category` AND related_category_shop.`id_shop` = 9)
LEFT JOIN `ps_category_product` displayed_category_product ON (displayed_category_product.`id_category` = apo.`id_displayed_category`)
LEFT JOIN `ps_category_shop` as displayed_category_product_shop ON (displayed_category_product.`id_category` = displayed_category_product_shop.`id_category` AND displayed_category_product_shop.`id_shop` = 9) 
LEFT JOIN `ps_lineven_apo_displayed_products` displayed_products_list ON (apo.`id` = displayed_products_list.`id_association`)  LEFT JOIN `ps_lineven_apo_groups` apo_groups
ON (apo.`id` = apo_groups.`id_association`) WHERE ((apo.`id_shop_group` is null and apo.`id_shop` is null) or (apo.`id_shop_group` = 1 
and apo.`id_shop` is null) or (apo.`id_shop` = 9)) AND (apo.`is_active_groups` = 0 OR (apo.`is_active_groups` = 1 AND 
apo_groups.`id_group` in (1)))  AND ((apo.`minimum_amount` = 0 OR apo.`minimum_amount` <= 0)
AND (apo.`maximum_amount` = 0 OR apo.`maximum_amount` >= 0)) AND (NULLIF(apo.`hooks`, '') IS NULL OR apo.`hooks` LIKE ('%OEP%'))  
AND (
(
apo.`id_related_category` is null AND apo.`id_related_product` is null
)OR
(
apo.`id_related_category` is not null AND
related_category.`id_product` in (15627) 
) OR
(
apo.`id_related_product` is not null AND
apo.`id_related_product` in (15627)
)
) 
ORDER BY apo.`order_display` ASC, displayed_products_list.`order_display` ASC
47.7 42050 Yes /modules/additionalproductsorder/classes/product/CrossSellingProductsSearch.php:305
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
35.9 8705 /classes/Configuration.php:148
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 12952) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
34.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
31.9 8705 /classes/Configuration.php:148
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
22 8705 /classes/Configuration.php:148
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
20.9 8705 /classes/Configuration.php:148
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 9) LIMIT 1
17.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1036) AND (id_product_attribute = 1292) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
15.7 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE pl.`id_product`
FROM `ps_product_lang` pl
WHERE `id_lang` = 2
AND pl.id_shop = 9 
AND pl.`link_rewrite` = 'iphone-12-pro-max-master-logic-card-without-icloud' LIMIT 1
11.4 31711 /modules/etseofriendlyurl/etseofriendlyurl.php:128
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
11.1 2 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1043) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
8.5 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
MAX(product_attribute_shop.id_product_attribute) 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`, MAX(image_shop.`id_image`) id_image,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
INTERVAL 550
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute` pa
ON (p.`id_product` = pa.`id_product`)
LEFT JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 9 )
LEFT JOIN `ps_image` i
ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9 AND image_shop.cover=1)
WHERE product_shop.`id_shop` = 9
AND product_shop.`visibility` IN ("both","catalog","search")
AND product_shop.`active` = 1
AND product_shop.`available_for_order` = 1
AND p.`id_product` in (13050,12952,16112,1036,1037,1039,1041,1043,1045,1046,1048,1050,6036,7746,7747,7749,6773,6775,6776,6777,6781,7051,7052,7053,7054,7049,7048,7047,7120,7064,6780,7766,7767,7768,7769,7770)
GROUP BY product_shop.id_product
ORDER BY  FIND_IN_SET(p.`id_product`, '13050,12952,16112,1036,1037,1039,1041,1043,1045,1046,1048,1050,6036,7746,7747,7749,6773,6775,6776,6777,6781,7051,7052,7053,7054,7049,7048,7047,7120,7064,6780,7766,7767,7768,7769,7770')
8.4 756 Yes /modules/additionalproductsorder/classes/product/CrossSellingProductsSearch.php:424
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1036) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
7.7 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1292,1293)
GROUP BY pac.id_product_attribute
7.7 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
7.6 2 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
MAX(product_attribute_shop.id_product_attribute) 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`, MAX(image_shop.`id_image`) id_image,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
INTERVAL 550
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute` pa
ON (p.`id_product` = pa.`id_product`)
LEFT JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 9 )
LEFT JOIN `ps_image` i
ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9 AND image_shop.cover=1)
WHERE product_shop.`id_shop` = 9
AND product_shop.`visibility` IN ("both","catalog","search")
AND product_shop.`active` = 1
AND product_shop.`available_for_order` = 1
AND p.`id_product` in (13050,12952,16112,1036,1037,1039,1041,1043,1045,1046,1048,1050,6036,7746,7747,7749,6773,6775,6776,6777,6781,7051,7052,7053,7054,7049,7048,7047,7120,7064,6780,7766,7767,7768,7769,7770)
GROUP BY product_shop.id_product
ORDER BY  FIND_IN_SET(p.`id_product`, '13050,12952,16112,1036,1037,1039,1041,1043,1045,1046,1048,1050,6036,7746,7747,7749,6773,6775,6776,6777,6781,7051,7052,7053,7054,7049,7048,7047,7120,7064,6780,7766,7767,7768,7769,7770')
5.8 756 Yes /modules/additionalproductsorder/classes/product/CrossSellingProductsSearch.php:424
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
5.5 2621 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 9 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 9) AND (mg.`id_shop` = 9 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
5.2 8960 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1041) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
4.8 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1041) AND (id_product_attribute = 1287) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
3.8 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (9)
3.4 7221 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 12952 AND id_shop=9 LIMIT 1
2.8 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE name FROM ps_product_lang WHERE id_product = 15627 AND id_lang = 2 LIMIT 1
2.7 1 /modules/lgcomments/lgcomments.php:890
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 2 AND stars < 4 LIMIT 1
2.7 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE *
FROM `ps_roybanners`
WHERE id_shop = 9 AND id_lang = 2
AND hook = 'footertop' AND active = 1
ORDER BY item_order ASC
2.6 110 Yes /modules/roybanners/roybanners.php:413
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 LIMIT 1
2.5 1847 /modules/lgcomments/lgcomments.php:856
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.id_product = 15627 LIMIT 1
2.5 4 /classes/Product.php:752
SELECT SQL_NO_CACHE date_format_lite FROM ps_lang WHERE id_lang = 2 LIMIT 1
2.2 1 /modules/lgcomments/lgcomments.php:1018
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 9)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.1 740 /classes/Hook.php:235
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 15627) AND (b.`id_shop` = 1) LIMIT 1
2.1 1 /Adapter/Adapter_EntityMapper.php:61
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 16112)
2 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.id_product = 1046 LIMIT 1
2 1 /classes/Product.php:752
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 16112
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.9 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 9 
AND cl.`id_category` = 2309 LIMIT 1
1.9 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1045) AND (b.`id_shop` = 9) LIMIT 1
1.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='1cd6cdb657de11b7de0a850608036e1c' AND cache_id="productpaymentlogos|1|9|1|1|3|21" AND compile_id="" LIMIT 1
1.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 2 AND stars < 4 LIMIT 1
1.8 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 16112) AND (b.`id_shop` = 9) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND id_lang = 2 AND active = 1 LIMIT 1
1.7 1847 /modules/lgcomments/lgcomments.php:879
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 12952) AND (b.`id_shop` = 9) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 9)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1.5 244 Yes /classes/Country.php:130
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1045)
1.5 2 /classes/Product.php:3002
SELECT SQL_NO_CACHE f.*, fl.title,fl.description,fl.button_submit_label,fl.friendly_url,fl.meta_title,fl.meta_description,fl.meta_keywords
FROM `ps_ets_livechat_ticket_form` f 
LEFT JOIN `ps_ets_livechat_ticket_form_lang` fl ON f.id_form=fl.id_form AND fl.id_lang=2
WHERE f.deleted=0  AND f.id_form!=1 GROUP BY f.id_form ORDER BY f.sort_order asc
1.4 2 Yes Yes /modules/ets_livechat/classes/LC_Ticket_form.php:267
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 4 AND stars < 6 LIMIT 1
1.4 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1046) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
1.3 1 /classes/shop/Shop.php:202
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 LIMIT 1
1.3 1847 /modules/lgcomments/lgcomments.php:856
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 8 AND stars < 10 LIMIT 1
1.3 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.2 364 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.id_product = 12952 LIMIT 1
1.2 1 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1045) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
1.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
1.1 168 Yes /classes/Dispatcher.php:452
UPDATE `ps_configuration` SET `value` = NULL,`date_upd` = '2025-05-08 00:50:26' WHERE `name` = 'PS_ROUTE_livechatformnoid' AND id_shop = 9 LIMIT 1
1.1 1 /classes/Configuration.php:418
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15627) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 16112) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 9)
WHERE c.`active` = 1 LIMIT 1
1 6 /classes/Currency.php:470
SELECT SQL_NO_CACHE f.id_form,fl.title,fl.button_link_contact_label as button_label FROM `ps_ets_livechat_ticket_form` f
LEFT JOIN `ps_ets_livechat_ticket_form_lang` fl ON (f.id_form=fl.id_form AND fl.id_lang="2")
WHERE f.id_form > 1 AND f.display_input_product=1
1 1 /modules/ets_livechat/classes/LC_Ticket_form.php:508
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1282,1283)
GROUP BY pac.id_product_attribute
1 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 9
LIMIT 1
) as mshop
FROM `ps_module` m
1 137 /classes/module/Module.php:277
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
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
1 0 /classes/tax/TaxRulesTaxManager.php:108
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 13050)
0.9 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE pc.*, CONCAT(c.firstname, ' ', (SUBSTRING(c.lastname,1,1)), '.') as customer FROM ps_lgcomments_productcomments pc LEFT JOIN ps_customer as c ON pc.id_customer = c.id_customer WHERE pc.id_product = 15627 AND pc.id_lang = 2 AND pc.active = 1 ORDER BY pc.position DESC
0.9 1847 Yes /modules/lgcomments/lgcomments.php:833
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1046
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.9 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 13050 AND `id_group` = 1 LIMIT 1
0.9 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM ps_cms c
INNER JOIN ps_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=9)
LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=2
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
0.9 84 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2535
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "w4wfaq" LIMIT 1
0.9 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 12952) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.9 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE pc.*, CONCAT(c.firstname, ' ', (SUBSTRING(c.lastname,1,1)), '.') as customer FROM ps_lgcomments_productcomments pc LEFT JOIN ps_customer as c ON pc.id_customer = c.id_customer WHERE pc.id_product = 15627 AND pc.id_lang = 2 AND pc.active = 1 ORDER BY pc.position DESC
0.8 1847 Yes /modules/lgcomments/lgcomments.php:833
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 13050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 9 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 9)
WHERE pl.id_lang = 2
AND pl.id_product = 15627
AND product_shop.active = 1 LIMIT 1
0.8 1 /override/classes/Meta.php:259
SELECT SQL_NO_CACHE date_format_lite FROM ps_lang WHERE id_lang = 2 LIMIT 1
0.8 1 /modules/lgcomments/lgcomments.php:1018
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 9 
AND cl.`id_category` = 2291 LIMIT 1
0.8 1 /classes/Category.php:1054
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND cr.date_from < "2025-05-08 00:50:26"
AND cr.date_to > "2025-05-08 00:50:26"
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND cr.date_from < "2025-05-08 00:50:26"
AND cr.date_to > "2025-05-08 00:50:26"
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
0.8 1 /classes/CartRule.php:291
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 16112) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1043) AND (b.`id_shop` = 9) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE date_format_lite FROM ps_lang WHERE id_lang = 2 LIMIT 1
0.8 1 /modules/lgcomments/lgcomments.php:1018
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
0.8 0 /classes/Manufacturer.php:246
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 92 AND `id_shop` = 9 LIMIT 1
0.7 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND id_lang = 2 AND active = 1 LIMIT 1
0.7 1847 /modules/lgcomments/lgcomments.php:879
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
0.7 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 15627
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 8 Yes Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 4 AND stars < 6 LIMIT 1
0.7 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 LIMIT 1
0.7 1847 /modules/lgcomments/lgcomments.php:856
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 `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 9)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 9 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 2291
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 13050) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 2 AND stars < 4 LIMIT 1
0.7 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 0 AND stars < 2 LIMIT 1
0.7 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocksearch" LIMIT 1
0.7 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1045
AND pac.`id_product_attribute` = 1282
AND agl.`id_lang` = 2
0.7 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 6 AND stars < 8 LIMIT 1
0.7 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 15627
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 8 Yes Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE pc.*, CONCAT(c.firstname, ' ', (SUBSTRING(c.lastname,1,1)), '.') as customer FROM ps_lgcomments_productcomments pc LEFT JOIN ps_customer as c ON pc.id_customer = c.id_customer WHERE pc.id_product = 15627 AND pc.id_lang = 2 AND pc.active = 1 ORDER BY pc.position DESC
0.6 1847 Yes /modules/lgcomments/lgcomments.php:833
SELECT SQL_NO_CACHE COUNT(id_lgcomments_productcomments) FROM ps_lgcomments_productcomments WHERE id_customer = 0 AND id_product = 15627 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:912
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.6 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 8 AND stars < 10 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE pc.*, CONCAT(c.firstname, ' ', (SUBSTRING(c.lastname,1,1)), '.') as customer FROM ps_lgcomments_productcomments pc LEFT JOIN ps_customer as c ON pc.id_customer = c.id_customer WHERE pc.id_product = 15627 AND pc.id_lang = 2 AND pc.active = 1 ORDER BY pc.position DESC
0.6 1847 Yes /modules/lgcomments/lgcomments.php:833
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1045) AND (id_product_attribute = 1283) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND id_lang = 2 AND active = 1 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:879
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1045) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 0 AND stars < 2 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 10 AND stars < 11 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(id_lgcomments_productcomments) FROM ps_lgcomments_productcomments WHERE id_customer = 0 AND id_product = 15627 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:912
SELECT SQL_NO_CACHE COUNT(id_lgcomments_productcomments) FROM ps_lgcomments_productcomments WHERE id_customer = 0 AND id_product = 15627 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:912
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, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-05-08 00:00:00",
INTERVAL 550 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_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=9)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 9 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 9 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=9)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 15627 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.6 1 Yes /classes/Product.php:3602
SELECT SQL_NO_CACHE COUNT(id_lgcomments_productcomments) FROM ps_lgcomments_productcomments WHERE id_customer = 0 AND id_product = 15627 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:912
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 4 AND stars < 6 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE f.*, fl.title,fl.description,fl.button_submit_label,fl.friendly_url,fl.meta_title,fl.meta_description,fl.meta_keywords
FROM `ps_ets_livechat_ticket_form` f 
LEFT JOIN `ps_ets_livechat_ticket_form_lang` fl ON f.id_form=fl.id_form AND fl.id_lang=2
WHERE f.deleted=0  AND f.active=1 AND f.id_form!=1 GROUP BY f.id_form ORDER BY f.sort_order asc
0.6 2 Yes Yes /modules/ets_livechat/classes/LC_Ticket_form.php:267
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1046) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 6 AND stars < 8 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:856
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 10 AND stars < 11 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND id_lang = 2 AND active = 1 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:879
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 0 AND stars < 2 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1048) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 6 AND stars < 8 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND id_lang = 2 AND active = 1 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:879
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:856
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 10 AND stars < 11 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 10 AND stars < 11 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND id_lang = 2 AND active = 1 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:879
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:856
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 4 AND stars < 6 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
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 `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 9)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 9 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 2291
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 6 AND stars < 8 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 0 AND stars < 2 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
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, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-05-08 00:00:00",
INTERVAL 550 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_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=9)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 9 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 9 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=9)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 15627 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.6 1 Yes /classes/Product.php:3602
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1045
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.6 1 /classes/SpecificPrice.php:196
UPDATE `ps_configuration` SET `value` = NULL,`date_upd` = '2025-05-08 00:50:26' WHERE `name` = 'PS_ROUTE_livechatform' AND id_shop = 9 LIMIT 1
0.6 1 /classes/Configuration.php:418
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 8 AND stars < 10 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 2 AND stars < 4 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 15627 AND active = 1 AND id_lang = 2 AND stars >= 8 AND stars < 10 LIMIT 1
0.6 1847 /modules/lgcomments/lgcomments.php:806
SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name ="ets_livechat" LIMIT 1
0.6 1 /modules/ets_livechat/classes/LC_Base.php:1891
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1050) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE DISTINCT g.`id_group`, g.`reduction`, g.`price_display_method`, gl.`name`
FROM `ps_group` g
LEFT JOIN `ps_group_lang` AS gl ON (g.`id_group` = gl.`id_group` AND gl.`id_lang` = 2)
ORDER BY g.`id_group` ASC
0.5 6 /classes/Group.php:92
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 9
LIMIT 1
) as mshop
FROM `ps_module` m
0.5 137 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 9
LIMIT 1
) as mshop
FROM `ps_module` m
0.5 137 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15627) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1041) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15627) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 9
LIMIT 1
) as mshop
FROM `ps_module` m
0.5 137 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 9
LIMIT 1
) as mshop
FROM `ps_module` m
0.5 137 /classes/module/Module.php:277
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1045 AND id_shop=9 LIMIT 1
0.5 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1037) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 9 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.5 168 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15627) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1039) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.id_product = 13050 LIMIT 1
0.5 1 /classes/Product.php:752
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15627) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1043) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 9)
WHERE p.id_product = 15627
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-05-08 00:00:00",
INTERVAL 550 DAY
)
) > 0
0.5 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1045) AND (id_product_attribute = 1282) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9)
WHERE i.`id_product` = 13050
AND image_shop.`cover` = 1 LIMIT 1
0.4 2 /classes/Product.php:2747
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 9 
AND cl.`id_category` = 2291 LIMIT 1
0.4 0 /classes/Category.php:1054
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 12952) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1045) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM ps_manufacturer m
INNER JOIN ps_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=9)            
WHERE active=1 
ORDER BY name asc
0.4 94 Yes /modules/ets_megamenu/ets_megamenu.php:2512
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 12952
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 15627
0.4 4 /classes/Product.php:5697
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15627) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.4 4 Yes /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 9, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 9) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15627) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-05-08 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.4 4 Yes /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `name` ASC
0.4 12 Yes /classes/ImageType.php:108
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM ps_manufacturer m
INNER JOIN ps_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=9)            
WHERE active=1 
ORDER BY name asc
0.4 94 Yes /modules/ets_megamenu/ets_megamenu.php:2512
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM ps_manufacturer m
INNER JOIN ps_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=9)            
WHERE active=1 
ORDER BY name asc
0.4 94 Yes /modules/ets_megamenu/ets_megamenu.php:2512
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.4 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1285, 1284) AND il.`id_lang` = 2 ORDER by i.`position`
0.4 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 9)
WHERE pf.id_product = 15627
ORDER BY f.position ASC
0.4 7 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 13050 AND id_shop=9 LIMIT 1
0.4 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 15627
0.4 4 /classes/Product.php:5697
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 12952)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1280,1281)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 9 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 9)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 15 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 16112 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 9 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 9)
WHERE c.nleft <= 12
AND c.nright >= 13
AND c.nleft >= 2
AND c.nright <= 1679
AND cl.id_lang = 2
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.3 7 Yes /classes/Tools.php:1308
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1045
0.3 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 9 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 9)
WHERE c.nleft <= 12
AND c.nright >= 13
AND c.nleft >= 2
AND c.nright <= 1679
AND cl.id_lang = 2
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.3 7 Yes /classes/Tools.php:1308
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1046) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1048
GROUP BY pa.`id_product_attribute`
0.3 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM ps_cms c
INNER JOIN ps_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=9)
LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=2
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
0.3 84 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2535
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1292,1293)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM ps_cms c
INNER JOIN ps_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=9)
LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=2
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
0.3 84 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2535
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9)
WHERE i.`id_product` = 12952
AND image_shop.`cover` = 1 LIMIT 1
0.3 2 /classes/Product.php:2747
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1048
AND pac.`id_product_attribute` = 1280
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1036) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 13050) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1036
AND pac.`id_product_attribute` = 1292
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1278,1279)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 15627) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1041) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1050) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1048) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1036
GROUP BY pa.`id_product_attribute`
0.3 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1039) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1043
AND pac.`id_product_attribute` = 1284
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1290,1291)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1282,1283)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 1037) AND (b.`id_shop` = 9) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1286,1287)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1036
GROUP BY pa.`id_product_attribute`
0.3 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1037
AND pac.`id_product_attribute` = 1290
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 13050
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1284,1285)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1039
AND pac.`id_product_attribute` = 1288
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1290,1291)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1037
GROUP BY pa.`id_product_attribute`
0.3 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1041
AND pac.`id_product_attribute` = 1286
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1288,1289)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1041
GROUP BY pa.`id_product_attribute`
0.3 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1050
AND pac.`id_product_attribute` = 1278
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:5597
SELECT SQL_NO_CACHE *
FROM `ps_roybanners`
WHERE id_shop = 9 AND id_lang = 2
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.3 110 Yes /modules/roybanners/roybanners.php:413
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1036)
0.3 2 /classes/Product.php:3002
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1288,1289)
GROUP BY pac.id_product_attribute
0.3 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1278,1279)
GROUP BY pac.id_product_attribute
0.2 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1286,1287)
GROUP BY pac.id_product_attribute
0.2 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1045
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1284,1285)
GROUP BY pac.id_product_attribute
0.2 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 15627
ORDER BY `position`
0.2 1 Yes /classes/Product.php:2725
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (1280,1281)
GROUP BY pac.id_product_attribute
0.2 2 /classes/Product.php:2045
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1043
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1050
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1037
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1043
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1283, 1282) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 15627
ORDER BY `position`
0.2 1 Yes /classes/Product.php:2725
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1048)
0.2 2 /classes/Product.php:3002
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1039
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1050)
0.2 2 /classes/Product.php:3002
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1050
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1048
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1039
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1041
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.`id_product` = 1045
GROUP BY pa.`id_product_attribute`
0.2 2 Yes Yes /classes/Product.php:2027
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
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
0.2 1 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1293, 1292) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 9
WHERE (a.`id_product` = 15627) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1287, 1286) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 5 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'discountmymobile.com' OR su.domain_ssl = 'discountmymobile.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.2 2 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1281, 1280) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1046)
0.2 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1291, 1290) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1289, 1288) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE *
FROM `ps_roybanners`
WHERE id_shop = 9 AND id_lang = 2
AND hook = 'footerbottom' AND active = 1
ORDER BY item_order ASC
0.2 110 Yes /modules/roybanners/roybanners.php:413
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 9) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.2 5 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (29680, 29682, 33799, 33800) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1279, 1278) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 15627)
0.2 4 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 9
WHERE (a.`id_category` = 2265) AND (b.`id_shop` = 9) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1279, 1278) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1293, 1292) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 13050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 9
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.2 1 /classes/shop/Shop.php:202
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1281, 1280) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
0.2 9 /classes/Category.php:1672
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1287, 1286) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 5 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1291, 1290) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1283, 1282) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE *
FROM `ps_roybanners`
WHERE id_shop = 9 AND id_lang = 2
AND hook = 'footerbottom' AND active = 1
ORDER BY item_order ASC
0.2 110 Yes /modules/roybanners/roybanners.php:413
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1285, 1284) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1289, 1288) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1041)
0.2 2 /classes/Product.php:3002
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1043)
0.2 2 /classes/Product.php:3002
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (29680, 29682, 33799, 33800) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 4 Yes /classes/Product.php:2189
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1039)
0.2 2 /classes/Product.php:3002
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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 9)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 9)
WHERE (p.`id_product` = 1037)
0.2 2 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 9
WHERE (a.`id_category` = 2291) AND (b.`id_shop` = 9) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.2 0 /classes/Supplier.php:192
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 9
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 9) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM ps_supplier s
INNER JOIN ps_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=9)            
WHERE active=1 
ORDER BY name asc
0.2 1 Yes /modules/ets_megamenu/ets_megamenu.php:2523
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM ps_supplier s
INNER JOIN ps_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=9)            
WHERE active=1 
ORDER BY name asc
0.2 1 Yes /modules/ets_megamenu/ets_megamenu.php:2523
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =4 AND m.page = "product" LIMIT 1
0.2 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 9
WHERE (a.`id_currency` = 3) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 9)
WHERE i.`id_product` = 16112
AND image_shop.`cover` = 1 LIMIT 1
0.2 1 /classes/Product.php:2747
SELECT SQL_NO_CACHE id_oparteasyredirect_redirections, source, destination, type, isRegExp
FROM `ps_oparteasyredirect_redirections`
WHERE  (`id_shop` = 0 OR `id_shop` =9) AND active = 1  ORDER BY position ASC
0.2 44 Yes /modules/oparteasyredirect/classes/redirections.php:152
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 15627 LIMIT 1
0.2 4 /classes/Product.php:765
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 9)
WHERE l.`active` = 1 LIMIT 1
0.2 1 /classes/Language.php:892
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 9
WHERE (a.`id_country` = 21) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_ets_livechat_ticket_form` a
LEFT JOIN `ps_ets_livechat_ticket_form_lang` `b` ON a.`id_form` = b.`id_form` AND b.`id_lang` = 2
WHERE (a.`id_form` = 2) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM ps_supplier s
INNER JOIN ps_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=9)            
WHERE active=1 
ORDER BY name asc
0.2 1 Yes /modules/ets_megamenu/ets_megamenu.php:2523
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.2 2 /classes/Language.php:777
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.2 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='74ec68343f7426f63c48ec9e3bc0450a' AND cache_id="blockcms|2|1|9|1|1|3|21" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1048) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.2 1 /classes/Language.php:892
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 9
WHERE (a.`id_lang` = 2) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 15627 AND id_lang = 2 LIMIT 1
0.2 1 /modules/lgcomments/lgcomments.php:901
SELECT SQL_NO_CACHE f.id_form,fl.title,fl.button_link_contact_label as button_label FROM `ps_ets_livechat_ticket_form` f
LEFT JOIN `ps_ets_livechat_ticket_form_lang` fl ON (f.id_form=fl.id_form AND fl.id_lang="2")
WHERE f.id_form > 1 AND f.display_input_product=1
0.2 1 /modules/ets_livechat/classes/LC_Ticket_form.php:508
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1048) AND (id_product_attribute = 1281) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE name FROM ps_product_lang WHERE id_product = 15627 AND id_lang = 2 LIMIT 1
0.2 1 /modules/lgcomments/lgcomments.php:890
SELECT SQL_NO_CACHE name FROM ps_product_lang WHERE id_product = 15627 AND id_lang = 2 LIMIT 1
0.2 1 /modules/lgcomments/lgcomments.php:890
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 15627 AND id_lang = 2 LIMIT 1
0.2 1 /modules/lgcomments/lgcomments.php:901
SELECT SQL_NO_CACHE name FROM ps_product_lang WHERE id_product = 15627 AND id_lang = 2 LIMIT 1
0.2 1 /modules/lgcomments/lgcomments.php:890
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 15627 AND ctg.`id_group` = 1 LIMIT 1
0.2 1 /classes/Product.php:4921
SELECT SQL_NO_CACHE type+0 AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = 15627  AND `type_object` = 1 LIMIT 1
0.2 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1629
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='8dab7ef94019b041c1999e4fc2ca125c' AND cache_id="royblocksocial|1|9|1|1|3|21" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1046 AND id_shop=9 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='65947b38145078c1fbf35076d93fd2fd' AND cache_id="azmegamenu|1|9|1|1|3|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 13050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE domain
FROM `ps_shop_url`
WHERE (main = 1) AND (active = 1)
AND id_shop IN (1, 9)
0.1 2 /classes/shop/Shop.php:748
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 9)
WHERE pa.id_product = 16112 LIMIT 1
0.1 1 /classes/Product.php:752
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=15627
0.1 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 15627 AND `id_shop` = 9
0.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 15627
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcanonicalurls" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 15627) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 9 LIMIT 1
0.1 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:837
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1043) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 9
WHERE (a.`id_group` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='cb13fe1dac5eeed450b8c96d03043a59' AND cache_id="roypaymentlogo|1|9|1|1|3|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 9 LIMIT 1
0.1 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 12952) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcomments" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 16112) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "deletelanguagefolder" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1037) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1036) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1
0.1 1 /classes/Image.php:471
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ybc_blog" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 15627 LIMIT 1
0.1 1 /classes/Page.php:77
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypalwithfee" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1041) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 9 LIMIT 1
0.1 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:837
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 15627) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1036) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1039) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1046 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1048 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_lang FROM ps_lang WHERE is_rtl=0 AND active=1 LIMIT 1
0.1 2 /modules/ets_megamenu/ets_megamenu.php:3490
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1037) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1037
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE COUNT(`id_shop`)
FROM `ps_product_shop`
WHERE `id_product` = 15627
AND active = 1
AND id_shop = 9 LIMIT 1
0.1 1 /modules/med_blocklanguages/class/mediacom87.php:195
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.1 12 /classes/ImageType.php:143
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1045) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 12952) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1041) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 15627
0.1 4 /classes/Product.php:2171
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 16112) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1046) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 15627
0.1 4 /classes/Product.php:2171
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1039) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1037
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1036
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1045
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1043
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name ="ets_livechat" LIMIT 1
0.1 1 /modules/ets_livechat/classes/LC_Base.php:1891
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 15627 LIMIT 1
0.1 1 /classes/Page.php:77
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1036
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 9 
AND cl.`id_category` = 867 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE type+0 AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = 15627  AND `type_object` = 1 LIMIT 1
0.1 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1629
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1039
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.1 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1050) AND (id_product_attribute = 1278) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1043) AND (id_product_attribute = 1284) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1048
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1041
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "roymap" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1043
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1036) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1050
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE `id_product_download`
FROM `ps_product_download`
WHERE `id_product` = 15627
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1
0.1 0 /classes/ProductDownload.php:183
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1037) AND (id_product_attribute = 1290) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1048) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 2291 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE type+0 AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = 15627  AND `type_object` = 1 LIMIT 1
0.1 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1629
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 15627) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
0.1 2 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1048) AND (id_product_attribute = 1280) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 4) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1036) AND (id_product_attribute = 1293) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1039) AND (id_product_attribute = 1288) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1041) AND (id_product_attribute = 1286) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(`id_shop`)
FROM `ps_product_shop`
WHERE `id_product` = 15627
AND active = 1
AND id_shop = 1 LIMIT 1
0.1 1 /modules/med_blocklanguages/class/mediacom87.php:195
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1039
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE pt.`id_page_type`,pt.`name`,p.`id_page_type`,p.`id_page`,p.`id_object`  
FROM `ps_page` p
LEFT JOIN `ps_page_type` pt ON p.`id_page_type` = pt.`id_page_type`
WHERE p.`id_page` = 7264 LIMIT 1
0.1 1 /modules/responsiveiframe/responsiveiframe.php:63
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockuserinfo" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1036
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2291 LIMIT 1
0.1 1 /classes/Category.php:1477
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1041
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1039
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  9 LIMIT 1
0.1 1 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:844
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1048
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 15627) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 9 
AND cl.`id_category` = 2147 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE * FROM icode_configuration
0.1 2 /modules/ICodePSLibrary/icodeLib/ICodeConfig.class.php:27
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1050
0.1 2 /classes/Product.php:2171
SELECT SQL_NO_CACHE data
FROM `ps_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 9 LIMIT 1
0.1 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 15627
AND id_shop = 9 LIMIT 1
0.1 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  9 LIMIT 1
0.1 1 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:844
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1048
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 3
AND id_shop = 9 LIMIT 1
0.1 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2025-05-08 00:00:00' AND '2025-05-08 23:59:59' LIMIT 1
0.1 1 /classes/SpecificPrice.php:302
SELECT SQL_NO_CACHE *
FROM ps_opartnoindex_products
WHERE id_product = 15627
AND id_lang = 2
AND id_shop = 9 LIMIT 1
0.1 0 /modules/opartnoindex/opartnoindex.php:1318
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1036 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE pt.`id_page_type`,pt.`name`,p.`id_page_type`,p.`id_page`,p.`id_object`  
FROM `ps_page` p
LEFT JOIN `ps_page_type` pt ON p.`id_page_type` = pt.`id_page_type`
WHERE p.`id_page` = 7264 LIMIT 1
0.1 1 /modules/responsiveiframe/responsiveiframe.php:63
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1039) AND (id_product_attribute = 1289) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE type+0 AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = 15627  AND `type_object` = 1 LIMIT 1
0.1 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1629
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 16112 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1050 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1037
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1039) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1043) AND (id_product_attribute = 1285) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 15627) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1046) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.1 1 /classes/Image.php:471
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1048) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1037) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1036) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcart" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 16112) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1041) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1041
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1050) AND (id_product_attribute = 1279) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1041 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 9 LIMIT 1
0.1 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1046) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 15627 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1037 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1046) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 9 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1043
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 15627 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1037) AND (id_product_attribute = 1291) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1036) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1043) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1043) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1037) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
0.1 1 /classes/Category.php:1477
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 9 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 12952 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1039 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 13050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1050
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1037) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1048) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'cart_default' LIMIT 1
0.1 1 /classes/Image.php:471
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1039) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 363 AND `id_shop` = 9 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.1 1 /classes/Image.php:471
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1039) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1043 AND id_shop=9 LIMIT 1
0.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 12952) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1045) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1045) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1041) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1
0.1 3 /classes/shop/Shop.php:1068
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 9 LIMIT 1
0.1 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2025-05-08 00:00:00' AND '2025-05-08 23:59:59' LIMIT 1
0.1 1 /classes/SpecificPrice.php:306
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 16112) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product.php' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 375 AND `id_shop` = 9 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `canonical_url` FROM `ps_lgcanonicalurls_lang` WHERE `id_object` = 15627   AND `type_object` = 1   AND `id_lang` = 1 LIMIT 1
0.1 0 /modules/lgcanonicalurls/lgcanonicalurls.php:1673
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1045 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1041 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ets_reviews" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1043) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1048) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE id_lang FROM ps_lang WHERE is_rtl=1 AND active=1 LIMIT 1
0.1 2 /modules/ets_megamenu/ets_megamenu.php:3490
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1050) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 540 AND `id_shop` = 9 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'index' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 2291
AND id_shop = 9 LIMIT 1
0.1 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 9 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'cms' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product.php' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'index.php' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE date_format_lite FROM ps_lang WHERE id_lang = 2 LIMIT 1
0.1 1 /modules/lgcomments/lgcomments.php:1018
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'cms.php' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 28 AND `id_shop` = 9 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1050 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1036 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1037 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1048 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'index' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1039 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1043 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 532 AND `id_shop` = 9 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'cms.php' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'index.php' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'cms' LIMIT 1
0.1 1 /classes/Page.php:96
SELECT SQL_NO_CACHE `canonical_url` FROM `ps_lgcanonicalurls_lang` WHERE `id_object` = 15627   AND `type_object` = 1   AND `id_lang` = 2 LIMIT 1
0.1 0 /modules/lgcanonicalurls/lgcanonicalurls.php:1673
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.1 1 /classes/Group.php:133

Doubles

29
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
27
SELECT out_of_stock
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
25
SELECT depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
24
SELECT COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = XX AND active = XX AND id_lang = XX AND stars >= XX AND stars < XX LIMIT XX
18
SELECT `id_product_attribute`
			FROM `ps_product_attribute`
			WHERE `id_product` = XX
17
			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `ps_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
16
SELECT pa.*, product_attribute_shop.*
				FROM `ps_product_attribute` pa
				 INNER JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
				WHERE pa.`id_product` = XX
				GROUP BY pa.`id_product_attribute`
16
SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
				FROM `ps_product_attribute_combination` pac
				LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
				LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
				LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
				LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
				WHERE pac.id_product_attribute IN (XX,XX)
				GROUP BY pac.id_product_attribute
16
			SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
			FROM `ps_product_attribute_image` pai
			LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
			LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
			WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
14
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
13
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
13
				SELECT `priority`, `id_specific_price_priority`
				FROM `ps_specific_price_priority`
				WHERE `id_product` = XX
				ORDER BY `id_specific_price_priority` DESC LIMIT XX
13
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
13
							SELECT `id_tax_rules_group`
							FROM `ps_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
9
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
8
			SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
			FROM `ps_attribute` a
			LEFT JOIN `ps_attribute_lang` al
				ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
			LEFT JOIN `ps_product_attribute_combination` pac
				ON (pac.`id_attribute` = a.`id_attribute`)
			LEFT JOIN `ps_product_attribute` pa
				ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
			 INNER JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
			LEFT JOIN `ps_attribute_group_lang` agl
				ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
			WHERE pa.`id_product` = XX
				AND pac.`id_product_attribute` = XX
				AND agl.`id_lang` = XX
6
SELECT SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = XX AND id_lang = XX AND active = XX LIMIT XX
6
SELECT COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = XX AND active = XX AND id_lang = XX LIMIT XX
6
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
5
SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
                FROM `ps_configuration` c
                LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
5
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `ps_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `ps_module` m
5
SELECT product_attribute_shop.id_product_attribute
				FROM ps_product_attribute pa
				 INNER JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
				WHERE pa.id_product = XX LIMIT XX
4
				SELECT id_page_type
				FROM ps_page_type
				WHERE name = 'product' LIMIT XX
4
SELECT image_shop.`id_image`
					FROM `ps_image` i
					 INNER JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
					WHERE i.`id_product` = XX
					AND image_shop.`cover` = XX LIMIT XX
4
SELECT pc.*, CONCAT(c.firstname, ' ', (SUBSTRING(c.lastname,XX,XX)), '.') as customer FROM ps_lgcomments_productcomments pc LEFT JOIN ps_customer as c ON pc.id_customer = c.id_customer WHERE pc.id_product = XX AND pc.id_lang = XX AND pc.active = XX ORDER BY pc.position DESC
4
SELECT type+XX AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = XX  AND `type_object` = XX LIMIT XX
4
SELECT date_format_lite FROM ps_lang WHERE id_lang = XX LIMIT XX
4
SELECT name FROM ps_product_lang WHERE id_product = XX AND id_lang = XX LIMIT XX
4
SELECT COUNT(id_lgcomments_productcomments) FROM ps_lgcomments_productcomments WHERE id_customer = XX AND id_product = XX LIMIT XX
3
            SELECT s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
            FROM ps_supplier s
            INNER JOIN ps_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=XX)            
            WHERE active=XX 
            ORDER BY name asc
        
3
            SELECT c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
            FROM ps_cms c
            INNER JOIN ps_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=XX)
            LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=XX
            WHERE c.active=XX 
            GROUP BY c.id_cms ORDER BY cl.meta_title asc
        
3
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
3
            SELECT m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
            FROM ps_manufacturer m
            INNER JOIN ps_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=XX)            
            WHERE active=XX 
            ORDER BY name asc
        
2
SELECT c.id_category, cl.name, cl.link_rewrite
						FROM ps_category c
						LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = XX )
						 INNER JOIN ps_category_shop category_shop
		ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX)
						WHERE c.nleft <= XX
							AND c.nright >= XX
							AND c.nleft >= XX
							AND c.nright <= XX
							AND cl.id_lang = XX
							AND c.active = XX
							AND c.level_depth > XX
						ORDER BY c.level_depth ASC
2
			SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
			FROM `ps_product_attribute_image` pai
			LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
			LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
			WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2
SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
					a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
					IFNULL(stock.quantity, XX) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
					product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
					product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
				FROM `ps_product_attribute` pa
				 INNER JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
				 LEFT JOIN ps_stock_available stock
			ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop_group = XX  AND stock.id_shop = XX  )
				LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
				LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
				LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
				LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
				LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
				 INNER JOIN ps_attribute_shop attribute_shop
		ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX)
				WHERE pa.`id_product` = XX
					AND al.`id_lang` = XX
					AND agl.`id_lang` = XX
				GROUP BY id_attribute_group, id_product_attribute
				ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
2
                SELECT COUNT(`id_shop`)
                FROM `ps_product_shop`
                WHERE `id_product` = XX
                    AND active = XX
                    AND id_shop = XX LIMIT XX
2
			SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
			FROM `ps_attribute` a
			LEFT JOIN `ps_attribute_lang` al
				ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
			LEFT JOIN `ps_attribute_group_lang` agl
				ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
			LEFT JOIN `ps_product_attribute_combination` pac
				ON (a.`id_attribute` = pac.`id_attribute`)
			LEFT JOIN `ps_product_attribute` pa
				ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
			 INNER JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
			 INNER JOIN ps_attribute_shop attribute_shop
		ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = XX)
			WHERE pa.`id_product` = XX
2
			SELECT nleft, nright, level_depth
			FROM ps_category
			WHERE id_category = XX LIMIT XX
2
SELECT version FROM `ps_module` WHERE name ="ets_livechat" LIMIT XX
2
		SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
		FROM `ps_category` c
		 INNER JOIN ps_category_shop category_shop
		ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX)
		LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX  AND cl.id_shop = XX )
		LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
		WHERE `id_parent` = XX
		AND `active` = XX
		AND cg.`id_group` =XX
		GROUP BY c.`id_category`
		ORDER BY `level_depth` ASC, category_shop.`position` ASC
2
SELECT id_lang FROM ps_lang WHERE is_rtl=XX AND active=XX LIMIT XX
2
SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, XX) 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, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, XX) id_product_attribute,
					DATEDIFF(
						p.`date_add`,
						DATE_SUB(
							"XX-XX-XX XX:XX:XX",
							INTERVAL XX DAY
						)
					) > XX AS new
				FROM `ps_accessory`
				LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_XX`
				 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX)
				LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
					ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX)
				LEFT JOIN `ps_product_lang` pl ON (
					p.`id_product` = pl.`id_product`
					AND pl.`id_lang` = XX AND pl.id_shop = XX 
				)
				LEFT JOIN `ps_category_lang` cl ON (
					product_shop.`id_category_default` = cl.`id_category`
					AND cl.`id_lang` = XX AND cl.id_shop = XX 
				)
				LEFT JOIN `ps_image_shop` image_shop
					ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX)
				LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX)
				LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
				 LEFT JOIN ps_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_product_attribute = XX AND stock.id_shop_group = XX  AND stock.id_shop = XX  )
				WHERE `id_product_XX` = XX AND product_shop.`active` = XX AND product_shop.`visibility` != 'none'
				GROUP BY product_shop.id_product
2
SELECT link_rewrite FROM ps_product_lang WHERE id_product = XX AND id_lang = XX LIMIT XX
2
SELECT m.page, ml.url_rewrite, ml.id_lang
					FROM `ps_meta` m
					LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = XX )
					ORDER BY LENGTH(ml.url_rewrite) DESC
2
		SELECT *
		FROM `ps_roybanners`
		WHERE id_shop = XX AND id_lang = XX
		AND hook = 'footerbottom' AND active = XX
		ORDER BY item_order ASC
2
SELECT `canonical_url` FROM `ps_lgcanonicalurls_lang` WHERE `id_object` = XX   AND `type_object` = XX   AND `id_lang` = XX LIMIT XX
2
SELECT *
FROM `ps_shop` a
WHERE (a.`id_shop` = XX) LIMIT XX
2
			SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
			FROM ps_shop s
			LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
			LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
			WHERE s.id_shop = XX
			AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX
2
				SELECT id_page_type
				FROM ps_page_type
				WHERE name = 'cms.php' LIMIT XX
2
				SELECT id_page_type
				FROM ps_page_type
				WHERE name = 'cms' LIMIT XX
2
				SELECT id_page_type
				FROM ps_page_type
				WHERE name = 'index.php' LIMIT XX
2
				SELECT id_page_type
				FROM ps_page_type
				WHERE name = 'index' LIMIT XX
2
				SELECT id_page_type
				FROM ps_page_type
				WHERE name = 'product.php' LIMIT XX
2
				SELECT tr.*
				FROM `ps_tax_rule` tr
				JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
				SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
				JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = XX)
				WHERE l.`active` = XX LIMIT XX
2
SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity,
                    MAX(product_attribute_shop.id_product_attribute) 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`, MAX(image_shop.`id_image`) id_image,
                    DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
                    INTERVAL XX
                        DAY)) > XX AS new, product_shop.price AS orderprice
                FROM `ps_product` p
                 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX)
                LEFT JOIN `ps_product_attribute` pa
                ON (p.`id_product` = pa.`id_product`)
                 LEFT JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX AND product_attribute_shop.`default_on` = XX)
                 LEFT JOIN ps_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, XX) AND stock.id_shop_group = XX  AND stock.id_shop = XX  )
                LEFT JOIN `ps_product_lang` pl
                    ON (p.`id_product` = pl.`id_product`
                    AND pl.`id_lang` = XX AND pl.id_shop = XX )
                LEFT JOIN `ps_image` i
                    ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX AND image_shop.cover=XX)
                WHERE product_shop.`id_shop` = XX
                    AND product_shop.`visibility` IN ("both","catalog","search")
                    AND product_shop.`active` = XX
                    AND product_shop.`available_for_order` = XX
                    AND p.`id_product` in (XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX)
                GROUP BY product_shop.id_product
                ORDER BY  FIND_IN_SET(p.`id_product`, 'XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX')
2
SELECT DISTINCT               
                apo.`id`, `name`, `short_description`, 
                `id_related_category`, `id_related_product`,
                displayed_category_product.`id_product` as `displayed_category_id_product`,
                displayed_products_list.`id_displayed_product` as `displayed_lists_id_product`,
                `minimum_amount`, `maximum_amount`, `is_active_groups`
                FROM `ps_lineven_apo` apo
                LEFT JOIN `ps_category_product` related_category ON (related_category.`id_category` = apo.`id_related_category`)
                LEFT JOIN `ps_category_shop` as related_category_shop ON (related_category.`id_category` = related_category_shop.`id_category` AND related_category_shop.`id_shop` = XX)
                LEFT JOIN `ps_category_product` displayed_category_product ON (displayed_category_product.`id_category` = apo.`id_displayed_category`)
                LEFT JOIN `ps_category_shop` as displayed_category_product_shop ON (displayed_category_product.`id_category` = displayed_category_product_shop.`id_category` AND displayed_category_product_shop.`id_shop` = XX) 
                LEFT JOIN `ps_lineven_apo_displayed_products` displayed_products_list ON (apo.`id` = displayed_products_list.`id_association`)  LEFT JOIN `ps_lineven_apo_groups` apo_groups
                    ON (apo.`id` = apo_groups.`id_association`) WHERE ((apo.`id_shop_group` is null and apo.`id_shop` is null) or (apo.`id_shop_group` = XX 
                            and apo.`id_shop` is null) or (apo.`id_shop` = XX)) AND (apo.`is_active_groups` = XX OR (apo.`is_active_groups` = XX AND 
                    apo_groups.`id_group` in (XX)))  AND ((apo.`minimum_amount` = XX OR apo.`minimum_amount` <= XX)
                AND (apo.`maximum_amount` = XX OR apo.`maximum_amount` >= XX)) AND (NULLIF(apo.`hooks`, '') IS NULL OR apo.`hooks` LIKE ('%OEP%'))  
                AND (
                (
                    apo.`id_related_category` is null AND apo.`id_related_product` is null
                )OR
                        (
                            apo.`id_related_category` is not null AND
                            related_category.`id_product` in (XX) 
                        ) OR
                        (
                            apo.`id_related_product` is not null AND
                            apo.`id_related_product` in (XX)
                        )
                ) 
                ORDER BY apo.`order_display` ASC, displayed_products_list.`order_display` ASC 
2
		SELECT pt.`id_page_type`,pt.`name`,p.`id_page_type`,p.`id_page`,p.`id_object`  
		FROM `ps_page` p
		LEFT JOIN `ps_page_type` pt ON p.`id_page_type` = pt.`id_page_type`
		WHERE p.`id_page` = XX LIMIT XX
2
SELECT `id_page`
				FROM `ps_page`
				WHERE `id_page_type` = XX AND `id_object` = XX LIMIT XX
2
			SELECT *,
					( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `ps_specific_price`
				WHERE
					`id_shop` IN (XX, XX) AND
					`id_currency` IN (XX, XX) AND
					`id_country` IN (XX, XX) AND
					`id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
					ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
		
2
SELECT COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = XX AND (`status` = -XX OR `aff` = -XX OR `aff` = -XX) AND id_shop =  XX LIMIT XX
2
SELECT COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = XX AND (`status` = -XX OR `loy` = -XX OR `loy` = -XX) AND id_shop = XX LIMIT XX
2
SELECT f.id_form,fl.title,fl.button_link_contact_label as button_label FROM `ps_ets_livechat_ticket_form` f
        LEFT JOIN `ps_ets_livechat_ticket_form_lang` fl ON (f.id_form=fl.id_form AND fl.id_lang="XX")
        WHERE f.id_form > XX AND f.display_input_product=XX
2
			SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
			FROM `ps_image` i
			 INNER JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
			LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
			WHERE i.`id_product` = XX
			ORDER BY `position`

Tables stress

87 stock_available
54 product_attribute
51 product_attribute_shop
50 product_shop
44 lgcomments_productcomments
34 product
28 attribute_group_lang
28 attribute_lang
28 attribute
28 product_attribute_combination
27 product_lang
26 image
24 specific_price
23 module
22 image_lang
18 product_attribute_image
18 attribute_group
17 category_lang
16 module_shop
16 page_type
13 specific_price_priority
13 product_group_reduction_cache
13 category_shop
11 category
10 image_shop
10 lang
7 shop
6 manufacturer
6 image_type
6 shop_url
6 configuration
5 category_product
5 ets_livechat_ticket_form_lang
5 ets_livechat_ticket_form
5 lang_shop
5 configuration_lang
5 smarty_lazy_cache
4 lgcanonicalurls
4 supplier
4 theme
4 attribute_shop
4 hook
4 page
4 customer
4 ets_am_user
4 roybanners
4 currency_shop
3 category_group
3 meta
3 manufacturer_shop
3 supplier_shop
3 cms
3 cms_shop
3 cms_lang
3 currency
3 group
2 country_shop
2 country_lang
2 lineven_apo_displayed_products
2 country
2 lineven_apo_groups
2 shop_group
2 lineven_apo
2 accessory
2 hook_module
2 group_lang
2 meta_lang
2 tax_rule
2 lgcanonicalurls_lang
2 tax_rules_group
2 group_shop
2 smarty_last_flush
2 hook_alias
2 cart_rule_lang
2 cart_rule
1 product_download
1 hook_module_exceptions
1 tag
1 product_tag
1 theme_meta
1 feature_lang
1 feature_shop
1 feature
1 feature_value_lang
1 oparteasyredirect_redirections
1 feature_product
1 zone
1 state
1 module_group
1 opartnoindex_products
1 ganalytics_data

ObjectModel instances

NameInstancesSource
Product 61 /classes/Link.php [104]
/controllers/front/ProductController.php [85]
/classes/Link.php [104]
/classes/Link.php [104]
/modules/oparteasyredirect/oparteasyredirect.php [284]
/modules/oparteasyredirect/oparteasyredirect.php [322]
/modules/oparteasyredirect/oparteasyredirect.php [363]
/classes/Link.php [104]
/modules/ets_affiliatemarketing/ets_affiliatemarketing.php [1786]
/modules/ets_affiliatemarketing/ets_affiliatemarketing.php [1851]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/classes/Link.php [104]
/modules/ets_affiliatemarketing/ets_affiliatemarketing.php [1786]
/modules/ets_affiliatemarketing/ets_affiliatemarketing.php [1851]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php [63]
/classes/Link.php [104]
Currency 18 /classes/Tools.php [617]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/classes/Tools.php [827]
/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php [49]
Category 8 /controllers/front/ProductController.php [158]
/modules/ets_megamenu/ets_megamenu.php [285]
/modules/ets_megamenu/ets_megamenu.php [561]
/modules/ets_megamenu/ets_megamenu.php [1086]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
Address 7 /classes/Product.php [492]
/classes/Product.php [5053]
/classes/Product.php [2941]
/controllers/front/ProductController.php [314]
/controllers/front/ProductController.php [355]
/controllers/front/ProductController.php [314]
/controllers/front/ProductController.php [355]
Shop 6 /config/config.inc.php [114]
/classes/Link.php [676]
/modules/med_blocklanguages/med_blocklanguages.php [276]
/classes/Link.php [676]
/modules/med_blocklanguages/med_blocklanguages.php [276]
/modules/lgcanonicalurls/lgcanonicalurls.php [1706]
Country 2 /config/config.inc.php [142]
/classes/controller/FrontController.php [279]
Language 2 /config/config.inc.php [195]
/classes/Tools.php [500]
Manufacturer 2 /controllers/front/ProductController.php [268]
/override/controllers/front/ProductController.php [122]
Theme 1 /config/config.inc.php [115]
ShopGroup 1 /classes/shop/Shop.php [518]
Customer 1 /config/config.inc.php [221]
Cart 1 /classes/controller/FrontController.php [348]
Group 1 /classes/Cart.php [184]
LC_Ticket_form 1 /modules/ets_livechat/ets_livechat.php [4062]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/settings.inc.php
5/config/autoload.php
6/config/alias.php
7/classes/PrestaShopAutoload.php
8/cache/class_index.php
9/config/bootstrap.php
10/Core/Business/Core_Business_ContainerBuilder.php
11/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
12/Adapter/Adapter_ServiceLocator.php
13/classes/controller/Controller.php
14/classes/ObjectModel.php
15/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
16/classes/db/Db.php
17/classes/Tools.php
18/classes/Context.php
19/classes/shop/Shop.php
20/classes/db/DbPDO.php
21/classes/Configuration.php
22/override/classes/Configuration.php
23/classes/Validate.php
24/override/classes/Validate.php
25/classes/cache/Cache.php
26/Adapter/Adapter_EntityMapper.php
27/classes/db/DbQuery.php
28/classes/Theme.php
29/config/defines_uri.inc.php
30/classes/Language.php
31/classes/Country.php
32/classes/PrestaShopCollection.php
33/classes/shop/ShopGroup.php
34/classes/Cookie.php
35/classes/Rijndael.php
36/config/smarty.config.inc.php
37/tools/smarty/Smarty.class.php
38/tools/smarty/sysplugins/smarty_internal_data.php
39/tools/smarty/sysplugins/smarty_internal_templatebase.php
40/tools/smarty/sysplugins/smarty_internal_template.php
41/tools/smarty/sysplugins/smarty_resource.php
42/tools/smarty/sysplugins/smarty_internal_resource_file.php
43/tools/smarty/sysplugins/smarty_cacheresource.php
44/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
45/classes/SmartyCustom.php
46/config/smartyfront.config.inc.php
47/classes/Customer.php
48/classes/Group.php
49/classes/Link.php
50/override/classes/Link.php
51/classes/shop/ShopUrl.php
52/classes/Dispatcher.php
53/classes/Hook.php
54/tools/mobile_Detect/Mobile_Detect.php
55/config/db_slave_server.inc.php
56/classes/module/Module.php
57/modules/etseofriendlyurl/etseofriendlyurl.php
58/classes/Translate.php
59/modules/smartblog/smartblog.php
60/modules/smartblog/classes/BlogCategory.php
61/modules/smartblog/classes/Blogcomment.php
62/modules/smartblog/classes/BlogPostCategory.php
63/modules/smartblog/classes/BlogTag.php
64/modules/smartblog/classes/SmartBlogPost.php
65/modules/smartblog/classes/BlogImageType.php
66/modules/smartblog/controllers/admin/AdminAboutUsController.php
67/classes/controller/ModuleAdminController.php
68/classes/controller/AdminController.php
69/themes/theme_discountmymobile/modules/smartblog/translations/en.php
70/modules/smartblog/translations/en.php
71/modules/colissimo/colissimo.php
72/classes/module/CarrierModule.php
73/modules/colissimo/classes/module.classes.php
74/modules/colissimo/classes/ColissimoTools.php
75/modules/colissimo/classes/ColissimoLink.php
76/modules/colissimo/classes/ColissimoModuleConfiguration.php
77/modules/colissimo/classes/ColissimoCarrier.php
78/classes/Carrier.php
79/modules/colissimo/classes/ColissimoService.php
80/modules/colissimo/classes/ColissimoOrder.php
81/modules/colissimo/classes/ColissimoLabel.php
82/modules/colissimo/classes/ColissimoLabelProduct.php
83/modules/colissimo/classes/ColissimoDepositSlip.php
84/modules/colissimo/classes/ColissimoLabelGenerator.php
85/modules/colissimo/classes/ColissimoPickupPoint.php
86/modules/colissimo/classes/ColissimoCartPickupPoint.php
87/modules/colissimo/classes/ColissimoTrackingCode.php
88/modules/colissimo/classes/ColissimoOrderCarrier.php
89/classes/order/OrderCarrier.php
90/modules/colissimo/classes/ColissimoCustomCategory.php
91/modules/colissimo/classes/ColissimoCustomProduct.php
92/modules/colissimo/classes/ColissimoCustomDocument.php
93/modules/colissimo/classes/ColissimoMerchantAddress.php
94/modules/colissimo/classes/ColissimoAddress.php
95/modules/colissimo/classes/ColissimoACE.php
96/modules/colissimo/classes/migration/ColissimoOtherModuleInterface.php
97/modules/colissimo/classes/migration/ColissimoMigration.php
98/modules/colissimo/classes/migration/ColissimoSoflexibiliteMigration.php
99/modules/colissimo/classes/migration/ColissimoSoniceEtiquetageMigration.php
100/modules/colissimo/classes/migration/ColissimoColissimoSimpliciteMigration.php
101/modules/colissimo/classes/migration/ColissimoSocolissimoMigration.php
102/modules/colissimo/classes/logger/AbstractColissimoHandler.php
103/modules/colissimo/classes/logger/ColissimoFileHandler.php
104/modules/colissimo/classes/logger/ColissimoNullHandler.php
105/modules/colissimo/classes/logger/ColissimoLogger.php
106/modules/colissimo/lib/loader.php
107/modules/colissimo/lib/ColissimoClient.php
108/modules/colissimo/lib/Request/AbstractColissimoRequest.php
109/modules/colissimo/lib/Request/ColissimoGenerateLabelRequest.php
110/modules/colissimo/lib/Request/ColissimoGenerateBordereauRequest.php
111/modules/colissimo/lib/Request/ColissimoWidgetAuthenticationRequest.php
112/modules/colissimo/lib/Request/ColissimoMailboxDetailsRequest.php
113/modules/colissimo/lib/Request/ColissimoTrackingEnrichiRequest.php
114/modules/colissimo/lib/Request/ColissimoTrackingSimpleRequest.php
115/modules/colissimo/lib/Request/ColissimoCheckGenerateLabelRequest.php
116/modules/colissimo/lib/Request/ColissimoPlanPickupRequest.php
117/modules/colissimo/lib/Request/ColissimoTrackingTimelineRequest.php
118/modules/colissimo/lib/Request/ColissimoCreateCustomDocumentRequest.php
119/modules/colissimo/lib/Request/ColissimoUpdateCustomDocumentRequest.php
120/modules/colissimo/lib/Response/ColissimoReturnedResponseInterface.php
121/modules/colissimo/lib/Response/AbstractColissimoResponse.php
122/modules/colissimo/lib/Response/ColissimoResponseParser.php
123/modules/colissimo/lib/Response/ColissimoGenerateLabelResponse.php
124/modules/colissimo/lib/Response/ColissimoGenerateBordereauResponse.php
125/modules/colissimo/lib/Response/ColissimoWidgetAuthenticationResponse.php
126/modules/colissimo/lib/Response/ColissimoMailboxDetailsResponse.php
127/modules/colissimo/lib/Response/ColissimoTrackingEnrichiResponse.php
128/modules/colissimo/lib/Response/ColissimoTrackingSimpleResponse.php
129/modules/colissimo/lib/Response/ColissimoCheckGenerateLabelResponse.php
130/modules/colissimo/lib/Response/ColissimoPlanPickupResponse.php
131/modules/colissimo/lib/Response/ColissimoTrackingTimelineResponse.php
132/modules/colissimo/lib/Response/ColissimoCreateCustomDocumentResponse.php
133/modules/colissimo/lib/Response/ColissimoUpdateCustomDocumentResponse.php
134/modules/colissimo/translations/en.php
135/modules/ets_livechat/ets_livechat.php
136/modules/ets_livechat/classes/src/autoload.php
137/modules/ets_livechat/classes/LC_Tools.php
138/modules/ets_livechat/classes/LC_Base.php
139/modules/ets_livechat/classes/LC_Conversation.php
140/modules/ets_livechat/classes/LC_Message.php
141/modules/ets_livechat/classes/LC_MadeMessage.php
142/modules/ets_livechat/classes/LC_AutoReplyMessage.php
143/modules/ets_livechat/classes/LC_Download.php
144/modules/ets_livechat/classes/LC_Departments.php
145/modules/ets_livechat/classes/LC_Ticket_form.php
146/modules/ets_livechat/classes/LC_Ticket_field.php
147/modules/ets_livechat/classes/LC_Ticket.php
148/modules/ets_livechat/classes/LC_Note.php
149/modules/ets_livechat/classes/LC_paggination_class.php
150/modules/ets_livechat/classes/LC_Mail.php
151/classes/Mail.php
152/tools/swift/swift_required.php
153/tools/swift/classes/Swift.php
154/modules/ets_livechat/classes/LC_Ticket_process.php
155/controllers/front/ProductController.php
156/classes/controller/FrontController.php
157/override/classes/controller/FrontController.php
158/override/controllers/front/ProductController.php
159/modules/jprestawebp/jprestawebp.php
160/modules/jprestawebp/classes/JprestaWebpUtils.php
161/modules/jprestawebp/classes/JprestaWebpModule.php
162/modules/jprestawebp/vendor/autoload.php
163/modules/jprestawebp/vendor/composer/autoload_real.php
164/modules/jprestawebp/vendor/composer/ClassLoader.php
165/modules/jprestawebp/vendor/composer/autoload_static.php
166/modules/jprestawebp/webp.config.php
167/modules/jprestawebp/classes/JprestaSubModule.php
168/modules/jprestawebp/translations/en.php
169/themes/theme_discountmymobile/lang/en.php
170/classes/Currency.php
171/classes/Cart.php
172/classes/CartRule.php
173/override/classes/CartRule.php
174/classes/Meta.php
175/override/classes/Meta.php
176/classes/Product.php
177/override/classes/Product.php
178/classes/webservice/WebserviceRequest.php
179/classes/Category.php
180/override/classes/Category.php
181/classes/Manufacturer.php
182/classes/Supplier.php
183/classes/Address.php
184/classes/tax/TaxManagerFactory.php
185/classes/tax/TaxRulesTaxManager.php
186/classes/tax/TaxManagerInterface.php
187/Adapter/Adapter_Configuration.php
188/Core/Business/Core_Business_ConfigurationInterface.php
189/classes/tax/TaxCalculator.php
190/classes/tax/Tax.php
191/classes/Combination.php
192/classes/SpecificPrice.php
193/classes/GroupReduction.php
194/classes/Tag.php
195/classes/stock/StockAvailable.php
196/classes/Media.php
197/modules/mondialrelay/mondialrelay.php
198/modules/mondialrelay/vendor/autoload.php
199/modules/mondialrelay/vendor/composer/autoload_real.php
200/modules/mondialrelay/vendor/composer/autoload_static.php
201/modules/mondialrelay/classes/MondialrelayTools.php
202/modules/mondialrelay/classes/services/MondialrelayService.php
203/modules/mondialrelay/classes/MondialrelayCarrierMethod.php
204/modules/mondialrelay/classes/MondialrelaySelectedRelay.php
205/modules/mondialrelay/vendor/totpsclasslib/src/Module.php
206/Adapter/Adapter_AddressFactory.php
207/Adapter/Adapter_ProductPriceCalculator.php
208/modules/ets_megamenu/ets_megamenu.php
209/modules/ets_megamenu/classes/MM_Obj.php
210/modules/ets_megamenu/classes/MM_Menu.php
211/modules/ets_megamenu/classes/MM_Column.php
212/modules/ets_megamenu/classes/MM_Block.php
213/modules/ets_megamenu/classes/MM_Config.php
214/modules/ets_megamenu/classes/MM_Cache.php
215/modules/ets_megamenu/classes/MM_Tab.php
216/modules/ets_megamenu/classes/MM_Products.php
217/modules/ets_megamenu/translations/en.php
218/classes/ImageType.php
219/modules/blockcart/blockcart.php
220/themes/theme_discountmymobile/modules/blockcart/translations/en.php
221/modules/blockcart/translations/en.php
222/modules/blocksearch/blocksearch.php
223/themes/theme_discountmymobile/modules/blocksearch/translations/en.php
224/modules/blocksearch/translations/en.php
225/modules/blockuserinfo/blockuserinfo.php
226/themes/theme_discountmymobile/modules/blockuserinfo/translations/en.php
227/modules/blockuserinfo/translations/en.php
228/modules/azmegamenu/azmegamenu.php
229/modules/azmegamenu/Megamenu.php
230/modules/azmegamenu/MegamenuGroup.php
231/themes/theme_discountmymobile/modules/azmegamenu/translations/en.php
232/modules/azmegamenu/translations/en.php
233/modules/med_blocklanguages/med_blocklanguages.php
234/modules/med_blocklanguages/class/mediacom87.php
235/cache/smarty/compile/04/e2/04/04e204a6e61a20f795e7162b63a114c17361bacc.file.med_blocklanguages_hreflang.tpl.php
236/tools/smarty/sysplugins/smarty_internal_filter_handler.php
237/modules/royblockcart/royblockcart.php
238/themes/theme_discountmymobile/modules/royblockcart/translations/en.php
239/modules/royblockcart/translations/en.php
240/modules/roythemescustomizer/roythemescustomizer.php
241/themes/theme_discountmymobile/modules/roythemescustomizer/translations/en.php
242/modules/blockmyaccountfooter/blockmyaccountfooter.php
243/themes/theme_discountmymobile/modules/blockmyaccountfooter/translations/en.php
244/modules/blockmyaccountfooter/translations/en.php
245/modules/blockmyaccount/blockmyaccount.php
246/themes/theme_discountmymobile/modules/blockmyaccount/translations/en.php
247/modules/blockmyaccount/translations/en.php
248/modules/blocksupplier/blocksupplier.php
249/themes/theme_discountmymobile/modules/blocksupplier/translations/en.php
250/modules/blocksupplier/translations/en.php
251/modules/productpaymentlogos/productpaymentlogos.php
252/themes/theme_discountmymobile/modules/productpaymentlogos/translations/en.php
253/modules/productpaymentlogos/translations/en.php
254/modules/royblocksocial/royblocksocial.php
255/themes/theme_discountmymobile/modules/royblocksocial/translations/en.php
256/modules/royblocksocial/translations/en.php
257/modules/royblocklayered/royblocklayered.php
258/themes/theme_discountmymobile/modules/royblocklayered/translations/en.php
259/modules/royblocklayered/translations/en.php
260/modules/roypaymentlogo/roypaymentlogo.php
261/themes/theme_discountmymobile/modules/roypaymentlogo/translations/en.php
262/modules/roypaymentlogo/translations/en.php
263/modules/royhomecategory1/royhomecategory1.php
264/themes/theme_discountmymobile/modules/royhomecategory1/translations/en.php
265/modules/w4wfaq/w4wfaq.php
266/modules/w4wfaq/FaqCategory.php
267/modules/w4wfaq/FaqEntry.php
268/modules/w4wfaq/W4wFaqUpgrader.class.php
269/themes/theme_discountmymobile/modules/w4wfaq/translations/en.php
270/modules/w4wfaq/translations/en.php
271/modules/roybanners/roybanners.php
272/modules/royblocknewsletter/royblocknewsletter.php
273/themes/theme_discountmymobile/modules/royblocknewsletter/translations/en.php
274/modules/royblocknewsletter/translations/en.php
275/cache/smarty/compile/4a/84/41/4a8441f975bd0f5ec478ea96aaabeaf7eaad3713.file.header.tpl.php
276/tools/js_minify/jsmin.php
277/modules/royhomecategory3/royhomecategory3.php
278/themes/theme_discountmymobile/modules/royhomecategory3/translations/en.php
279/modules/royhomecategory2/royhomecategory2.php
280/themes/theme_discountmymobile/modules/royhomecategory2/translations/en.php
281/modules/roynewproducts/roynewproducts.php
282/themes/theme_discountmymobile/modules/roynewproducts/translations/en.php
283/modules/royhomecategory5/royhomecategory5.php
284/themes/theme_discountmymobile/modules/royhomecategory5/translations/en.php
285/modules/blockwishlist/blockwishlist.php
286/modules/blockwishlist/WishList.php
287/themes/theme_discountmymobile/modules/blockwishlist/translations/en.php
288/modules/blockwishlist/translations/en.php
289/modules/blockcms/blockcms.php
290/modules/blockcms/BlockCMSModel.php
291/themes/theme_discountmymobile/modules/blockcms/translations/en.php
292/modules/blockcms/translations/en.php
293/modules/royspecials/royspecials.php
294/themes/theme_discountmymobile/modules/royspecials/translations/en.php
295/modules/royspecials/translations/en.php
296/modules/royhomecategory4/royhomecategory4.php
297/themes/theme_discountmymobile/modules/royhomecategory4/translations/en.php
298/modules/royhomecategory6/royhomecategory6.php
299/themes/theme_discountmymobile/modules/royhomecategory6/translations/en.php
300/modules/mailalerts/mailalerts.php
301/modules/mailalerts/MailAlert.php
302/themes/theme_discountmymobile/modules/mailalerts/translations/en.php
303/modules/mailalerts/translations/en.php
304/modules/responsiveiframe/responsiveiframe.php
305/classes/Page.php
306/cache/smarty/compile/c3/65/0c/c3650ccd20324b84a50e4b25de496a2ec627e39a.file.respoi-footer.tpl.php
307/modules/deliveryorderautoupdate/deliveryorderautoupdate.php
308/modules/deliveryorderautoupdate/classes/emailHelper.php
309/modules/deliveryorderautoupdate/classes/trackingmodel.php
310/modules/deliveryorderautoupdate/classes/status.php
311/modules/deliveryorderautoupdate/classes/connectors/Carrier.php
312/modules/deliveryorderautoupdate/classes/returns.php
313/modules/deliveryorderautoupdate/translations/en.php
314/modules/abandonedcart/abandonedcart.php
315/modules/abandonedcart/classes/abandonedcart_core.php
316/modules/abandonedcart/translations/en.php
317/cache/smarty/compile/b2/92/e2/b292e2408ca7f78d9540d704d4e64d2a5932c1ec.file.abandonedcart_front.tpl.php
318/modules/lgcanonicalurls/lgcanonicalurls.php
319/modules/lgcanonicalurls/config/config.inc.php
320/modules/lgcanonicalurls/vendor/autoload.php
321/modules/lgcanonicalurls/vendor/composer/autoload_real.php
322/modules/lgcanonicalurls/vendor/composer/platform_check.php
323/modules/lgcanonicalurls/vendor/composer/autoload_static.php
324/modules/lgcanonicalurls/classes/LGCanonicalurlsObj.php
325/modules/lgcanonicalurls/translations/en.php
326/cache/smarty/compile/97/34/5e/97345ef8850521a92cb786ff0dd24d5cce87cdff.file.tag_canonical.tpl.php
327/modules/paypalwithfee/paypalwithfee.php
328/modules/paypalwithfee/classes/PaypalOrder.php
329/modules/paypalwithfee/classes/PaypalRefund.php
330/modules/paypalwithfee/helpers/TPLHelper.php
331/classes/PaymentModule.php
332/modules/paypalwithfee/translations/en.php
333/modules/royfeatured/royfeatured.php
334/themes/theme_discountmymobile/modules/royfeatured/translations/en.php
335/modules/royblockuserinfo/royblockuserinfo.php
336/themes/theme_discountmymobile/modules/royblockuserinfo/translations/en.php
337/modules/royblockuserinfo/translations/en.php
338/modules/stripe_official/stripe_official.php
339/modules/stripe_official/vendor/autoload.php
340/modules/stripe_official/vendor/composer/autoload_real.php
341/modules/stripe_official/vendor/composer/autoload_static.php
342/modules/stripe_official/vendor/stripe/stripe-php/lib/Event.php
343/modules/stripe_official/vendor/stripe/stripe-php/lib/ApiResource.php
344/modules/stripe_official/vendor/stripe/stripe-php/lib/StripeObject.php
345/modules/stripe_official/vendor/stripe/stripe-php/lib/ApiOperations/Request.php
346/modules/stripe_official/vendor/stripe/stripe-php/lib/ApiOperations/All.php
347/modules/stripe_official/vendor/stripe/stripe-php/lib/ApiOperations/Retrieve.php
348/modules/stripe_official/translations/en.php
349/modules/stripe_official/smarty/plugins/modifier.stripelreplace.php
350/modules/stripe_official/vendor/stripe/stripe-php/lib/Stripe.php
351/modules/ICodePSLibrary/ICodePSLibrary.php
352/modules/ICodePSLibrary/icodeLib/includes.php
353/modules/ICodePSLibrary/icodeLib/ICodeConfig.class.php
354/modules/ICodePSLibrary/icodeLib/ICodeDB.class.php
355/modules/ICodePSLibrary/icodeLib/ICodeError.class.php
356/modules/ICodePSLibrary/icodeLib/ICodeLicense.class.php
357/modules/ICodePSLibrary/icodeLib/ICodeMenu.class.php
358/modules/ICodePSLibrary/icodeLib/ICodePSAdvert.class.php
359/modules/ICodePSLibrary/icodeLib/ICodePSEnv.class.php
360/modules/ICodePSLibrary/icodeLib/ICodePSModule.class.php
361/modules/ICodePSLibrary/icodeLib/ICodeTools.class.php
362/modules/ICodePSLibrary/translations/en.php
363/modules/additionalproductsorder/additionalproductsorder.php
364/modules/additionalproductsorder/config/config.inc.php
365/modules/additionalproductsorder/src/Core/Module.php
366/modules/additionalproductsorder/src/Core/Context.php
367/modules/additionalproductsorder/src/Core/Configuration.php
368/modules/additionalproductsorder/src/Core/Controller.php
369/modules/additionalproductsorder/src/Core/Model.php
370/modules/additionalproductsorder/src/Core/Presenter/Presenter.php
371/modules/additionalproductsorder/src/Core/Presenter/FrontPresenter.php
372/modules/additionalproductsorder/src/Core/Presenter/HookPresenter.php
373/modules/additionalproductsorder/src/Core/Cache.php
374/modules/additionalproductsorder/src/Core/Translator.php
375/modules/additionalproductsorder/src/Core/Tools.php
376/modules/additionalproductsorder/src/Plugins/Partners/Partner.php
377/modules/additionalproductsorder/src/Plugins/Partners.php
378/modules/additionalproductsorder/classes/association/Association.php
379/modules/additionalproductsorder/classes/product/search/ProductSearchContext.php
380/modules/additionalproductsorder/classes/product/search/ProductSearchQuery.php
381/modules/additionalproductsorder/classes/product/search/ProductSearchResult.php
382/modules/additionalproductsorder/classes/product/CrossSellingProductsSearch.php
383/modules/additionalproductsorder/classes/product/ProductPresenter.php
384/modules/additionalproductsorder/classes/product/ProductClassicPresenter.php
385/modules/additionalproductsorder/classes/product/ProductThemePresenter.php
386/modules/additionalproductsorder/classes/product/ProductsListPresenter.php
387/modules/additionalproductsorder/classes/statistics/Statistics.php
388/modules/additionalproductsorder/controllers/hook/OnHook.php
389/modules/additionalproductsorder/translations/en.php
390/modules/additionalproductsorder/controllers/hook/Header.php
391/cache/smarty/compile/e0/e6/ae/e0e6aef9c0a920fdbad5ce60ab5d05211e8c304b.file.header.tpl.php
392/cache/smarty/compile/88/16/d6/8816d64742b3a6b2f61ce2fe6933431c4c8c6895.file.javascript.tpl.php
393/modules/tinymcepro/tinymcepro.php
394/modules/tinymcepro/lib/htmlTemplatesManager/htmlTemplatesManager.php
395/themes/theme_discountmymobile/modules/tinymcepro/translations/en.php
396/modules/tinymcepro/translations/en.php
397/modules/tinymcepro/key.php
398/modules/ybc_blocksearch/ybc_blocksearch.php
399/modules/ybc_blocksearch/classes/search_data.php
400/modules/ybc_blocksearch/classes/ybc_search_suggestion.php
401/modules/ybc_blocksearch/classes/blog_link_class.php
402/cache/smarty/compile/7c/b4/11/7cb41105451252d2ed525fca454b7efa2e1848fe.file.front-header.tpl.php
403/modules/ps_googleanalytics/ps_googleanalytics.php
404/modules/ps_googleanalytics/vendor/autoload.php
405/modules/ps_googleanalytics/vendor/composer/autoload_real.php
406/modules/ps_googleanalytics/vendor/composer/autoload_static.php
407/modules/ps_googleanalytics/translations/en.php
408/modules/ps_googleanalytics/classes/Hook/HookDisplayHeader.php
409/modules/ps_googleanalytics/classes/Hook/HookInterface.php
410/cache/smarty/compile/b3/66/54/b366549cde0501632cba3f2994dc2a5a9055a556.file.ps_googleanalytics.tpl.php
411/modules/ps_googleanalytics/classes/Handler/ModuleHandler.php
412/modules/ps_googleanalytics/classes/Handler/GanalyticsJsHandler.php
413/modules/ps_googleanalytics/classes/GoogleAnalyticsTools.php
414/cache/smarty/compile/7b/ed/28/7bed281d01bb416ecd3512bfc90ec1dfb0f4612a.file.ga_tag.tpl.php
415/modules/opartnoindex/opartnoindex.php
416/modules/roybrands/roybrands.php
417/themes/theme_discountmymobile/modules/roybrands/translations/en.php
418/modules/oparteasyredirect/oparteasyredirect.php
419/modules/oparteasyredirect/classes/redirections.php
420/modules/oparteasyredirect/classes/OpartPagesNotFound.php
421/modules/oparteasyredirect/helpers/helper.php
422/classes/Pack.php
423/modules/ets_multilayerslider/ets_multilayerslider.php
424/modules/ets_multilayerslider/classes/MLS_Obj.php
425/modules/ets_multilayerslider/classes/MLS_Slide.php
426/modules/ets_multilayerslider/classes/MLS_Layer.php
427/modules/ets_multilayerslider/classes/MLS_Config.php
428/modules/ets_multilayerslider/classes/Ets_mls_defines.php
429/modules/ets_affiliatemarketing/ets_affiliatemarketing.php
430/modules/ets_affiliatemarketing/classes/EtsAmAdmin.php
431/modules/ets_affiliatemarketing/classes/Ets_AM.php
432/modules/ets_affiliatemarketing/classes/Ets_Loyalty.php
433/modules/ets_affiliatemarketing/classes/Ets_Participation.php
434/modules/ets_affiliatemarketing/classes/Ets_Affiliate.php
435/modules/ets_affiliatemarketing/classes/Ets_Sponsor.php
436/modules/ets_affiliatemarketing/classes/Ets_Reward_Usage.php
437/modules/ets_affiliatemarketing/classes/Ets_Invitation.php
438/modules/ets_affiliatemarketing/classes/Ets_Banner.php
439/modules/ets_affiliatemarketing/classes/Ets_Withdraw.php
440/modules/ets_affiliatemarketing/classes/Ets_Withdraw_Field.php
441/modules/ets_affiliatemarketing/classes/Ets_PaymentMethod.php
442/modules/ets_affiliatemarketing/classes/Ets_Voucher.php
443/modules/ets_affiliatemarketing/controllers/front/all.php
444/classes/controller/ModuleFrontController.php
445/modules/ets_affiliatemarketing/classes/Ets_User.php
446/modules/ets_affiliatemarketing/classes/Ets_Reward_Product.php
447/modules/ets_affiliatemarketing/classes/Ets_Access_Key.php
448/modules/ets_affiliatemarketing/classes/Ets_Product_View.php
449/modules/ets_affiliatemarketing/classes/Ets_ImportExport.php
450/modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php
451/modules/ets_affiliatemarketing/classes/Ets_Affiliate_Config.php
452/modules/ets_affiliatemarketing/classes/Ets_PaymentMethodField.php
453/modules/ets_affiliatemarketing/defines.php
454/modules/ets_affiliatemarketing/classes/Ets_aff_email.php
455/modules/ets_affiliatemarketing/classes/Ets_aff_qr_code.php
456/modules/ets_affiliatemarketing/translations/en.php
457/cache/smarty/compile/41/52/7b/41527bc64343b4868674c6070c6214f2b23aa2ac.file.head.tpl.php
458/cache/smarty/compile/0d/91/75/0d917560dfc409b989e0c04ed6d0ff9a43421242.file.royblockuserinfo.tpl.php
459/cache/smarty/compile/66/4c/2a/664c2a6ef200faade77a015fee30dc01d705aa22.file.blocksearch-top.tpl.php
460/modules/pagesnotfound/pagesnotfound.php
461/themes/theme_discountmymobile/modules/pagesnotfound/translations/en.php
462/modules/pagesnotfound/translations/en.php
463/cache/smarty/compile/c5/11/86/c511863eb75a5165631df70c37dce6a9944c742f.file.blockwishlist_top.tpl.php
464/classes/ProductDownload.php
465/modules/ps_googleanalytics/classes/Hook/HookDisplayFooterProduct.php
466/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php
467/modules/ps_googleanalytics/classes/Wrapper/WrapperInterface.php
468/classes/Image.php
469/classes/Feature.php
470/modules/lgcomments/lgcomments.php
471/themes/theme_discountmymobile/modules/lgcomments/translations/en.php
472/modules/lgcomments/translations/en.php
473/cache/smarty/compile/90/46/ac/9046acb8dfef3ee534695851ea4566cddd0cade2.file.product_extra_right.tpl.php
474/cache/smarty/compile/ae/01/73/ae0173002ba7271d483832a08dcc61f4e4e52b42.file.product-additional.tpl.php
475/cache/smarty/compile/10/0a/bc/100abc680ed0e5403f0cc5ee48a2e033a91b8b95.file.product.tpl.php
476/cache/smarty/compile/6f/db/5b/6fdb5b0758d8b4dd815fb04d089528d07eb3bffb.file.blockwishlist-extra.tpl.php
477/cache/smarty/cache/productpaymentlogos/1/9/1/1/3/21/ff/e2/0c/ffe20ce6963b00a2081ffca8d3d2ef7861f63e90.productpaymentlogos.tpl.php
478/modules/additionalproductsorder/controllers/hook/ExtraProductPage.php
479/cache/smarty/compile/21/28/41/212841391adbc7149e7545ca562d30b6ce5bd45c.file.thumbnails.tpl.php
480/cache/smarty/compile/16/08/56/160856435eab54fbad3b5805ab6ffe3354a6539e.file.product_reviews_16.tpl.php
481/tools/smarty/plugins/modifier.date_format.php
482/cache/smarty/compile/21/67/db/2167dbfbae1b32e59e3b603ea1e28d6826b0176a.file.product_reviews_15.tpl.php
483/cache/smarty/compile/68/64/61/686461df34debbbe05142ad7b45e534bc9bd862c.file.hook.tpl.php
484/cache/smarty/cache/blockcms/2/1/9/1/1/3/21/0f/a7/b1/0fa7b16557f8a874fbce88808936d6fbe8b881d9.blockcms.tpl.php
485/cache/smarty/compile/f7/b4/fd/f7b4fd7328d0a50c90f2839bf7d9886df70be33f.file.form_block.tpl.php
486/modules/ps_googleanalytics/classes/Hook/HookDisplayFooter.php
487/modules/ps_googleanalytics/classes/Handler/GanalyticsDataHandler.php
488/modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php
489/cache/smarty/compile/fe/51/b5/fe51b5132b1ad1b435aa053c8d255428910b0664.file.product.tpl.php
490/tools/smarty/plugins/modifier.replace.php
491/tools/smarty/plugins/function.math.php
492/tools/smarty/plugins/function.cycle.php
493/tools/smarty/plugins/function.counter.php
494/cache/smarty/compile/38/87/91/38879112fd2e4063d8391d33504ef5dca0335d04.file.errors.tpl.php
495/tools/smarty/plugins/shared.mb_str_replace.php
496/tools/smarty/plugins/shared.make_timestamp.php
497/cache/smarty/compile/9c/f0/6d/9cf06d2a58ec922d9bf52f5a48a9b2fcdef6efbb.file.layout.tpl.php
498/cache/smarty/compile/5c/8b/5a/5c8b5ac7367175f14f355620cd2bc0c01ff90e16.file.header.tpl.php
499/tools/smarty/plugins/function.implode.php
500/cache/smarty/compile/7d/67/a4/7d67a477146feae0747777b8b1a64bd321b780f5.file.royaccount.tpl.php
501/classes/Customization.php
502/cache/smarty/compile/a7/8c/d2/a78cd25e994782c5acd774f6470552dc639fb4c4.file.blockcart.tpl.php
503/cache/smarty/cache/azmegamenu/1/9/1/1/3/21/8b/86/4b/8b864b16af4fc6efbda26dfbdeea53dfa0c69279.azmegamenu.tpl.php
504/cache/smarty/compile/81/5a/26/815a263e8ba66dc260bac5c9bea32d53e81f820c.file.megamenu.tpl.php
505/cache/smarty/compile/f4/16/ca/f416ca5d3ac69d99b10bb4b37595ccd139ce0dea.file.breadcrumb.tpl.php
506/tools/smarty/plugins/modifier.regex_replace.php
507/cache/smarty/compile/84/32/a1/8432a1584c5c5764331e65a4f14954fadcfd051f.file.footer.tpl.php
508/cache/smarty/cache/royblocksocial/1/9/1/1/3/21/43/f5/21/43f5218209a40c2c2b6f7f840b817a83560d467a.royblocksocial.tpl.php
509/cache/smarty/compile/f1/c0/22/f1c0226830856a4d9a89d6ab4901f024b2d12b85.file.blocknewsletter.tpl.php
510/themes/theme_discountmymobile/modules/blocknewsletter/translations/en.php
511/modules/blocknewsletter/translations/en.php
512/cache/smarty/cache/roypaymentlogo/1/9/1/1/3/21/32/72/63/327263d6a8099d0eb594022f407eb8816f43e165.roypaymentlogo.tpl.php
513/cache/smarty/compile/49/41/5a/49415a97f3df3cd88406d76888c4e2cad0051602.file.blockcart_side.tpl.php
514/cache/smarty/compile/77/b6/58/77b658cf035f27d438a6961c0361462b1aa74fd1.file.roymobile.tpl.php
515/modules/roylevibox/roylevibox.php
516/themes/theme_discountmymobile/modules/roylevibox/translations/en.php
517/cache/smarty/compile/2c/a9/00/2ca900077a73baf09a43b0b17db37dc9235f8e2b.file.global.tpl.php
518/cache/smarty/compile/27/41/12/27411267df9cc6ef72bf48edad9f3940a880a813.file.javascript.tpl.php