Kategorie

Szampony w kostce dla mężczyzn

Szampony w kostce cieszą się coraz większą popularnością i nic w tym dziwnego. Działają skutecznie, są bardzo wydajne, a przy tym pozwalają ograniczyć produkcję śmieci. W Drogerii Pigment znajdziesz szampony w kostce dla mężczyzn, które nie tylko świetnie działają, lecz także wyróżniają się wyjątkowym zapachem. To produkty wygodne w stosowaniu i cechujące się doskonale skomponowanymi składami. Sprawdź, jakie szampony w kostce dla mężczyzn przygotowaliśmy.

9 produktów
  • Mydlarnia Cztery Szpaki, Szampon w kostce detoksykujący, 75 g
    PROMOCJA
    Dodaj do koszyka
    Deleted
    Add again
    Cztery Szpaki Mydlarnia

    Potrzebujesz konkretnego oczyszczenia i odświeżenia? Szampon detoksykujący od 4 szpaków przychodzi z pomocą. Oparty na naturalnych detergentach, które są odpowiedzialne za utrzymanie świeżości. Węgiel aktywny pozyskiwany z bambusa dogłębnie oczyszcza skórę głowy z wszelkiego rodzaju zanieczyszczeń. Dodatkowo unosi włosy od nasady, dzięki czemu zyskują na...

    39,20 zł Na stanie 31,36 zł
    
    Do koszyka
  • Mydlarnia Cztery Szpaki, Szampon normalizujący w kostce Rozmaryn i Mandarynka, 75g
    PROMOCJA
    Dodaj do koszyka
    Deleted
    Add again
    Cztery Szpaki Mydlarnia

    Teraz to już chyba oficjalnie możemy powiedzieć: do wyboru, do koloru! Nasz ostatnio powiększony skład szamponów zasila właśnie kolejny i myślimy, że z miejsca zachwyci osoby próbujące poradzić sobie z problemem przetłuszczających się włosów. Witamy na pokładzie zieloną, normalizującą kostkę ROZMARYN i MANDARYNKA. Myje, pachnie i wygląda - a mówią, że nie...

    39,20 zł Na stanie 31,36 zł
    
    Do koszyka
  • Mydlarnia Cztery Szpaki, Delikatny szampon w kostce do wszystkich rodzajów włosów, 75 g
    PROMOCJA
    Dodaj do koszyka
    Deleted
    Add again
    Cztery Szpaki Mydlarnia

    Delikatny szampon w kostce z Mydlarni Cztery Szpaki stworzony został z myślą o pielęgnacji każdego typu włosów. Skutecznie i zarazem delikatnie oczyszcza włosy i skórę głowy nie wysuszając jej i nie podrażniając. Szampon obficie się pieni, pięknie pachnie, a dodatkowo nawilża i kondycjonuje skórę głowy. Dzięki zawartości naturalnych olejów i maseł,...

    39,20 zł Na stanie 31,36 zł
    
    Do koszyka
  • Mydlarnia Cztery Szpaki, Szampon w kostce uniwersalny, 75 g
    PROMOCJA ULUBIEŃCY
    Dodaj do koszyka
    Deleted
    Add again
    Cztery Szpaki Mydlarnia

    Stworzony bez użycia surowców pochodzenia zwierzęcego i w duchu Zero Waste - oto naturalny szampon w kostce Cztery Szpaki. Nadaje się do codziennego stosowania oraz dla wegan i dla wszystkich rodzajów włosów - czyli właściwie dla wszystkich. Opakowanie? Musisz przyzwyczaić się do zmydlającej się kostki - nie generuje niepotrzebnych śmieci :) Szampon...

    39,20 zł Na stanie 31,36 zł
    
    Do koszyka
  • Mydlarnia Cztery Szpaki, Superkostka myjąca do ciała, twarzy i włosów, 75 g
    PROMOCJA
    Powiadom o dostępności
    Deleted
    Add again
    Cztery Szpaki Mydlarnia

    Superkostka to kosmetyk będący definicją idei zero waste. Wegańska, poręczna, stała, wielofunkcyjna, wydajna formuła zamknięta w ekologicznym opakowaniu z powodzeniem zastąpi kilka produktów pielęgnacyjnych - z korzyścią dla planety, portfela i miejsca w kosmetyczce. To produkt, który multifunkcyjność ma wpisaną w swoje DNA, powstał z myślą o...

    45,20 zł Brak na stanie 36,16 zł
    
    Oczekiwanie na dostawę
  • Ministerstwo Dobrego Mydła, Szampon w kostce, Zielona herbata, 85 g
    PROMOCJA
    Powiadom o dostępności
    Deleted
    Add again
    Ministerstwo Dobrego Mydła

    Uniwersalny szampon w kostce do mycia włosów, zarostu oraz całego ciała o przyjemnym odświeżającym zapachu zielonej herbaty. To multifunkcyjny kosmetyk dedykowany osobom aktywnym i szukającym prostych rozwiązań. Wydajna i wygodna w użyciu forma kostki doskonale sprawdza się zarówno w domu, jak i w podróży, czy podczas uprawiania sportów - na siłowni,...

    42,19 zł Brak na stanie 33,75 zł
    
    Oczekiwanie na dostawę
  • Anwen, Peace of Mint, Szampon w kostce, 75g
    PROMOCJA
    Powiadom o dostępności
    Deleted
    Add again
    ANWEN

    Szampon w kostce o zapachu słodkiej mięty przeznaczony jest do skóry normalnej lub skłonnej do nadmiernego wydzielania sebum. Detergenty pochodzenia naturalnego skutecznie usuwają zanieczyszczenia ze skalpu oraz włosów, równocześnie formuła szamponu pozostaje łagodna dla skóry i błon śluzowych. Ekstrakt z fiołka trójbarwnego działa przeciwzapalnie oraz...

    25,19 zł Brak na stanie 20,15 zł
    
    Oczekiwanie na dostawę
  • Anwen, Peace of Mint, Szampon w kostce (w puszce), 75g
    PROMOCJA
    Powiadom o dostępności
    Deleted
    Add again
    ANWEN

    Szampon w kostce o zapachu słodkiej mięty przeznaczony jest do skóry normalnej lub skłonnej do nadmiernego wydzielania sebum. Detergenty pochodzenia naturalnego skutecznie usuwają zanieczyszczenia ze skalpu oraz włosów, równocześnie formuła szamponu pozostaje łagodna dla skóry i błon śluzowych. Ekstrakt z fiołka trójbarwnego działa przeciwzapalnie oraz...

    30,19 zł Brak na stanie 24,15 zł
    
    Oczekiwanie na dostawę
  • Mydlarnia Cztery Szpaki, Męskie mydło do włosów i brody WALIGÓRA, 110 g
    PROMOCJA
    Powiadom o dostępności
    Deleted
    Add again
    Cztery Szpaki Mydlarnia

    Prawdziwie męskie mydło do włosów i brody WALIGÓRA to uniwersalny kosmetyk do pielęgnacji. Mydło tworzone ręcznie metodą na zimno, bez użycia maszyn i skomplikowanych algorytmów – cały proces to czyste rzemiosło. Każda kostka mydła jest dzięki temu inna i nie zawsze wygląda tak, jak ta na zdjęciu. Produkt stworzony bez użycia surowców pochodzenia...

    23,20 zł Brak na stanie 18,56 zł
    
    Oczekiwanie na dostawę

Szampony w kostce dla mężczyzn – co warto o nich wiedzieć?

Szampony w kostce dla mężczyzn są łatwe w stosowaniu. Należy zwilżyć kostkę, namydlić ją w dłoniach, a uzyskaną pianę nanieść na włosy i wykonać masaż, a później dokładnie spłukać. Szampony w kostce dla mężczyzn wyróżniają się świetnymi składami, w których możesz znaleźć między innymi glinkę, na przykład niebieską. Jest ona składnikiem działającym przeciwzapalnie, tonizująco oraz regenerująco. W szamponach w kostkach możesz znaleźć również ekstrakt z ogórka, który łagodzi swędzenie. Kosmetyki mogą dbać nie tylko o skórę głowy, lecz także włosy. Jeśli Ci na tym zależy, szukaj wśród szamponów w kostce zawierających hydrolizat z jedwabiu. Działa on na włosy wygładzająco, ułatwia ich rozczesywanie. Masło shea czy kakaowe również przyczynią się do poprawy kondycji włosów.

Szampony w kostce dla mężczyzn to nie wszystko! Sprawdź naszą ofertę

W Drogerii Pigment znajdziesz duży wybór szamponów dla mężczyzn. Oferujemy nie tylko produkty w kostce, lecz także znane i lubiane kosmetyki w płynie. Znajdziesz wśród nich produkty 2 w 1, czyli łączące funkcję żelu oraz szamponu. Są one wygodne do stosowania, a na czas podróży możesz przelać nieco kosmetyku do jednej butelki, która nie zajmie wiele miejsca w bagażu. Oferujemy również szampony przeznaczone na konkretny problem, na przykład działające przeciwłupieżowo. Przygotowaliśmy też bogaty asortyment szamponów wzmacniających, które są przeznaczone dla mężczyzn zmagających się z często występującym problemem wypadania włosów.

Load Time3841 ms - You'd better run your shop on a toaster
Querying Time970 ms
Queries1573
Memory Peak Usage56.3 Mb
Included Files563 files - 7.20 Mb
PrestaShop Cache- Mb
Global vars1.47 Mb
PrestaShop Version1.6.1.18
PHP Version7.1.33 (OK)
MySQL Version10.6.18-MariaDB-cll-lve (OK)
Memory Limit1024M
Max Execution Time3600s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 852 ms 852 ms 10.67 Mb 25.98 Mb
__construct 0 ms 852 ms - Mb 25.98 Mb
init 278 ms 1130 ms 1.17 Mb 25.98 Mb
checkAccess 0 ms 1130 ms - Mb 25.98 Mb
setMedia 37 ms 1167 ms 0.26 Mb 25.98 Mb
postProcess 0 ms 1167 ms - Mb 25.98 Mb
initHeader 0 ms 1167 ms - Mb 25.98 Mb
initContent 1911 ms 3078 ms 33.20 Mb 47.11 Mb
initFooter 494 ms 3572 ms 0.79 Mb 56.25 Mb
display 269 ms 3841 ms 3.38 Mb 56.25 Mb
Hook Time Memory Usage
hookdisplayTop 665 ms 16.00 Mb
hookdisplayFooter 488 ms 6.00 Mb
hookleftcolumn 480 ms 10.00 Mb
__construct 380 ms 2.00 Mb
hookproductlistassign 236 ms - Mb
hookHeader 154 ms - Mb
hookdisplayProductListReviews 40 ms - Mb
hookdisplayHeader 30 ms - Mb
hookdisplayNav 29 ms - Mb
hookdisplayPopups 8 ms - Mb
hookdisplayCategoryBaner 7 ms - Mb
hookdisplayBanner2 7 ms - Mb
hookdisplayTopColumn 5 ms - Mb
hookactionOutputHTMLBefore 4 ms - Mb
hookdisplayAnalyticsProductList 4 ms - Mb
hookdisplayProductListFunctionalButtons 4 ms - Mb
hookdisplayCustomerAccount 3 ms - Mb
hookactionFrontControllerSetMedia 3 ms - Mb
hookdisplayProductFilters 2 ms - Mb
hookdisplayBodyOpen 2 ms - Mb
hookfooterBottomMenu 2 ms - Mb
hookfooterBottomHook 2 ms - Mb
hookbodyOpen 2 ms - Mb
hookcustomeraccount 1 ms - Mb
hookdisplayLeftColumn 1 ms - Mb
hookmoduleRoutes 1 ms - Mb
hookdisplayProductPriceBlock 0 ms - Mb
hookpromoBanner 0 ms - Mb
hookfooter - ms - Mb
hooktop - ms - Mb
hooklitespeedEsiBegin - ms - Mb
hooklitespeedEsiEnd - ms - Mb
hookdisplayProductExtraFlag - ms - Mb
hookactionDispatcher - ms - Mb
hookDisplayOverrideTemplate - ms - Mb
35 hooks 2558 ms 34.00 Mb
Module Time Memory Usage
blocktopmenu 643 ms 16.00 Mb
facebookconversiontrackingplus 468 ms 6.00 Mb
blockcategories 400 ms 10.00 Mb
blocklayered 267 ms - Mb
rcpgtagmanager 130 ms - Mb
cookiesplus 110 ms - Mb
myaccountnavmenu 82 ms - Mb
litespeedcache 68 ms - Mb
blockcart 66 ms - Mb
payu 58 ms - Mb
sensbitinpost 56 ms - Mb
productcomments 41 ms - Mb
x13lookbook 31 ms - Mb
pocztapolskaen 12 ms - Mb
sekeywords 11 ms - Mb
accountpopup 10 ms - Mb
waynetga 9 ms - Mb
promoboxes2 8 ms 2.00 Mb
blockwishlist 8 ms - Mb
wcategorybaner2 8 ms - Mb
blocknewsletter 6 ms - Mb
themeconfigurator 5 ms - Mb
promoboxes 5 ms - Mb
gdatalayer 5 ms - Mb
blocksearchproduct 5 ms - Mb
blocksocial 4 ms - Mb
wfooterinfoblock 4 ms - Mb
blockuserinfo 4 ms - Mb
mailalerts 4 ms - Mb
footerbottommenu 3 ms - Mb
footercopyright 3 ms - Mb
edrone 2 ms - Mb
searchhelper 2 ms - Mb
floatingcartsummary 2 ms - Mb
blockviewed 1 ms - Mb
wcmshome 1 ms - Mb
blockcms 1 ms - Mb
blockmyaccountfooter 1 ms - Mb
customheaderhtml 1 ms - Mb
homeslider 1 ms - Mb
blocknewproducts 1 ms - Mb
blockbestsellers 1 ms - Mb
blockspecials 1 ms - Mb
multifeatures 1 ms - Mb
pagesnotfound 1 ms - Mb
gm_omniprice 1 ms - Mb
blockmanufacturer 1 ms - Mb
blockcontactinfos 1 ms - Mb
blockmyaccount 1 ms - Mb
promobanner 1 ms - Mb
wbrandbadge 1 ms - Mb
newproductscategory 1 ms - Mb
elevatezoom 1 ms - Mb
bestsellerscategory 1 ms - Mb
pdgoogleconsumeropinionspro 1 ms - Mb
csoft_instagramfeeds 0 ms - Mb
wpromoslider 0 ms - Mb
57 modules 2558 ms 34.00 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 1573 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE c.*, cl.*
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 255 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 87.5 2863 Yes Yes /classes/Category.php:584 
SELECT SQL_NO_CACHE DISTINCT a.*, cl.`name` AS country, s.name AS state, s.iso_code AS state_iso
FROM `ps_address` a
LEFT JOIN `ps_country` c ON (a.`id_country` = c.`id_country`)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country`)
LEFT JOIN `ps_state` s ON (s.`id_state` = a.`id_state`)
INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
WHERE `id_lang` = 2 AND `id_customer` = 0 AND a.`deleted` = 0
 69.7 39266 /classes/Customer.php:459 
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`)
 49.7 39971 /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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 85) AND (b.`id_shop` = 1) LIMIT 1
 45.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 814) AND (b.`id_shop` = 1) LIMIT 1
 38.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 35.2 29004 /classes/SpecificPrice.php:230 
SELECT SQL_NO_CACHE 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` = 2 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` = 2)
AND c.`id_category` != 1
AND nleft >= 7 AND nright <= 2446
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
 32.5 2863 Yes /modules/blockcategories/blockcategories.php:252 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 25106) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 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
 29.6 36 Yes /classes/SpecificPrice.php:362 
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` = 2
AND c.`id_parent` = 321
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 29.1 5 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE id_category, id_parent, level_depth, name, is_root_category, active FROM ps_category LEFT JOIN ps_category_lang AS cl USING (id_category) LEFT JOIN ps_category_shop AS cs USING (id_category) WHERE cs.id_shop = 1 AND cl.id_lang = 2 ORDER BY `ps_category`.`id_parent` ASC, `ps_category`.`id_category` ASC
 15.3 5726 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2471 
SELECT SQL_NO_CACHE id_category, id_parent, level_depth, name, is_root_category, active FROM ps_category LEFT JOIN ps_category_lang AS cl USING (id_category) LEFT JOIN ps_category_shop AS cs USING (id_category) WHERE cs.id_shop = 1 AND cl.id_lang = 2 ORDER BY `ps_category`.`id_parent` ASC, `ps_category`.`id_category` ASC
 12.7 5726 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2471 
SELECT SQL_NO_CACHE id_category, id_parent, level_depth, name, is_root_category, active FROM ps_category LEFT JOIN ps_category_lang AS cl USING (id_category) LEFT JOIN ps_category_shop AS cs USING (id_category) WHERE cs.id_shop = 1 AND cl.id_lang = 2 ORDER BY `ps_category`.`id_parent` ASC, `ps_category`.`id_category` ASC
 12.3 5726 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2471 
SELECT SQL_NO_CACHE id_category, id_parent, level_depth, name, is_root_category, active FROM ps_category LEFT JOIN ps_category_lang AS cl USING (id_category) LEFT JOIN ps_category_shop AS cs USING (id_category) WHERE cs.id_shop = 1 AND cl.id_lang = 2 ORDER BY `ps_category`.`id_parent` ASC, `ps_category`.`id_category` ASC
 12.3 5726 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2471 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 991) AND (b.`id_shop` = 1) LIMIT 1
 10.9 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE id_category, id_parent, level_depth, name, is_root_category, active FROM ps_category LEFT JOIN ps_category_lang AS cl USING (id_category) LEFT JOIN ps_category_shop AS cs USING (id_category) WHERE cs.id_shop = 1 AND cl.id_lang = 2 ORDER BY `ps_category`.`id_parent` ASC, `ps_category`.`id_category` ASC
 10.7 5726 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2471 
SELECT SQL_NO_CACHE id_category, id_parent, level_depth, name, is_root_category, active FROM ps_category LEFT JOIN ps_category_lang AS cl USING (id_category) LEFT JOIN ps_category_shop AS cs USING (id_category) WHERE cs.id_shop = 1 AND cl.id_lang = 2 ORDER BY `ps_category`.`id_parent` ASC, `ps_category`.`id_category` ASC
 10.4 5726 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2471 
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 (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 4.2 208 Yes Yes /override/classes/Hook.php:64 
SELECT SQL_NO_CACHE product_id, COUNT(product_id) AS sales FROM `ps_order_detail` WHERE product_id IN (SELECT id_product FROM `ps_category_product` LEFT JOIN ps_product USING (id_product) WHERE id_category = 1111 AND active = 1) GROUP BY product_id ORDER BY sales DESC LIMIT 5
 4.1 1350 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2438 
SELECT SQL_NO_CACHE c.*, cl.*
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2859 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 3.3 2863 Yes Yes /classes/Category.php:584 
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` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
 3.1 244 Yes /classes/Country.php:130 
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m
INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)
WHERE m.`active` = 1
ORDER BY m.`name` ASC
 2.8 428 Yes /override/classes/Manufacturer.php:57 
SELECT SQL_NO_CACHE product_id, COUNT(product_id) AS sales FROM `ps_order_detail` WHERE product_id IN (SELECT id_product FROM `ps_category_product` LEFT JOIN ps_product USING (id_product) WHERE id_category = 1111 AND active = 1) GROUP BY product_id ORDER BY sales DESC LIMIT 5
 2.7 1350 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:2438 
INSERT INTO ps_cat_restriction
SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight, 0 FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 1533
AND c.nright <= 1534
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
 2.6 1 /modules/blocklayered/blocklayered.php:2402 
SELECT SQL_NO_CACHE * FROM (
SELECT *, 1 sortOrder FROM (
SELECT
p.`id_product`,
ps.quantity AS sales,
cp.`position`,
p.`id_supplier`,
p.`id_manufacturer`,
p.`id_shop_default`,
p.`ean13`,
p.`upc`,
p.`reference`,
p.`supplier_reference`,
p.`location`,
p.`width`,
p.`height`,
p.`depth`,
p.`weight`,
p.`quantity_discount`,
p.`cache_is_pack`,
p.`cache_has_attachments`,
p.`is_virtual`,
p.`quantity_on_main`,
p.`quantity_on_second`,
p.`quantity_on_third`,
p.`new_product`,
p.`product_status`,
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`, product_shop.`id_shop`,
product_shop.`id_category_default`,
product_shop.`id_tax_rules_group`,
product_shop.`on_sale`,
product_shop.`online_only`,
product_shop.`ecotax`,
product_shop.`minimal_quantity`,
product_shop.`price`,
product_shop.`wholesale_price`,
product_shop.`unity`,
product_shop.`unit_price_ratio`,
product_shop.`additional_shipping_cost`,
product_shop.`customizable`,
product_shop.`uploadable_files`,
product_shop.`text_fields`,
product_shop.`active`,
product_shop.`redirect_type`,
product_shop.`id_product_redirected`,
product_shop.`available_for_order`,
product_shop.`available_date`,
product_shop.`condition`,
product_shop.`show_price`,
product_shop.`indexed`,
product_shop.`visibility`,
product_shop.`cache_default_attribute`,
product_shop.`advanced_stock_management`,
product_shop.`date_add`,
product_shop.`date_upd`,
product_shop.`pack_stock_type`,image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-09-07 00:00:00", INTERVAL 360 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM ps_cat_filter_restriction 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_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 2)
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` = 2)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.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  )
LEFT JOIN ps_product_sale ps ON ps.id_product = product_shop.id_product
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND stock.`quantity` > 0 AND cp.id_guest=0
) as `withquantity` UNION ALL SELECT *, 2 sortOrder FROM (
SELECT
p.`id_product`,
ps.quantity AS sales,
cp.`position`,
p.`id_supplier`,
p.`id_manufacturer`,
p.`id_shop_default`,
p.`ean13`,
p.`upc`,
p.`reference`,
p.`supplier_reference`,
p.`location`,
p.`width`,
p.`height`,
p.`depth`,
p.`weight`,
p.`quantity_discount`,
p.`cache_is_pack`,
p.`cache_has_attachments`,
p.`is_virtual`,
p.`quantity_on_main`,
p.`quantity_on_second`,
p.`quantity_on_third`,
p.`new_product`,
p.`product_status`,
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`, product_shop.`id_shop`,
product_shop.`id_category_default`,
product_shop.`id_tax_rules_group`,
product_shop.`on_sale`,
product_shop.`online_only`,
product_shop.`ecotax`,
product_shop.`minimal_quantity`,
product_shop.`price`,
product_shop.`wholesale_price`,
product_shop.`unity`,
product_shop.`unit_price_ratio`,
product_shop.`additional_shipping_cost`,
product_shop.`customizable`,
product_shop.`uploadable_files`,
product_shop.`text_fields`,
product_shop.`active`,
product_shop.`redirect_type`,
product_shop.`id_product_redirected`,
product_shop.`available_for_order`,
product_shop.`available_date`,
product_shop.`condition`,
product_shop.`show_price`,
product_shop.`indexed`,
product_shop.`visibility`,
product_shop.`cache_default_attribute`,
product_shop.`advanced_stock_management`,
product_shop.`date_add`,
product_shop.`date_upd`,
product_shop.`pack_stock_type`,image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-09-07 00:00:00", INTERVAL 360 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM ps_cat_filter_restriction 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_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 2)
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` = 2)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.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  )
LEFT JOIN ps_product_sale ps ON ps.id_product = product_shop.id_product
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND stock.`quantity` <= 0 AND cp.id_guest=0
) as `woquantity`
) result ORDER BY sortOrder ASC,date_add desc  LIMIT 0,24
 2.4 1458 Yes /modules/blocklayered/blocklayered.php:2420 
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 (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 2.3 208 Yes Yes /override/classes/Hook.php:64 
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='945a3f90e979ad7d01ae068c2fbdc79f' AND cache_id LIKE "productlist_colors|15743|1|2%"
 1.9 1 /classes/SmartyCustom.php:295 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('07657e8ba4239547db4cf925a71904ac',"blocktopmenu|1|1|1|14|category|1111","", FROM_UNIXTIME(1725722463))
 1.8 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
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_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 2) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 1533
AND c.nright < 1534
AND c.level_depth <= 7
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
 1.8 26550 Yes /modules/blocklayered/blocklayered.php:2420 
SELECT SQL_NO_CACHE c.*, cl.*
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 250 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 1.8 2 Yes Yes /classes/Category.php:584 
INSERT INTO ps_cat_filter_restriction
SELECT cp.id_product, MIN(cp.position) position, 0 FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 1533
AND c.nright <= 1534
AND c.active = 1)
STRAIGHT_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)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY cp.id_product ORDER BY position, id_product
 1.5 1 /modules/blocklayered/blocklayered.php:2402 
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
 1.5 155 /classes/module/Module.php:277 
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
 1.3 600 /classes/Hook.php:235 
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
 1.3 155 /classes/module/Module.php:277 
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
 1.3 0 /classes/Hook.php:131 
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
 1.3 155 /classes/module/Module.php:277 
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 <= 1533
AND c.nright >= 1534
AND c.nleft >= 2
AND c.nright <= 5725
AND cl.id_lang = 2
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
 1.2 715 Yes /classes/Tools.php:1306 
SELECT SQL_NO_CACHE hs.`id_wcategorybaner2_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`description`, hssl.`image`, hssl.`image2`,  hss.`category`, hss.`manufacturer`, hss.`place`, hss.`after`
FROM ps_wcategorybaner2 hs
LEFT JOIN ps_wcategorybaner2_slides hss ON (
hs.id_wcategorybaner2_slides = hss.id_wcategorybaner2_slides
AND ((hss.date_from < NOW() OR hss.date_from ="0000-00-00 00:00:00") AND (hss.date_to > NOW() OR hss.date_to = "0000-00-00 00:00:00"))
)
LEFT JOIN ps_wcategorybaner2_slides_lang hssl ON (hss.id_wcategorybaner2_slides = hssl.id_wcategorybaner2_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position
 1 35 Yes /modules/wcategorybaner2/wcategorybaner2.php:788 
SELECT SQL_NO_CACHE p.reference, p.id_product, pa.id_product_attribute, pl.name, cl.name AS category_name, m.name AS manufacturer_name,
GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM ps_product p
LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product
LEFT JOIN ps_category_lang cl ON (p.id_category_default = cl.id_category AND cl.id_lang = pl.id_lang AND cl.id_shop = pl.id_shop)
LEFT JOIN ps_manufacturer m ON (p.id_manufacturer = m.id_manufacturer)
LEFT JOIN `ps_product_attribute` pa ON (pa.id_product = p.id_product AND pa.id_product_attribute = p.cache_default_attribute)
LEFT JOIN `ps_product_attribute_combination` pac ON pa.id_product_attribute = pac.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` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE p.id_product IN (23774,22632,22412,15743,25106,23420,22598,22597,9585)
AND pl.id_lang = 2
GROUP BY p.id_product
 0.9 9 /modules/waynetga/waynetga.php:523 
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
 0.9 312 Yes /classes/Country.php:137 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 369) AND (b.`id_shop` = 1) LIMIT 1
 0.9 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcart" LIMIT 1
 0.9 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 9585) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.8 37 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.8 48 Yes /classes/Dispatcher.php:452 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 23420) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.8 31 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE p.`id_product`, sa.`quantity`, sa.`out_of_stock`, sa.`unavailable`, sa.`available` 
FROM ps_cat_restriction p
LEFT JOIN (
SELECT sa1.*, SUM(sa1.quantity <= 0) > 0 as unavailable, SUM(sa1.quantity > 0) > 0 as available
FROM ps_stock_available sa1
GROUP BY sa1.id_product, sa1.id_shop, sa1.id_shop_group ) sa
ON (sa.id_product = p.id_product  AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND p.id_guest = 0
 0.8 18 /modules/blocklayered/blocklayered.php:2420 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 394) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
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  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (23774,22632,22412,15743,25106,23420,22598,22597,9585) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.7 9 Yes /classes/Product.php:3464 
SELECT SQL_NO_CACHE cc.name
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 2
AND ccl.`id_lang` = 2 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
 0.7 87 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.7 4 /classes/Language.php:892 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 22597) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.7 28 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE id_manufacturer,
sales as quantity_sold
FROM ps_manufacturer
WHERE active=1
ORDER BY sales DESC
 0.6 428 Yes /modules/manufacturers/classes/ManufacturerSelling.php:114 
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` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 1111
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:656 
SELECT SQL_NO_CACHE public_name
FROM `ps_attribute_group_lang` agl
LEFT JOIN `ps_layered_indexable_attribute_group` liag
ON liag.id_attribute_group = agl.id_attribute_group
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 2
 0.6 174 /modules/blocklayered/blocklayered.php:2420 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 22632) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.6 33 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 15743) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.6 47 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 23774) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.6 30 Yes /classes/SpecificPrice.php:362 
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` = 2
AND c.`id_parent` = 255
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 21 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 22412) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.6 32 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 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, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 22598) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-07 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.6 27 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE cc.name
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 1
AND ccl.`id_lang` = 2 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
 0.6 87 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
 0.6 2 /classes/Category.php:1672 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 1111
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.6 4 Yes Yes /modules/blocklayered/blocklayered.php:2420 
SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 2
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
 0.5 1 Yes Yes /classes/Supplier.php:127 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
 0.5 0 /classes/Hook.php:131 
SELECT SQL_NO_CACHE s.*
FROM `ps_scene_category` sc
LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene)
INNER JOIN ps_scene_shop scene_shop
ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1)
LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene)
WHERE sc.id_category = 1111
AND sl.id_lang = 2 AND s.active = 1
ORDER BY sl.name ASC
 0.5 1 Yes /classes/Scene.php:226 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1111) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 304
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 20 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE cc.name
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 3
AND ccl.`id_lang` = 2 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
 0.5 87 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118 
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 1
AND ccl.`id_lang` = 2 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
 0.5 87 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118 
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` = 2
AND c.`id_parent` = 44
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 10 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 968) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 52
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 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` = 2
AND c.`id_parent` = 208
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 14 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2981) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 44
AND `active` = 1 LIMIT 1
 0.5 10 /classes/Category.php:889 
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` = 2
AND c.`id_parent` = 2872
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 13 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` = 2
AND c.`id_parent` = 24
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 19 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2953) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE cc.name
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 4
AND ccl.`id_lang` = 2 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
 0.4 87 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118 
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` = 2
AND c.`id_parent` = 165
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 17 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
FROM ps_linksmenutop l
LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 2 AND ll.id_shop=1)
LEFT JOIN ps_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_linksmenutop = "2"
AND l.id_shop IN (0, 1)
 0.4 1 /modules/blocktopmenu/menutoplinks.class.php:38 
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (200) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
 0.4 2 Yes /classes/CMS.php:103 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1238) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 53
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 16 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_finality cf LEFT JOIN ps_cookiesplus_finality_lang cfl on cf.`id_cookiesplus_finality` = cfl.`id_cookiesplus_finality`
WHERE
cfl.`id_lang` = 2 AND cf.`active` = 1 AND cf.`id_shop` = 1
ORDER BY `position`;
 0.4 4 Yes /modules/cookiesplus/classes/CookiesPlusFinality.php:98 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 361) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 29
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 14 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_finality cf LEFT JOIN ps_cookiesplus_finality_lang cfl on cf.`id_cookiesplus_finality` = cfl.`id_cookiesplus_finality`
WHERE
cfl.`id_lang` = 2 AND cf.`active` = 1 AND cf.`id_shop` = 1
ORDER BY `position`;
 0.4 4 Yes /modules/cookiesplus/classes/CookiesPlusFinality.php:98 
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` = 2
AND c.`id_parent` = 55
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 11 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name 
FROM ps_cat_restriction p
INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND p.id_guest = 0
GROUP BY p.id_manufacturer ORDER BY m.name
 0.4 9 Yes /modules/blocklayered/blocklayered.php:2420 
SELECT SQL_NO_CACHE s.*, cl.name country, st.iso_code state
FROM ps_store s
INNER JOIN ps_store_shop store_shop
ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1)
LEFT JOIN ps_country_lang cl ON (cl.id_country = s.id_country)
LEFT JOIN ps_state st ON (st.id_state = s.id_state)
WHERE  cl.id_lang = 2
 0.4 3 /override/classes/controller/FrontController.php:394 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 22598
AND pc.`deleted` = 0 LIMIT 1
 0.4 2 /modules/productcomments/ProductComment.php:219 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 877) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 250) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2949
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
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` = 2
AND c.`id_parent` = 14
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 6 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 3
AND ccl.`id_lang` = 2 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
 0.4 87 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
 0.4 2 /classes/Category.php:1672 
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` = 2
AND c.`id_parent` = 26
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 14 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 89) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 61
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 11 Yes Yes /classes/Category.php:859 
DELETE FROM ps_cat_restriction WHERE id_guest = 0
 0.4 1 /modules/blocklayered/blocklayered.php:2402 
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_finality cf LEFT JOIN ps_cookiesplus_finality_lang cfl on cf.`id_cookiesplus_finality` = cfl.`id_cookiesplus_finality`
WHERE
cfl.`id_lang` = 2 AND cf.`active` = 1 AND cf.`id_shop` = 1
ORDER BY `position`;
 0.4 4 Yes /modules/cookiesplus/classes/CookiesPlusFinality.php:98 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 376) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 88
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 13 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 322) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 915) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 115
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 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` = 2
AND c.`id_parent` = 25
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 11 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` = 2
AND c.`id_parent` = 30
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 13 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1224) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
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 =2 AND m.page = "category" LIMIT 1
 0.4 1 /classes/Theme.php:275 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'drogeriapigment.pl' OR su.domain_ssl = 'drogeriapigment.pl')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.4 1 Yes /classes/shop/Shop.php:334 
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` = 2
AND c.`id_parent` = 212
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 9 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 872) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1225) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (274) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
 0.4 2 Yes /classes/CMS.php:103 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2968) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2965
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 869) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
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
 0.4 1 Yes /classes/Currency.php:231 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2971
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 911) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 970) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 47
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 7 Yes Yes /classes/Category.php:859 
SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
FROM ps_linksmenutop l
LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 2 AND ll.id_shop=1)
LEFT JOIN ps_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_linksmenutop = "1"
AND l.id_shop IN (0, 1)
 0.4 1 /modules/blocktopmenu/menutoplinks.class.php:38 
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 2
AND ccl.`id_lang` = 2 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
 0.4 87 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118 
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` = 2
AND c.`id_parent` = 13
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 7 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2972) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 279
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 9 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` = 2
AND c.`id_parent` = 200
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 4 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 883) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1242) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1226) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 203) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 204) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2980) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 969) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 62
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 9 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 321) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2891) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 52
AND `active` = 1 LIMIT 1
 0.4 12 /classes/Category.php:889 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 381) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 323
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 9 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` = 2
AND c.`id_parent` = 2866
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 9 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` = 2
AND c.`id_parent` = 65
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 4 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2968) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 909) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2946) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 378) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '5a276a9dee333548e02149a31bc61569' LIMIT 1
 0.4 1 /modules/blocklayered/blocklayered.php:2437 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 377) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 390) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 150) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1239) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 158) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 156) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM ps_cat_restriction p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1 AND p.id_guest = 0
 0.4 9 /modules/blocklayered/blocklayered.php:2420 
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` = 2
AND c.`id_parent` = 70
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 6 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 157) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 164
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 7 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` = 2
AND c.`id_parent` = 170
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 6 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 376) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 391) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 22598
AND pc.`deleted` = 0 LIMIT 1
 0.4 2 /modules/productcomments/ProductComment.php:206 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2975
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2951
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 387) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 907) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 155) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 873) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2950
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 346) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9585) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.4 1 Yes /classes/shop/Shop.php:663 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 247) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps_category_product` WHERE id_category=250
 0.4 177 /override/classes/Product.php:403 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 342) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 165) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 201) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 870) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2964) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 386) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 2883
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 5 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2914) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 15) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 385) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2952) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 382) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2947) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 158) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 323) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 876) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 384) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 152
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 5 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 913) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 875) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 22598) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 910) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 343) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2913) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2949) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23420) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2916) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 884) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 279) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 2 AND cl.id_shop = 1 ) WHERE c.`id_category` = 1111 LIMIT 1
 0.4 1 /classes/Category.php:1219 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 154) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 914) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 2916
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 5 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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 159) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1245) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 379) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2948) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2974
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1244) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 389) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 366) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 345) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 247) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2913) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2891) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 372) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE c.id_category, "" as name
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` = 2
AND c.`id_parent` = 2952
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Category.php:889 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2982) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1240) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 912) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
AND c.`id_parent` = 56
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 2 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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23774) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 154) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 907) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 377) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 874) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 380) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 878) AND (b.`id_shop` = 1) LIMIT 1
 0.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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2947) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61