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

Йога для творческой души. Возвращаем свободу самовыражения (183368)

Автор: Байрон Э.

Издательство: ИГ Весь

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

10 Товары

Наличие: На складе

Посмотреть все характеристики ↓
Комплексная йога-терапия, которой посвящена книга психотерапевта Эрин Байрон, нацелена на то, чтобы определить сферы раз-балансировки в вашей жизни и помочь пра... далее->

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

486 грн.

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

- +

Аннотация

Комплексная йога-терапия, которой посвящена книга психотерапевта Эрин Байрон, нацелена на то, чтобы определить сферы раз-балансировки в вашей жизни и помочь практиковать своего рода саморефлексию для обеспечения настоящих, устойчивых изменений. Основанная на принципах классической йоги, комплексная йога-терапия обладает множеством методов для того, чтобы помочь вам вернуть утраченное равновесие. Ее составляющие — йогические позы, дыхательные практики, расслабление и философия. Когда мы управляем умом и чувствами, интеллектом и творческими ресурсами, мы обретаем подлинную силу. Практики в этой книге нацелены на восстановление контакта с вашей творческой сутью. Вы научитесь работать с эмоциями и мыслями, в разы повысите свою креативность, будете легко находить идеи и вдохновение для начала нового проекта и силы для его завершения, улучшите отношения с близкими и просто будете получать больше удовольствия от жизни — день за днем.

ФИО Автора Байрон Э.
Издательство ИГ Весь
Язык Русский
Переплет Твердый
Бумага Офсетная
Кол-во страниц 288
Формат печатный 60х90/16
Кому подарить Мужчине, Женщине, Девушке, Жене, Домохозяйке
Возраст 16+
Написать отзыв
Йога для творческой души. Возвращаем свободу самовыражения

Йога для творческой души. Возвращаем свободу самовыражения

Мой отзыв
Рекомендуемые товары:
Товары из этой категории:
  • Тревожный мозг. Как успокоить мысли, исцелить разум и вернуть контроль над собственной жизнью
    450 грн. 450 грн.
    Тревожный мозг. Как успокоить мысли, исцелить разум и

    Вы всю жизнь считали себя лентяем,

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

    Цена: 450 грн.
    (4)
    Код предмета:105695 На складе издательства
  • Людина. Навчальний посібник з анатомії та фізіології
    456 грн. 456 грн.
    Людина. Навчальний посібник з анатомії та фізіології

    Перше видання всесвітньо відомої

    Перше видання всесвітньо відомої книги “The Human Body” (A Dorling Kindersley Book) в українському перекладі. Розглянуті всі головні системи організму людини – ...

    Цена: 456 грн.
    (3)
    Код предмета:103924 Ожидается
  • Viva la vagina. Хватит замалчивать скрытые возможности органа, который не принято называть
    276 грн. 276 грн.
    Viva la vagina. Хватит замалчивать скрытые

    "Авторы этой книги Нина Брокманн и

    "Авторы этой книги Нина Брокманн и Эллен Стёкен Даль, по их собственному признанию, не волшебницы - они только учатся. И это, наверное, к лучшему. Во-первых, им …

    Цена: 276 грн.
    (4)
    Fast
    Код предмета:106140 В наличии
  • Вальс гормонов. Вес, сон, секс, красота и здоровье как по нотам
    110 грн. 110 грн.
    Вальс Гормонів, маса тіла, сон, секс, краса і

    Наталья Зубарева - врач,

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

    Цена: 110 грн.
    (4)
    Код предмета:106160 На складе
  • Анатомия йоги
    584 грн. 584 грн.
    Анатомия йоги

    Практическое пособие по йоге,

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

    Цена: 584 грн.
    (3)
    Fast
    Код предмета:106183 В наличии
  • Аденоиды без операции
    356 грн. 356 грн.
    Аденоиды без операции

    Вы только что узнали, что вашего

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

    Цена: 356 грн.
    (4)
    Код предмета:106491 На складе издательства
  • Анатомия виньяса-флоу и асан, выполняемых стоя
    710 грн. 710 грн.
    Анатомия виньяса-флоу и асан, выполняемых стоя

    С помощью полноцветных трехмерных

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

    Цена: 710 грн.
    (3)
    Код предмета:106578 На складе
  • Анатомия и биохимия человека за 60 секунд
    545 грн. 545 грн.
    Анатомия и биохимия человека за 60 секунд

    Человеческое тело — не меньшая

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

    Цена: 545 грн.
    (3)
    Код предмета:106580 На складе издательства
  • Анатомия и физиология. Большой популярный атлас
    845 грн. 845 грн.
    Анатомия и физиология. Большой популярный атлас

    Сегодня существует огромный выбор

    Сегодня существует огромный выбор атласов по анатомии и физиологии. Научные книги изобилуют терминами, мелкими непонятными рисунками, бесконечными подписями. По...

    Цена: 845 грн.
    (3)
    Код предмета:106581 На складе издательства
  • Анатомия упражнений для спины (2-е изд.)
    776 грн. 776 грн.
    Анатомия упражнений для спины (2-е изд.)

    Боли в спине больше не проблема -

    Боли в спине больше не проблема - благодаря более чем сотне лучших упражнений для спины и шее вы навсегда сможете избавиться от неприятных ощущений. Простые объ...

    Цена: 776 грн.
    (3)
    Код предмета:106588 На складе издательства
  • Анатомия человека: компактный атлас-раскраска
    390 грн. 390 грн.
    Анатомия человека: компактный атлас-раскраска

    Компактный атлас-раскраска - для

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

    Цена: 390 грн.
    (4)
    Код предмета:106592 На складе издательства
  • Анатомия человека: большой популярный атлас
    573 грн. 573 грн.
    Анатомия человека: большой популярный атлас

    Выбирая домашний анатомический

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

    Цена: 573 грн.
    (3)
    Код предмета:106593 На складе издательства
  • Анатомия человека: 2 издание
    537 грн. 537 грн.
    Анатомия человека: 2 издание

    Атлас "Анатомии человека: 2-е

    Атлас "Анатомии человека: 2-е издание" компактен и удобен для использования студентами всех медицинских специальностей. Он будет служить надежным и простым спра...

    Цена: 537 грн.
    (3)
    Код предмета:106594 На складе издательства
  • Биодобавки: природная альтернатива лекарствам
    399 грн. 399 грн.
    Биодобавки: природная альтернатива лекарствам

    Научно обоснованные рекомендации

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

    Цена: 399 грн.
    (3)
    Код предмета:106777 На складе
  • Болезни позвоночника и суставов. Информационно-энергетическое Учение. Начальный курс
    475 грн. 475 грн.
    Болезни позвоночника и суставов.

    Эта книга посвящена одной из главных

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

    Цена: 475 грн.
    (3)
    Код предмета:106834 На складе издательства
  • Боли в плече, или Как вернуть подвижность рукам. Методика Бубновского: краткий путеводитель
    349 грн. 349 грн.
    Боли в плече, или Как вернуть подвижность рукам.

    В этой книге доктора медицинских

    В этой книге доктора медицинских наук, профессора С.М.Бубновского подробно рассказывается об особенностях современной кинезитерапии и о ее практическом применен...

    Цена: 349 грн.
    (3)
    Код предмета:106835 На складе
  • Большая иллюстрированная энциклопедия лекарственных растений
    679 грн. 679 грн.
    Большая иллюстрированная энциклопедия лекарственных

    Целебные растения — бесценная

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

    Цена: 679 грн.
    (3)
    Код предмета:106845 На складе издательства
  • Большая книга здоровья и радости (Подарочное издание)
    693 грн. 693 грн.
    Большая книга здоровья и радости (Подарочное издание)

    Как прожить долгую, здоровую и

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

    Цена: 693 грн.
    (5)
    Код предмета:106864 На складе издательства
  • Ваш семейный ЛОР. Случаи из практики врача
    202 грн. 202 грн.
    Ваш семейный ЛОР. Случаи из практики врача

    В этой книге известный московский

    В этой книге известный московский врач-оториноларинголог, кандидат медицинских наук Дмитрий Семенович Горин рассказывает о заболеваниях ЛОР-органов - уха, горла...

    Цена: 202 грн.
    Код предмета:106999 На складе издательства
  • В гармонии с гормонами. Как научиться понимать сигналы своего организма и вовремя на них реагировать
    442 грн. 442 грн.
    В гармонии с гормонами. Как научиться понимать

    Автор этой книги - Алиса Витти,

    Автор этой книги - Алиса Витти, врач, консультант по вопросам здоровья, – страдала от синдрома поликистоза яичников. Сегодня этот диагноз ставят каждой девятой ...

    Цена: 442 грн.
    (4)
    Код предмета:107013 На складе издательства
  • Верни себя к жизни! Как избавиться от хронической боли за 15 минут в день
    295 грн. 295 грн.
    Верни себя к жизни! Как избавиться от хронической

    Миранда Эсмонд-Уайт создала

    Миранда Эсмонд-Уайт создала уникальную систему избавления от хронических видов боли, которую официально использует сборная Канады по хоккею! Боли в коленях, зап...

    Цена: 295 грн.
    Код предмета:107064 На складе издательства
  • Взгляд внутрь болезни. Все секреты хронических и таинственных заболеваний и эффективные способы их полного исцеления
    267 грн. 267 грн.
    Взгляд внутрь болезни. Все секреты хронических и

    Медиум Энтони Уильям обладает

    Медиум Энтони Уильям обладает уникальной способностью, данной ему от рождения, - он контактирует с таинственным Духом, который рассказывает ему о состоянии здор...

    Цена: 267 грн.
    (4)
    Fast
    Код предмета:107091 В наличии
  • Вода - натуральное лекарство от ожирения, рака, депрессии
    242 грн. 242 грн.
    Вода - натуральное лекарство от ожирения, рака,

    В своей книге знаменитый врач, автор

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

    Цена: 242 грн.
    (3)
    Код предмета:107169 На складе издательства
  • Вода - натуральное лекарство от ожирения, рака, депрессии (мягкая обложка)
    200 грн. 200 грн.
    Вода - натуральное лекарство от ожирения, рака,

    «Мудрость Воды», по мнению автора,

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

    Цена: 200 грн.
    (3)
    Код предмета:107170 На складе издательства
  • Всё о женских гормонах
    306 грн. 306 грн.
    Всё о женских гормонах

    Данная книга станет отличным

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

    Цена: 306 грн.
    Код предмета:107338 На складе
  • Второй мозг. Как микробы в кишечнике управляют нашим настроением, решениями и здоровьем
    333 грн. 333 грн.
    Второй мозг. Как микробы в кишечнике управляют нашим

    Могут ли микробы влиять на наши

    Могут ли микробы влиять на наши эмоции и поступки? Оказывается, они способны не только на это, но и на многое другое! Доктор медицинских наук Эмеран Майер предс...

    Цена: 333 грн.
    (3)
    Код предмета:107377 На складе
  • Гипертония. Современная энциклопедия
    435 грн. 435 грн.
    Гипертония. Современная энциклопедия

    Вы оздоровитесь, будете подвижны,

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

    Цена: 435 грн.
    (3)
    Fast
    Код предмета:107473 В наличии
  • Держите спину прямо. Как забота о позвоночнике может изменить вашу жизнь
    468 грн. 468 грн.
    Держите спину прямо. Как забота о позвоночнике может

    Мосараф Али - настоящий знаток

    Мосараф Али - настоящий знаток человеческого тела, всемирно известный пионер интеграционной медицины, получивший всестороннее медицинское образование в Индии, Р...

    Цена: 468 грн.
    Код предмета:107660 На складе издательства
  • Дочки-матери. Все, о чем вам не рассказывала ваша мама и чему стоит научить свою дочь
    562 грн. 562 грн.
    Дочки-матери. Все, о чем вам не рассказывала ваша

    Все ли вы знаете о собственном

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

    Цена: 562 грн.
    (3)
    Код предмета:107844 На складе издательства
  • Европейское исследование: бады, витамины, ГМО, биопродукты. Как сделать правильный шаг к здоровому долголетию
    468 грн. 468 грн.
    Европейское исследование: бады, витамины, ГМО,

    Эта книга – собрание наиболее полной

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

    Цена: 468 грн.
    Код предмета:107897 На складе издательства
Вперед Назад
Перечень
Load Time1876 ms - You'd better run your shop on a toaster
Querying Time1607 ms
Queries470
Memory Peak Usage36.7 Mb
Included Files684 files - 11.72 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 45 ms 45 ms 3.52 Mb 3.52 Mb
__construct 0 ms 45 ms - Mb 3.52 Mb
init 486 ms 531 ms 1.72 Mb 5.93 Mb
checkAccess 0 ms 531 ms - Mb 5.93 Mb
setMedia 1 ms 533 ms 0.01 Mb 5.93 Mb
postProcess 0 ms 533 ms - Mb 5.93 Mb
initHeader 0 ms 533 ms - Mb 5.93 Mb
initContent 1281 ms 1814 ms 11.62 Mb 36.67 Mb
initFooter 10 ms 1824 ms 0.30 Mb 36.67 Mb
display 52 ms 1876 ms 1.81 Mb 36.67 Mb
Hook Time Memory Usage
hookdisplayRightColumnProduct 678 ms - Mb
hookdisplayHeader 449 ms 4.00 Mb
__construct 60 ms 4.00 Mb
hookdisplayTop 15 ms - Mb
hookdisplayTopColumn 12 ms - Mb
hookproductfooter 10 ms 2.00 Mb
hookdisplayFooter 10 ms 2.00 Mb
hookHeader 9 ms - Mb
hookdisplayNav 6 ms - Mb
hookdisplayLeftColumn 5 ms - Mb
hookproducttabcontent 4 ms - Mb
hookdisplayProductButtons 3 ms - Mb
hookdisplayHomeBottomColumn 2 ms - Mb
hookdisplayProductTab 2 ms - Mb
hookdisplayProductTabContent 2 ms - Mb
hookdisplayCategorySlider 2 ms - Mb
hookdisplayOvicCategorySizeChart 2 ms - Mb
hookproducttab 1 ms - Mb
hookdisplaySocialSharing 1 ms - Mb
hookdisplayHomeTopColumn 1 ms - Mb
hookdisplayContactInfo 1 ms - Mb
hookdisplayVerticalMenu 1 ms - Mb
hookdisplayBottomColumn 1 ms - Mb
hookdisplayHomeBottomContent 0 ms - Mb
hookproductactions 0 ms - Mb
hookdisplayHomeTopContent 0 ms - Mb
hookCustomVideoHook 0 ms - Mb
hookdisplayStoreMap 0 ms - Mb
hookdisplayBeforeLogo 0 ms - Mb
hookdisplayProductStockLabel 0 ms - Mb
hookdisplayAfterBody 0 ms - Mb
hooksetProductStockValue 0 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookactionObjectAddAfter 0 ms - Mb
hookdisplayDigitalBookIcon 0 ms - Mb
hookPackWebseregascart - ms - Mb
hookDisplayOverrideTemplate - ms - Mb
hookdisplayFooterProduct - ms - Mb
hookdisplayProductDeliveryTime - ms - Mb
hookdisplayProductPriceBlock - ms - Mb
hookactionProductOutOfStock - ms - Mb
hookPackWebseregas - ms - Mb
hookdisplayLeftColumnProduct - ms - Mb
43 hooks 1278 ms 12.00 Mb
Module Time Memory Usage
seosaproductlabels 676 ms - Mb
socialsharing 387 ms - Mb
oviclayoutcontrol 58 ms 2.00 Mb
pm_advancedpack 47 ms 4.00 Mb
bookworks 9 ms - Mb
productcomments 8 ms - Mb
advanceblog 6 ms - Mb
crossselling 6 ms - Mb
categoryslider 4 ms - Mb
report_product_availability 4 ms - Mb
oviccategorysizechart 4 ms - Mb
productscategory 4 ms 2.00 Mb
productvideo 4 ms - Mb
ovicstoremap 4 ms - Mb
blocknewsletter 3 ms - Mb
homesliderpro 3 ms - Mb
verticalmegamenus 3 ms - Mb
newsletterpro 2 ms - Mb
bg_prestasms 2 ms - Mb
gsnippetsreviews 2 ms - Mb
pm_advancedsearch4 2 ms - Mb
blockbestsellers 2 ms - Mb
accumulative_discount 2 ms - Mb
dealershippage 1 ms - Mb
anchorfeatures 1 ms - Mb
order_synchronization 1 ms - Mb
ecm_shipping_up 1 ms - Mb
lgtagmanager 1 ms - Mb
jsox_newgallery 1 ms - Mb
blockwishlist 1 ms - Mb
parsing_products 1 ms - Mb
ultimateimagetool 1 ms - Mb
tinymcepro 1 ms - Mb
sendreviewrequest 1 ms - Mb
jsoxActuals 1 ms - Mb
multistyle 1 ms - Mb
ecm_feedback 1 ms - Mb
ecm_novaposhta 1 ms - Mb
g_ordermanager 1 ms 2.00 Mb
statsdata 1 ms - Mb
npcashdeliverystatistics 1 ms - Mb
jsoxLitresWorker 1 ms - Mb
blocklanguages 1 ms - Mb
bookproductlog 1 ms - Mb
jsox_adminorderchat 0 ms - Mb
bookworks_filters 0 ms - Mb
google_recaptcha 0 ms - Mb
trackorderstatus 0 ms - Mb
ovicnewsletter 0 ms - Mb
ganalytics 0 ms - Mb
blocklayered 0 ms - Mb
relinkingblocks 0 ms - Mb
mailalerts 0 ms - Mb
recalculate_products_price 0 ms - Mb
jsox_ordersplitter 0 ms - Mb
importproduct 0 ms - Mb
blocktags 0 ms - Mb
jsoxFids 0 ms - Mb
automaticpacketgeneration 0 ms - Mb
additionalorders 0 ms - Mb
autoliqpay 0 ms - Mb
gremarketing 0 ms - Mb
sekeywords 0 ms - Mb
blockcart 0 ms - Mb
jsoxLitresSeller 0 ms - Mb
ba_ajax_search 0 ms - Mb
reviewsadv 0 ms - Mb
ovicblockcms 0 ms - Mb
jsox_ordercomplectcorrector 0 ms - Mb
advancetopmenu 0 ms - Mb
homefeatured 0 ms - Mb
jsox_newpost_pay_corrector 0 ms - Mb
advancedfeaturesvalues 0 ms - Mb
bookatel 0 ms - Mb
blockstore 0 ms - Mb
blockbanner 0 ms - Mb
homeslider 0 ms - Mb
customsuppliers 0 ms - Mb
categorysearch 0 ms - Mb
discountproducts 0 ms - Mb
wholesale_products_price 0 ms - Mb
blockuserinfo 0 ms - Mb
oviccustomtags 0 ms - Mb
jsoxEANUpdateAndNPAddress 0 ms - Mb
themeconfigurator 0 ms - Mb
advancefooter 0 ms - Mb
blockreinsurance 0 ms 2.00 Mb
pagesnotfound 0 ms - Mb
blocksupplier 0 ms - Mb
blockcontactinfos 0 ms - Mb
brandsslider 0 ms - Mb
productpaymentlogos 0 ms - Mb
blockspecials 0 ms - Mb
blocknewproducts 0 ms - Mb
jsox_waitstate 0 ms - Mb
competitorpricechange 0 ms - Mb
blockmanufacturer 0 ms - Mb
blockcontact 0 ms - Mb
jsox_adminproductnamecopybutton 0 ms - Mb
sendsmsbystatus 0 ms - Mb
jsoxNeironet 0 ms - Mb
blockhtml 0 ms - Mb
promomod 0 ms - Mb
oviccustombanner 0 ms - Mb
blocksocial 0 ms - Mb
blockmyaccount 0 ms - Mb
jsoxCache 0 ms - Mb
107 modules 1278 ms 12.00 Mb

Stopwatch SQL - 470 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
616.1 123218 Yes /override/classes/ProductSale.php:131
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
457.4 394638 /classes/SpecificPrice.php:230
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='a42c52ba8ab3087125211a13758108f4' AND cache_id LIKE "socialsharing_header|85581|1|1|1|1|216%"
380.5 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE app.`id_pack`
FROM `ps_pm_advancedpack` app
19.8 54237 /modules/pm_advancedpack/AdvancedPack.php:717
SELECT SQL_NO_CACHE * FROM ps_ecm_seoredirect WHERE url_old = "/ru/medicina/85581-joga-dlya-tvorcheskoj-dushi-vozvrashhaem-svobodu-samovyrazheniya.html" AND id_shop = "1" ORDER BY id DESC LIMIT 1
9 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`)
7.3 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 254 Yes Yes /classes/Hook.php:355
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
3.2 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 cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1.8 245 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.5 159 /classes/module/Module.php:277
SHOW TABLES LIKE 'ps_order_synchronization_stores';
1.1 1 /modules/bookworks/bookworks.php:285
show tables like "ps_sesliders_slideconf"
1.1 1 /modules/homesliderpro/homesliderpro.php:1218
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` = 85581 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 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 = 12584
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 21 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_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` = 85581 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 = 104440
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 18 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 = 7070
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 = 1775
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 16 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 = 4966
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 19 Yes /override/classes/Product.php:664
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.9 1 /classes/ObjectModel.php:487
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.9 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.9 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
0.9 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 = 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 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.9 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 = 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 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.9 159 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.9 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, 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.9 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, 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.9 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.9 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.9 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, 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
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, 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 *, ( 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 `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 = 85581
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 17 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, 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.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, 85581) 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 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` = 85581 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.8 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 = 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 `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 `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
0.7 6 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` = 85581 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 m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.7 58 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE 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` = 85581
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 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 <= 291
AND c.nright >= 294
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 147 Yes /classes/Tools.php:1349
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` = 85581
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, 85581) 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 * FROM `ps_state` ORDER BY `name` ASC
0.6 338 Yes /classes/Country.php:137
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 <= 291
AND c.nright >= 294
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 147 Yes /classes/Tools.php:1349
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` = 66
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE * 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.6 15 Yes /modules/advancetopmenu/advancetopmenu.php:1086
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 = 85581
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.6 0 /classes/Product.php:1286
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` = 66
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 *,
( 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, 85581) 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 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` = 85581
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.5 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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` = 85581
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.5 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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 ('630e02f8362891eb606d689047eedb5f', 'https://www.bookovka.ua/ru/medicina/85581-joga-dlya-tvorcheskoj-dushi-vozvrashhaem-svobodu-samovyrazheniya.html', 1,
1, 216, 1,'630e02f8362891eb606d689047eedb5f1121610', 39871,
0, 1, 0, 1615286142, 'product', 85581, 0,'2021-03-09 10:35:42','')
ON DUPLICATE KEY UPDATE miss = miss + 1,
last_updated ='2021-03-09 10:35:42',
cache = '630e02f8362891eb606d689047eedb5f1121610', cache_size = 39871,
miss_time = ((miss_time*miss) + 1615286142.618) / (miss + 1)
0.5 1 /override/classes/controller/FrontController.php:381
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` = 66
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_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.4 34 Yes /classes/order/OrderState.php:127
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.4 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE *
FROM `ps_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 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` = 85581
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 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` = 85581
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` = 'displayTopColumn'
AND `id_shop` = 1 LIMIT 1
0.4 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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 *
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 *
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.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4966) AND (b.`id_shop` = 1) LIMIT 1
0.4 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 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` = 85581
AND l.`active` = 1
0.3 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` = 75973) 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` = 113090) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.3 194 /classes/module/Module.php:2141
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 *
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` = 85581) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.3 20 Yes /classes/Currency.php:231
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 85581) 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 id_required_field, object_name, field_name
FROM ps_required_field
0.3 1 /classes/ObjectModel.php:1376
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` = 85581
ORDER BY `position`
0.3 11 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` = 94700) 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` = 75973)
0.3 1 /classes/Product.php:3012
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.3 7 /modules/advancetopmenu/advancetopmenu.php:1047
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.3 1 /classes/Product.php:3012
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` = 85581
0.3 1 /classes/Product.php:5707
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value)
WHERE `id_product` = 85581
0.3 17 /classes/Product.php:3696
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` = 85581
0.3 1 /classes/Product.php:5707
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` = 85581 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
0.3 1 Yes /modules/productcomments/ProductComment.php:114
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` = 85581
ORDER BY `position`
0.3 11 Yes /classes/Product.php:2735
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.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 85581
ORDER BY i.`position`
0.3 11 Yes /classes/Product.php:5410
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_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_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 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` = 85581)
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 = 85581)
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 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_employee`
WHERE `id_profile` = 1
0.3 6 /classes/Employee.php:452
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 = 85581
AND product_shop.active = 1 LIMIT 1
0.2 1 /override/classes/Meta.php:47
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.2 1 /classes/Image.php:471
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` = 85581) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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` = 66
AND cscl.id_lang = 1 AND csc.`active` = 1
ORDER BY csc.position
0.2 1 Yes /modules/oviccategorysizechart/oviccategorysizechart.php:610
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.2 1 /Adapter/Adapter_EntityMapper.php:61
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 `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 47342985
AND `date_add` > '2021-03-09 12:05:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.2 1 /classes/Connection.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` = 12584)
0.2 1 /classes/Product.php:3012
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` = 85581
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.2 1 /modules/productcomments/ProductComment.php:168
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_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.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` = 4986)
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` = 85581)
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` = 94700)
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 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`=85581)
0.2 1 /modules/pm_advancedpack/AdvancedPack.php:740
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_tab, class_name FROM `ps_tab`
0.2 164 /classes/Tab.php:296
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 = 85581
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 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_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.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 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_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 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` = 85581
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.2 1 /modules/productcomments/ProductComment.php:168
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 *
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` = 66) 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` = 104440)
0.2 1 /classes/Product.php:3012
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 *
FROM `ps_employee`
WHERE `id_profile` = 2
0.2 20 /classes/Employee.php:452
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_employee`
WHERE `id_profile` = 2
0.2 20 /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 = 85581
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 COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=169 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
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 (85581)
0.2 1 /modules/crossselling/crossselling.php:133
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.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 = 94700
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.2 87 /classes/Hook.php:187
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 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 *
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` = 156) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE l.*, sm.id_manufacturer, sl.text
FROM ps_seosaproductlabels_manufacturer sm
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = sm.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.2 2 /modules/seosaproductlabels/classes/ProductLabelLocation.php:138
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 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 = 85581
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 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 = 85581)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.2 8 /modules/seosaproductlabels/classes/ProductLabelLocation.php:104
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 *
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` = 18) 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 = 104440
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE biagramm
FROM
ps_biagramms_product_description
WHERE
id_product = '85581' AND
id_lang = 1 LIMIT 1
0.2 2 /override/classes/Meta.php:98
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` = 137
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
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 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 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`=85581
0.2 1 /classes/Tag.php:205
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` = 85581
AND image_shop.`cover` = 1 LIMIT 1
0.2 11 /classes/Product.php:2757
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 85581 AND ctg.`id_group` = 1 LIMIT 1
0.2 4 /classes/Product.php:4931
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeTopColumn'
AND `id_shop` = 1 LIMIT 1
0.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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 *
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 *
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_feature_value_lang`
WHERE `id_feature_value` = 1187880
ORDER BY `id_lang`
0.2 2 /classes/FeatureValue.php:108
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 *
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_lang`
WHERE `id_product` = 85581 AND `id_shop` = 1
0.2 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 = 123331
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` = 4
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 = 113090 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`=85581
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 1
0.2 6 /classes/Employee.php:452
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 234 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 85581
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
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 = 4966
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE *
FROM `ps_feature_value_lang`
WHERE `id_feature_value` = 239751
ORDER BY `id_lang`
0.2 2 /classes/FeatureValue.php:108
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 = 85581
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_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 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 * FROM `ps_seosaproductlabels` WHERE 1
0.2 8 /modules/seosaproductlabels/classes/ProductLabel.php:179
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 = 85581 LIMIT 1
0.2 1 /classes/Product.php:760
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 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 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 *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeBottomColumn'
AND `id_shop` = 1 LIMIT 1
0.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 85581
0.2 4 /classes/Product.php:2629
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 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.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`='383a3dc2a2a99268e32812bcda082ec4' AND cache_id="module|1|166|product" AND compile_id="" LIMIT 1
0.2 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 = 123331 LIMIT 1
0.2 1 /classes/Product.php:760
SELECT SQL_NO_CACHE biagramm
FROM
ps_biagramms_product
WHERE
id_product = '85581' AND
id_lang = 1 LIMIT 1
0.2 2 /override/classes/Meta.php:72
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 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 = 85581
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:218
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 *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayTop'
AND `id_shop` = 1 LIMIT 1
0.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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` = 5
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 = 1775 LIMIT 1
0.2 1 /classes/Product.php:760
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 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.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
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.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 = 94700 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 = 75973 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`=85581
0.2 1 /classes/Tag.php:205
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 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 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 (85581)
0.2 1 /modules/crossselling/crossselling.php:133
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.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 66 AND `id_shop` = 1
0.2 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 85581
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 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 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` = 127
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
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 = 85581
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_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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('24b95e1565cc57795e88d1bb46347dd1',"crossselling|productfooter|85581|1|1|1|1|216","", FROM_UNIXTIME(1615286142))
0.2 1 /classes/SmartyCustom.php:263
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` = 2
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
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`=85581
0.2 1 /classes/Tag.php:205
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 out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 85581) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:690
SELECT SQL_NO_CACHE *
FROM `ps_feature_value_lang`
WHERE `id_feature_value` = 236590
ORDER BY `id_lang`
0.2 2 /classes/FeatureValue.php:108
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 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(18,31,66,156),
sc.`id_category` = 66) AND l.active = 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:121
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 COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 85581 AND `validate` = 1
AND `grade` > 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:260
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_videos WHERE id_product = 85581 AND id_shop = 1 ORDER BY position ASC
0.2 1 Yes /modules/productvideo/productvideo.php:1153
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 85581
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
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.1 1 /classes/SpecificPrice.php:302
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.1 1 /classes/Language.php:777
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 85581) 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 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 *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayFooter'
AND `id_shop` = 1 LIMIT 1
0.1 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 85581
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
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|66|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='crossselling/productfooter/85581/1/1/1/1/216/ea/7b/ae/ea7baef235d5836c8731c50d0dcb907cbfa11252.crossselling.tpl.php'
WHERE `template_hash`='24b95e1565cc57795e88d1bb46347dd1' AND cache_id="crossselling|productfooter|85581|1|1|1|1|216" AND compile_id=""
0.1 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="85581"
0.1 1 /modules/jsoxActuals/jsoxActuals.php:987
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 6
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='080060b264ab6efe03e6dc2bdfd63347' AND cache_id="blockbestsellers-colknigi|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
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 DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 85581 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 7
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.1 3 /Adapter/Adapter_EntityMapper.php:68
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` = 85581
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 216
0.1 3 /Adapter/Adapter_EntityMapper.php:68
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 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 = 85581
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:184
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 COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=37 AND id_shop IN (1) LIMIT 1
0.1 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
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_jsoxActualsParams WHERE pid="85581"
0.1 1 /modules/report_product_availability/report_product_availability.php:107
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` = 66 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 8
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 85581) 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 COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 85581 AND `validate` = 1
AND `grade` > 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:260
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 85581) 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_employee`
WHERE `id_profile` = 4
0.1 1 /classes/Employee.php:452
UPDATE `ps_smarty_lazy_cache`
SET filepath='crossselling/productfooter/85581/1/1/1/1/216/ea/7b/ae/ea7baef235d5836c8731c50d0dcb907cbfa11252.crossselling.tpl.php'
WHERE `template_hash`='24b95e1565cc57795e88d1bb46347dd1' AND cache_id="crossselling|productfooter|85581|1|1|1|1|216" AND compile_id=""
0.1 1 /classes/SmartyCustom.php:183
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 `id_category` FROM `ps_category_product`
WHERE `id_product` = 123331
0.1 3 /classes/Product.php:2629
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` = 85581
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
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 *
FROM `ps_employee`
WHERE `id_profile` = 5
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 7
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 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 3
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=169 AND id_shop IN (1) LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 75973) 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 = 85581 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 85581) 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 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`=85581
0.1 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="85581"
0.1 1 /modules/report_product_availability/report_product_availability.php:107
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='fe840aa409c2c4fab283ef3d5183e176' AND cache_id="5|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 3
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 85581) 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 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.1 1 /classes/SmartyCustom.php:215
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 = 85581 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
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
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 = 85581 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
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` = 18 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 6
0.1 1 /classes/Employee.php:452
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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 12584) 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 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 COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=71 AND id_shop IN (1) LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='24b95e1565cc57795e88d1bb46347dd1' AND cache_id="crossselling|productfooter|85581|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
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 = 85581 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
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 `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 7070 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 12584
0.1 6 /classes/Product.php:2629
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`=85581
0.1 1 /classes/Tag.php:205
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 `id_category` FROM `ps_category_product`
WHERE `id_product` = 75973
0.1 3 /classes/Product.php:2629
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 66) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 85581
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
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 COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=72 AND id_shop IN (1) LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 94700
0.1 2 /classes/Product.php:2629
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.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1
0.1 1 /classes/Image.php:471
SELECT SQL_NO_CACHE `left` FROM `ps_ovic_options_sidebar` WHERE `page` ='product' AND `id_shop`=1 LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:528
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 1775
0.1 8 /classes/Product.php:2629
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 94700) 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 `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 `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4986
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 113090
0.1 3 /classes/Product.php:2629
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=98 AND id_shop IN (1) LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 85581) 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_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 85581) 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 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 (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 85581
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 7070
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 113090
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 7070
0.1 6 /classes/Product.php:2629
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 104440
0.1 4 /classes/Product.php:2629
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` = 2388 LIMIT 1