Интернет-магазин «Bookovka» +380980543003;+38(044)333-6783;+38(099)109-3003;+38(073)053-3003 online@bookovka.com.ua
Киев ул.Тампере, 5
#128325
128325

Донжуанский список Пушкина. Потаенная любовь поэта

Автор: Александр Пушкин, Петр Губер

Язык: Русский

Издательство: Амфора

10 Товары

Наличие: На складе издательства

Посмотреть все характеристики ↓
В блестящем исследовании известного русского писателя и переводчика рассмотрен шутливый Донжуанский список - перечень возлюбленных величайшего поэта нашей стран... далее->

Больше информации

170 грн.

Почему такая цена?

- +

Аннотация

В блестящем исследовании известного русского писателя и переводчика рассмотрен шутливый Донжуанский список - перечень возлюбленных величайшего поэта нашей страны.

ФИО Автора Александр Пушкин, Петр Губер
Переплет Твердый
Вес 180
Язык Русский
Кол-во страниц 256
Издательство Амфора
Издание Отдельное издание
Размер книги 130х200
Написать отзыв

Мой отзыв

Товары из этой категории:

  • Фанаты бизнеса

    Говорят, что русские люди склонны

    Говорят, что русские люди склонны изобретать и выдумывать, но не строить эффективный бизнес. Говорят, что успеха в России можно добиться, занимаясь лишь нефтью ...

    313 грн.
    Fast
    Код предмета:100513 В наличии
  • Сказки и легенды Шотландии

    Подборка из 11 лучших волшебных

    Подборка из 11 лучших волшебных шотландских и кельтских сказок и легенд в обработке Терезы Бреслин - всемирно известной британской детской писательницы, уроженк...

    1 095 грн.
    Код предмета:100519 На складе издательства
  • Плюшевый заяц, или как игрушки становятся настоящими

    "Плюшевый заяц, или Как игрушки

    "Плюшевый заяц, или Как игрушки становятся настоящими" стала классикой жанра и вошла в "золотой фонд" всемирной литературы. Впервые опубликованная в 1922 году, ...

    697 грн.
    Код предмета:100533 На складе издательства
  • Мужчины без женщин

    Это первый сборник рассказов за

    Это первый сборник рассказов за последние годы, с тех пор как в Японии вышли "Токийские легенды" (2005). Харуки Мураками написал несколько романов. И только вес...

    316 грн.
      (1)
    Fast
    Код предмета:100546 В наличии
  • Генри Форд. Моя жизнь, мои достижения (твердый

    Перед вами книга, выдержавшая более

    Перед вами книга, выдержавшая более ста изданий по всему миру. Ее принято считать биографией Генри Форда, но это, скорее, биография его дела...

    211 грн.
    bestsellers
    Код предмета:101843 На складе издательства
  • Ілон Маск. Tesla, SpaceX і шлях у фантастичне

    Независимый и разносторонний взгляд

    Независимый и разносторонний взгляд на жизнь и достижения самого яркого предпринимателя Кремниевой долины.

    362 грн.
    Fast
    Код предмета:100124 В наличии
  • Как это было у меня: 90-е

    Книга Сергея Васильева, начинавшего

    Книга Сергея Васильева, начинавшего свой бизнес с Тверьуниверсалбанка, - уникальные личные заметки о 1990-х. Эта книга о трансформации типичной советской молоде...

    520 грн.
    Код предмета:100598 На складе издательства
  • Alibaba. Дім, який збудував Джек Ма

    Захоплива історія про те, як учитель

    Захоплива історія про те, як учитель побудував одну з наи?дорожчих у світі компаніи? — суперника Walmart та Amazon — і назавжди змінив обличчя світовоі? економі...

    272 грн.
    Fast
    Код предмета:100624 В наличии
  • PewDiePie. Эта книга любит тебя

    Этот сборник творчески оформленных

    Этот сборник творчески оформленных цитат о вдохновении от популярного видеоблогера Феликса Чельберга, известного на своем канале YouTube под именем PewDiePie, п...

    114 грн.
    Код предмета:100657 На складе издательства
  • Бабий ветер

    В центре повествования этой, подчас

    В центре повествования этой, подчас шокирующей, резкой и болевой книги - Женщина. Героиня, в юности - парашютистка и пилот воздушного шара, пережив личную траге...

    291 грн.
    Fast
    Код предмета:100690 В наличии
  • Безгрешность

    Двадцатитрехлетняя Пип ненавидит

    Двадцатитрехлетняя Пип ненавидит свое полное имя - Пьюрити ("чистота", или "безгрешность"), не знает, кто ее отец, не может расплатиться с учебным долгом и не у...

    387 грн.
    Fast
    Код предмета:100696 В наличии
  • Бійцівський клуб 2. Графічний роман

    Книга, в которой устами Чака

    Книга, в которой устами Чака Паланика заговорило не просто "Поколение Икс", но — "Поколение Икс" уже озлобленное, уже растерявшее свои последние иллюзии. Вы смо...

    275 грн.
    Fast
    Код предмета:100716 В наличии
  • Блиск і полум’я. Біографія діамантів

    Діаманти вічні, люди – ні. Але саме

    Діаманти вічні, люди – ні. Але саме люди творили історію цих прекрасних блискучих каменів. Шукачі та покупці, королеви та майстри, інвестори та інноватори, крас...

    369 грн.
    Код предмета:100719 На складе
  • Братья Райт. Люди, которые научили мир летать

    В начале ХХ века человечество

    В начале ХХ века человечество охватила "летная лихорадка" - страстное стремление воплотить, наконец, в жизнь многовековую мечту об управляемом полете. Правитель...

    371 грн.
    Код предмета:100733 На складе
  • Бэтман Аполло

    Книга, от которой еще до выхода

    Книга, от которой еще до выхода обалдели Алексей Навальный, Эдуард Лимонов и Дмитрий Быков! ...

    260 грн.
    Код предмета:100740 На складе издательства
  • В тихой ночи. Лирика

    Тилль Линдеманн - легенда мира

    Тилль Линдеманн - легенда мира музыки и автор текстов песен немецкой группы Rammstein. Его стихи, проиллюстрированные талантливым художником Маттиасом Матисом, ...

    610 грн.
    Fast
    Код предмета:100749 В наличии
  • Важкі рішення

    Зазнавши поразки в ході виборчих

    Зазнавши поразки в ході виборчих перегонів 2008 року, Гілларі Клінтон спромоглася здобути повагу свого головного супротивника Барака Обами. Цінуючи принциповіст...

    323 грн.
    Код предмета:100753 На складе
  • Ваш официальный Бизнес на Amazon. com

    Это откровенный рассказ о прибыльном

    Это откровенный рассказ о прибыльном бизнесе, основанный на реальных событиях. Который в максимально простой форме, пошагово отвечает на главный вопрос: как зар...

    243 грн.
    Код предмета:100757 На складе
  • Добыча. Всемирная история борьбы за нефть, деньги и

    "Добыча" описывает борьбу за

    "Добыча" описывает борьбу за богатство и власть, которая в течение десятилетий сопутствовала нефтедобыче и которая будет вечным топливом глобального противостоя...

    767 грн.
      (1)
    Код предмета:100868 На складе
  • Имя розы

    Имя розы - книга с загадкой. В

    Имя розы - книга с загадкой. В начале XIV века, вскоре после того, как Данте сочинил "Божественную комедию", в сердце Европы, в бенедиктинском монастыре обнаруж...

    632 грн.
    Код предмета:100956 На складе издательства
  • Источник (два тома в одной книге)

    Главные герои романа - архитектор

    Главные герои романа - архитектор Говард Рорк и журналистка Доминик Франкон - отстаивают свободу творческой личности в борьбе с обществом, где ценят "равные воз...

    323 грн.
    Fast
    Код предмета:100987 В наличии
  • Інґа

    Сьогодні іі би називали it-girl, але

    Сьогодні іі би називали it-girl, але за масштабами авантюризму і харизми, більшість сучасних героінь модних журналів до неі не дотягують. До того, як зустріти К...

    281 грн.
    Код предмета:100991 На складе
  • Коррупция при дворе Короля-Солнце. Взлет и падение

    Книга представляет собой

    Книга представляет собой захватывающую историю взлета и падения главы финансового ведомства двора Людовика XIV - Никола Фуке. Тщательное и захватывающее биограф...

    633 грн.
    Код предмета:101073 На складе
  • Край навылет

    Изданный в 2013 году "Край навылет"

    Изданный в 2013 году "Край навылет" сразу стал бест­селлером: множество комплиментарных рецензий в прессе, восторженные отзывы поклонников. Пинчон верен себе -...

    158 грн.
    Код предмета:101075 На складе издательства
  • Мата Хари. Шпионка

    От детства в маленьком голландском

    От детства в маленьком голландском городке и брака с алкоголиком на Яве - к покорению Парижа, куда Мата Хари приехала без денег и где вскоре приобрела славу одн...

    316 грн.
    Код предмета:101135 На складе издательства
  • Мемуары

    Вступив на путь коммерции раньше,

    Вступив на путь коммерции раньше, чем кто бы то ни было (уже в возрасте семи лет наш герой «со всем достоинством делового человека» продавал индюшек), он, вероя...

    355 грн.
      (1)
    Fast
    Код предмета:101143 В наличии
  • Мозг Леонардо: Постигая гений Да Винчи

    Леонардо вызывает у нас негаснущий

    Леонардо вызывает у нас негаснущий интерес, поскольку достиг наивысшего совершенства в том, к чему стремимся все мы, простые смертные: к всестороннему развитию,...

    367 грн.
    Fast
    Код предмета:101178 В наличии
  • На островах ГУЛАГа. Воспоминания заключенной

    Автор книги, Евгения Федорова,

    Автор книги, Евгения Федорова, хотела стать детской писательницей, но оказалась в сталинских лагерях. В результате литературные плоды ее жизни связаны с очень в...

    502 грн.
    Код предмета:101204 На складе издательства
  • Найти умного: Как проверить логическое мышление и

    Методику интервьюирования при приеме

    Методику интервьюирования при приеме на работу в корпорацию Microsoft, основанную на решении задач и головоломок, теперь перенимают многие компании, которые хот...

    257 грн.
    Код предмета:101208 На складе
  • Структура реальности. Наука параллельных вселенных

    "Дэвид Дойч формулирует Теорию

    "Дэвид Дойч формулирует Теорию Всего, переплетая низко- и высокоуровневые теории: Квантовую физику, Эпистемологию, Теорию вычислений и Эволюционную доктрину. Ра...

    340 грн.
    Fast
    Код предмета:101492 В наличии
Вперед Назад
Перечень
Load Time2463 ms - You'd better run your shop on a toaster
Querying Time1862 ms
Queries2597
Memory Peak Usage75.2 Mb
Included Files535 files - 9.89 Mb
PrestaShop Cache- Mb
Global vars2.85 Mb
PrestaShop Version1.6.1.20
PHP Version7.1.33 (OK)
MySQL Version10.3.18-MariaDB (OK)
Memory Limit512M
Max Execution Time259200s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 67 ms 67 ms 12.47 Mb 12.69 Mb
__construct 0 ms 67 ms - Mb 12.69 Mb
init 26 ms 92 ms 3.56 Mb 16.32 Mb
checkAccess 0 ms 92 ms - Mb 16.32 Mb
setMedia 1 ms 93 ms 0.16 Mb 16.39 Mb
postProcess 0 ms 93 ms - Mb 16.39 Mb
initHeader 0 ms 93 ms - Mb 16.39 Mb
initContent 2292 ms 2385 ms 54.11 Mb 71.16 Mb
initFooter 10 ms 2395 ms 0.71 Mb 71.38 Mb
display 68 ms 2463 ms 3.01 Mb 75.16 Mb
Hook Time Memory Usage
hookdisplayLeftColumn 1306 ms 2.00 Mb
hookproductfooter 801 ms 32.00 Mb
hookdisplayProductListReviews 377 ms 12.00 Mb
__construct 144 ms 24.00 Mb
hookdisplayHeader 23 ms 2.00 Mb
hookdisplayTopColumn 21 ms 2.00 Mb
hookdisplayFooter 10 ms 2.00 Mb
hookdisplayTop 10 ms 2.00 Mb
hookdisplayHomeBottomColumn 8 ms 2.00 Mb
hookdisplayProductStockLabel 7 ms - Mb
hooksetProductStockValue 7 ms - Mb
hookdisplayProductListFunctionalButtons 6 ms - Mb
hookdisplayRightColumnProduct 6 ms - Mb
hookHeader 5 ms - Mb
hookproducttabcontent 3 ms - Mb
hookdisplayNav 3 ms - Mb
hookdisplayProductButtons 3 ms - Mb
hookdisplayBottomColumn 2 ms - Mb
hookdisplayHomeTopColumn 2 ms - Mb
hookdisplaySocialSharing 1 ms - Mb
hookdisplayProductTabContent 1 ms - Mb
hookdisplayProductTab 1 ms - Mb
hookproducttab 1 ms - Mb
hookdisplayOvicCategorySizeChart 1 ms - Mb
hookCustomVideoHook 1 ms - Mb
hookdisplayBeforeLogo 1 ms - Mb
hookdisplayCategorySlider 1 ms - Mb
hookdisplayVerticalMenu 1 ms - Mb
hookdisplayProductPriceBlock 1 ms - Mb
hookdisplayHomeBottomContent 0 ms - Mb
hookproductactions 0 ms - Mb
hookdisplayContactInfo 0 ms - Mb
hookdisplayStoreMap 0 ms - Mb
hookactionProductOutOfStock 0 ms - Mb
hookdisplayHomeTopContent 0 ms - Mb
hookdisplayAfterBody 0 ms - Mb
hookactionObjectAddAfter 0 ms - Mb
hookPackWebseregas - ms - Mb
hookdisplayFooterProduct - ms - Mb
hookDisplayOverrideTemplate - ms - Mb
hookdisplayLeftColumnProduct - ms - Mb
hookmoduleRoutes - ms - Mb
hookPackWebseregascart - ms - Mb
hookdisplayProductDeliveryTime - ms - Mb
44 hooks 2753 ms 80.00 Mb
Module Time Memory Usage
oviclayoutcontrol 1377 ms 12.00 Mb
productscategory 798 ms 32.00 Mb
seosaproductlabels 303 ms 10.00 Mb
productcomments 88 ms 2.00 Mb
newsletterpro 16 ms 6.00 Mb
jsoxActuals 16 ms - Mb
pm_advancedsearch4 13 ms - Mb
pm_advancedpack 10 ms - Mb
order_synchronization 8 ms 2.00 Mb
homesliderpro 8 ms 2.00 Mb
blockwishlist 8 ms - Mb
advanceblog 7 ms - Mb
ecm_novaposhta 7 ms 4.00 Mb
groupcategory 6 ms 2.00 Mb
report_product_availability 6 ms - Mb
bookworks 5 ms - Mb
socialsharing 5 ms - Mb
productvideo 5 ms - Mb
blocknewsletter 4 ms - Mb
blocklayered 4 ms 2.00 Mb
verticalmegamenus 4 ms 2.00 Mb
crossselling 3 ms - Mb
categoryslider 2 ms - Mb
oviccategorysizechart 2 ms - Mb
gsnippetsreviews 2 ms - Mb
ovicstoremap 2 ms - Mb
blockbestsellers 2 ms - Mb
prestasms 2 ms - Mb
ba_ajax_search 2 ms 2.00 Mb
reviewsadv 2 ms - Mb
g_ordermanager 2 ms - Mb
lgtagmanager 2 ms - Mb
gremarketing 1 ms - Mb
ovicnewsletter 1 ms - Mb
advancefooter 1 ms - Mb
mailalerts 1 ms - Mb
ganalytics 1 ms - Mb
homeslider 1 ms - Mb
ovicblockcms 1 ms - Mb
advancetopmenu 1 ms - Mb
sendreviewrequest 1 ms - Mb
themeconfigurator 1 ms - Mb
blockreinsurance 1 ms 2.00 Mb
blocktags 1 ms - Mb
bookworks_filters 1 ms - Mb
jsox_ordersplitter 1 ms - Mb
sekeywords 1 ms - Mb
bookproductlog 1 ms - Mb
recalculate_products_price 1 ms - Mb
tinymcepro 1 ms - Mb
jsoxNeironet 1 ms 2.00 Mb
statsdata 1 ms - Mb
blockcart 1 ms - Mb
jsoxFids 1 ms - Mb
jsox_adminorderchat 1 ms - Mb
sendsmsbystatus 1 ms - Mb
multistyle 1 ms - Mb
blockbanner 1 ms - Mb
oviccustomtags 1 ms - Mb
bookatel 0 ms - Mb
additionalorders 0 ms - Mb
autoliqpay 0 ms - Mb
blockhtml 0 ms - Mb
pagesnotfound 0 ms - Mb
oviccustombanner 0 ms - Mb
discountproducts 0 ms - Mb
jsox_ordercomplectcorrector 0 ms - Mb
categorysearch 0 ms - Mb
blockstore 0 ms - Mb
blockspecials 0 ms - Mb
jsox_waitstate 0 ms - Mb
jsox_newpost_pay_corrector 0 ms - Mb
ecm_feedback 0 ms - Mb
homefeatured 0 ms - Mb
blocksocial 0 ms - Mb
blocksupplier 0 ms - Mb
blockmanufacturer 0 ms - Mb
brandsslider 0 ms - Mb
promomod 0 ms - Mb
trackorderstatus 0 ms - Mb
blocknewproducts 0 ms - Mb
jsoxEANUpdateAndNPAddress 0 ms - Mb
blockcontactinfos 0 ms - Mb
blockcontact 0 ms - Mb
productpaymentlogos 0 ms - Mb
advancedfeaturesvalues 0 ms - Mb
jsox_adminproductnamecopybutton 0 ms - Mb
blockmyaccount 0 ms - Mb
blockuserinfo 0 ms - Mb
jsoxCache 0 ms - Mb
90 modules 2753 ms 80.00 Mb

Stopwatch SQL - 2597 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.id_product, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, pl.`link_rewrite`, pl.`name`, pl.`description_short`, product_shop.`id_category_default`,
MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, p.`ean13`, p.`upc`, p.`reference`, cl.`link_rewrite` AS category, p.show_price, p.available_for_order, IFNULL(stock.quantity, 0) as quantity, p.customizable,
IFNULL(pa.minimal_quantity, p.minimal_quantity) as minimal_quantity, stock.out_of_stock,
product_shop.`date_add` > "2019-10-30" as new,
product_shop.`on_sale`, MAX(product_attribute_shop.minimal_quantity) AS product_attribute_minimal_quantity
FROM `ps_product_sale` ps
LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute` pa
ON (p.`id_product` = pa.`id_product`)
LEFT JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_lang` pl
ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN ps_jsoxActualsParams jsa ON p.`id_product` = jsa.`pid`
LEFT JOIN `ps_category_lang` cl
ON cl.`id_category` = product_shop.`id_category_default`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`)
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE product_shop.`active` = 1 AND p.`id_category_default` IN (156,14,16,15,17,19,18,86,26,25,31,27,28,29,13)
AND jsa.`stock` IN (1,2,3,4)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1)
GROUP BY p.`id_product`
ORDER BY sales DESC
LIMIT 0, 12
1256.7 4575775050 Yes /override/classes/ProductSale.php:225
SELECT SQL_NO_CACHE p.id_product, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`link_rewrite`, pl.`name`, pl.`description_short`, product_shop.`id_category_default`,
image_shop.`id_image` id_image, il.`legend`,
ps.`quantity` AS sales, p.`ean13`, p.`upc`, p.`reference`, cl.`link_rewrite` AS category, p.show_price, p.available_for_order, IFNULL(stock.quantity, 0) as quantity, p.customizable,
IFNULL(pa.minimal_quantity, p.minimal_quantity) as minimal_quantity, stock.out_of_stock,
product_shop.`date_add` > "2019-10-30" as new,
product_shop.`on_sale`, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM `ps_product_sale` ps
LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_attribute` pa ON (product_attribute_shop.id_product_attribute=pa.id_product_attribute)
LEFT JOIN `ps_product_lang` pl
ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN ps_jsoxActualsParams jsa ON p.`id_product` = jsa.`pid`
LEFT JOIN `ps_category_lang` cl
ON cl.`id_category` = product_shop.`id_category_default`
AND cl.`id_lang` = 1 AND cl.id_shop = 1  LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE product_shop.`active` = 1
AND jsa.`stock` IN (1,2,3,4)
AND p.`is_virtual` = 0
AND p.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`)
ORDER BY ps.quantity DESC
LIMIT 0, 12
146.5 137970 /override/classes/ProductSale.php:160
SELECT SQL_NO_CACHE e.`id_included_product`, pl.`name`
FROM `ps_seosaproductlabels_included` e
JOIN `ps_product` p ON e.`id_included_product` = p.`id_product`
JOIN `ps_product_lang` pl ON pl.`id_product` = p.`id_product`
WHERE e.`id_product_label` = 22 AND pl.`id_lang` = 1
34.8 338 /modules/seosaproductlabels/classes/ProductLabel.php:226
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_items` ti
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (ti.`id_item` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tis ON (ti.`id_item` = tis.`id_item`)
WHERE `id_block` = 0 AND
tis.`id_shop` = 1 AND
til.`id_lang` = 1 AND active = 1
ORDER BY  ti.`position` ASC
5.9 15 Yes /modules/advancetopmenu/advancetopmenu.php:1086
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2059
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
5.7 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
4 1729 /classes/Configuration.php:148
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 8) AND (b.`id_shop` = 1) LIMIT 1
3.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.7 236 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
2.5 1297 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayBottomColumn'
AND `id_shop` = 1 LIMIT 1
2.1 294 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1.9 245 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1165
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.8 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 122673
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.8 9 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2349
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.7 12 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 12584
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.7 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 166
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 20 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.4 602 /classes/Hook.php:235
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8dcf9465b8279ca5377786f78a0b0441',"productcomments|1|1|1|216|797","", FROM_UNIXTIME(1573641002))
1.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2059) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 29707
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.3 13 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1515
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 565
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 19 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE l.*, ss.id_supplier, sl.text
FROM ps_seosaproductlabels_supplier ss
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ss.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
1.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:154
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 10) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 7538
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
1 1297 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2121
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 623
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 904
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 18 Yes /override/classes/Product.php:659
INSERT INTO ps_express_cache 
(page_id, page_url, id_currency, id_language, id_country, id_shop, 
cache, cache_size, hits, miss, hit_time,
miss_time, entity_type, id_entity, is_mobile, last_updated, customer_groups)
VALUES ('7351ff0cc64bff70c1cfba7f8061b1ee', 'https://www.bookovka.com.ua/khudozhestvennaya-literatura/29707-donzhuanskij-spisok-pushkinapotaennaya-lyubov-poeta.html', 1, 
1, 216, 1,'7351ff0cc64bff70c1cfba7f8061b1ee1121610', 36687,
0, 1, 0, 1573641002, 'product', 29707, 0,'2019-11-13 10:30:02','')
ON DUPLICATE KEY UPDATE miss = miss + 1,
last_updated ='2019-11-13 10:30:02',
cache = '7351ff0cc64bff70c1cfba7f8061b1ee1121610', cache_size = 36687,
miss_time = ((miss_time*miss) + 1573641002.788) / (miss + 1)
1 1 /override/classes/controller/FrontController.php:280
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1103
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 269
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1173
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 311
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 323
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 989
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1620
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2072
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 20 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4966
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1539
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1594
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1022
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 294
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 18 Yes /override/classes/Product.php:659
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(
"2019-11-13 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessoryz`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_jsoxActualsParams` ja ON (p.`id_product` = ja.`pid`)
WHERE `id_product_1` = 29707 AND ja.`stock` != 5 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
ORDER BY product_shop.`type_of_book`
0.8 1 Yes Yes /override/classes/Product.php:393
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 533
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 29707
ORDER BY `position`
0.8 1 Yes /classes/Product.php:2731
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 268
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 774
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 737
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 5
ORDER BY  `position` ASC
0.8 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1641
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10418
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 67) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 640
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2077
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 789
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 123
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 113090
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 5 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10806
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1236
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3584
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 11 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=29707
0.7 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 296
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1633
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 793
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 281
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 698
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2079
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 282
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1595
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 318
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 20 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2350
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 17 Yes /override/classes/Product.php:659
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(
"2019-11-13 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessoryz`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_jsoxActualsParams` ja ON (p.`id_product` = ja.`pid`)
WHERE `id_product_1` = 29707 AND ja.`stock` != 5 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
ORDER BY product_shop.`type_of_book`
0.7 1 Yes Yes /override/classes/Product.php:393
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 295
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 19 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1018
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 123 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.7 2 Yes /classes/Image.php:187
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2050
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 13 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3535
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.7 338 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1645
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1208
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 13 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 666
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2228
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 29707
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.6 1 Yes Yes /classes/Product.php:3523
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayBeforeLogo'
AND `id_shop` = 1 LIMIT 1
0.6 294 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 797 AND `id_shop` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1232
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 13
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.6 11 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 757
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3544
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 10 Yes /override/classes/Product.php:659
show tables like "ps_sesliders_slideconf"
0.6 1 /modules/homesliderpro/homesliderpro.php:1218
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 312
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 16 Yes /override/classes/Product.php:659
SHOW TABLES LIKE 'ps_order_synchronization_stores';
0.6 1 /modules/bookworks/bookworks.php:285
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4986
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 617
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 313
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 328
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 463
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 326
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2175
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name`
FROM `ps_product_comment_criterion` pcc
LEFT JOIN `ps_product_comment_criterion_lang` pccl
ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion)
LEFT JOIN `ps_product_comment_criterion_product` pccp
ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 29707)
LEFT JOIN `ps_product_comment_criterion_category` pccc
ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`)
LEFT JOIN `ps_product_shop` ps
ON (ps.id_category_default = pccc.id_category AND ps.id_product = 29707)
WHERE pccl.`id_lang` = 1
AND (
pccp.id_product IS NOT NULL
OR ps.id_product IS NOT NULL
OR pcc.id_product_comment_criterion_type = 1
)
AND pcc.active = 1
GROUP BY pcc.id_product_comment_criterion
0.6 1 Yes /modules/productcomments/ProductCommentCriterion.php:176
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 299
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 731
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 780 AND `id_shop` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE p.`id_profile`, `name`
FROM `ps_profile` p
LEFT JOIN `ps_profile_lang` pl ON (p.`id_profile` = pl.`id_profile` AND `id_lang` = 1)
ORDER BY `id_profile` ASC
0.6 8 /classes/Profile.php:57
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 315
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE l.`id_product_label`,
l.`name`,
l.`mini_price`,
l.`max_price`,
l.`quantity`,
l.`quantity_max`,
pl.`url`,
l.`active`,
ll.id_product_label_location, ll.position,
ll.`id_product`,
l.`label_type`,
l.`groups`,
l.`product_condition`,
l.`date_from`,
l.`date_to`
FROM `ps_seosaproductlabels_location` ll
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ll.id_product_label
LEFT JOIN `ps_seosaproductlabels_lang` pl ON pl.id_product_label = l.id_product_label
WHERE l.active = 1 AND (ll.id_product = 666)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.6 2415 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.bookovka.com.ua' OR su.domain_ssl = 'www.bookovka.com.ua')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.6 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 123 AND `id_shop` = 1
0.6 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 330
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 316
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1777
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 7070
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 286
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 287
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1105
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 539
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 553
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1165) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 329
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2107
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 760
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2123
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8dcf9465b8279ca5377786f78a0b0441',"productcomments|1|1|1|216|698","", FROM_UNIXTIME(1573641002))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 503
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1775
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 171
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 20 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 780
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 566
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3590
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 11 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3564
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 11 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1564
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 797
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 11 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.5 58 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2177
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 13 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 1515 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.5 2 Yes /classes/Image.php:187
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 29707
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-13 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.5 0 /classes/Product.php:1282
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2107) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 29707
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.5 1 Yes Yes /classes/Product.php:3523
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 904) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1620) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 331
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2246
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 13
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.5 11 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 353
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 281) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 789 AND `id_shop` = 1
0.5 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1633) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 332
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
0.5 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 333
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "product" LIMIT 1
0.5 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 334
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 337
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 361
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 19 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 533 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.5 3 Yes /classes/Image.php:187
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 489
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.5 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.4 1 /classes/Language.php:777
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 1
0.4 9 /classes/Employee.php:452
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 151
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeBottomContent'
AND `id_shop` = 1 LIMIT 1
0.4 294 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2347
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10806) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 640) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 323) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE l.`id_product_label`,
l.`name`,
l.`mini_price`,
l.`max_price`,
l.`quantity`,
l.`quantity_max`,
pl.`url`,
l.`active`,
ll.id_product_label_location, ll.position,
ll.`id_product`,
l.`label_type`,
l.`groups`,
l.`product_condition`,
l.`date_from`,
l.`date_to`
FROM `ps_seosaproductlabels_location` ll
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ll.id_product_label
LEFT JOIN `ps_seosaproductlabels_lang` pl ON pl.id_product_label = l.id_product_label
WHERE l.active = 1 AND (ll.id_product = 989)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.4 2415 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 338
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 617) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 151) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2019-11-13 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 29707 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.4 1 Yes /classes/Product.php:3608
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 566
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.4 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE l.`id_product_label`,
l.`name`,
l.`mini_price`,
l.`max_price`,
l.`quantity`,
l.`quantity_max`,
pl.`url`,
l.`active`,
ll.id_product_label_location, ll.position,
ll.`id_product`,
l.`label_type`,
l.`groups`,
l.`product_condition`,
l.`date_from`,
l.`date_to`
FROM `ps_seosaproductlabels_location` ll
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ll.id_product_label
LEFT JOIN `ps_seosaproductlabels_lang` pl ON pl.id_product_label = l.id_product_label
WHERE l.active = 1 AND (ll.id_product = 757)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.4 2415 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2183
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 337) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 147 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 294) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2194
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 147 /classes/module/Module.php:277
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2241
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2228) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2178
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 12 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE l.`id_product_label`,
l.`name`,
l.`mini_price`,
l.`max_price`,
l.`quantity`,
l.`quantity_max`,
pl.`url`,
l.`active`,
ll.id_product_label_location, ll.position,
ll.`id_product`,
l.`label_type`,
l.`groups`,
l.`product_condition`,
l.`date_from`,
l.`date_to`
FROM `ps_seosaproductlabels_location` ll
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ll.id_product_label
LEFT JOIN `ps_seosaproductlabels_lang` pl ON pl.id_product_label = l.id_product_label
WHERE l.active = 1 AND (ll.id_product = 904)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.4 2415 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.4 194 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 147 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 353) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 147 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 123) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3609
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 12 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.4 1 /classes/Language.php:892
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2184
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `left` FROM `ps_ovic_options_sidebar` WHERE `page` ='product' AND `id_shop`=1 LIMIT 1
0.4 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:528
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1645) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2019-11-13 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 29707 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.4 1 Yes /classes/Product.php:3608
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 666) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3589
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 11 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3591
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.4 11 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 533 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.4 3 Yes /classes/Image.php:187
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 904) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE l.*, cr.id_cart_rule, sl.text, sl.hint, sl.url
FROM ps_seosaproductlabels_cart_rules cr
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = cr.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.4 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:175
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 1
AND pl.id_product = 29707
AND product_shop.active = 1 LIMIT 1
0.4 1 /classes/Meta.php:259
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2072) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 904 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.4 3 Yes /classes/Image.php:187
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1103) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 797) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1165) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1595) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 67
AND `active` = 1 LIMIT 1
0.4 1 /override/classes/Manufacturer.php:239
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 326) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 1
0.4 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options` a
LEFT JOIN `ps_ovic_options_lang` `b` ON a.`id_option` = b.`id_option` AND b.`id_lang` = 1
WHERE (a.`id_option` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 29707 LIMIT 1
0.4 1 /classes/Page.php:77
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1022) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.4 20 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 698 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.4 2 Yes /classes/Image.php:187
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.4 154 /classes/Tab.php:296
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.4 11 /classes/ImageType.php:143
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 617 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.4 3 Yes /classes/Image.php:187
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 737) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1539) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1236) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 328) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 780) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE l.`id_product_label`,
l.`name`,
l.`mini_price`,
l.`max_price`,
l.`quantity`,
l.`quantity_max`,
pl.`url`,
l.`active`,
ll.id_product_label_location, ll.position,
ll.`id_product`,
l.`label_type`,
l.`groups`,
l.`product_condition`,
l.`date_from`,
l.`date_to`
FROM `ps_seosaproductlabels_location` ll
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ll.id_product_label
LEFT JOIN `ps_seosaproductlabels_lang` pl ON pl.id_product_label = l.id_product_label
WHERE l.active = 1 AND (ll.id_product = 698)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.3 2415 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 216) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2175) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 698) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 330) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 329) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE l.*, sm.id_manufacturer, sl.text
FROM ps_seosaproductlabels_manufacturer sm
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = sm.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.3 2 /modules/seosaproductlabels/classes/ProductLabelLocation.php:137
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 731) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 318) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1018) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1564) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 539) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 789) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.3 1 /classes/Page.php:96
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 760) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'ru' LIMIT 1
0.3 1 /classes/Language.php:680
SELECT SQL_NO_CACHE e.`id_included_product`, pl.`name`
FROM `ps_seosaproductlabels_included` e
JOIN `ps_product` p ON e.`id_included_product` = p.`id_product`
JOIN `ps_product_lang` pl ON pl.`id_product` = p.`id_product`
WHERE e.`id_product_label` = 25 AND pl.`id_lang` = 1
0.3 1 /modules/seosaproductlabels/classes/ProductLabel.php:226
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 989) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2123) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE l.*, sm.id_manufacturer, sl.text
FROM ps_seosaproductlabels_manufacturer sm
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = sm.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.3 2 /modules/seosaproductlabels/classes/ProductLabelLocation.php:137
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 553) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2050) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 29707
AND image_shop.`cover` = 1 LIMIT 1
0.3 1 /classes/Product.php:2753
SELECT SQL_NO_CACHE distinct
id,
name,
link
FROM
ps_order_synchronization_stores;
0.3 1 /modules/bookworks/bookworks.php:296
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="29707"
0.3 1 /modules/report_product_availability/report_product_availability.php:107
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 539 AND `id_shop` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 489) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.3 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 182
AND c.nright >= 205
AND c.nleft >= 2
AND c.nright <= 541
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.3 135 Yes /classes/Tools.php:1335
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1105) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_hook, conf FROM `ps_sesliders_slideconf`
WHERE `id_shop` = 1
0.3 2 /modules/homesliderpro/homesliderpro.php:402
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 333) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `index_image_css` `index`, `product_image_css` `product`, `category_image_css` `category`
FROM `ps_seosaproductlabels` WHERE `id_product_label` = 25 LIMIT 1
0.3 1 /modules/seosaproductlabels/classes/ProductLabel.php:207
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 617 AND `id_shop` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 757) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(`id_option`) FROM `ps_ovic_options` WHERE `id_option` = 1 LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:355
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 503) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2077) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 731) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 268) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE t.*,t2.img_path, tl.link_rewrite, tl.post_title, p.active, p.publication_time FROM `ps_fme_blog_products` t
LEFT JOIN `ps_fme_blog_posts_lang` tl
ON (t.`id_post` = tl.`id_post` AND tl.`id_lang` = 1)
LEFT JOIN `ps_fme_blog_posts` p
ON (t.`id_post` = p.`id_post`)
LEFT JOIN `ps_fme_blog_images` t2
ON (t.id_post = t2.id_post and t2.featured = 1)
WHERE t.`id_product` = 29707
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.3 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='8dcf9465b8279ca5377786f78a0b0441' AND cache_id="productcomments|1|1|1|216|698" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE l.*, ss.id_supplier, sl.text
FROM ps_seosaproductlabels_supplier ss
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ss.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.3 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:154
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 463) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-13 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.3 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 14 Yes Yes