Notice: Undefined property: Product::$context in /var/www/bookovka.com.ua/data/www/bookovka.com.ua/modules/socialsharing/socialsharing.php on line 172 Notice: Trying to get property of non-object in /var/www/bookovka.com.ua/data/www/bookovka.com.ua/modules/socialsharing/socialsharing.php on line 172 Notice: Trying to get property of non-object in /var/www/bookovka.com.ua/data/www/bookovka.com.ua/modules/socialsharing/socialsharing.php on line 173 Notice: Undefined property: Product::$context in /var/www/bookovka.com.ua/data/www/bookovka.com.ua/modules/socialsharing/socialsharing.php on line 174 Notice: Trying to get property of non-object in /var/www/bookovka.com.ua/data/www/bookovka.com.ua/modules/socialsharing/socialsharing.php on line 174 Notice: Trying to get property of non-object in /var/www/bookovka.com.ua/data/www/bookovka.com.ua/modules/socialsharing/socialsharing.php on line 174  Почему это шедевр? Наталья Гончарова купить электронную (цифровую) книгу на bookovka.ua|978-5-04-293581-7
Интернет-магазин «Bookovka» +380980543003;+38(044)333-6783;+38(099)109-3003;+38(073)053-3003 online@bookovka.com.ua
Киев ул.Тампере, 5
#E34726546
Аудиокнига
E34726546

Почему это шедевр? Наталья Гончарова (E34726546)

Автор: Творческий коллектив программы «Хочу всё знать»

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

9999 Товары

Наличие: В наличии

Посмотреть все характеристики ↓
Наталья Гончарова – двоюродная правнучка жены Пушкина Натали Гончаровой – родилась в деревне Ладыжино Тульской губернии. «Вся Гончарова в двух словах: дар и ... далее->

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

- +

Наталья Гончарова – двоюродная правнучка жены Пушкина Натали Гончаровой – родилась в деревне Ладыжино Тульской губернии. «Вся Гончарова в двух словах: дар и труд», – писала о ней Марина Цветаева. О картинах Натальи Гончаровой рассказывает искусствовед Виктория Анисимова: Автопортрет с желтыми лилиями, 1907-1908| Хоровод, 1910| Троица, 1910 и Троица, рисунок, 1910| Полиптих «Жатва», Ангелы, метающие камни в город, 1911| Полиптих «Жатва», Птица Феникс, 1911| Павлин под ярким солнцем.

ФИО Автора Творческий коллектив программы «Хочу всё знать»
Язык Русский
Возраст 6
Серия Хочу всё знать. Искусство (радио «Маяк»)
Правообладатель ВГТРК (Радио "МАЯК")
Рейтинг 10
Тип книги Аудиокнига
Написать отзыв
Почему это шедевр? Наталья Гончарова

Почему это шедевр? Наталья Гончарова

Мой отзыв
Товары из этой категории:
  • Салон красоты на дому
    2190 грн. 2190 грн.
    Салон красоты на дому

    Стильной женщину делают признаки

    Стильной женщину делают признаки постоянного ухода – чистая кожа, ровно окрашенные волосы, мягкие руки. Научитесь выбирать косметические процедуры и найдите ...

    Цена: 2190 грн.
    Код предмета:E185122 В наличии
  • Против лома – есть приемы!
    1640 грн. 1640 грн.
    Против лома – есть приемы!

    Данной книгой я начинаю серию работ,

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

    Цена: 1640 грн.
    Код предмета:E638245 В наличии
  • Лучшие рецепты блюд из творога
    1060 грн. 1060 грн.
    Лучшие рецепты блюд из творога

    В этом издании читатель найдет

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

    Цена: 1060 грн.
    Код предмета:E295822 В наличии
  • Гламур по-рублевски
    913 грн. 913 грн.
    Гламур по-рублевски

    Первая книга-тренинг по гламуру для

    Первая книга-тренинг по гламуру для российских женщин. Известный специалист по элитному велнесу Оксана Хомски раскрывает читательницам секреты гламура, освои...

    Цена: 913 грн.
    Код предмета:E182630 В наличии
  • Лозоплетение. Как заготовить сырьё
    2170 грн. 2170 грн.
    Лозоплетение. Как заготовить сырьё

    Плетеные изделия тонкой,

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

    Цена: 2170 грн.
    Код предмета:E3264085 В наличии
  • ВАЗ. Ремонт
    2170 грн. 2170 грн.
    ВАЗ. Ремонт

    Прочитав эту книгу, Вы не узнаете о

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

    Цена: 2170 грн.
    Код предмета:E3262485 В наличии
  • Вяжем красивые вещи для детей
    1630 грн. 1630 грн.
    Вяжем красивые вещи для детей

    На страницах данной книги

    На страницах данной книги представлены модели вязаной детской одежды. Ознакомившись с азами вязания спицами и крючком, а также с подробными описаниями и схем...

    Цена: 1630 грн.
    Код предмета:E293772 В наличии
  • Все разновидности комнатных растений (от А до Л)
    2170 грн. 2170 грн.
    Все разновидности комнатных растений (от А до Л)

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

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

    Цена: 2170 грн.
    Код предмета:E3264015 В наличии
  • Чай – великий целитель. Сорта и их лечебные свойства, профилактика заболеваний. Травяные чаи, лечебные свойства...
    1650 грн. 1650 грн.
    Чай – великий целитель. Сорта и их лечебные свойства,

    Умеете ли вы заваривать чай

    Умеете ли вы заваривать чай правильно?Знаете ли вы, какую пользу приносит чай и травяные отвары?В этой книге вы найдете исчерпывающие ответы на эти вопросы, ...

    Цена: 1650 грн.
    Код предмета:E293292 В наличии
  • Секреты современной моды
    1830 грн. 1830 грн.
    Секреты современной моды

    Эта книга не о том, как рабски

    Эта книга не о том, как рабски следовать за последними модными тенденциями, она о том, как создать свой персональный стиль. Следовать моде может оказаться оч...

    Цена: 1830 грн.
    Код предмета:E182643 В наличии
  • Cварка легированных сталей
    2170 грн. 2170 грн.
    Cварка легированных сталей

    В книге изложены основы теории

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

    Цена: 2170 грн.
    Код предмета:E3262605 В наличии
  • Тренируем мышцы живота и спины за 10 минут в день
    1460 грн. 1460 грн.
    Тренируем мышцы живота и спины за 10 минут в день

    Если вы хотите стать стройной и

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

    Цена: 1460 грн.
    Код предмета:E182479 В наличии
  • Разносолы из капусты. 350 рецептов из свежей, квашеной и маринованной капусты
    2010 грн. 2010 грн.
    Разносолы из капусты. 350 рецептов из свежей,

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

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

    Цена: 2010 грн.
    Код предмета:E606235 В наличии
  • Грузовые автомобили. Тормоза
    2170 грн. 2170 грн.
    Грузовые автомобили. Тормоза

    Механизмы торможения предусмотрены

    Механизмы торможения предусмотрены для снижения скорости движения, остановки и удержания автомобиля в неподвижном состоянии.В книге подробно рассказано о вид...

    Цена: 2170 грн.
    Код предмета:E4942654 В наличии
  • Диетный эксклюзив
    549 грн. 549 грн.
    Диетный эксклюзив

    В книге представлены не только

    В книге представлены не только лучшие диеты и рецепты приготовления блюд от Мадонны, Эль Макферсон, Синди Кроуфорд, Мэла Гибсона, Ричарда Гира и т. д., но и ...

    Цена: 549 грн.
    Код предмета:E182453 В наличии
  • Особенности изготовления некоторых предметов мебели
    2170 грн. 2170 грн.
    Особенности изготовления некоторых предметов мебели

    Плетеные изделия тонкой,

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

    Цена: 2170 грн.
    Код предмета:E3264115 В наличии
  • Грузовые автомобили. Ведущие мосты
    2170 грн. 2170 грн.
    Грузовые автомобили. Ведущие мосты

    Книга посвящена ведущим мостам

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

    Цена: 2170 грн.
    Код предмета:E4942602 В наличии
  • Работы с полами. Паркет, плитка, ламинат, линолеум
    1630 грн. 1630 грн.
    Работы с полами. Паркет, плитка, ламинат, линолеум

    С тем, что к полам во все времена

    С тем, что к полам во все времена предъявлялись повышенные требования, не поспоришь. Наши дни не являются исключением. Но если в прошлом больше волновал вопр...

    Цена: 1630 грн.
    Код предмета:E594415 В наличии
  • Поединок в таиландском боксе
    2190 грн. 2190 грн.
    Поединок в таиландском боксе

    Классическое учебное пособие по

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

    Цена: 2190 грн.
    Код предмета:E182384 В наличии
  • Лучшие блюда из селедки. Разнообразные меню для будней и праздников
    11 грн. 11 грн.
    Лучшие блюда из селедки. Разнообразные меню для

    В книге собраны многочисленные

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

    Цена: 11 грн.
    Код предмета:E639205 В наличии
  • Крючковые рыболовные снасти
    1830 грн. 1830 грн.
    Крючковые рыболовные снасти

    В книге рассматриваются способы

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

    Цена: 1830 грн.
    Код предмета:E172790 В наличии
  • Новогодняя выпечка. Пироги, пирожки, пирожные и тортики
    1060 грн. 1060 грн.
    Новогодняя выпечка. Пироги, пирожки, пирожные и

    Новый год – праздник особенный. Его

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

    Цена: 1060 грн.
    Код предмета:E3850495 В наличии
  • Путеводитель по «Отчаянным домохозяйкам». Сезон 6
    2170 грн. 2170 грн.
    Путеводитель по «Отчаянным домохозяйкам». Сезон 6

    Вы поклонник сериала «Отчаянные

    Вы поклонник сериала «Отчаянные домохозяйки»? Тогда эта книга для вас. Если вы случайно пропустили какую-нибудь серию, этот путеводитель поможет узнать, что ...

    Цена: 2170 грн.
    Код предмета:E2372135 В наличии
  • ВАЗ. Ремонт двигателя
    2170 грн. 2170 грн.
    ВАЗ. Ремонт двигателя

    Прочитав эту книгу, Вы не узнаете о

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

    Цена: 2170 грн.
    Код предмета:E3262495 В наличии
  • Приготовление мясных блюд
    2170 грн. 2170 грн.
    Приготовление мясных блюд

    Важными составными частями мяса

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

    Цена: 2170 грн.
    Код предмета:E3264835 В наличии
  • Детские праздники. Сценарии, игры, конкурсы
    1060 грн. 1060 грн.
    Детские праздники. Сценарии, игры, конкурсы

    На таких праздниках нет места скуке!

    На таких праздниках нет места скуке! В нашей книге есть все, чтобы максимально интересно организовать самые разнообразные детские праздники, будь то день рож...

    Цена: 1060 грн.
    Код предмета:E307892 В наличии
  • Овощи и зелень. Заготовки по-деревенски
    1460 грн. 1460 грн.
    Овощи и зелень. Заготовки по-деревенски

    Многие хозяйки запасают овощи впрок,

    Многие хозяйки запасают овощи впрок, ведь это так удобно, – всегда под рукой и наверняка вкуснее, чем из магазина. Эта книга расскажет вам, как заготовить в ...

    Цена: 1460 грн.
    Код предмета:E2376405 В наличии
  • Современные узлы для галстуков, шарфов, парео
    1060 грн. 1060 грн.
    Современные узлы для галстуков, шарфов, парео

    И женщины, и мужчины хотят в любой

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

    Цена: 1060 грн.
    Код предмета:E306402 В наличии
  • Сладкое без сахара. Диабетическое меню
    1240 грн. 1240 грн.
    Сладкое без сахара. Диабетическое меню

    Книга Михаила Ахманова «Сладкое без

    Книга Михаила Ахманова «Сладкое без сахара» адресована не только диабетикам, но и всем, кто желает по той или иной причине ограничить потребление углеводов и...

    Цена: 1240 грн.
    Код предмета:E161094 В наличии
  • Вкусный праздничный стол
    1640 грн. 1640 грн.
    Вкусный праздничный стол

    В этой небольшой, но праздничной

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

    Цена: 1640 грн.
    Код предмета:E2932725 В наличии
Вперед Назад
Перечень
Load Time2127 ms - You'd better run your shop on a toaster
Querying Time1857 ms
Queries600
Memory Peak Usage36.7 Mb
Included Files683 files - 11.70 Mb
PrestaShop Cache- Mb
Global vars2.91 Mb
PrestaShop Version1.6.1.20
PHP Version7.1.33 (OK)
MySQL Version10.3.27-MariaDB (OK)
Memory Limit4G
Max Execution Time259200s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 41 ms 41 ms 3.70 Mb 3.70 Mb
__construct 0 ms 41 ms - Mb 3.70 Mb
init 482 ms 522 ms 1.66 Mb 6.05 Mb
checkAccess 0 ms 522 ms - Mb 6.05 Mb
setMedia 1 ms 523 ms 0.01 Mb 6.05 Mb
postProcess 0 ms 523 ms - Mb 6.05 Mb
initHeader 0 ms 523 ms - Mb 6.05 Mb
initContent 1539 ms 2063 ms 12.92 Mb 36.72 Mb
initFooter 9 ms 2072 ms 0.30 Mb 36.72 Mb
display 55 ms 2127 ms 1.77 Mb 36.72 Mb
Hook Time Memory Usage
hookdisplayRightColumnProduct 735 ms - Mb
hookdisplayLeftColumn 599 ms 2.00 Mb
hookdisplayHeader 73 ms 20.00 Mb
__construct 56 ms 2.00 Mb
hookdisplayTopColumn 13 ms - Mb
hookdisplayTop 12 ms - Mb
hookdisplayFooter 9 ms 2.00 Mb
hookHeader 8 ms - Mb
hookproductfooter 8 ms - Mb
hookdisplayNav 6 ms - Mb
hookproducttabcontent 3 ms - Mb
hookdisplayProductButtons 2 ms - Mb
hookdisplayCategorySlider 2 ms - Mb
hookdisplayOvicCategorySizeChart 2 ms - Mb
hookdisplayProductTab 2 ms - Mb
hookdisplaySocialSharing 2 ms - Mb
hookdisplayHomeBottomColumn 2 ms - Mb
hookdisplayProductTabContent 1 ms - Mb
hookproducttab 1 ms - Mb
hookdisplayVerticalMenu 1 ms - Mb
hookdisplayContactInfo 1 ms - Mb
hookdisplayHomeTopColumn 1 ms - Mb
hookdisplayBottomColumn 1 ms - Mb
hookdisplayHomeTopContent 0 ms - Mb
hookdisplayHomeBottomContent 0 ms - Mb
hookproductactions 0 ms - Mb
hookdisplayStoreMap 0 ms - Mb
hookCustomVideoHook 0 ms - Mb
hookdisplayBeforeLogo 0 ms - Mb
hookdisplayDigitalBookIcon 0 ms - Mb
hookdisplayProductStockLabel 0 ms - Mb
hookdisplayAfterBody 0 ms - Mb
hooksetProductStockValue 0 ms - Mb
hookPackWebseregascart 0 ms - Mb
hookactionProductOutOfStock 0 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookDisplayOverrideTemplate - ms - Mb
hookactionObjectAddAfter - ms - Mb
hookdisplayProductDeliveryTime - ms - Mb
hookdisplayProductPriceBlock - ms - Mb
hookPackWebseregas - ms - Mb
hookdisplayFooterProduct - ms - Mb
hookdisplayLeftColumnProduct - ms - Mb
43 hooks 1541 ms 26.00 Mb
Module Time Memory Usage
seosaproductlabels 734 ms - Mb
oviclayoutcontrol 648 ms 4.00 Mb
pm_advancedpack 53 ms 20.00 Mb
bookworks 8 ms 2.00 Mb
productcomments 7 ms - Mb
blocknewsletter 6 ms - Mb
socialsharing 5 ms - Mb
crossselling 5 ms - Mb
advanceblog 5 ms - Mb
categoryslider 4 ms - Mb
report_product_availability 4 ms - Mb
oviccategorysizechart 4 ms - Mb
ovicstoremap 4 ms - Mb
productvideo 3 ms - Mb
verticalmegamenus 3 ms - Mb
homesliderpro 2 ms - Mb
newsletterpro 2 ms - Mb
productscategory 2 ms - Mb
gsnippetsreviews 2 ms - Mb
blockbestsellers 2 ms - Mb
bg_prestasms 1 ms - Mb
pm_advancedsearch4 1 ms - Mb
accumulative_discount 1 ms - Mb
dealershippage 1 ms - Mb
lgtagmanager 1 ms - Mb
anchorfeatures 1 ms - Mb
jsoxLitresWorker 1 ms - Mb
order_synchronization 1 ms - Mb
jsox_newgallery 1 ms - Mb
ecm_shipping_up 1 ms - Mb
blockwishlist 1 ms - Mb
jsoxActuals 1 ms - Mb
multistyle 1 ms - Mb
google_recaptcha 1 ms - Mb
g_ordermanager 1 ms - Mb
tinymcepro 1 ms - Mb
ecm_novaposhta 1 ms - Mb
parsing_products 1 ms - Mb
jsox_adminorderchat 1 ms - Mb
statsdata 1 ms - Mb
trackorderstatus 1 ms - Mb
ecm_feedback 1 ms - Mb
blocktags 1 ms - Mb
sendreviewrequest 1 ms - Mb
ba_ajax_search 1 ms - Mb
gremarketing 0 ms - Mb
ovicnewsletter 0 ms - Mb
ganalytics 0 ms - Mb
advancetopmenu 0 ms - Mb
mailalerts 0 ms - Mb
blockstore 0 ms - Mb
sekeywords 0 ms - Mb
blockcart 0 ms - Mb
recalculate_products_price 0 ms - Mb
jsox_ordersplitter 0 ms - Mb
bookworks_filters 0 ms - Mb
jsox_newpost_pay_corrector 0 ms - Mb
bookproductlog 0 ms - Mb
blocklayered 0 ms - Mb
ultimateimagetool 0 ms - Mb
jsoxNeironet 0 ms - Mb
jsox_ordercomplectcorrector 0 ms - Mb
blockreinsurance 0 ms - Mb
blockcontact 0 ms - Mb
jsoxFids 0 ms - Mb
pagesnotfound 0 ms - Mb
categorysearch 0 ms - Mb
customsuppliers 0 ms - Mb
reviewsadv 0 ms - Mb
jsoxLitresSeller 0 ms - Mb
ovicblockcms 0 ms - Mb
blockspecials 0 ms - Mb
themeconfigurator 0 ms - Mb
productpaymentlogos 0 ms - Mb
autoliqpay 0 ms - Mb
bookatel 0 ms - Mb
advancefooter 0 ms - Mb
discountproducts 0 ms - Mb
jsox_waitstate 0 ms - Mb
blockmyaccount 0 ms - Mb
blocknewproducts 0 ms - Mb
homeslider 0 ms - Mb
brandsslider 0 ms - Mb
oviccustomtags 0 ms - Mb
blockuserinfo 0 ms - Mb
npcashdeliverystatistics 0 ms - Mb
blocksocial 0 ms - Mb
blocksupplier 0 ms - Mb
competitorpricechange 0 ms - Mb
blockcontactinfos 0 ms - Mb
blockhtml 0 ms - Mb
sendsmsbystatus 0 ms - Mb
jsoxCache 0 ms - Mb
jsoxEANUpdateAndNPAddress 0 ms - Mb
wholesale_products_price 0 ms - Mb
additionalorders 0 ms - Mb
blockmanufacturer 0 ms - Mb
blocklanguages 0 ms - Mb
importproduct 0 ms - Mb
blockbanner 0 ms - Mb
jsox_adminproductnamecopybutton 0 ms - Mb
homefeatured 0 ms - Mb
oviccustombanner 0 ms - Mb
relinkingblocks 0 ms - Mb
automaticpacketgeneration 0 ms - Mb
promomod 0 ms - Mb
advancedfeaturesvalues 0 ms - Mb
107 modules 1541 ms 26.00 Mb

Stopwatch SQL - 600 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE od.product_id AS id_product,
SUM(od.product_quantity) AS sales
FROM
ps_orders AS ord
LEFT JOIN
ps_order_detail AS od ON (ord.id_order = od.id_order)
LEFT JOIN
ps_jsoxActualsParams jsa ON  od.product_id = jsa.`pid`
WHERE
ord.date_add >= CONCAT(DATE_ADD(CURDATE(), INTERVAL - 6 MONTH),
' 00:00:00')
AND od.product_id IS NOT NULL
AND jsa.`stock` IN (1 , 2, 3, 4)
GROUP BY od.product_id
ORDER BY sales DESC
LIMIT 0, 10
670.2 123204 Yes /override/classes/ProductSale.php:131
SELECT SQL_NO_CACHE od.product_id AS id_product,
SUM(od.product_quantity) AS sales
FROM
ps_orders AS ord
LEFT JOIN
ps_order_detail AS od ON (ord.id_order = od.id_order)
LEFT JOIN
ps_product AS pr ON (od.product_id = pr.id_product)
LEFT JOIN
ps_jsoxActualsParams jsa ON (od.product_id = jsa.`pid`)
INNER JOIN
ps_product_shop product_shop ON (pr.id_product = product_shop.id_product
AND product_shop.id_shop = 1)
WHERE
ord.date_add >= CONCAT(DATE_ADD(CURDATE(), INTERVAL - 6 MONTH),
' 00:00:00')
AND od.product_id IS NOT NULL
AND jsa.`stock` IN (1 , 2, 3, 4)
AND pr.price >= 100
AND product_shop.`active` = 1
AND pr.`id_category_default` IN (201,202,203,204,205,206,207,208,209,2807,2808,2809)
GROUP BY od.product_id
ORDER BY sales DESC
LIMIT 0, 10
547 123204 Yes /override/classes/ProductSale.php:543
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
460.8 394638 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE app.`id_pack`
FROM `ps_pm_advancedpack` app
19 54237 /modules/pm_advancedpack/AdvancedPack.php:717
SELECT SQL_NO_CACHE * FROM ps_ecm_seoredirect WHERE url_old = "/ru/uvlecheniya-i-khobbi/272836-pochemu-eto-shedevr-natalya-goncharova.html" AND id_shop = "1" ORDER BY id DESC LIMIT 1
6.4 1 /override/classes/controller/FrontController.php:505
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
6.2 2009 /classes/Configuration.php:148
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`
4.2 254 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1775) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.1 1 /classes/stock/StockAvailable.php:380
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
3.2 245 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 123331
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.5 6 Yes /override/classes/Product.php:664
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.3 632 /classes/Hook.php:235
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`,
SUM(0) 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` > "2021-02-23" as new,
product_shop.`on_sale`, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
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 (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_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
p.id_product IN (113090,12584,75973,104440,7070,123331,4966,1775,94700,4986)
AND p.price >= 0
AND product_shop.`active` = 1
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`)
GROUP BY p.id_product
ORDER BY sales DESC
1.9 10 Yes /override/classes/ProductSale.php:183
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`, SUM(0) 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` > "2021-02-23" as new,
product_shop.`on_sale`, MAX(product_attribute_shop.minimal_quantity) AS product_attribute_minimal_quantity
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` 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_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 
WHERE
p.id_product in (651286,687566,370867,763699,506394,862485,366165,290880,754973,460839)
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, 10
1.5 10 Yes /override/classes/ProductSale.php:598
SHOW TABLES LIKE 'ps_order_synchronization_stores';
1.3 1 /modules/bookworks/bookworks.php:285
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 = 460839
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 19 Yes /override/classes/Product.php:664
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.1 16 Yes /override/classes/Product.php:664
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, 460839) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2021-03-09 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` = 272836 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 1 Yes Yes /override/classes/Product.php:398
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 20 Yes /override/classes/Product.php:664
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, 1775) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 2 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(
"2021-03-09 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` = 272836 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 1 Yes Yes /override/classes/Product.php:398
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 = 862485
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 20 Yes /override/classes/Product.php:664
show tables like "ps_sesliders_slideconf"
0.9 1 /modules/homesliderpro/homesliderpro.php:1218
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4966
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 19 Yes /override/classes/Product.php:664
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 = 75973
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 23 Yes /override/classes/Product.php:664
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 = 370867
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 20 Yes /override/classes/Product.php:664
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
0.9 21 Yes /override/classes/Product.php:664
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 = 366165
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 20 Yes /override/classes/Product.php:664
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4986
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 14 Yes /override/classes/Product.php:664
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 = 506394
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 20 Yes /override/classes/Product.php:664
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.8 338 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7070) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 *, ( 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, 94700) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 *, ( 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, 370867) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 `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 = 104440
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 18 Yes /override/classes/Product.php:664
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, 12584) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 *, ( 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, 75973) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 3 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
0.8 159 /classes/module/Module.php:277
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, 104440) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 *, ( 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, 123331) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.8 159 /classes/module/Module.php:277
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, 113090) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 `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 = 651286
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 19 Yes /override/classes/Product.php:664
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, 506394) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 *, ( 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, 651286) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 *, ( 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, 4966) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 * 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.8 15 Yes /modules/advancetopmenu/advancetopmenu.php:1086
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, 687566) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.7 159 /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 = 687566
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 20 Yes /override/classes/Product.php:664
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, 754973) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 2 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, 862485) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 2 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
0.7 159 /classes/module/Module.php:277
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, 4986) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 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 = 113090
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 5 Yes /override/classes/Product.php:664
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, 763699) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 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 = 94700
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 5 Yes /override/classes/Product.php:664
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.7 159 /classes/module/Module.php:277
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2021-03-09 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` = 272836 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.7 1 Yes /classes/Product.php:3612
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 = 272836
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 8 Yes /override/classes/Product.php:664
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.7 159 /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 = 754973
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.7 20 Yes /override/classes/Product.php:664
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2021-03-09 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` = 272836 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.6 1 Yes /classes/Product.php:3612
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 = 290880
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 9 Yes /override/classes/Product.php:664
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` = 272836
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.6 1 Yes Yes /classes/Product.php:3527
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, 272836) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 452
AND c.nright >= 453
AND c.nleft >= 2
AND c.nright <= 775
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.6 162 Yes /classes/Tools.php:1349
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.6 159 /classes/module/Module.php:277
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 452
AND c.nright >= 453
AND c.nleft >= 2
AND c.nright <= 775
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.6 162 Yes /classes/Tools.php:1349
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, 366165) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 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 = 763699
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.6 19 Yes /override/classes/Product.php:664
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, 290880) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 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 2 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` = 272836
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.6 1 Yes Yes /classes/Product.php:3527
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, 272836) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.6 2 Yes /classes/SpecificPrice.php:419
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, 272836) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.5 2 Yes /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.5 58 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1)
WHERE deleted = 0
ORDER BY `name` ASC
0.5 34 Yes /classes/order/OrderState.php:127
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` = 207
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.5 1 Yes Yes /classes/Category.php:656
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` = 207
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.5 1 Yes Yes /classes/Category.php:656
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` = 201
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 11 Yes Yes /classes/Category.php:859
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 ('1d070ade3e33b733096131766d869e28', 'https://www.bookovka.ua/ru/uvlecheniya-i-khobbi/272836-pochemu-eto-shedevr-natalya-goncharova.html', 1,
1, 216, 1,'1d070ade3e33b733096131766d869e281121610', 37770,
0, 1, 0, 1615283335, 'product', 272836, 0,'2021-03-09 09:48:55','')
ON DUPLICATE KEY UPDATE miss = miss + 1,
last_updated ='2021-03-09 09:48:55',
cache = '1d070ade3e33b733096131766d869e281121610', cache_size = 37770,
miss_time = ((miss_time*miss) + 1615283335.315) / (miss + 1)
0.4 1 /override/classes/controller/FrontController.php:381
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` = 272836
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.4 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` = 7070) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 207
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.4 1 Yes /modules/categoryslider/categoryslider.php:715
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeBottomContent'
AND `id_shop` = 1 LIMIT 1
0.4 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.4 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE 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` = 272836
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.4 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeTopContent'
AND `id_shop` = 1 LIMIT 1
0.4 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE i.`id_image` as id
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 272836
ORDER BY i.`position`
0.4 1 Yes /classes/Product.php:5410
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` = 272836
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.4 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` = 4966) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 15 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`)
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 )
WHERE p.`id_product` = 272836
AND l.`active` = 1
0.4 1 /classes/Product.php:5027
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` = 4986) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1775) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12584) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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.ua' OR su.domain_ssl = 'www.bookovka.ua')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.3 1 Yes /classes/shop/Shop.php:334
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` = 94700) AND (b.`id_shop` = 1) LIMIT 1
0.3 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` = 272836
0.3 1 /classes/Product.php:5707
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.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 16) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 104440) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 123331) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE t.*,t2.img_path, tl.link_rewrite, tl.post_title, p.active, p.publication_time FROM `ps_fme_blog_products` t
LEFT JOIN `ps_fme_blog_posts_lang` tl
ON (t.`id_post` = tl.`id_post` AND tl.`id_lang` = 1)
LEFT JOIN `ps_fme_blog_posts` p
ON (t.`id_post` = p.`id_post`)
LEFT JOIN `ps_fme_blog_images` t2
ON (t.id_post = t2.id_post and t2.featured = 1)
WHERE t.`id_product` = 272836
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.3 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
SELECT SQL_NO_CACHE 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` = 4986)
0.3 1 /classes/Product.php:3012
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` = 75973) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE DISTINCT app.`id_pack`
FROM `ps_pm_advancedpack` ap
INNER JOIN `ps_pm_advancedpack_products` app ON app.`id_pack` = ap.`id_pack`
WHERE (ap.`id_shop` IN (1)) AND (app.`id_product`=272836)
0.3 1 /modules/pm_advancedpack/AdvancedPack.php:740
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` = 754973) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 460839) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.`id_profile`, `name`
FROM `ps_profile` p
LEFT JOIN `ps_profile_lang` pl ON (p.`id_profile` = pl.`id_profile` AND `id_lang` = 1)
ORDER BY `id_profile` ASC
0.3 8 /classes/Profile.php:57
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` = 370867) AND (b.`id_shop` = 1) LIMIT 1
0.3 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` = 272836)
0.3 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 25) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 272836
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.3 0 /classes/Product.php:1286
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.3 1 /classes/Language.php:892
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` = 506394) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 687566) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pc.`id_product_comment`,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, 
IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `ps_product_comment` pc
LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 272836 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
0.3 1 Yes /modules/productcomments/ProductComment.php:114
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 272836) AND (b.`id_shop` = 1) LIMIT 1
0.3 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` = 272836
0.3 1 /classes/Product.php:5707
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` = 651286) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name`
FROM `ps_product_comment_criterion` pcc
LEFT JOIN `ps_product_comment_criterion_lang` pccl
ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion)
LEFT JOIN `ps_product_comment_criterion_product` pccp
ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 272836)
LEFT JOIN `ps_product_comment_criterion_category` pccc
ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`)
LEFT JOIN `ps_product_shop` ps
ON (ps.id_category_default = pccc.id_category AND ps.id_product = 272836)
WHERE pccl.`id_lang` = 1
AND (
pccp.id_product IS NOT NULL
OR ps.id_product IS NOT NULL
OR pcc.id_product_comment_criterion_type = 1
)
AND pcc.active = 1
GROUP BY pcc.id_product_comment_criterion
0.3 1 Yes /modules/productcomments/ProductCommentCriterion.php:176
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` = 763699) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 862485) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 272836
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.3 0 /classes/Product.php:1286
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayBeforeLogo'
AND `id_shop` = 1 LIMIT 1
0.3 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayTop'
AND `id_shop` = 1 LIMIT 1
0.3 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 272836
ORDER BY `position`
0.3 1 Yes /classes/Product.php:2735
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='383a3dc2a2a99268e32812bcda082ec4' AND cache_id="module|1|166|product" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayBottomColumn'
AND `id_shop` = 1 LIMIT 1
0.3 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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` = 272836) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 87 /classes/Hook.php:187
SELECT SQL_NO_CACHE cs.`id_category_sizechart` as id_sizechart,
cscl.`image`,
csc.`position`,
csc.`id_category`,
csc.`active`
FROM ps_categorysizechart_shop cs
LEFT JOIN ps_category_sizechart csc ON (cs.id_category_sizechart = csc.id_category_sizechart)
LEFT JOIN ps_category_sizechart_lang cscl ON (csc.id_category_sizechart = cscl.id_category_sizechart)
WHERE (id_shop = 1) AND csc.`id_category` = 207
AND cscl.id_lang = 1 AND csc.`active` = 1
ORDER BY csc.position
0.3 1 Yes /modules/oviccategorysizechart/oviccategorysizechart.php:610
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 138
0.3 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.3 20 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE * FROM `ps_seosaproductlabels` WHERE 1
0.2 8 /modules/seosaproductlabels/classes/ProductLabel.php:179
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2021-03-09 00:00:00' AND '2021-03-09 23:59:59' LIMIT 1
0.2 1 /classes/SpecificPrice.php:302
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayBottomColumn'
AND `id_shop` = 1 LIMIT 1
0.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.2 194 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 135
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 134
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 136
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 137
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 2
0.2 20 /classes/Employee.php:452
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` = 460839)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 272836
ORDER BY `position`
0.2 1 Yes /classes/Product.php:2735
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` = 366165) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 1
0.2 6 /classes/Employee.php:452
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 272836
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.2 0 /classes/Product.php:1286
SELECT SQL_NO_CACHE e.`id_included_product`, pl.`name`
FROM `ps_seosaproductlabels_included` e
JOIN `ps_product` p ON e.`id_included_product` = p.`id_product`
JOIN `ps_product_lang` pl ON pl.`id_product` = p.`id_product`
WHERE e.`id_product_label` = 25 AND pl.`id_lang` = 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabel.php:232
SELECT SQL_NO_CACHE l.*, sm.id_manufacturer, sl.text
FROM ps_seosaproductlabels_manufacturer sm
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = sm.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.2 2 /modules/seosaproductlabels/classes/ProductLabelLocation.php:138
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` = 4966)
0.2 1 /classes/Product.php:3012
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` = 272836) LIMIT 1
0.2 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` = 290880) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 94700)
0.2 1 /classes/Product.php:3012
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 = 272836)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.2 8 /modules/seosaproductlabels/classes/ProductLabelLocation.php:104
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 1
AND pl.id_product = 272836
AND product_shop.active = 1 LIMIT 1
0.2 1 /override/classes/Meta.php:47
SELECT SQL_NO_CACHE spr.id_specific_price_rule, sp.id_product
FROM
ps_specific_price_rule AS spr
LEFT JOIN
ps_specific_price AS sp ON (spr.id_specific_price_rule = sp.id_specific_price_rule)
WHERE
sp.id_product = 272836
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:218
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` = 113090)
0.2 1 /classes/Product.php:3012
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` = 7070)
0.2 1 /classes/Product.php:3012
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` = 370867)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE sl.`text`, s.`id_product_label`, s.`text_css`, sl.`hint`,
sl.`url`, s.`label_type`, s.`product_status`, s.`position`, s.`name`, s.`groups`, s.`product_condition`,
s.`date_from`, s.`date_to`, s.`select_for`, s.`mini_price`,s.`max_price`, s.`quantity`, s.`quantity_max`
FROM ps_seosaproductlabels_lang sl
LEFT JOIN `ps_seosaproductlabels` AS s ON sl.id_product_label = s.id_product_label
WHERE sl.id_lang="1" AND s.`active` = 1
0.2 8 /modules/seosaproductlabels/classes/ProductLabelLocation.php:241
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` = 75973)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 272836
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.2 0 /classes/Product.php:1286
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`)
WHERE `id_block` = 21 AND
id_lang = 1 AND active = 1
ORDER BY  ti.`position` ASC
0.2 34 Yes /modules/advancetopmenu/advancetopmenu.php:1064
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` = 1775)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 1775
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 272836 LIMIT 1
0.2 1 /classes/Product.php:760
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` = 104440)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE book_type FROM ps_jsoxLitresItems WHERE id_product = 272836 LIMIT 1
0.2 1 /modules/jsoxLitresWorker/jsoxLitresWorker.php:201
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` = 12584)
0.2 1 /classes/Product.php:3012
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`=272836
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 2
0.2 20 /classes/Employee.php:452
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.2 1 /classes/Country.php:173
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "expresscache" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE l.*, cr.id_catalog_rule, sl.text, sl.hint, sl.url
FROM ps_seosaproductlabels_catalog_rules cr
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = cr.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:207
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` = 123331)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 47339098
AND `date_add` > '2021-03-09 11:18:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.2 1 /classes/Connection.php:138
SELECT SQL_NO_CACHE pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion`
FROM `ps_product_comment` pc
LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`)
LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
WHERE pc.`id_product` = 272836
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.2 1 /modules/productcomments/ProductComment.php:168
SELECT SQL_NO_CACHE @curRow := @curRow + 1 AS level,
id, from_summ, to_summ, discount
FROM
ps_level_customers_discount
JOIN (SELECT @curRow := 0) r
ORDER BY id ASC;
0.2 0 /modules/accumulative_discount/accumulative_discount.php:366
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 201) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion`
FROM `ps_product_comment` pc
LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`)
LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
WHERE pc.`id_product` = 272836
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.2 1 /modules/productcomments/ProductComment.php:168
SELECT SQL_NO_CACHE *
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 272836
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
0.2 1 Yes /modules/productcomments/ProductComment.php:136
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 123331
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 370867 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5047
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 216) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 4986
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE l.*, cr.id_cart_rule, sl.text, sl.hint, sl.url
FROM ps_seosaproductlabels_cart_rules cr
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = cr.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:176
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 1
0.2 6 /classes/Employee.php:452
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 272836
0.2 2 /classes/Product.php:2629
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4966 LIMIT 1
0.2 1 /classes/Product.php:760
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`=272836
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='f70798523bddbf8e5346cabd3db9ba05' AND cache_id="ovicstoremap|1|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 31) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 370867
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 7070
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 4966
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "product" LIMIT 1
0.2 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 113090
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.2 164 /classes/Tab.php:296
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 216) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 104440
0.2 1 /classes/Product.php:4485
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` = 506394)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 651286
0.2 1 /classes/Product.php:4485
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`=272836
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 94700
0.2 1 /classes/Product.php:4485
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
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE l.*, ss.id_supplier, sl.text
FROM ps_seosaproductlabels_supplier ss
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ss.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:155
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 12584
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 75973
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 272836
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 1
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE crprv.id_item AS id_product, crprg.id_cart_rule FROM `ps_cart_rule_product_rule_value` crprv
LEFT JOIN `ps_cart_rule_product_rule` crpr ON crprv.id_product_rule = crpr.id_product_rule
LEFT JOIN `ps_cart_rule_product_rule_group` crprg ON crprg.id_product_rule_group = crpr.id_product_rule_group
LEFT JOIN `ps_cart_rule` cr ON cr.id_cart_rule = crprg.id_cart_rule
WHERE crprv.id_item = 272836
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:184
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 216
0.2 3 /Adapter/Adapter_EntityMapper.php:68
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` = 207 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE l.*
FROM ps_seosaproductlabels_category sc
LEFT JOIN `ps_seosaproductlabels` AS l
ON l.id_product_label = sc.id_product_label
WHERE IF(l.`include_category_product`,
sc.`id_category` IN(201,207),
sc.`id_category` = 207) AND l.active = 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:121
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` = 687566)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 94700 LIMIT 1
0.2 1 /classes/Product.php:760
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` = 651286)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 272836
AND image_shop.`cover` = 1 LIMIT 1
0.2 1 /classes/Product.php:2757
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'left' AND active = 1
ORDER BY item_order ASC
0.2 26 Yes /modules/themeconfigurator/themeconfigurator.php:375
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 366165
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 3
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 272836 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 272836
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.2 0 /classes/Product.php:1286
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.2 11 /classes/ImageType.php:143
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 1775 LIMIT 1
0.2 1 /classes/Product.php:760
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.2 1 /classes/shop/Shop.php:202
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 (272836)
0.2 1 /modules/crossselling/crossselling.php:133
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='fe840aa409c2c4fab283ef3d5183e176' AND cache_id="2|1|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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` = 862485)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 123331 LIMIT 1
0.2 1 /classes/Product.php:760
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` = 754973)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 12584 LIMIT 1
0.2 1 /classes/Product.php:760
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'ru' LIMIT 1
0.2 1 /classes/Language.php:680
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 109
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 104440 LIMIT 1
0.2 1 /classes/Product.php:760
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`=272836
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE id_hook, conf FROM `ps_sesliders_slideconf`
WHERE `id_shop` = 1
0.2 2 /modules/homesliderpro/homesliderpro.php:402
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 (272836)
0.2 1 /modules/crossselling/crossselling.php:133
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 7070 LIMIT 1
0.2 1 /classes/Product.php:760
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayNav'
AND `id_shop` = 1 LIMIT 1
0.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.2 1 /classes/Language.php:777
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 207) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 75973 LIMIT 1
0.2 1 /classes/Product.php:760
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 113090 LIMIT 1
0.2 1 /classes/Product.php:760
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='0723ba904f3d8ae211f1237b2cfc71af' AND cache_id="blockbestsellers-colvirtual111|1|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 506394
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options` a
LEFT JOIN `ps_ovic_options_lang` `b` ON a.`id_option` = b.`id_option` AND b.`id_lang` = 1
WHERE (a.`id_option` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.2 4 /classes/Currency.php:470
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 272836
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE * FROM ps_product_videos WHERE id_product = 272836 AND id_shop = 1 ORDER BY position ASC
0.2 1 Yes /modules/productvideo/productvideo.php:1153
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 460839 LIMIT 1
0.2 1 /classes/Product.php:760
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` = 763699)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="272836"
0.2 1 /modules/jsoxActuals/jsoxActuals.php:987
UPDATE `ps_smarty_lazy_cache`
SET filepath='crossselling/productfooter/272836/1/1/1/1/216/ea/7b/ae/ea7baef235d5836c8731c50d0dcb907cbfa11252.crossselling.tpl.php'
WHERE `template_hash`='24b95e1565cc57795e88d1bb46347dd1' AND cache_id="crossselling|productfooter|272836|1|1|1|1|216" AND compile_id=""
0.2 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 272836
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="272836"
0.2 1 /modules/report_product_availability/report_product_availability.php:87
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 234 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='fe840aa409c2c4fab283ef3d5183e176' AND cache_id="6|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4986 LIMIT 1
0.1 1 /classes/Product.php:760
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea94faa84c5b896540f5a4d720839b91' AND cache_id="ovicblockcms|3|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeBottomColumn'
AND `id_shop` = 1 LIMIT 1
0.1 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "product" LIMIT 1
0.1 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 272836 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 272836 AND `id_shop` = 1
0.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 862485
0.1 1 /classes/Product.php:4485
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` = 366165)
0.1 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 272836 AND `validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4c54ecfbb4c624d1a48e94bd4fa62aa1' AND cache_id="productscategory|207|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 460839
0.1 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 272836) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:690
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 272836) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:666
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 272836
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.1 0 /classes/Product.php:1286
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 272836 LIMIT 1
0.1 1 /classes/Page.php:77
SELECT SQL_NO_CACHE COUNT(`id_option`) FROM `ps_ovic_options` WHERE `id_option` = 1 LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:355
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 4966
0.1 24 /classes/Product.php:2629
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
0.1 1 /classes/ObjectModel.php:487
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 27) AND (b.`id_shop` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 272836
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
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` = 290880)
0.1 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9e60fe123a5951d4fef6eae8b173fc1f' AND cache_id="socialsharing|272836|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 113090) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 763699
0.1 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayTopColumn'
AND `id_shop` = 1 LIMIT 1
0.1 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 272836 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4966) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 272836 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="272836"
0.1 1 /modules/report_product_availability/report_product_availability.php:107
SELECT SQL_NO_CACHE `index_image_css` `index`, `product_image_css` `product`, `category_image_css` `category`
FROM `ps_seosaproductlabels` WHERE `id_product_label` = 25 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabel.php:213
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 687566
0.1 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 272836) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:690
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 4986
0.1 11 /classes/Product.php:2629
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.1 1 /classes/Country.php:173
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 7070) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "order"
OR m.page = "order"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.1 1 /classes/Meta.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 123331) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9e60fe123a5951d4fef6eae8b173fc1f' AND cache_id="socialsharing|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 4
0.1 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 3
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 104440) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1