Mascot stella marina Patrick amico SpongeBob - Costume - MASFR00710 - Stella Marina mascotte Visualizza grande

Mascot stella marina Patrick amico SpongeBob - Costume

419,00 €

Nuovo prodotto

Patrick costume, stelle marine amico famoso di costume della mascotte SpongeBob proposto con tutti i suoi accessori in molti formati. Con il nostro costume Patrick la stella marina, organizzare carnevali, mostre, promozioni di vendita o feste private. Le nostre mascotte con tessuto lavabile verrà inviata rapidamente. Sav vostro ascolto.

Più dettagli

FormatoS (160-170 cm) | M (170-175 cm) | L (175-180 cm) | XL (180-185 cm) | XXL (185-190 cm) | XXXL (190-195 cm) | Formato Del Bambino | XXXXL (195-225 cm)
PaccoUn
Gruppo d'etàAdulti
SessoUnisex
AttrezzaturaNylon | Polyfoam | Lana Di Vetro
QualitàFiniture Incluse | Premio
ConsegnaNazionale | Internationale

Caratteristiche generali di prodotti:

Costume della mascotte venduta sul nostro sito SpotSound specializzata nel noleggio di attrezzature luce e suono a Parigi e l'Ile de France e nella vendita di mascotte, costumi e costumi per l'Europa su Internet. I nostri costumi mascotte sono l'ideale per numerose attività commerciali e di marketing o semplicemente per il vostro evento pubblico o privato, o semplicemente per una serata di festa con gli amici. Si precisa che non siamo più i costumi noleggio costumi, mascotte o Parigi per motivi pratici. Abbiamo in magazzino o su ordinazione oltre 5000 modelli!

I costumi mascotte sono in 3 parti: la testa, copricapo semirigido polyfoam con rinforzo per la stabilità, il corpo in cotone nylon e sintetici (scegliere la dimensione) e gli accessori che vanno dalle scarpe (dimensione della vostra scelta ), guanti o integrazioni la tua richiesta. Accessori quali tessuti sono lavabili in lavatrice in acqua calda circa come freddo e stirati. Siamo in grado di personalizzare qualsiasi mascotte secondo la vostra richiesta: aggiunta del logo, cambiare colore, regolazione in altezza o richieste particolari. Il nostro team è a vostra disposizione sia per posta, telefono o sulle nostre varie piattaforme di supporto online.

Le nostre mascotte sono forniti principalmente in Europa, ma siamo in grado di garantire la consegna in tutto il mondo dai corrieri internazionali a costi inferiori. I numeri di ricerca saranno le foto di mascotte in azione e riposo sono tratte direttamente dai luoghi di produzione dei nostri costumi. Tutti i nostri costumi rispettare le norme.

Questo prodotto contiene:

- 1 mascotte: Luce interna traspirante e lavabile in tessuto

- Accessori inclusi: abbigliamento corpo, scarpe, guanti, (corpo mascotte con chiusura a zip nella parte posteriore). Per altri accessori, non esitate a contattarci tramite la pagina di personalizzazione.

Il peso approssimativo è di circa 6 sterline - L'imballaggio su di lui: 60 * 60 * 50cm (lunghezza, larghezza, altezza)

Il costume della mascotte è disponibile in 7 taglie disponibili (scegliere al momento dell'ordine): S, M, L, XL, XXL, XXXL, XXXXL. Formati personalizzati per la tua richiesta, ma gli attuali standard dovrebbero concordare.

 

Spese di spedizione:

consegna con numero di pacchi in 7/8 giorni lavorativi al massimo dopo il ricevimento e la conferma del vostro pagamento.

Servizio di prima / vendita disponibili per  e-mail.

Nota: Si prega di moltiplicare le caratteristiche generali di cui sopra per il numero di persone che si vedono sulle immagini di cui sopra.

Non ci sono recensioni dei clienti per il momento.


Solo gli utenti che hanno già acquistato il prodotto possono aggiungere una recensione.

Non ci sono domande per il cliente per il momento.


La tua domanda è stata inviata con successo al nostro team. Grazie per la domanda!
Fai una domanda
nascondi modulo
Opzioni del prodotto
  
  Quantità:
Dimensione
Dimensione
 
Dimensione Del Bambino
[Sottrarre 15,00 €]
 
S (160-170 Cm)
 
 
M (170-180 Cm)
 
 
L (180-190 Cm)
 
 
Xl (190-200 Cm)
 
 
Xxl (200-220 Cm)
 
Cambiare colore
Cambiare colore
 
Nessun Cambiamento
 
 
1 Del Cambiamento Di Colore
[Inserisci 30,00 €]
 
2 Cambi Di Colore
[Inserisci 40,00 €]
 
3 Cambi Di Colore
[Inserisci 50,00 €]
Commento colore (codice esadecimale, il codice RGB, ecc ..)
Commento colore (codice esadecimale, il codice RGB, ecc ..)
Comentario De Color (Si El Cambio Seleccionado) 
 
Aggiunta Logo
Aggiunta Logo
Sì - Testa / Hat
 
[Inserisci 20,00 €]
Sì - Spalle X2
 
[Inserisci 30,00 €]
Sì - Indietro (Piccolo Formato)
 
[Inserisci 30,00 €]
Sì - Indietro (Grande Formato)
 
[Inserisci 50,00 €]
Sì - Torace (Formato Piccolo)
 
[Inserisci 30,00 €]
Sì - Petto (Grande Formato)
 
[Inserisci 50,00 €]
Sì - Ginocchia X2
 
[Inserisci 20,00 €]
Aggiunta di testo
Aggiunta di testo
Sì - Testa / Hat 
 
[Inserisci 20,00 €]
Sì - Torace (Formato Piccolo) 
 
[Inserisci 30,00 €]
Sì - Petto (Grande Formato) 
 
[Inserisci 40,00 €]
Sì - Indietro (Piccolo Formato)  
 
[Inserisci 30,00 €]
Sì - Indietro (Grande Formato) 
 
[Inserisci 40,00 €]
Con abbigliamento ? (se presente nella foto)
Con abbigliamento ? (se presente nella foto)
 
No
 
 
[Inserisci 20,00 €]
Accessori
Accessori
No
 
No
Cappello
 
Cappello
[Inserisci 30,00 €]
Pompons X2
 
Pompons X2
[Inserisci 15,00 €]
Cravatta
 
Cravatta
[Inserisci 15,00 €]
Occhiali
 
Occhiali
[Inserisci 20,00 €]
Ventre Ripieno
 
Ventre Ripieno
[Inserisci 60,00 €]
Fan
 
Fan
[Inserisci 40,00 €]
Scarpe
 
Scarpe
[Inserisci 50,00 €]
Accessorio Di Scelta
 
Accessorio Di Scelta
[Inserisci 50,00 €]
Schizzo (prima produzione)
Schizzo (prima produzione)
 
No
 
 
[Inserisci 40,00 €]
  
  Quantità:
Load Time18186 ms - You'd better run your shop on a toaster
Querying Time4236 ms
Queries1072
Memory Peak Usage51.3 Mb
Included Files409 files - 7.64 Mb
PrestaShop Cache- Mb
Global vars2.61 Mb
PrestaShop Version1.6.1.8
PHP Version5.6.40-0+deb8u12 (OK)
MySQL Version10.0.38-MariaDB-0+deb8u1 (OK)
Memory Limit4096M
Max Execution Time120s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 216 ms 216 ms 8.69 Mb 8.94 Mb
__construct 0 ms 216 ms - Mb 8.94 Mb
init 125 ms 341 ms 3.51 Mb 12.44 Mb
checkAccess 0 ms 341 ms - Mb 12.44 Mb
setMedia 15 ms 356 ms 0.07 Mb 12.50 Mb
postProcess 0 ms 356 ms - Mb 12.50 Mb
initHeader 0 ms 356 ms - Mb 12.50 Mb
initContent 9847 ms 10203 ms 27.60 Mb 40.42 Mb
initFooter 514 ms 10717 ms 1.74 Mb 43.86 Mb
display 7469 ms 18186 ms 7.34 Mb 51.28 Mb
Hook Time Memory Usage
hookproductfooter 6071 ms 10.50 Mb
hookvegamenu 1186 ms 1.00 Mb
__construct 1104 ms 17.00 Mb
hookdisplayTop 772 ms 2.50 Mb
hookdisplayProductListReviews 677 ms 5.50 Mb
hookheader 585 ms 1.00 Mb
hookmegamenu 308 ms 2.25 Mb
hookfooter 280 ms - Mb
hookproducttabcontent 155 ms - Mb
hookdisplayHeader 147 ms - Mb
hookdisplayRightColumnProduct 122 ms 0.75 Mb
hookdisplayNav 82 ms - Mb
hookdisplayFooter 33 ms - Mb
hooktop 25 ms - Mb
hookblockFooter4 20 ms - Mb
hookextraright 15 ms 0.25 Mb
hookextraleft 13 ms 0.25 Mb
hookdisplayProductTabContent 11 ms 0.50 Mb
hookblockFooter1 9 ms - Mb
hookblockFooter3 9 ms - Mb
hookproductactions 7 ms - Mb
hookproducttab 6 ms - Mb
hookblockFooterExtra 5 ms - Mb
hookdisplayProductTab 4 ms - Mb
hookdisplayFooterProduct 3 ms - Mb
hookblockFooter2 2 ms - Mb
hookDisplayOverrideTemplate 2 ms - Mb
hookdisplayLeftColumnProduct 1 ms - Mb
hookdisplayProductButtons 1 ms - Mb
hookmoduleRoutes - ms - Mb
hookactionProductOutOfStock - ms - Mb
31 hooks 11655 ms 41.50 Mb
Module Time Memory Usage
attributewizardpro 3201 ms 2.25 Mb
productscategory 2931 ms 9.00 Mb
posvegamenu 1213 ms 1.00 Mb
possearchcategories 798 ms 2.75 Mb
contentpack 655 ms 5.00 Mb
gsnippetsreviews 373 ms 3.00 Mb
fbloginblock 352 ms 0.75 Mb
posmegamenu 328 ms 2.50 Mb
blockcategories 278 ms 0.50 Mb
facebookpsessentials 268 ms 1.00 Mb
internationaltargeting 161 ms - Mb
posstaticfooter 113 ms 1.50 Mb
mailalerts 86 ms 2.00 Mb
blockmyaccountfooter 80 ms 0.50 Mb
htmlboxpro 70 ms 1.25 Mb
pm_modalcart3 63 ms 1.00 Mb
blocklanguages 46 ms 0.25 Mb
blockwishlist 46 ms 0.25 Mb
tawkto 40 ms - Mb
blockcart 40 ms 0.25 Mb
sendtoafriend 39 ms 0.25 Mb
ganalytics 38 ms 0.25 Mb
stripe_official 36 ms 1.00 Mb
blocknewsletter 33 ms 0.50 Mb
posthemeoption 32 ms - Mb
posslideshow 31 ms 0.75 Mb
favoriteproducts 31 ms 0.25 Mb
posspecialproducts 30 ms - Mb
blockcurrencies 29 ms 0.50 Mb
facebookpsshoptab 28 ms 0.25 Mb
infinitescroll 28 ms 0.50 Mb
blockcms 25 ms 0.25 Mb
blockcontact 25 ms - Mb
blockviewed 25 ms - Mb
posstaticblocks 21 ms - Mb
blockpaymentlogo 15 ms - Mb
blockuserinfo 15 ms - Mb
artfreegdpr 13 ms 1.25 Mb
smartblog 7 ms 0.75 Mb
blocksupplier 6 ms - Mb
blockmanufacturer 3 ms 0.50 Mb
blockmyaccount 3 ms - Mb
pm_multiplefeatures 2 ms - Mb
43 modules 11655 ms 41.50 Mb

Stopwatch SQL - 1072 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2021-01-20 00:00:00",
INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 7 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 7 AND pl.id_shop = 1 )
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=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 7)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 9882949 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100
1417.7 182277 Yes /classes/Category.php:783
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/4/4/7/1/21/9882949/4/5b/d8/37/5bd837ac47c60610a5a73dbb2f6ed98c86ed7173.blockcategories_footer.tpl.php'
WHERE `template_hash`='f19000fcda7f38bfdc7cff8c81c5dd1d' AND cache_id="blockcategories|1|4|4|7|1|21|9882949|4" AND compile_id=""
30 1 /classes/SmartyCustom.php:183
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` = 19
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 710) AND (b.`id_shop` = 1) LIMIT 1
27.5 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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 710) AND (b.`id_shop` = 1) LIMIT 1
27.2 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
26.6 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='83b6732a48d65fe35e1cf970ad056af2' AND cache_id="productscategory|710|9882949|1|4|4|7|1|21" AND compile_id="" LIMIT 1
25.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 705988 LIMIT 1
23.2 1 /classes/Combination.php:344
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
23 300 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`,
ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, pa.`unit_price_impact`, IFNULL(stock.quantity, 0) as quantity
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 = 1)
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 = 1  AND stock.id_shop_group = 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` AND al.`id_lang` = 7)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 710 
GROUP BY pa.`id_product_attribute`, a.`id_attribute`
ORDER BY pa.`id_product_attribute`
22.6 37 Yes Yes /modules/attributewizardpro/attributewizardpro.php:1941
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 7
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 44) LIMIT 1
22.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 24
AND cl.id_shop = 1 
AND cl.`id_category` = 9882949 LIMIT 1
20.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 9882949 LIMIT 1
17.7 1 /classes/Category.php:1054
UPDATE `ps_smarty_lazy_cache`
SET filepath='812/1/4/4/7/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="812|1|4|4|7|1|21" AND compile_id=""
17.6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
17.6 0 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE nleft, nright FROM `ps_category` WHERE id_category = 9882949 LIMIT 1
16.9 1 /classes/Category.php:1512
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 73 AND `id_shop` = 1 LIMIT 1
16.7 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 7)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
16.7 245 Yes /classes/Country.php:131
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
16.4 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE *
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 7
AND `active` = 1
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
14.8 153 Yes /modules/possearchcategories/possearchcategories.php:306
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
14.8 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 58 AND `id_shop` = 1 LIMIT 1
14.5 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
14.2 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='083720f0af31d239edd1031b3d29245f' AND cache_id="blockcontact|1|4|4|7|1|21" AND compile_id="" LIMIT 1
13.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="812|1|4|4|7|1|21" AND compile_id="" LIMIT 1
13.6 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 17
AND cl.id_shop = 1 
AND cl.`id_category` = 9882949 LIMIT 1
13.4 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
13.3 16 Yes /classes/SpecificPrice.php:361
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` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 710) AND (b.`id_shop` = 1) LIMIT 1
13.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 1 AND `id_shop` = 1 LIMIT 1
12.9 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 710 AND `id_shop` = 1
12.8 11 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
12.7 0 /classes/Category.php:1219
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34112) AND (b.`id_shop` = 1) LIMIT 1
12.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
12.5 196 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
12.4 16 Yes /classes/SpecificPrice.php:361
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
12.2 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 45401 LIMIT 1
12.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883003) LIMIT 1
12 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882958) LIMIT 1
11.2 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 1
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
11 9 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
11 1 /classes/shop/Shop.php:1067
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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 1172 LIMIT 1
11 39 /classes/Product.php:765
SELECT SQL_NO_CACHE id_product FROM `ps_category_product` WHERE `id_product` = 710 AND `id_category` IN (9882949) LIMIT 1
10.8 4 /classes/Product.php:4885
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24131|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
10.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883088) LIMIT 1
10.7 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='21235/1/4/4/7/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21235|1|4|4|7|1|21" AND compile_id=""
10.6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
10.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 54) LIMIT 1
10.4 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` = 15
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 710) AND (b.`id_shop` = 1) LIMIT 1
10.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
10 1 /classes/Country.php:174
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"4081|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
9.9 1 /classes/SmartyCustom.php:263
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882928) AND (b.`id_shop` = 1) LIMIT 1
9.7 1 /Adapter/Adapter_EntityMapper.php:61
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`=710
9.7 83 /classes/Tag.php:205
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883029) AND (b.`id_shop` = 1) LIMIT 1
9.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
9.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
9.3 0 /classes/Category.php:1219
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
9.2 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22017
ORDER BY `id_specific_price_priority` DESC LIMIT 1
9.1 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4081) AND (id_product_attribute = 45031) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
9.1 0 /classes/stock/StockAvailable.php:378
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882937) AND (b.`id_shop` = 1) LIMIT 1
9.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 6 AND `id_shop` = 1 LIMIT 1
9 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (4))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
9 304 Yes Yes /classes/Hook.php:355
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 = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 9882949
AND `active` = 1
AND cg.`id_group` =4
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
8.9 1 Yes Yes /classes/Category.php:658
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882957) AND (b.`id_shop` = 1) LIMIT 1
8.8 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 = 1)
WHERE i.`id_product` = 710
AND image_shop.`cover` = 1 LIMIT 1
8.7 1 /classes/Product.php:2743
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
8.7 0 /classes/Category.php:1219
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"20340|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
8.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 710
ORDER BY `id_specific_price_priority` DESC LIMIT 1
8.6 0 /classes/SpecificPrice.php:198
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882950) AND (b.`id_shop` = 1) LIMIT 1
8.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6268) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.6 0 /classes/stock/StockAvailable.php:378
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` = 7)
WHERE `level_depth` = 1
8.5 24 /classes/Category.php:1673
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882905) LIMIT 1
8.5 1 /Adapter/Adapter_EntityMapper.php:61
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883035) AND (b.`id_shop` = 1) LIMIT 1
8.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 8 AND `id_shop` = 1 LIMIT 1
8.4 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"1666|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
8.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
8.3 0 /classes/Category.php:1219
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883004
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.1 6 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883042"
8.1 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883087) LIMIT 1
8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883082"
8 7 /modules/posvegamenu/posvegamenu.php:553
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883039) AND (b.`id_shop` = 1) LIMIT 1
7.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
7.7 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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 16 Yes /classes/SpecificPrice.php:361
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882959
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.6 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883009) LIMIT 1
7.6 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883033
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE pc.*
FROM `ps_blockguestbook` pc
WHERE pc.active = 1 AND pc.`is_deleted` = 0 AND
`id_shop` = '1' AND `id_lang` = '7'
ORDER BY pc.`date_add` DESC LIMIT 0 ,3
7.4 1 Yes /modules/contentpack/classes/guestbook.class.php:206
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1666
ORDER BY f.position ASC
7.3 8 Yes /classes/Product.php:4453
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883028) AND (b.`id_shop` = 1) LIMIT 1
7.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_menu_idcat_9883087"
7.3 7 /modules/posmegamenu/posmegamenu.php:556
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882897) AND (b.`id_shop` = 1) LIMIT 1
7.2 1 /Adapter/Adapter_EntityMapper.php:61
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882940) AND (b.`id_shop` = 1) LIMIT 1
7.2 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882946
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.2 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.1 16 Yes /classes/SpecificPrice.php:361
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882957
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.1 1 Yes Yes /classes/Category.php:859
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
7 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE pc.*
FROM `ps_reviewsnippets` pc
WHERE pc.`id_product` = 710
AND pc.deleted = 0  AND id_shop = 1
ORDER BY pc.`date_add` DESC LIMIT 0 ,5
7 0 /modules/contentpack/classes/reviewshelp.class.php:520
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882845) AND (b.`id_shop` = 1) LIMIT 1
7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883025) LIMIT 1
7 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882906
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE l.id_linksmegatop, l.new_window, ll.link, ll.label
FROM ps_linksmegatop l
LEFT JOIN ps_linksmegatop_lang ll ON (l.id_linksmegatop = ll.id_linksmegatop AND ll.id_lang = 7 AND ll.id_shop=1)
WHERE 1  AND l.id_linksmegatop = "3"
AND l.id_shop IN (0, 1)
7 1 /modules/posmegamenu/megatoplinks.class.php:37
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 64 AND `id_shop` = 1
6.9 14 /Adapter/Adapter_EntityMapper.php:68
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883021
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.9 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 57
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.8 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
6.8 16 /classes/Currency.php:472
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882805
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.7 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 16 AND `id_shop` = 1 LIMIT 1
6.7 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883082_right"
6.7 7 /modules/posvegamenu/posvegamenu.php:553
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882912) AND (b.`id_shop` = 1) LIMIT 1
6.7 1 /Adapter/Adapter_EntityMapper.php:61
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`)
6.7 9060 /classes/Configuration.php:148
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882808) AND (b.`id_shop` = 1) LIMIT 1
6.7 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"6268|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
6.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883009 AND `id_shop` = 1
6.6 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =7
AND `hook_position` = "blockFooter1" 
AND `showhook` = 1
6.6 4 /modules/posstaticfooter/models/Staticfooter.php:51
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883011) LIMIT 1
6.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21235 AND id_shop=1 LIMIT 1
6.6 1 /classes/Product.php:5032
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"2319|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
6.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
6.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 7) LIMIT 1
6.4 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883019
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.4 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 54) AND (b.`id_shop` = 1) LIMIT 1
6.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882959) AND (b.`id_shop` = 1) LIMIT 1
6.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882889) AND (b.`id_shop` = 1) LIMIT 1
6.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2319) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.3 1 /classes/stock/StockAvailable.php:378
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 =7 AND m.page = "product" LIMIT 1
6.3 1 /classes/Theme.php:275
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883032
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.3 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882964) AND (b.`id_shop` = 1) LIMIT 1
6.2 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24123|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
6.2 1 /classes/SmartyCustom.php:263
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4081)
6.2 38 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
6.1 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
6.1 1 /classes/shop/ShopUrl.php:169
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2319) AND (b.`id_shop` = 1) LIMIT 1
6.1 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882945
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.1 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882812) AND (b.`id_shop` = 1) LIMIT 1
6.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
6 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='34fbf4ad1f968e5cc818dbd64715ce34' AND cache_id="blocksearch-top|1|4|4|7|1|21" AND compile_id="" LIMIT 1
6 1 /classes/SmartyCustom.php:215
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883089
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6 1 Yes Yes /classes/Category.php:859
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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 21235 LIMIT 1
6 37 /classes/Product.php:765
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882929
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.9 1 Yes Yes /classes/Category.php:859
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 (44811, 44812, 44813, 44814, 44815, 44816, 44817, 44818, 44819, 44820, 44821, 44822, 44823, 44824, 44825, 44826, 44827, 44828, 44829, 44830, 44831, 44832, 44833, 44834, 44835, 44836, 44837, 44838, 44839, 44840, 44841, 44842, 44843, 44844, 44845, 44846, 44847) AND il.`id_lang` = 7 ORDER by i.`position`
5.9 1 Yes /classes/Product.php:2186
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882881
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.9 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882936) AND (b.`id_shop` = 1) LIMIT 1
5.9 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
5.8 0 /classes/Product.php:1278
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883037
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.8 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1666) AND (b.`id_shop` = 1) LIMIT 1
5.8 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882939
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.8 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882922
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.7 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 7) LIMIT 1
5.7 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
WHERE pa.id_product = 1666 LIMIT 1
5.7 36 /classes/Product.php:752
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
5.7 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883089 AND `id_shop` = 1
5.7 14 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
5.6 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882816) LIMIT 1
5.6 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 54
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.6 6 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "cloudcache" LIMIT 1
5.5 0 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.5 0 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 27 AND `id_shop` = 1 LIMIT 1
5.5 1 /modules/fbloginblock/classes/facebookhelp.class.php:110
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 24131
ORDER BY f.position ASC
5.5 8 Yes /classes/Product.php:4453
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882918) AND (b.`id_shop` = 1) LIMIT 1
5.5 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882916
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882960) LIMIT 1
5.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2319 AND id_shop=1 LIMIT 1
5.5 1 /classes/Product.php:5032
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882932) AND (b.`id_shop` = 1) LIMIT 1
5.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 5 AND `id_shop` = 1 LIMIT 1
5.4 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883034
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.4 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883065) AND (b.`id_shop` = 1) LIMIT 1
5.4 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`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="31827|1|4|4|7|1|21" AND compile_id="" LIMIT 1
5.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 26 AND `id_shop` = 1 LIMIT 1
5.4 1 /modules/fbloginblock/classes/facebookhelp.class.php:132
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882949) AND (b.`id_shop` = 1) LIMIT 1
5.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
5.3 139 /classes/module/Module.php:2141
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883031) AND (b.`id_shop` = 1) LIMIT 1
5.3 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='1172/1/4/4/7/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="1172|1|4|4|7|1|21" AND compile_id=""
5.2 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883027_right"
5.2 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
5.2 0 /classes/Category.php:1219
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
5.2 0 /classes/Product.php:1278
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883036) AND (b.`id_shop` = 1) LIMIT 1
5.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31827) AND (id_product_attribute = 45401) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.1 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="1172|1|4|4|7|1|21" AND compile_id="" LIMIT 1
5.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
5.1 192 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883035) LIMIT 1
5.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 7 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND c.`id_category` != 9883001
AND `level_depth` <= 4
AND c.id_category IN (SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (4))
ORDER BY `level_depth` ASC, cl.`name` ASC
5 146 Yes /modules/posvegamenu/posvegamenu.php:983
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 20340 AND id_shop=1 LIMIT 1
5 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21235) AND (id_product_attribute = 45216) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 710 AND deleted = 0  
AND id_shop = 1 LIMIT 1
5 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883021) AND (b.`id_shop` = 1) LIMIT 1
4.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 45031 LIMIT 1
4.8 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9882958 AND `id_shop` = 1
4.8 13 /Adapter/Adapter_EntityMapper.php:68
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882842
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.8 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 9882949 AND ctg.`id_group` = 4 LIMIT 1
4.8 1 /classes/Category.php:1309
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883041) LIMIT 1
4.8 1 /Adapter/Adapter_EntityMapper.php:61
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 22017
ORDER BY f.position ASC
4.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
4.8 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1666
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.7 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 21235
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.7 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.6 0 /classes/stock/StockAvailable.php:670
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882803
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.6 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882926
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.6 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 24131
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.6 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1172 AND id_shop=1 LIMIT 1
4.6 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
4.6 0 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24131|1|4|4|7|1|21" AND compile_id="" LIMIT 1
4.6 1 /classes/SmartyCustom.php:215
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883081) AND (b.`id_shop` = 1) LIMIT 1
4.6 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
4.6 0 /classes/Product.php:1278
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
4.6 0 /classes/Product.php:1278
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882940
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1666 AND `id_group` = 4 LIMIT 1
4.5 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883027) LIMIT 1
4.5 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`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="24131|1|4|4|7|1|21" AND compile_id="" LIMIT 1
4.5 1 /classes/SmartyCustom.php:215
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882905
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883042 AND `id_shop` = 1
4.5 14 /Adapter/Adapter_EntityMapper.php:68
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 = 1)
WHERE pa.id_product = 20340 LIMIT 1
4.5 37 /classes/Product.php:752
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882844) AND (b.`id_shop` = 1) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE round(AVG(`rating`),2) AS "avg_rating_decimal"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 710 AND deleted = 0 AND id_shop = 1 LIMIT 1
4.4 0 /modules/contentpack/classes/reviewshelp.class.php:385
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
4.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
4.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 23
AND cl.id_shop = 1 
AND cl.`id_category` = 9882949 LIMIT 1
4.3 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
4.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =7
AND `hook_position` = "blockFooter3" 
AND `showhook` = 1
4.3 4 /modules/posstaticfooter/models/Staticfooter.php:51
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
4.3 16 Yes /classes/SpecificPrice.php:361
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882958) AND (b.`id_shop` = 1) LIMIT 1
4.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.1 0 /classes/stock/StockAvailable.php:670
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882809
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.1 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
4.1 196 /classes/module/Module.php:277
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 33414 AND `id_group` = 4 LIMIT 1
4.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
4.1 16 Yes /classes/SpecificPrice.php:361
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882885
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882963
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 710 AND deleted = 0  
AND id_shop = 1 LIMIT 1
4 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882923) AND (b.`id_shop` = 1) LIMIT 1
4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
4 16 Yes /classes/SpecificPrice.php:361
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882896) AND (b.`id_shop` = 1) LIMIT 1
3.9 1 /Adapter/Adapter_EntityMapper.php:61
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(
"2021-01-20 00:00:00",
INTERVAL 1000 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 = 1)
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=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 7 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 7 AND cl.id_shop = 1 
)
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=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 7)
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 = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 710 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
3.9 9 Yes Yes /classes/Product.php:3598
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882815) AND (b.`id_shop` = 1) LIMIT 1
3.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 710 AND deleted = 0  
AND id_shop = 1 LIMIT 1
3.9 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2319
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.9 0 /classes/SpecificPrice.php:198
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 33954)
3.8 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 33954) AND (id_product_attribute = 725931) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.8 0 /classes/stock/StockAvailable.php:378
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882925
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.8 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 710 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
3.7 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 45290 LIMIT 1
3.7 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883033) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22017|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
3.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882815) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
WHERE p.id_product = 710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
3.7 0 /classes/Product.php:1278
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"1666|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
3.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 20340 AND `id_group` = 4 LIMIT 1
3.7 0 /classes/GroupReduction.php:149
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882845
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.7 12 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883049
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.7 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
3.7 16 Yes /classes/SpecificPrice.php:361
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 33954) AND (b.`id_shop` = 1) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_menu_idcat_45"
3.7 7 /modules/posmegamenu/posmegamenu.php:556
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883041) AND (b.`id_shop` = 1) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883038) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 44994 LIMIT 1
3.6 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
3.6 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE round(AVG(`rating`),2) AS "avg_rating_decimal"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 710 AND deleted = 0 AND id_shop = 1 LIMIT 1
3.6 0 /modules/contentpack/classes/reviewshelp.class.php:385
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882930) AND (b.`id_shop` = 1) LIMIT 1
3.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883087 AND `id_shop` = 1
3.5 14 /Adapter/Adapter_EntityMapper.php:68
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` = 24
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 710) AND (b.`id_shop` = 1) LIMIT 1
3.5 1 /Adapter/Adapter_EntityMapper.php:61
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`=710
3.5 83 /classes/Tag.php:205
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882920) AND (b.`id_shop` = 1) LIMIT 1
3.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 58) LIMIT 1
3.5 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22151|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
3.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
3.4 16 Yes /classes/SpecificPrice.php:361
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`=710
3.4 83 /classes/Tag.php:205
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "facebookpsconnect" LIMIT 1
3.4 0 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 33414) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4081
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.4 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 812 AND id_shop=1 LIMIT 1
3.3 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883004"
3.3 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24131) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.3 0 /classes/stock/StockAvailable.php:378
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882813) AND (b.`id_shop` = 1) LIMIT 1
3.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 812 AND `id_group` = 4 LIMIT 1
3.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="2319|1|4|4|7|1|21" AND compile_id="" LIMIT 1
3.3 1 /classes/SmartyCustom.php:215
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883037) AND (b.`id_shop` = 1) LIMIT 1
3.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22017 AND `id_group` = 4 LIMIT 1
3.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883015) LIMIT 1
3.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 21235
ORDER BY f.position ASC
3.2 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
3.2 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 45216 LIMIT 1
3.2 1 /classes/Combination.php:344
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882943
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.2 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 57 AND `id_shop` = 1 LIMIT 1
3.1 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 34112)
3.1 37 /classes/Product.php:2998
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882903) AND (b.`id_shop` = 1) LIMIT 1
3.1 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883082
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.1 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883027
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.1 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882952) AND (b.`id_shop` = 1) LIMIT 1
3.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 45) LIMIT 1
3.1 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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 33414) AND (b.`id_shop` = 1) LIMIT 1
3.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"34112|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
3.1 1 /classes/SmartyCustom.php:263
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882948
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 10 AND `id_shop` = 1 LIMIT 1
3 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
3 16 Yes /classes/SpecificPrice.php:361
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882960) AND (b.`id_shop` = 1) LIMIT 1
3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9882815"
3 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
3 16 Yes /classes/SpecificPrice.php:361
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883009) AND (b.`id_shop` = 1) LIMIT 1
3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882959) LIMIT 1
2.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 18 AND `id_shop` = 1 LIMIT 1
2.9 1 /modules/fbloginblock/classes/facebookhelp.class.php:132
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_1"
2.9 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
2.9 776 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24131 AND `id_group` = 4 LIMIT 1
2.8 0 /classes/GroupReduction.php:149
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882949
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.8 1 Yes Yes /classes/Category.php:859
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20340
ORDER BY f.position ASC
2.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 45364 LIMIT 1
2.8 1 /classes/Combination.php:344
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 812
ORDER BY f.position ASC
2.8 8 Yes /classes/Product.php:4453
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 = 1)
WHERE pa.id_product = 710 LIMIT 1
2.7 37 /classes/Product.php:752
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.7 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =7
AND `hook_position` = "blockFooter4" 
AND `showhook` = 1
2.7 4 /modules/posstaticfooter/models/Staticfooter.php:51
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 45 AND `id_shop` = 1
2.7 14 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="34112|1|4|4|7|1|21" AND compile_id="" LIMIT 1
2.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883004_right"
2.7 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 45327 LIMIT 1
2.7 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9882905 AND `id_shop` = 1
2.7 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 710 AND deleted = 0  
AND id_shop = 1 LIMIT 1
2.6 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883087) AND (b.`id_shop` = 1) LIMIT 1
2.6 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 44
AND c.nright >= 45
AND c.nleft >= 8
AND c.nright <= 293
AND cl.id_lang = 7
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
2.6 18 Yes /classes/Tools.php:1304
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 45253 LIMIT 1
2.6 1 /classes/Combination.php:344
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883029
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.6 1 Yes Yes /classes/Category.php:859
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24123|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
2.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24131|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
2.6 1 /classes/SmartyCustom.php:263
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`=710
2.5 83 /classes/Tag.php:205
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.5 0 /classes/stock/StockAvailable.php:646
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 20340)
2.5 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
2.5 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.5 16 Yes /classes/SpecificPrice.php:361
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 = 1)
WHERE pa.id_product = 33954 LIMIT 1
2.5 36 /classes/Product.php:752
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="33414|1|4|4|7|1|21" AND compile_id="" LIMIT 1
2.5 1 /classes/SmartyCustom.php:215
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883004
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.4 6 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9882816_right"
2.4 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1666 AND id_shop=1 LIMIT 1
2.4 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 22 AND `id_shop` = 1 LIMIT 1
2.4 1 /modules/fbloginblock/classes/facebookhelp.class.php:132
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.4 16 Yes /classes/SpecificPrice.php:361
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882892) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
WHERE pa.id_product = 2319 LIMIT 1
2.4 38 /classes/Product.php:752
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 22151
ORDER BY f.position ASC
2.4 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9882960 AND `id_shop` = 1
2.4 13 /Adapter/Adapter_EntityMapper.php:68
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 = 1)
WHERE pa.id_product = 1172 LIMIT 1
2.4 39 /classes/Product.php:752
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.4 16 Yes /classes/SpecificPrice.php:361
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882951
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.4 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882815
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.4 3 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 64) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"33954|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
2.4 1 /classes/SmartyCustom.php:263
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 = 1)
WHERE pa.id_product = 6268 LIMIT 1
2.4 37 /classes/Product.php:752
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 = 1)
WHERE pa.id_product = 34112 LIMIT 1
2.3 37 /classes/Product.php:752
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882916) AND (b.`id_shop` = 1) LIMIT 1
2.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882803) AND (b.`id_shop` = 1) LIMIT 1
2.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 812 LIMIT 1
2.3 37 /classes/Product.php:765
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882934
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.3 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883089) LIMIT 1
2.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.3 16 Yes /classes/SpecificPrice.php:361
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882954
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.3 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 34112 AND `id_group` = 4 LIMIT 1
2.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9882816 AND `id_shop` = 1
2.2 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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
2.2 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = ""
2.2 7 /modules/posvegamenu/posvegamenu.php:553
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883065
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.2 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883049"
2.2 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 55) LIMIT 1
2.2 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882961
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.2 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883089"
2.2 7 /modules/posvegamenu/posvegamenu.php:553
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 24123) AND (b.`id_shop` = 1) LIMIT 1
2.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_awp_attribute_wizard_pro`
2.2 1 /modules/attributewizardpro/attributewizardpro.php:252
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 = 1)
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 = 1  AND stock.id_shop_group = 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 = 1)
WHERE pa.`id_product` = 710
AND al.`id_lang` = 7
AND agl.`id_lang` = 7
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
2.1 37 Yes Yes /override/classes/Product.php:28
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 33414
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.1 0 /classes/SpecificPrice.php:198
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882806) AND (b.`id_shop` = 1) LIMIT 1
2.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 23 AND `id_shop` = 1 LIMIT 1
2.1 1 /modules/fbloginblock/classes/facebookhelp.class.php:110
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883063) LIMIT 1
2.1 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.1 529 /classes/Hook.php:236
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24123 AND `id_group` = 4 LIMIT 1
2.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 7 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND c.`id_category` != 9883001
AND `level_depth` <= 4
AND c.id_category IN (SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (4))
ORDER BY `level_depth` ASC, cl.`name` ASC
2.1 146 Yes /modules/posmegamenu/posmegamenu.php:997
SELECT SQL_NO_CACHE count(o.id_order) as count FROM ps_orders as o 
LEFT JOIN ps_order_detail as od ON(o.id_order = od.id_order)
WHERE o.id_customer = 0 AND od.product_id = 710
AND o.id_shop = 1 AND od.id_shop = 1
2.1 1 /modules/contentpack/classes/reviewshelp.class.php:984
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` = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
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 = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 710
2.1 37 /classes/Product.php:5692
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9882816"
2.1 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 7 AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 9883001)
AND `level_depth` <= 4
AND cg.`id_group` IN (4)
ORDER BY `level_depth` ASC, cl.`name` ASC
2.1 147 Yes /modules/blockcategories/blockcategories.php:304
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883063) AND (b.`id_shop` = 1) LIMIT 1
2.1 1 /Adapter/Adapter_EntityMapper.php:61
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882943) AND (b.`id_shop` = 1) LIMIT 1
2.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 54 AND `id_shop` = 1
2.1 13 /Adapter/Adapter_EntityMapper.php:68
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 24123)
2.1 37 /classes/Product.php:2998
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 = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 710
ORDER BY `position`
2.1 1 Yes /classes/Product.php:2723
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 = 1)
WHERE pa.id_product = 33414 LIMIT 1
2.1 37 /classes/Product.php:752
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 38 AND `id_shop` = 1 LIMIT 1
2.1 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 30 AND `id_shop` = 1 LIMIT 1
2.1 1 /modules/fbloginblock/classes/facebookhelp.class.php:132
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 24123
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.1 0 /classes/SpecificPrice.php:198
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882928
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2 1 Yes Yes /classes/Category.php:859
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1666)
2 37 /classes/Product.php:2998
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882958
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883027"
2 7 /modules/posvegamenu/posvegamenu.php:553
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882910
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`)
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 )
WHERE p.`id_product` = 710
AND l.`active` = 1
2 13 /classes/Product.php:5014
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883003) AND (b.`id_shop` = 1) LIMIT 1
2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9882806"
2 7 /modules/posvegamenu/posvegamenu.php:553
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882891
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2 1 Yes Yes /classes/Category.php:859
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883089) AND (b.`id_shop` = 1) LIMIT 1
2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 44957 LIMIT 1
1.9 1 /classes/Combination.php:344
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882937
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.9 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =7
AND `hook_position` = "blockFooterExtra" 
AND `showhook` = 1
1.9 4 /modules/posstaticfooter/models/Staticfooter.php:51
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22151) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.9 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.9 0 /classes/stock/StockAvailable.php:646
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883025
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.9 2 Yes Yes /classes/Category.php:859
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"812|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
1.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
1.9 16 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.9 16 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"1172|1|4|4|7|1|21","", FROM_UNIXTIME(1611162567))
1.9 1 /classes/SmartyCustom.php:263
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 33414)
1.9 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6268) AND (id_product_attribute = 45068) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.9 0 /classes/stock/StockAvailable.php:378
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882881) AND (b.`id_shop` = 1) LIMIT 1
1.9 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883082
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.8 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 6268
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.8 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883049_right"
1.8 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
1.8 0 /classes/Category.php:1219
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883088
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.8 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882918
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.8 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9883042_right"
1.8 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.8 0 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
1.8 0 /classes/Category.php:1219
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882816
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.8 1 Yes Yes /classes/Category.php:859
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 33954
ORDER BY f.position ASC
1.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9882806_right"
1.8 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_ver_menu_idcat_9882815_right"
1.8 7 /modules/posvegamenu/posvegamenu.php:553
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882907
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.8 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22017) AND (id_product_attribute = 45253) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.8 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="4081|1|4|4|7|1|21" AND compile_id="" LIMIT 1
1.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.8 0 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a1297ed277cb58a582cfd72c4a862fb9' AND cache_id="blockcms|2|1|4|4|7|1|21" AND compile_id="" LIMIT 1
1.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_prodquestions` pc
WHERE `id_product` = 710 AND is_active = 1 
AND  id_shop = 1 AND id_lang = 7 LIMIT 1
1.8 40 /modules/contentpack/classes/prodquestionshelp.class.php:65
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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 = 1)
WHERE pa.`id_product_attribute` = 731777 LIMIT 1
1.8 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882806) LIMIT 1
1.8 1 /Adapter/Adapter_EntityMapper.php:61
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883023
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.8 1 Yes Yes /classes/Category.php:859
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 = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1172)
1.7 39 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9882959 AND `id_shop` = 1
1.7 13 /Adapter/Adapter_EntityMapper.php:68
UPDATE `ps_smarty_lazy_cache`
SET filepath='24131/1/4/4/7/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24131|1|4|4|7|1|21" AND compile_id=""
1.7 1 /classes/SmartyCustom.php:183
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882934) AND (b.`id_shop` = 1) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1666) AND (id_product_attribute = 44957) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.7 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =7
AND `identify` = "pt_menu_idcat_45_right"
1.7 7 /modules/posmegamenu/posmegamenu.php:556
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9883027
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.7 1 Yes Yes /classes/Category.php:859
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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 9882932
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.7 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.7 16 Yes /classes/SpecificPrice.php:361
UPDATE `ps_smarty_lazy_cache`
SET filepath='22151/1/4/4/7/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22151|1|4|4|7|1|21" AND compile_id=""
1.7 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883038 AND `id_shop` = 1
1.7 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 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.7 16 Yes /classes/SpecificPrice.php:361
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` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883023) AND (b.`id_shop` = 1) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:61