WP-100E ULTRA Irygator Waterpik

379,00 zł
Brutto

WP-100 Irygator ULTRA z pokrywą i siedmioma końcówkami.

W zestawie 

2końcówki standardowe (JT-100)

1 końcówka ortodontyczna (OD-100)

1 końcówka poddziąsłowa do czysczenia kieszonek przyzębnych (PP-100)

1 końcówka do koron mostów implantow (PS-100)

1 końcówka szczoteczka do użycia ogólnego (TB-100)

1 końcówka do czyszczenia języka (TC-100)

Waterpik WP-100E ULTRA to nowoczesny irygator w 93% skuteczniejszy w profilaktyce zapalenia dziąseł od tradycyjnych metod czyszczenia nitką dentystyczną. Badania naukowe dowiodły że po 28 dniach używania irygatora nastąpiło w 40%-93% obniżenie krwawienia i zapalenia dziąseł.
Zdrowsze dziąsła już po 14 dniach. Usuwa bakterie głęboko między zębami i poniżej dziąseł, gdzie czyszczenie tradycyjną szczoteczką nie daje rezultatów.
Masuje dziąsła, nadając w efekcie ich silny i zdrowy wygląd.
 

  •     Idealny do czyszczenia wokół stałych aparatów ortodontycznych, dzięki zastosowaniu specjalnej końcówki.
  •     10 stopni regulacji ciśnienia (od 5 do 90 Psi).
  •     Nowy wygląd oraz 20% cichszy niż poprzednie modele.
  •     Zbiornik z pokrywą ułatwia utrzymać go w czystości i przechowywać załączone akcesoria.
  •     Dwa lata gwaracji

WP-100 Waterpik ultra to nowoczesny irygator w 93% skuteczniejszy w profilaktyce zapalenia dziąseł w porównaniu z tradycyjnymi metodami czyszczenia nitką dentystyczną. Badania naukowe dowiodły że po 28 dniach używania irygatora nastąpiło znaczące obniżenie krwawienia i zapalenia dziąseł. Usuwa on bakterie znajdujące się głęboko między zębami oraz poniżej linii dziąseł, gdzie czyszczenie tradycyjną szczoteczką nie daje wystarczających rezultatów. Dodatkowo, masuje dziąsła, wpływając na ich piękny i zdrowy wygląd.

WP-100 Waterpik doskonale nadaje się do czyszczenia aparatów ortodontycznych. Dzięki zastosowaniu specjalnej końcówki dociera tam, gdzie nie ma możliwości dotarcia zwykła szczoteczka do zębów, dzięki czemu skutecznie usuwa wszelkie zanieczyszczenia oraz szkodliwe bakterie. Posiada aż 10 stopni regulacji ciśnienia (od 5 do 90 Psi), nowy, elegancki wygląd oraz zbiornik z pokrywą ułatwiający utrzymywanie go w czystości. Każdy irygator jest niezwykle skuteczny i posiada aż 2 lata gwarancji.

 

WP-100 – irygator od Waterpika, to doskonała inwestycja

Irygatory WP-100 Waterpik wykorzystywane są do codziennych zabiegów czyszczących jamę ustną. Urządzenie to przypomina powszechnie znaną elektryczną szczoteczkę do zębów, jednak zamiast standardowej główki z włosiem, wyposażone jest w specjalną dyszę, która wystrzeliwuje strumień wody. Irygatory są więc niezwykle wygodne oraz łatwe w obsłudze, dlatego też polecane są osobom w każdym wieku. Strumień wody doskonale oczyszcza zęby ze szkodliwej płytki nazębnej, gwarantując utrzymanie zębów w dobrej kondycji. Jest również w stanie dotrzeć do miejsc, których nie doczyści zwykła szczoteczka oraz nić dentystyczna.

Badania przeprowadzone przez niezależne uniwersytety dowodzą że produkty Waterpik są znacznie bardziej efektywne od tradycyjnych metod utrzymywania higieny jamy ustnej. Skutecznie zmniejszają zapalenie i krwawienie dziąseł, powodując redukcję płytki nazębnej. WP-100 Waterpik to nowy standard w higienie jamy ustnej, który znajduje coraz więcej zwolenników. Jeżeli również i Państwo poszukują profesjonalnych i skutecznych irygatorów dentystycznych, serdecznie zapraszamy do zapoznania się z naszą ofertą!

 
ILOŚĆ KO?C
7
MAKSYMALNE CIŚNIENIA
8 bar
POJEMNOŚĆ ZBIORNIKA
600 ml
FUNKCJA MASAŻU
-
FUNKCJA CHWILOWEGO ZATRZYMANIA WYPŁYWU WODY NA RĄCZCE
V
WP-100
Brak opinii

Klienci którzy zakupili ten produkt kupili również:

Produkt dodany do Ulubionych
Produkt dodany do porównania

Drogi Użytkowniku!

W związku z odwiedzaniem naszego serwisu internetowego przetwarzamy Twój adres IP, pliki cookies i podobne dane nt. aktywności lub urządzeń użytkownika. Jeżeli dane te pozwalają zidentyfikować Twoją tożsamość, wówczas będą traktowane jako dane osobowe zgodnie z Rozporządzeniem Parlamentu Europejskiego i Rady 2016/679 (RODO). Administratora tych danych, cele i podstawy przetwarzania oraz inne informacje wymagane przez RODO znajdziesz w Polityce Prywatności.

Load Time1340 ms - OK... for a shared hosting
Querying Time668 ms
Queries355
Memory Peak Usage34.7 Mb
Included Files638 files - 8.83 Mb
PrestaShop Cache0.01 Mb
Global vars0.24 Mb
PrestaShop Version1.7.4.2
PHP Version5.6.34 (Consider upgrading)
MySQL Version5.7.21-20-log (OK)
Memory Limit1024M
Max Execution Time1800s
Smarty Cachedisabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 96 ms 96 ms 8.37 Mb 8.67 Mb
__construct 0 ms 96 ms - Mb 8.67 Mb
init 37 ms 133 ms 5.42 Mb 14.15 Mb
checkAccess 0 ms 133 ms - Mb 14.15 Mb
setMedia 0 ms 133 ms 0.01 Mb 14.15 Mb
postProcess 0 ms 133 ms - Mb 14.15 Mb
initHeader 0 ms 133 ms - Mb 14.15 Mb
initContent 298 ms 431 ms 8.35 Mb 22.27 Mb
initFooter 0 ms 431 ms - Mb 22.27 Mb
display 909 ms 1340 ms 12.06 Mb 34.74 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 355 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `pok_country` c  INNER JOIN pok_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `pok_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 7)
LEFT JOIN `pok_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
123.3 276008896 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE DISTINCT od.product_id
FROM pok_order_detail od
LEFT JOIN pok_product p ON (p.id_product = od.product_id)
INNER JOIN pok_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `pok_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
LEFT JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN pok_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN pok_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN pok_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN pok_image i ON (i.id_product = od.product_id)
LEFT JOIN `pok_category_product` cp ON (cp.`id_category` = product_shop.id_category_default AND cp.id_product = product_shop.id_product)
LEFT JOIN `pok_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (11,15,20,25,33,41,44,50,57,59,65,66,100,151,155,165,177,178,180,196,197,202,215,240,266,324,367,368,371,409,426,447)
AND pl.id_lang = 7
AND cl.id_lang = 7
AND od.product_id NOT IN (26)
AND i.cover = 1
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 10
118.9 106978692705730560 Yes /modules/iqitcrossselling/iqitcrossselling.php:213
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2018-10-17 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `pok_accessory`
LEFT JOIN `pok_product` p ON p.`id_product` = `id_product_2`
INNER JOIN pok_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_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 `pok_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 7 AND pl.id_shop = 1 
)
LEFT JOIN `pok_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 7 AND cl.id_shop = 1 
)
LEFT JOIN `pok_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 `pok_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 7)
LEFT JOIN `pok_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN pok_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 26 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
69.6 17643608819712 Yes Yes /classes/Product.php:3927
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 `pok_configuration` c
LEFT JOIN `pok_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
45.1 653971 /classes/Configuration.php:157
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2018-10-17 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM  `pok_product` p 
INNER JOIN pok_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_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 `pok_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 7 AND pl.id_shop = 1 
)
LEFT JOIN `pok_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 7 AND cl.id_shop = 1 
)
LEFT JOIN `pok_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 `pok_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 7)
LEFT JOIN `pok_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN pok_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (802,803) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
23.8 608400304128 Yes Yes /modules/iqitmegamenu/iqitmegamenu.php:3636
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pok_module` m
INNER JOIN pok_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 `pok_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `pok_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pok_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pok_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
11.6 2923208352 Yes Yes /classes/Hook.php:629
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 50 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 50 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
10.2 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 26 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 26 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.9 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 35 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 35 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.8 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 28 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 28 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.7 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 43 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 43 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.4 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 26
ORDER BY `position`
8.3 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 780 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 780 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.2 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 44 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 44 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.2 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 45 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 45 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.2 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 802 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 802 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.1 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pok_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 803 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pok_cart_product` cp JOIN `pok_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pok_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 803 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
8.1 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE 1 FROM pok_cart_product cp INNER JOIN pok_product p
ON (p.id_product = cp.id_product) INNER JOIN pok_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
8.1 27717 /classes/Cart.php:3922
SELECT SQL_NO_CACHE 1 FROM pok_cart_product cp INNER JOIN pok_product p
ON (p.is_virtual = 0 AND p.id_product = cp.id_product) INNER JOIN pok_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
7.8 27717 /classes/Cart.php:3939
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 803
ORDER BY `position`
7.4 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 780
ORDER BY `position`
6.7 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 802
ORDER BY `position`
6.5 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 45
ORDER BY `position`
5.4 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 50
ORDER BY `position`
5.1 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 44
ORDER BY `position`
5.1 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 35
ORDER BY `position`
4.9 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 28
ORDER BY `position`
4.8 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pok_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 43
ORDER BY `position`
4.8 9641232 Yes /classes/Product.php:2986
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `pok_meta` m
LEFT JOIN `pok_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
3.7 38160 Yes /classes/Dispatcher.php:530
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `pok_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `pok_hook_alias` ha
INNER JOIN `pok_hook` h ON ha.name = h.name
2.6 0 /classes/Hook.php:186
SELECT SQL_NO_CACHE *
FROM `pok_country` a
LEFT JOIN `pok_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 7
LEFT JOIN `pok_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 14) LIMIT 1
2.2 276008896 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active
FROM `pok_hook_module` hm
STRAIGHT_JOIN `pok_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `pok_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.6 447 Yes /classes/Hook.php:375
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pok_module` m
LEFT JOIN `pok_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1.6 16936 /classes/module/Module.php:301
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pok_module` m
LEFT JOIN `pok_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1.5 16936 /classes/module/Module.php:301
SELECT SQL_NO_CACHE *
FROM `pok_country_lang`
WHERE `id_country` = 14
1.4 4636 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_manufacturer` a
LEFT JOIN `pok_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 7
LEFT JOIN `pok_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 14) LIMIT 1
1.1 171 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pok_image` i
INNER JOIN pok_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 26
AND image_shop.`cover` = 1 LIMIT 1
1 738 /classes/Product.php:3006
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `pok_product_attribute` pa
INNER JOIN pok_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 pok_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pok_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `pok_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN pok_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 26
AND al.`id_lang` = 7
AND agl.`id_lang` = 7
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 230389840871424 Yes Yes /classes/Product.php:3841
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 23 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 968832 Yes Yes /classes/Category.php:748
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 `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7  AND cl.id_shop = 1 )
LEFT JOIN `pok_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 2
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.9 968832 Yes Yes /classes/Category.php:875
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 18 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 968832 Yes Yes /classes/Category.php:748
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 40 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 968832 Yes Yes /classes/Category.php:748
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 26
ORDER BY f.position ASC
0.8 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 20 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 968832 Yes Yes /classes/Category.php:748
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 43 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 968832 Yes Yes /classes/Category.php:748
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 19 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 968832 Yes Yes /classes/Category.php:748
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 802
ORDER BY f.position ASC
0.8 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 22 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 968832 Yes Yes /classes/Category.php:748
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pok_category` c
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pok_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pok_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pok_category` c2 ON c2.`id_category` = 21 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 7
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 968832 Yes Yes /classes/Category.php:748
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 803
ORDER BY f.position ASC
0.7 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE *
FROM `pok_category` a0
LEFT JOIN `pok_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 3) AND (a0.`nright` > 54) AND (a1.`id_lang` = 7)
ORDER BY a0.`nleft` asc
0.7 11600 Yes /classes/PrestaShopCollection.php:357
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 780
ORDER BY f.position ASC
0.7 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE cp.id_product  as id_product
FROM `pok_category_product` as cp
RIGHT JOIN `pok_product` as p
ON p.id_product=cp.id_product
WHERE cp.id_category = 2
AND p.active = 1
AND cp.position < 0 ORDER BY cp.position DESC LIMIT 1
0.6 1390 Yes /modules/iqitproductsnav/iqitproductsnav.php:170
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE cp.id_product as id_product
FROM `pok_category_product` as cp
RIGHT JOIN `pok_product` as p
ON p.id_product=cp.id_product
WHERE cp.id_category = 2
AND p.active = 1
AND cp.position != 0 ORDER BY cp.position DESC LIMIT 1
0.6 1390 Yes /modules/iqitproductsnav/iqitproductsnav.php:140
SELECT SQL_NO_CACHE o.id_order
FROM pok_orders o
LEFT JOIN pok_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (26)
0.6 676 /modules/iqitcrossselling/iqitcrossselling.php:157
SELECT SQL_NO_CACHE cp.id_product as id_product
FROM `pok_category_product` as cp
RIGHT JOIN `pok_product` as p
ON p.id_product=cp.id_product
WHERE cp.id_category = 2
AND p.active = 1
AND cp.position > 0 ORDER BY cp.position ASC LIMIT 1
0.6 1390 Yes /modules/iqitproductsnav/iqitproductsnav.php:155
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE * FROM `pok_state` ORDER BY `name` ASC
0.6 316 Yes /classes/Country.php:153
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 43) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 18 AND `id_shop` = 1
0.6 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 70) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM pok_meta m
LEFT JOIN pok_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1
0.6 38160 /classes/Meta.php:190
SELECT SQL_NO_CACHE value FROM `pok_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.6 2063 /classes/shop/Shop.php:1127
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM pok_iqitmegamenu_tabs_shop hs
LEFT JOIN pok_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN pok_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 7
ORDER BY hss.position
0.6 1700 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:179
SELECT SQL_NO_CACHE *
FROM pok_meta m
LEFT JOIN pok_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1
0.6 38160 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM pok_meta m
LEFT JOIN pok_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1
0.6 38160 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) AND (b.`id_shop` = 1) LIMIT 1
0.6 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 43 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 20 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 23 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM pok_meta m
LEFT JOIN pok_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1
0.5 38160 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 70 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 21 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2018-10-17 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM pok_product p
LEFT JOIN pok_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN pok_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 50
0.5 1 /classes/ProductAssembler.php:91
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `pok_category` c
LEFT JOIN `pok_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN pok_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 13456 Yes Yes /classes/Category.php:1098
SELECT SQL_NO_CACHE *
FROM `pok_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
0.5 464 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `pok_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.5 13456 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 26) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 50)
0.4 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 35
ORDER BY f.position ASC
0.4 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (50) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 35
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE COUNT(*)
FROM `pok_hook_module` hm
LEFT JOIN `pok_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'moduleRoutes' AND hm.`id_module` = 169 LIMIT 1
0.4 447 /classes/module/Module.php:2170
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 43) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 35) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 28
ORDER BY f.position ASC
0.4 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pok_category_product` cp
INNER JOIN `pok_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 35 AND ctg.`id_group` = 1 LIMIT 1
0.4 100080 /classes/Product.php:5399
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
0.4 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (26) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE COUNT(*)
FROM `pok_hook_module` hm
LEFT JOIN `pok_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'displayPrestaHomeBlogAfterPostContent' AND hm.`id_module` = 169 LIMIT 1
0.4 447 /classes/module/Module.php:2170
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 50
ORDER BY f.position ASC
0.4 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE tr.*
FROM `pok_tax_rule` tr
JOIN `pok_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 14
AND tr.`id_tax_rules_group` = 53
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.4 1 Yes /classes/tax/TaxRulesTaxManager.php:111
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (44) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE *
FROM pok_iqitsizechart t
LEFT JOIN pok_iqitsizechart_lang tl ON (t.id_iqitsizechart = tl.id_iqitsizechart AND tl.id_lang = 7)
INNER JOIN pok_iqitsizechart_shop iqitsizechart_shop
ON (iqitsizechart_shop.id_iqitsizechart = t.id_iqitsizechart AND iqitsizechart_shop.id_shop = 1)
INNER JOIN pok_iqitsizechart_category sc  ON (t.id_iqitsizechart = sc.id_iqitsizechart AND sc.id_category = 2)
GROUP BY t.id_iqitsizechart
0.4 1 Yes Yes /modules/iqitsizecharts/src/IqitSizeCharts.php:106
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN pok_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 26
0.4 38398306811904 /classes/Product.php:6046
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM pok_shop_url su
LEFT JOIN pok_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.polkardbis.pl' OR su.domain_ssl = 'www.polkardbis.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:344
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 27) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `pok_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 45 LIMIT 1
0.4 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 43
ORDER BY f.position ASC
0.4 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (780) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (28) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (35) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 44) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 803) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 802) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 802
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM pok_iqitadditionaltab t
LEFT JOIN pok_iqitadditionaltab_lang tl ON (t.id_iqitadditionaltab = tl.id_iqitadditionaltab AND tl.id_lang = 7)
INNER JOIN pok_iqitadditionaltab_shop iqitadditionaltab_shop
ON (iqitadditionaltab_shop.id_iqitadditionaltab = t.id_iqitadditionaltab AND iqitadditionaltab_shop.id_shop = 1)
WHERE (t.id_product = 0 OR t.id_product = 26) AND t.`active` = 1  GROUP BY t.id_iqitadditionaltab
ORDER BY t.`position`
0.4 1 Yes Yes /modules/iqitadditionaltabs/src/IqitAdditionalTab.php:119
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
0.4 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 50) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 808) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
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 pok_shop_group gs
LEFT JOIN pok_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pok_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:692
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 50
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `pok_module` m
LEFT JOIN `pok_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
0.4 116 /src/Adapter/Module/ModuleDataProvider.php:157
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 43
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (802) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 45
ORDER BY f.position ASC
0.3 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pok_category_product` cp
INNER JOIN `pok_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 45 AND ctg.`id_group` = 1 LIMIT 1
0.3 100080 /classes/Product.php:5399
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 803
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.3 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 28) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 780) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 780
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.3 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `pok_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 50 LIMIT 1
0.3 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (803) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 45
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.3 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 44
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.3 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM pok_feature_product pf
LEFT JOIN pok_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN pok_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN pok_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN pok_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 44
ORDER BY f.position ASC
0.3 170459640 Yes /classes/Product.php:4862
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM pok_iqit_link_block cb
INNER JOIN pok_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 21
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
0.3 8 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
0.3 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE position
FROM `pok_category_product`
WHERE id_category = 2
AND id_product = 26 LIMIT 1
0.3 1390 /modules/iqitproductsnav/iqitproductsnav.php:112
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 43)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM pok_tag t
LEFT JOIN pok_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=26
0.3 4 /classes/Tag.php:228
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (45) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pok_product_attribute` pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `pok_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pok_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pok_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `pok_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (43) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 63155109888 Yes Yes /classes/Product.php:3790
SELECT SQL_NO_CACHE *
FROM `pok_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 35)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE id_tab, class_name FROM `pok_tab`
0.3 153 /classes/Tab.php:314
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN pok_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 26
0.3 38398306811904 /classes/Product.php:6046
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 26)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 44)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE *
FROM `pok_country` a
LEFT JOIN `pok_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 14) LIMIT 1
0.3 59536 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 803)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE id_threesixty FROM pok_iqit_threesixty WHERE id_product = 26 LIMIT 1
0.3 1 /modules/iqitextendedproduct/src/IqitThreeSixty.php:73
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 802)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pok_attribute` a
LEFT JOIN `pok_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `pok_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pok_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pok_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 `pok_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 26
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.3 1199947087872 /classes/Product.php:6020
SELECT SQL_NO_CACHE p.id_product
FROM `pok_product` p
INNER JOIN pok_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 26
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2018-10-17 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1369
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM pok_tag t
LEFT JOIN pok_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=26
0.3 4 /classes/Tag.php:228
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pok_category_product` cp
INNER JOIN `pok_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 28 AND ctg.`id_group` = 1 LIMIT 1
0.3 100080 /classes/Product.php:5399
SELECT SQL_NO_CACHE * FROM `pok_image_type`
0.3 8 /classes/ImageType.php:144
SELECT SQL_NO_CACHE *
FROM `pok_product` a
LEFT JOIN `pok_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `pok_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 45) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `pok_currency` c
LEFT JOIN pok_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.3 25 /classes/Currency.php:659
SELECT SQL_NO_CACHE tr.*
FROM `pok_tax_rule` tr
JOIN `pok_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 14
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 0 /classes/tax/TaxRulesTaxManager.php:111
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `pok_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 28 LIMIT 1
0.3 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `pok_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 44 LIMIT 1
0.3 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 780)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `pok_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 43 LIMIT 1
0.3 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 45)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM pok_iqit_link_block cb
INNER JOIN pok_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 349
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
0.3 8 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE id_shop
FROM `pok_lang_shop`
WHERE `id_lang` = 7
AND id_shop = 1 LIMIT 1
0.3 3 /classes/ObjectModel.php:1549
SELECT SQL_NO_CACHE * FROM `pok_hook_alias`
0.3 88 /classes/Hook.php:226
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 70) LIMIT 1
0.3 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
0.3 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_currency` a
LEFT JOIN `pok_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
0.3 5 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE id_productvideo FROM pok_iqit_productvideo WHERE id_product = 26 LIMIT 1
0.3 1 /modules/iqitextendedproduct/src/IqitProductVideo.php:73
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) LIMIT 1
0.3 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 802 LIMIT 1
0.3 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pok_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM pok_shop s
LEFT JOIN pok_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.3 1 /classes/shop/Shop.php:204
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) LIMIT 1
0.3 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) LIMIT 1
0.3 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `pok_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 35 LIMIT 1
0.3 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pok_product` p
INNER JOIN `pok_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pok_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 28)
0.3 68 /classes/Product.php:3280
SELECT SQL_NO_CACHE id_elementor FROM pok_iqit_elementor_product WHERE id_product = 26 LIMIT 1
0.3 1 /modules/iqitelementor/src/IqitElementorProduct.php:57
SELECT SQL_NO_CACHE * FROM `pok_hook_alias`
0.3 88 /classes/Hook.php:249
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 43) LIMIT 1
0.3 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 803 LIMIT 1
0.3 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE id_iqitsizechart FROM pok_iqitsizechart_product WHERE id_product = 26 LIMIT 1
0.3 18 /modules/iqitsizecharts/src/IqitSizeCharts.php:277
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 11 LIMIT 1
0.3 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
0.3 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-panorama-addon/revslider-panorama-addon.php' LIMIT 1
0.3 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `pok_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
0.3 146 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) LIMIT 1
0.2 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) LIMIT 1
0.2 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_group` a
LEFT JOIN `pok_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.2 3 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 50 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 35) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `pok_lang` l
JOIN pok_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.2 9 /classes/Language.php:1030
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_lang` a
LEFT JOIN `pok_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 7) LIMIT 1
0.2 9 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 28 LIMIT 1
0.2 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE * FROM `pok_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.2 8 Yes /classes/ImageType.php:108
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) LIMIT 1
0.2 29 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 50) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `pok_lang` l
LEFT JOIN `pok_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.2 9 /classes/Language.php:881
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-panorama-addon/revslider-panorama-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-polyfold-addon/revslider-polyfold-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 802) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 2 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 2 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 43
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 26) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 43 LIMIT 1
0.2 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pok_category_lang` cl
WHERE `id_lang` = 7
AND cl.id_shop = 1 
AND cl.`id_category` = 11 LIMIT 1
0.2 464 /classes/Category.php:1321
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 35
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE *
FROM `pok_tax_lang`
WHERE `id_tax` = 53
0.2 19 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 35 LIMIT 1
0.2 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pok_category_product` cp
INNER JOIN `pok_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 43 AND ctg.`id_group` = 1 LIMIT 1
0.2 100080 /classes/Product.php:5399
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 803) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 44 LIMIT 1
0.2 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 2 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM `pok_tax` a
WHERE (a.`id_tax` = 53) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 2 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM `pok_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 1
0.2 26 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE id_simpleblog_post, id_product
FROM `pok_simpleblog_related_post`
WHERE (id_product = 26)
0.2 1 /modules/ph_relatedposts/models/SimpleBlogRelatedPost.php:35
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pok_category_product` cp
INNER JOIN `pok_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 44 AND ctg.`id_group` = 1 LIMIT 1
0.2 100080 /classes/Product.php:5399
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 44
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE *
FROM `pok_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `id_module` FROM `pok_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.2 146 /src/Adapter/Module/ModuleDataProvider.php:169
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 803 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 50
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 802 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE depends_on_stock
FROM `pok_stock_available`
WHERE (id_product = 26) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:661
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 11 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 43 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE `width`, `height`
FROM pok_image_type
WHERE `name` = 'small_default' LIMIT 1
0.2 8 /classes/Image.php:497
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 44 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 802
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 780 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE `width`, `height`
FROM pok_image_type
WHERE `name` = 'home_default' LIMIT 1
0.2 8 /classes/Image.php:497
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 28
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 50 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE * FROM `pok_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.2 1 /classes/module/Module.php:2066
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_hook` a
WHERE (a.`id_hook` = 21) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE * FROM pok_revslider_sliders
0.2 1 /modules/revsliderprestashop/includes/revslider_db.class.php:215
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-typewriter-addon/revslider-typewriter-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 2
0.2 26 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `pok_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 1) LIMIT 1
0.2 4 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 44) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE id_shop
FROM `pok_category_shop`
WHERE `id_category` = 2
AND id_shop = 1 LIMIT 1
0.2 29 /classes/ObjectModel.php:1549
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 802 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 780) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `pok_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 2) LIMIT 1
0.2 4 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `id_module` FROM `pok_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.2 146 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 2 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 803
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 43 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `pok_category` c
WHERE (c.`id_category` = 2) LIMIT 1
0.2 1 /classes/Category.php:1867
SELECT SQL_NO_CACHE id_shop
FROM `pok_currency_shop`
WHERE `id_currency` = 4
AND id_shop = 1 LIMIT 1
0.2 5 /classes/ObjectModel.php:1549
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 45) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `pok_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 780 LIMIT 1
0.2 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE *
FROM `pok_hook` a
WHERE (a.`id_hook` = 349) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 803 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 2 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 26 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `pok_group`
WHERE `id_group` = 1 LIMIT 1
0.2 3 /classes/Group.php:150
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 45 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `pok_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.2 146 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 45
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE *
FROM `pok_iqitreviews_products` pr
WHERE pr.`id_product` = 26 AND pr.`status` = 1
ORDER BY pr.`date_add` DESC
0.2 1 Yes /modules/iqitreviews/src/IqitProductReview.php:98
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 44 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 35 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 780 LIMIT 1
0.2 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE *
FROM `pok_group_lang`
WHERE `id_group` = 1
0.2 81 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pok_required_field
0.2 1 /classes/ObjectModel.php:1416
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pok_stock_available`
WHERE (id_product = 28) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE id_shop
FROM `pok_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1549
SELECT SQL_NO_CACHE `id_module` FROM `pok_module_shop` WHERE `id_module` = 169 AND `id_shop` = 1 LIMIT 1
0.2 116 /classes/module/Module.php:2151
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 780 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pok_category_lang` cl
WHERE `id_lang` = 7
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
0.2 464 /classes/Category.php:1321
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 35 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 45 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `name` FROM `pok_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.2 0 /classes/Supplier.php:242
SELECT SQL_NO_CACHE name FROM pok_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 2 LIMIT 1
0.2 464 /classes/Product.php:4634
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 45 LIMIT 1
0.2 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE * FROM pok_revslider_sliders
0.2 1 /modules/revsliderprestashop/includes/revslider_db.class.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pok_product_shop`
WHERE `id_product` = 28 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pok_product_attribute`
WHERE `id_product` = 780
0.2 68 /classes/Product.php:2417
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `pok_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 116 /classes/module/Module.php:2151
SELECT SQL_NO_CACHE `reduction`
FROM `pok_product_group_reduction_cache`
WHERE `id_product` = 28 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE option_value FROM `pok_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
0.2 9 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pok_product_attribute pa
INNER JOIN pok_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 26 LIMIT 1
0.2 4624 /classes/Product.php:832
SELECT SQL_NO_CACHE * FROM pok_revslider_sliders
0.2 1 /modules/revsliderprestashop/includes/revslider_db.class.php:215
SELECT SQL_NO_CACHE *
FROM `pok_category` a
LEFT JOIN `pok_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 23) LIMIT 1
0.2 29 /src/Adapter/EntityMapper.php:67