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

Год с Питером Друкером: 52 недели тренировки эффективного руководителя

Автор: Джозеф Мачиариелло

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

Издательство: Эксмо

10 Товары

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

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

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

818 грн.

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

- +

Аннотация

Вы держите в руках незаменимую книгу для каждого, кто готов стать признанным лидером. В ее основе лежит курс Питера Друкера, прославленного теоретика менеджмента, оказавшего влияние на каждого второго руководителя в мире.  Точнее, это даже не книга, а рабочая тетрадь с увлекательными заданиями и вопросами в конце каждой главы, которые помогут вам лучше запомнить и сразу воплотить в жизнь прочитанное.  Курс содержит 52 статьи, по одной на каждую неделю года. Необязательно читать их подряд и делать упражнения по порядку, выбирайте актуальные для себя темы и развивайте те качества, которые вам необходимы.  Всего несколько минут в неделю работы над собой, и вы станете эффективным руководителем, которого описывал в своем бессмертном труде Питер Друкер.

От магазина

Книгу Год с Питером Друкером: 52 недели тренировки эффективного руководителя купить с доставкой по Киеву и Украине, Вы всегда сможете в интернет магазине "Bookovka". Будем рады ответить на любые Ваши вопросы.

ФИО АвтораДжозеф Мачиариелло
ПереплетМягкая обложка
ЯзыкРусский
БумагаОфсетная
Кол-во страниц256
ИздательствоЭксмо
Иллюстрациинет
ИзданиеОтдельное издание
Размер книги245x340
ФИО ПереводчикаА. Соколова
Написать отзыв
Год с Питером Друкером: 52 недели тренировки эффективного руководителя

Год с Питером Друкером: 52 недели тренировки эффективного руководителя

Мой отзыв

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

  • Думай медленно...Решай быстро (Суперобложка)

    Наши действия и поступки определены

    Наши действия и поступки определены нашими мыслями. Но всегда ли мы контролируем наше мышление? Нобелевский лауреат Даниэль Канеман объясняет, почему мы подчас совершаем нерациональные поступки и как мы принимаем неверные решения... 

    507 грн.
    Код предмета:100485 На складе издательства
  • 7 навыков высокоэффективных людей (обложка с

    Во-первых, эта книга излагает

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

    315 грн.
    bestsellers
    Код предмета:101845 В наличии
  • История You Tube

    В этой книге ты откроешь целый мир.

    В этой книге ты откроешь целый мир. Мир, созданный двумя неуклюжими парнями, которые рассказывают о своей жизни всему интернету. Ну, то есть, нами. Нас зовут Д...

    158 грн.
    Fast
    Код предмета:100496 В наличии
  • Как заработать на кризисе

    Кризис выбивает вас из колеи? Не

    Кризис выбивает вас из колеи? Не дайте стрессу и хаосу захватить власть. Ведь кризис - это испытание на прочность. В нашей стране, при неопределенной и нестабил...

    190 грн.
    Fast
    Код предмета:100498 В наличии
  • Я всегда знаю, что сказать

    Книга, которую вы держите в руках,

    Книга, которую вы держите в руках, объединяет в себе то множество научных подходов, которые существуют в современном мире переговоров. В основе книги лежит сил...

    452 грн.
    Fast
    Код предмета:100500 В наличии
  • Действуй как лидер

    Эрминия Ибарра создала ценную и

    Эрминия Ибарра создала ценную и успешную модель, которая поможет прогрессивно мыслящим руководителям продолжить путь к вершинам управления. На основе принципа «...

    315 грн.
    Fast
    Код предмета:100502 В наличии
  • Тренинг по нейромаркетингу

    Эта книга о том, как исследования

    Эта книга о том, как исследования мозга помогают привлечь внимание покупателя и увеличить продажи. Авторы предлагают эффективные техники создания запоминающихся...

    434 грн.
    Код предмета:100503 На складе издательства
  • Психология согласия

    Если и существует на свете книга,

    Если и существует на свете книга, которая может стать причиной экстраординарного рывка в карьере и бизнесе, вы держите ее в руках. Автор "Психологии согласия", ...

    300 грн.
      (1)
    Fast
    Код предмета:100551 В наличии
  • НЕТ. Лучшая стратегия ведения переговоров.

    Если всякий раз, когда ваш партнер

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

    430 грн.
    Fast
    Код предмета:100554 В наличии
  • Сначала скажите НЕТ". Секреты профессиональных

    Если ваш клиент, угрожая разрывом

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

    479 грн.
    Fast
    Код предмета:100555 В наличии
  • Копирайтинг. Как не съесть собаку. Создаем тексты,

    Эта книга - набор методик, приемов и

    Эта книга - набор методик, приемов и секретов по написанию продающих текстов (текстов для сайтов, полиграфии, коммерческих предложений и других рекламных целей)...

    332 грн.
    Код предмета:100580 На складе издательства
  • Scrum. Навчись робити вдвічі більше за менший час

    Методика Scrum — решение, найденное

    Методика Scrum — решение, найденное Джеффом Сазерлендом, чтобы преодолеть классические недостатки управления проектами: отсутствие слаженной работы внутри коман...

    140 грн.
    bestsellers
    Код предмета:100591 В наличии
  • Нейромаркетинг. Визуализация эмоций.

    Книга помогает постичь тайны

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

    201 грн.
    Fast
    Код предмета:100592 В наличии
  • 7 навыков высокоэффективных людей (интегральная

    Во-первых, эта книга излагает

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

    344 грн.
    Код предмета:100593 На складе
  • Дело не в кофе. Корпоративная культура Starbucks

    О том, что компания должна

    О том, что компания должна рассматривать и своих сотрудников, и своих клиентов прежде всего как людей, тогда все остальное придет само собой. Если руководитель ...

    242 грн.
    bestsellers
    Код предмета:100594 В наличии
  • 7 навыков высокоэффективных людей (твердый переплет).

    Во-первых, эта книга излагает

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

    327 грн.
      (1)
    bestsellers
    Top
    Код предмета:101850 В наличии
  • Как это было у меня: 90-е

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

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

    520 грн.
    Код предмета:100598 На складе издательства
  • 50 советов по рекрутингу

    В своей новой книге Светлана Иванова

    В своей новой книге Светлана Иванова сформулировала наиболее важные советы HR-менеджеру, которые помогут правильно действовать при найме специалистов любого уро...

    502 грн.
    Fast
    Код предмета:100614 В наличии
  • 9 техник сторителлинга

    Организационный сторителлинг -

    Организационный сторителлинг - мощный инструмент руководства и изменения стиля менеджмента. Он усиливает ваше влияние как лидера. Знание того, какую историю рас...

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

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

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

    272 грн.
    Fast
    Код предмета:100624 В наличии
  • MBA в кармане: Практическое руководство по развитию

    "MBA в кармане" - это практическое

    "MBA в кармане" - это практическое руководство по ключевым навыкам управления, от которых зависит как коммерческий, так и личный успех. Книга состоит из трех ча...

    454 грн.
    Код предмета:100649 На складе издательства
  • MBA за 10 дней: Самое важное из программ ведущих

    В этой книге вы найдете

    В этой книге вы найдете квинтэссенцию знаний, необходимых руководителям и менеджерам для эффективного управления бизнесом. Это книга для тех, кто ценит свое вре...

    428 грн.
    Fast
    Код предмета:100650 В наличии
  • Private labels. Новые конкуренты традиционных брендов

    О товарах под собственными марками,

    О товарах под собственными марками, которые в современном мире мало чем уступают торговым маркам производителей. О том, как розничные магазины выстраивают страт...

    257 грн.
    Код предмета:100659 На складе
  • Sony. Сделано в Японии

    О жизни и работе великих японцев от

    О жизни и работе великих японцев от имени не менее великого представителя своей нации Акио Мариты. Сплетения судеб выдающихся изобретателей и предпринимателей, ...

    293 грн.
    Fast
    Код предмета:100664 В наличии
  • TED TALKS. Слова меняют мир. Первое официальное

    Вы держите в руках новое руководство

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

    282 грн.
    Fast
    Код предмета:100667 В наличии
  • Актерское мастерство. Американская школа

    В настоящем издании впервые

    В настоящем издании впервые представлен полный обзор и анализ основных методик, разработанных для американских актеров за последние 60 лет...

    380 грн.
    Fast
    Код предмета:100677 В наличии
  • Алгоритм успешного общения при подборе персонала.

    Залог успеха при подборе персонала -

    Залог успеха при подборе персонала - правильно выстроенная коммуникация на всех этапах. Автор предлагает четкий алгоритм общения при подборе сотрудников: как со...

    331 грн.
    Fast
    Код предмета:100678 В наличии
  • Алгоритмы эффективной работы

    Каждый современный менеджер

    Каждый современный менеджер испытывает постоянную нехватку времени. Как же научиться все успевать? Как не поддаться искушению отложить работу на «потом»? Как на...

    349 грн.
    Код предмета:100679 На складе
  • Банк 3.0. Почему сегодня банк - это не то, куда вы

    Книга Бретта Кинга "Банк 2.0" более

    Книга Бретта Кинга "Банк 2.0" более полутора лет держалась на первом месте в списке бестселлеров Amazon по банкингу и финансам в США, Великобритании, Германии, ...

    963 грн.
    Код предмета:100691 На складе
  • Бережливое производство: Как избавиться от потерь и

    О бережливом производстве (lean

    О бережливом производстве (lean production) - прорывном подходе к менеджменту и управлению качеством, обеспечивающем долговременную конкурентоспособность без су...

    489 грн.
    Fast
    Код предмета:100697 В наличии
Вперед Назад

Покупатели, которые купили этот товар, также интересуются:

Перечень
Load Time3071 ms - You'd better run your shop on a toaster
Querying Time2027 ms
Queries2301
Memory Peak Usage41.3 Mb
Included Files562 files - 9.86 Mb
PrestaShop Cache- Mb
Global vars2.85 Mb
PrestaShop Version1.6.1.20
PHP Version7.1.28 (OK)
MySQL Version10.3.18-MariaDB (OK)
Memory Limit8192M
Max Execution Time259200s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 67 ms 67 ms 3.06 Mb 3.08 Mb
__construct 0 ms 68 ms - Mb 3.08 Mb
init 43 ms 111 ms 1.62 Mb 4.80 Mb
checkAccess 0 ms 111 ms - Mb 4.80 Mb
setMedia 1 ms 112 ms 0.01 Mb 4.80 Mb
postProcess 0 ms 112 ms - Mb 4.80 Mb
initHeader 0 ms 112 ms - Mb 4.80 Mb
initContent 2840 ms 2952 ms 33.28 Mb 38.85 Mb
initFooter 13 ms 2965 ms 0.34 Mb 38.85 Mb
display 106 ms 3071 ms 1.74 Mb 41.26 Mb
Hook Time Memory Usage
hookproductfooter 1711 ms 28.00 Mb
hookdisplayLeftColumn 833 ms 2.00 Mb
hookdisplayProductListReviews 523 ms 8.00 Mb
__construct 80 ms 6.00 Mb
hookdisplayHeader 48 ms - Mb
hookdisplayTop 24 ms - Mb
hookdisplayTopColumn 24 ms - Mb
hookdisplayProductStockLabel 20 ms - Mb
hooksetProductStockValue 19 ms - Mb
hookdisplayProductListFunctionalButtons 15 ms - Mb
hookdisplayFooter 12 ms - Mb
hookdisplayRightColumnProduct 10 ms - Mb
hookHeader 10 ms - Mb
hookproducttabcontent 6 ms - Mb
hookdisplayHomeBottomColumn 5 ms - Mb
hookdisplayNav 5 ms - Mb
hookdisplaySocialSharing 4 ms - Mb
hookdisplayCategorySlider 4 ms - Mb
hookdisplayProductButtons 4 ms - Mb
hookdisplayProductTabContent 3 ms - Mb
hookdisplayProductTab 3 ms - Mb
hookproducttab 2 ms - Mb
hookdisplayOvicCategorySizeChart 2 ms - Mb
hookdisplayVerticalMenu 2 ms - Mb
hookdisplayProductPriceBlock 2 ms - Mb
hookdisplayHomeTopColumn 1 ms - Mb
hookdisplayContactInfo 1 ms - Mb
hookdisplayBottomColumn 1 ms - Mb
hookproductactions 1 ms - Mb
hookdisplayBeforeLogo 1 ms - Mb
hookdisplayHomeBottomContent 0 ms - Mb
hookdisplayStoreMap 0 ms - Mb
hookCustomVideoHook 0 ms - Mb
hookdisplayHomeTopContent 0 ms - Mb
hookdisplayAfterBody 0 ms - Mb
hookactionProductOutOfStock 0 ms - Mb
hookdisplayFooterProduct 0 ms - Mb
hookDisplayOverrideTemplate 0 ms - Mb
hookPackWebseregas 0 ms - Mb
hookdisplayLeftColumnProduct 0 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookPackWebseregascart 0 ms - Mb
hookactionObjectAddAfter - ms - Mb
hookdisplayProductDeliveryTime - ms - Mb
44 hooks 3377 ms 44.00 Mb
Module Time Memory Usage
productscategory 1691 ms 28.00 Mb
oviclayoutcontrol 918 ms 2.00 Mb
seosaproductlabels 478 ms 8.00 Mb
productcomments 67 ms - Mb
jsoxActuals 41 ms 2.00 Mb
crossselling 20 ms - Mb
socialsharing 19 ms - Mb
blockwishlist 17 ms - Mb
categoryslider 14 ms - Mb
blocknewsletter 8 ms 2.00 Mb
bookworks 8 ms - Mb
advanceblog 8 ms - Mb
report_product_availability 6 ms - Mb
productvideo 6 ms - Mb
verticalmegamenus 5 ms - Mb
ovicstoremap 4 ms - Mb
oviccategorysizechart 4 ms - Mb
newsletterpro 4 ms - Mb
pm_advancedpack 4 ms - Mb
homesliderpro 3 ms - Mb
pm_advancedsearch4 3 ms - Mb
lgtagmanager 2 ms - Mb
ecm_novaposhta 2 ms 2.00 Mb
blockbestsellers 2 ms - Mb
groupcategory 2 ms - Mb
jsox_newpost_pay_corrector 1 ms - Mb
blocktags 1 ms - Mb
order_synchronization 1 ms - Mb
multistyle 1 ms - Mb
ganalytics 1 ms - Mb
jsox_adminorderchat 1 ms - Mb
gsnippetsreviews 1 ms - Mb
ovicblockcms 1 ms - Mb
prestasms 1 ms - Mb
jsox_ordersplitter 1 ms - Mb
tinymcepro 1 ms - Mb
blockstore 1 ms - Mb
sendreviewrequest 1 ms - Mb
bookproductlog 1 ms - Mb
ecm_feedback 1 ms - Mb
advancetopmenu 1 ms - Mb
pagesnotfound 1 ms - Mb
blocklayered 1 ms - Mb
statsdata 1 ms - Mb
sekeywords 1 ms - Mb
g_ordermanager 1 ms - Mb
mailalerts 1 ms - Mb
themeconfigurator 1 ms - Mb
blockcart 1 ms - Mb
promomod 1 ms - Mb
blocksupplier 1 ms - Mb
advancedfeaturesvalues 1 ms - Mb
categorysearch 1 ms - Mb
ba_ajax_search 1 ms - Mb
reviewsadv 1 ms - Mb
blockmyaccount 1 ms - Mb
jsox_waitstate 1 ms - Mb
autoliqpay 1 ms - Mb
blocknewproducts 1 ms - Mb
gremarketing 1 ms - Mb
homefeatured 1 ms - Mb
recalculate_products_price 1 ms 2.00 Mb
blockcontact 1 ms - Mb
blockhtml 1 ms - Mb
blockuserinfo 1 ms - Mb
trackorderstatus 0 ms - Mb
ovicnewsletter 0 ms - Mb
blockspecials 0 ms - Mb
homeslider 0 ms - Mb
discountproducts 0 ms - Mb
advancefooter 0 ms - Mb
blockbanner 0 ms - Mb
jsox_ordercomplectcorrector 0 ms - Mb
blocksocial 0 ms - Mb
additionalorders 0 ms - Mb
blockreinsurance 0 ms - Mb
sendsmsbystatus 0 ms - Mb
oviccustomtags 0 ms - Mb
oviccustombanner 0 ms - Mb
bookworks_filters 0 ms - Mb
bookatel 0 ms - Mb
productpaymentlogos 0 ms - Mb
jsox_adminproductnamecopybutton 0 ms - Mb
brandsslider 0 ms - Mb
blockmanufacturer 0 ms - Mb
jsoxNeironet 0 ms - Mb
jsoxFids 0 ms - Mb
jsoxCache 0 ms - Mb
jsoxEANUpdateAndNPAddress 0 ms - Mb
blockcontactinfos 0 ms - Mb
90 modules 3377 ms 44.00 Mb

Stopwatch SQL - 2301 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-29" 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
749.6 4038538500 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-29" 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
194.8 116100 /override/classes/ProductSale.php:160
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` = 322) AND (b.`id_shop` = 1) LIMIT 1
23.1 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
13.5 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` = 252) AND (b.`id_shop` = 1) LIMIT 1
12.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 253)
10.9 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 353 AND `id_group` = 1 LIMIT 1
9.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 322
ORDER BY `id_specific_price_priority` DESC LIMIT 1
8.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 253
8.1 11 /classes/Product.php:2625
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` = 253) AND (b.`id_shop` = 1) LIMIT 1
8.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 = 322
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
8 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 253
ORDER BY `id_specific_price_priority` DESC LIMIT 1
8 1 /classes/SpecificPrice.php:196
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`)
7.8 1729 /classes/Configuration.php:148
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 252
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.3 1 /classes/SpecificPrice.php:196
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` = 523) AND (b.`id_shop` = 1) LIMIT 1
6.8 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
6.7 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 252
5.8 10 /classes/Product.php:2625
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` = 481) AND (b.`id_shop` = 1) LIMIT 1
5.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 322)
5.3 1 /classes/Product.php:3008
UPDATE `ps_smarty_lazy_cache`
SET filepath='socialsharing_header/867/1/1/1/216/07/6e/c7/076ec7cb9349bfb67512b8417798bd61850cc55a.socialsharing_header.tpl.php'
WHERE `template_hash`='9405c352066b2fe7282158bd9de91622' AND cache_id="socialsharing_header|867|1|1|1|216" AND compile_id=""
5.2 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 353) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.2 1 /classes/stock/StockAvailable.php:380
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
5.1 602 /classes/Hook.php:235
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 353)
4.9 1 /classes/Product.php:3008
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 = 840
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
4.8 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 = 942
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
4.6 15 Yes /override/classes/Product.php:659
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
4.5 338 /modules/seosaproductlabels/classes/ProductLabel.php:226
SELECT SQL_NO_CACHE DISTINCT od.product_id, pl.name, pl.description_short, pl.link_rewrite, p.reference, i.id_image, product_shop.show_price,
cl.link_rewrite category, p.ean13, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
FROM ps_order_detail od
LEFT JOIN ps_product p ON (p.id_product = od.product_id)
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 (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN ps_image i ON (i.id_product = od.product_id)
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = product_shop.id_category_default
AND cp.id_product = product_shop.id_product)
LEFT JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (25351)
AND pl.id_lang = 1
AND cl.id_lang = 1
AND od.product_id NOT IN (867)
AND i.cover = 1
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 100
4.4 6 Yes /modules/crossselling/crossselling.php:179
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
4.4 245 Yes /classes/Country.php:130
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`
3.9 228 Yes Yes /classes/Hook.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` = 353) AND (b.`id_shop` = 1) LIMIT 1
3.9 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('2a8b85a36dcd9f24acdad9b38a80b6e7',"productscategory|867|14|1|1|1|216","", FROM_UNIXTIME(1573549937))
3.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 353 AND id_shop=1 LIMIT 1
3.7 1 /classes/Product.php:5043
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.7 1 Yes /classes/SpecificPrice.php:362
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
3.4 338 /modules/seosaproductlabels/classes/ProductLabel.php:226
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 = 464
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
3.3 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
3.3 1311 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE DISTINCT od.product_id, pl.name, pl.description_short, pl.link_rewrite, p.reference, i.id_image, product_shop.show_price,
cl.link_rewrite category, p.ean13, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
FROM ps_order_detail od
LEFT JOIN ps_product p ON (p.id_product = od.product_id)
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 (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN ps_image i ON (i.id_product = od.product_id)
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = product_shop.id_category_default
AND cp.id_product = product_shop.id_product)
LEFT JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (25351)
AND pl.id_lang = 1
AND cl.id_lang = 1
AND od.product_id NOT IN (867)
AND i.cover = 1
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 100
3.3 6 Yes /modules/crossselling/crossselling.php:179
SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1 AND od.product_id IN (867)
3.2 2 /modules/crossselling/crossselling.php:133
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 = 252
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
3.1 18 Yes /override/classes/Product.php:659
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
2.8 338 /modules/seosaproductlabels/classes/ProductLabel.php:226
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 253 AND id_shop=1 LIMIT 1
2.8 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
2.8 1311 /classes/SpecificPrice.php:238
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` = 848) AND (b.`id_shop` = 1) LIMIT 1
2.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=40 AND id_shop IN (1) LIMIT 1
2.5 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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 = 190
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.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 = 522
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.4 19 Yes /override/classes/Product.php:659
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
2.4 338 /modules/seosaproductlabels/classes/ProductLabel.php:226
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.4 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 481
2.3 7 /classes/Product.php:2625
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 464 AND `id_group` = 1 LIMIT 1
2.2 0 /classes/GroupReduction.php:149
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 = 933
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.2 16 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` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2.2 18 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 523
2.1 9 /classes/Product.php:2625
SELECT SQL_NO_CACHE hs.`id_categoryslider_slides` as id_slide,
hssl.`image`,
hss.`position`,
hss.`id_category`,
hss.`active`,
hssl.`title`,
hssl.`url`,
hssl.`legend`,
hssl.`description`
FROM ps_categoryslider hs
LEFT JOIN ps_categoryslider_slides hss ON (hs.id_categoryslider_slides = hss.id_categoryslider_slides)
LEFT JOIN ps_categoryslider_slides_lang hssl ON (hss.id_categoryslider_slides = hssl.id_categoryslider_slides)
WHERE (id_shop = 1) AND hss.`id_category` = 14
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
2.1 1 Yes /modules/categoryslider/categoryslider.php:715
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
2 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 = 317
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2 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 = 771
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2 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 = 249
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2 16 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-12 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` = 867 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`
2 1 Yes Yes /override/classes/Product.php:393
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` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 18 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 322 AND `id_group` = 1 LIMIT 1
1.9 0 /classes/GroupReduction.php:149
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 = 778
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 = 253
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.8 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 = 749
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.8 15 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 ('dc3b468c302c456f2a10f35a5820a018', 'https://www.bookovka.com.ua/biznes-dengi-ekonomika/867-god-s-piterom-drukerom-52-nedeli-trenirovki-effektivnogo-rukovoditelia.html', 1, 
1, 216, 1,'dc3b468c302c456f2a10f35a5820a0181121610', 32455,
0, 1, 0, 1573549937, 'product', 867, 0,'2019-11-12 09:12:17','')
ON DUPLICATE KEY UPDATE miss = miss + 1,
last_updated ='2019-11-12 09:12:17',
cache = 'dc3b468c302c456f2a10f35a5820a0181121610', cache_size = 32455,
miss_time = ((miss_time*miss) + 1573549937.578) / (miss + 1)
1.8 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 = 256
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.8 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 = 366
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 262
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.8 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 = 521
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 752
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 = 762
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 261
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 732
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 257
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 835
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.7 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
1.7 1 /classes/Country.php:173
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 = 700
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 12
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 606
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 718
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 748
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 708
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 575
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 763
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 738
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 739
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 254
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 747
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 598
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 2228
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 705
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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 = 46
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 255
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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 = 719
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 7538
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 750
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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 = 10418
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 523
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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 = 754
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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
1.5 140 /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 = 574
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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 = 519
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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 = 744
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 691
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 720
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 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 = 612
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.5 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 571) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.5 1 /classes/stock/StockAvailable.php:380
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
1.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 = 690
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 939
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 640
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 938
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 607
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 258
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 665
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 656
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 666
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 12584
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.4 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 = 605
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 179
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 275
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.4 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 = 289
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.3 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 = 113090
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.3 5 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 1 Yes /classes/SpecificPrice.php:362
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-12 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` = 867 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`
1.3 1 Yes Yes /override/classes/Product.php:393
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 262
1.3 16 /classes/Product.php:2625
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-12 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` = 867 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.3 1 Yes /classes/Product.php:3608
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 = 288
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.3 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 179)
1.2 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.2 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 = 571
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 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 = 2349
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 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 = 903
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 519
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.2 1 /classes/SpecificPrice.php:196
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 = 848
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 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 = 925
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 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 = 867
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.2 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 = 884
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 481
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 785
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 295
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 886
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 15 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 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` 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 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 = 178
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 812
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 2350
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 173
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 920
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 822
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 189
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 565
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 794
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 186
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 164
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 248
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 = 517
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 18 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 571)
1 1 /classes/Product.php:3008
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 = 240
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 = 7070
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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 = 500
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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 = 932
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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 = 1775
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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 = 820
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 = 895
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 = 807
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 = 888
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 = 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 = 168
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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 = 245
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 = 881
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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
1 140 /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 = 4966
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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 = 489
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 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 = 237
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 = 4986
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE * FROM `ps_seosaproductlabels` WHERE 1
1 7 /modules/seosaproductlabels/classes/ProductLabel.php:173
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` = 867
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
1 1 Yes Yes /classes/Product.php:3523
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=5 AND id_shop IN (1) LIMIT 1
1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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` = 46209) AND (b.`id_shop` = 1) LIMIT 1
1 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1 140 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1 140 /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 = 46209
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 8 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` = 289) AND (b.`id_shop` = 1) LIMIT 1
0.9 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 = 514
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 18 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` = 522) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 257 AND id_shop=1 LIMIT 1
0.9 1 /classes/Product.php:5043
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` = 254) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 848
0.9 7 /classes/Product.php:2625
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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.9 1 Yes /classes/SpecificPrice.php:362
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` = 867
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.9 1 Yes Yes /classes/Product.php:3523
SELECT SQL_NO_CACHE `id_excluded_product`
FROM `ps_seosaproductlabels_excluded`
WHERE `id_product_label` = 25 AND `id_excluded_product` = 500 LIMIT 1
0.9 0 /modules/seosaproductlabels/classes/ProductLabel.php:233
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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.9 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` = 500 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.9 5 Yes /classes/Image.php:187
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
0.9 15 Yes /modules/advancetopmenu/advancetopmenu.php:1086
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 = 720)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.9 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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` = 867
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.8 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:362
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-12 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` = 867 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.8 1 Yes /classes/Product.php:3608
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 = 598)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.8 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:362
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` = 867
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.8 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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` = 738) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 884)
0.8 1 /classes/Product.php:3008
SET @@group_concat_max_len = 4096
0.8 1 /override/classes/Product.php:650
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.8 194 /classes/module/Module.php:2141
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 = 606)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.8 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 288)
0.8 1 /classes/Product.php:3008
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:362
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 = 521)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.8 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:362
show tables like "ps_sesliders_slideconf"
0.8 1 /modules/homesliderpro/homesliderpro.php:1218
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:362
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 = 574)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.8 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 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` = 288) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SHOW TABLES LIKE 'ps_order_synchronization_stores';
0.8 1 /modules/bookworks/bookworks.php:285
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` = 464) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 156
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.8 14 Yes Yes /classes/Category.php:859
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 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` = 640) AND (b.`id_shop` = 1) LIMIT 1
0.8 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` = 262) AND (b.`id_shop` = 1) LIMIT 1
0.8 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 = 575)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.8 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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, 46209) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 464
0.7 10 /classes/Product.php:2625
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.7 58 Yes /classes/Dispatcher.php:452
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` = 258) AND (b.`id_shop` = 1) LIMIT 1
0.7 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 = 738)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.7 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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` = 4) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 104 LIMIT 1
0.7 1 /classes/Category.php:1054
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.7 1 Yes /classes/SpecificPrice.php:419
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` = 763) AND (b.`id_shop` = 1) LIMIT 1
0.7 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 = 732)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.7 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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` = 317) AND (b.`id_shop` = 1) LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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` = 739) AND (b.`id_shop` = 1) LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:362
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.7 1 Yes /classes/shop/Shop.php:334
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:362
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` = 867
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.7 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:362
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`=867
0.7 1 /classes/Tag.php:205
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 523
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 1 /classes/SpecificPrice.php:196
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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` = 275) AND (b.`id_shop` = 1) LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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` = 366) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.7 1 Yes /classes/shop/Shop.php:663
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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` = 867) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 14 Yes Yes /classes/Category.php:859
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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` = 840) AND (b.`id_shop` = 1) LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 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` = 113090) AND (b.`id_shop` = 1) LIMIT 1
0.6 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 262 AND `id_group` = 1 LIMIT 1
0.6 0 /classes/GroupReduction.php:149
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 606)
0.6 1 /classes/Product.php:3008
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` = 700) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SET @@group_concat_max_len = 4096
0.6 1 /override/classes/Product.php:650
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` = 749) AND (b.`id_shop` = 1) LIMIT 1
0.6 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 12584
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.6 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 258) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 771) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 522)
0.6 1 /classes/Product.php:3008
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` = 607) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 812) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 289)
0.6 1 /classes/Product.php:3008
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` = 708) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 574) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 762) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 738) LIMIT 1
0.6 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` = 12) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 867
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.6 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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` = 256) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 521) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 867
0.6 1 /classes/Product.php:5703
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.6 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 *
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` = 778) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 7538) AND (b.`id_shop` = 1) LIMIT 1
0.6 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 *, ( 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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 *
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` = 705) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 606) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 785) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 718) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 598) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 164) AND (b.`id_shop` = 1) LIMIT 1
0.6 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_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.6 1 Yes /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 168)
0.6 1 /classes/Product.php:3008
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` = 720) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 12584) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 261) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 938) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 942) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 691) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 514)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.6 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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` = 665) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 46) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 867)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.6 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 666)
0.6 1 /classes/Product.php:3008
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-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 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 *
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` = 750) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 571)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.6 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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` = 732) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 522)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.6 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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 = 519)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.5 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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` = 719) 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` = 666) 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` = 255) 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` = 748) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61