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
#143391
143391

Рак молочной железы (143391)

Автор: под ред.Каприна

Издательство: ГЭОТАР-Медиа

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

10 Товары

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

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

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

1 547 грн.

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

- +

Аннотация

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

ФИО Автора под ред.Каприна
Издательство ГЭОТАР-Медиа
Язык Русский
Переплет Твердый
Кол-во страниц 456
Вес 395
Иллюстрации Нет
Издание Отдельное издание
Размер книги 170x245
Написать отзыв
Рак молочной железы

Рак молочной железы

Мой отзыв
Товары из этой категории:
  • Беременность. Руководство пользователя: Основная информация, рекомендации по устранению неполадок, советы будущим родителям
    201 грн. 201 грн.
    Беременность. Руководство пользователя: Основная

    Планируете завести ребенка или уже

    Планируете завести ребенка или уже "в процессе"? Вас ждет удивительное приключение под названием "беременность" - чудо создания новой жизни! Вы будете с замиран...

    Цена: 201 грн.
    (3)
    Fast
    Код предмета:100699 В наличии
  • Большая книга общения с ребенком
    739 грн. 739 грн.
    Большая книга общения с ребенком

    "Большая книга общения с ребенком" -

    "Большая книга общения с ребенком" - представляет собой дополненное и переработанное издание книг "Общаться с ребенком. Как?", "Продолжаем общаться с ребенком. ...

    Цена: 739 грн.
    (4)
    Код предмета:100724 На складе издательства
  • Ваш малыш неделя за неделей: От рождения до 6 месяцев
    333 грн. 333 грн.
    Ваш малыш неделя за неделей: От рождения до 6 месяцев

    К младенцам инструкция не

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

    Цена: 333 грн.
    (3)
    Код предмета:100756 На складе
  • Воспитание без шаблонов: Научитесь слышать своего ребенка
    347 грн. 347 грн.
    Воспитание без шаблонов: Научитесь слышать своего

    Сегодня на родителей обрушивается

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

    Цена: 347 грн.
    (3)
    Код предмета:100792 На складе
  • Воспитывать просто. Как дать детям главное, не перегружая лишним
    306 грн. 306 грн.
    Воспитывать просто. Как дать детям главное, не

    Испортить жизнь своему ребенку очень

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

    Цена: 306 грн.
    (3)
    Код предмета:100793 На складе
  • Гаррі Поттер і таємна кімната (Велике ілюстроване видання)
    495 грн. 495 грн.
    Гаррі Поттер і таємна кімната (Велике ілюстроване

    Історії про чаклуна в окулярах з

    Історії про чаклуна в окулярах з друзями Герміоною та Роном захопили увагу читачів всього світу. «Гаррі Поттер», який є витвором фантазії та результатом літерат...

    Цена: 495 грн.
    (3)
    Fast
    Код предмета:100814 В наличии
  • Гаррі Поттер і філософський камінь. Ілюстроване видання
    475 грн. 475 грн.
    Гаррі Поттер і філософський камінь. Ілюстроване

    Перше ілюстроване видання магічної

    Перше ілюстроване видання магічної класики Дж. К. Ролінґ містить у собі безліч пречудових кольорових ілюстрацій Джима Кея, кавалера медалі Кейт Ґрінвей. Це спра...

    Цена: 475 грн.
    (4)
    Код предмета:100815 На складе
  • Годовой курс обучающих занятий. Для одаренных детей 5-6 лет
    671 грн. 671 грн.
    Годовой курс обучающих занятий. Для одаренных детей

    Книга включает в себя полный годовой

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

    Цена: 671 грн.
    (3)
    Код предмета:100832 На складе издательства
  • Детский сон: Простые решения для родителей
    640 грн. 640 грн.
    Детский сон: Простые решения для родителей

    Сон - важнейшее условие правильного

    Сон - важнейшее условие правильного развития ребенка. Однако похвастаться идеальным сном своего малыша могут единицы. Известный во всем мире педиатр Харви Карп ...

    Цена: 640 грн.
    (3)
    Код предмета:100854 На складе издательства
  • Здоровый сон — счастливый ребенок
    351 грн. 351 грн.
    Здоровый сон — счастливый ребенок

    Что такое здоровый сон и почему он

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

    Цена: 351 грн.
    (3)
    Fast
    Код предмета:100936 В наличии
  • Земля. Повна енциклопедія
    431 грн. 431 грн.
    Земля. Повна енциклопедія

    Видання містить докладну інформацію

    Видання містить докладну інформацію про нашу планету, про процеси, що відбуваються у її надрах та на поверхні. Зокрема, читачі дізнаються, як виникла Земля, які...

    Цена: 431 грн.
    (3)
    Код предмета:100938 На складе
  • Земля. Полная энциклопедия
    349 грн. 349 грн.
    Земля. Полная энциклопедия

    В книге "Земля. Полная энциклопедия"

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

    Цена: 349 грн.
    Код предмета:100939 На складе
  • Играем в науку
    107 грн. 107 грн.
    Играем в науку

    Книга "Играем в науку" помогает

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

    Цена: 107 грн.
    (3)
    Код предмета:100945 На складе
  • Инвестиционная оценка: Инструменты и методы оценки любых активов
    1 542 грн. 1 542 грн.
    Инвестиционная оценка: Инструменты и методы оценки

    В основе книги лежит предположение,

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

    Цена: 1 542 грн.
    (3)
    Код предмета:100959 На складе издательства
  • Как говорить, чтобы дети вас услышали, или Фабер и Мазлиш по-русски
    331 грн. 331 грн.
    Как говорить, чтобы дети вас услышали, или Фабер и

    Эта книга опирается на методику

    Эта книга опирается на методику А.Фабер и Э.Мазлиш - американских педагогов, многодетных мам и авторов бестселлеров. Детский и семейный психолог Юлия Василькина...

    Цена: 331 грн.
    Код предмета:100999 На складе издательства
  • Младенец. Инструкция для владельцев: Руководство по эксплуатации, рекомендации по устранению неис
    494 грн. 494 грн.
    Младенец. Инструкция для владельцев: Руководство по

    Инструкция по эксплуатации,

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

    Цена: 494 грн.
    Код предмета:101169 На складе издательства
  • От 0 до 5. Простые подсказки для умных родителей
    299 грн. 299 грн.
    От 0 до 5. Простые подсказки для умных родителей

    Кто из начинающих родителей не

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

    Цена: 299 грн.
    (4)
    Код предмета:101262 На складе
  • Папины сказки
    507 грн. 507 грн.
    Папины сказки

    Во-первых, она обращена к папам — к

    Во-первых, она обращена к папам — к тем замечательным отцам, которые понимают, что по-    rV.l/1 . .мимо работы надо ещё и заниматься своими детьми, иначе они в...

    Цена: 507 грн.
    (4)
    Код предмета:101276 На складе
  • Ребенок от 3 до 7 лет. Интенсивное воспитание
    396 грн. 396 грн.
    Ребенок от 3 до 7 лет. Интенсивное воспитание

    Ваш ребенок подрос, он уже говорит,

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

    Цена: 396 грн.
    (3)
    Код предмета:101379 На складе издательства
  • Семейная педагогика. Воспитание ребенка в любви, свободе и творчестве
    553 грн. 553 грн.
    Семейная педагогика. Воспитание ребенка в любви,

    Перед вами уникальная книга -

    Перед вами уникальная книга - настоящая энциклопедия воспитания ребенка. Яркое и фундаментальное пособие по семейному воспитанию станет настольной книгой для ка...

    Цена: 553 грн.
    Код предмета:101418 На складе издательства
  • Семь навыков эффективных родителей: Семейный тайм-менеджмент, или Как успевать все
    285 грн. 285 грн.
    Семь навыков эффективных родителей: Семейный

    Проблема, которую приходится решать

    Проблема, которую приходится решать всем родителям, - "как успевать все". Как объединить работу, личные увлечения и воспитание детей? Как найти время на себя, с...

    Цена: 285 грн.
    Код предмета:101419 На складе
  • Спортсмен, музыкант, поэт, математик… Как выявить и развить способности вашего ребенка
    309 грн. 309 грн.
    Спортсмен, музыкант, поэт, математик… Как выявить и

    Елена Первушина - автор книг по

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

    Цена: 309 грн.
    (3)
    Код предмета:101461 На складе
  • Стратегия семейной жизни. Как реже мыть посуду, чаще заниматься сексом и меньше ссориться
    339 грн. 339 грн.
    Стратегия семейной жизни. Как реже мыть посуду, чаще

    Эта книга способна поднять экономику

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

    Цена: 339 грн.
    (3)
    Код предмета:101486 На складе
  • Суперобъекты: Звезды размером с город
    281 грн. 281 грн.
    Суперобъекты: Звезды размером с город

    Книга посвящена нейтронным звездам -

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

    Цена: 281 грн.
    (3)
    Код предмета:101495 На складе
  • Тайм-менеджмент для детей. Книга продвинутых родителей
    344 грн. 344 грн.
    Тайм-менеджмент для детей. Книга продвинутых

    Процессы - и особенно

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

    Цена: 344 грн.
    (3)
    Код предмета:101498 На складе
  • Тайм-менеджмент для школьника. Как Федя Забывакин учился временем управлять
    412 грн. 412 грн.
    Тайм-менеджмент для школьника. Как Федя Забывакин

    Если ваш ребенок учится в школе, вам

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

    Цена: 412 грн.
    (4)
    Код предмета:101499 На складе
  • Удивительный волшебник Страны Оз (ил. М. Маринелли)
    282 грн. 282 грн.
    Удивительный волшебник Страны Оз (ил. М. Маринелли)

    Соломенное пугало, железный лесоруб,

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

    Цена: 282 грн.
    Код предмета:101541 На складе издательства
  • Чем занять ребенка. Игры без планшета и компьютера для детей от 6 до 10 лет
    299 грн. 299 грн.
    Чем занять ребенка. Игры без планшета и компьютера

    Проводить время с ребенком - весело.

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

    Цена: 299 грн.
    (3)
    Код предмета:101607 На складе
  • Алгебра. Естественная наука в комиксах
    198 грн. 198 грн.
    Алгебра. Естественная наука в комиксах

    Новая книга всемирно знаменитого

    Новая книга всемирно знаменитого карикатуриста Ларри Гоника, изучавшего и преподававшего математику в Гарвардском университете, представляет собой интенсивный к...

    Цена: 198 грн.
    (3)
    Код предмета:102042 На складе
  • Архив журнала "Ёж". Том 1. 1928
    1 395 грн. 1 395 грн.
    Архив журнала "Ёж". Том 1. 1928

    С 1928 по 1935 год в Ленинграде

    С 1928 по 1935 год в Ленинграде выходил детский журнал "Ёж", название которого остроумно расшифровывалось как "ежемесячный журнал". Его издавали для пионеров, н...

    Цена: 1 395 грн.
    Код предмета:102105 На складе издательства
Вперед Назад
Перечень
Load Time2859 ms - You'd better run your shop on a toaster
Querying Time2548 ms
Queries470
Memory Peak Usage36.8 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 52 ms 52 ms 3.70 Mb 3.70 Mb
__construct 0 ms 52 ms - Mb 3.70 Mb
init 709 ms 761 ms 1.72 Mb 6.11 Mb
checkAccess 0 ms 761 ms - Mb 6.11 Mb
setMedia 1 ms 762 ms 0.01 Mb 6.11 Mb
postProcess 0 ms 762 ms - Mb 6.11 Mb
initHeader 0 ms 762 ms - Mb 6.11 Mb
initContent 2025 ms 2787 ms 11.26 Mb 36.84 Mb
initFooter 11 ms 2798 ms 0.30 Mb 36.84 Mb
display 61 ms 2859 ms 1.78 Mb 36.84 Mb
Hook Time Memory Usage
hookdisplayRightColumnProduct 1754 ms - Mb
__construct 79 ms - Mb
hookdisplayHeader 72 ms 2.00 Mb
hookdisplayTop 21 ms - Mb
hookproductfooter 15 ms - Mb
hookdisplayTopColumn 12 ms - Mb
hookdisplayFooter 11 ms - Mb
hookHeader 10 ms - Mb
hookdisplayLeftColumn 10 ms - Mb
hookdisplayNav 7 ms - Mb
hookproducttabcontent 4 ms - Mb
hookdisplayProductTabContent 3 ms - Mb
hookdisplayProductButtons 3 ms - Mb
hookdisplayProductTab 3 ms - Mb
hookdisplaySocialSharing 2 ms - Mb
hookdisplayHomeBottomColumn 2 ms - Mb
hookdisplayCategorySlider 2 ms - Mb
hookproducttab 1 ms - Mb
hookdisplayOvicCategorySizeChart 1 ms - Mb
hookdisplayBottomColumn 1 ms - Mb
hookdisplayVerticalMenu 1 ms - Mb
hookdisplayHomeTopColumn 1 ms - Mb
hookdisplayContactInfo 1 ms - Mb
hookproductactions 1 ms - Mb
hookCustomVideoHook 0 ms - Mb
hookdisplayHomeTopContent 0 ms - Mb
hookdisplayProductStockLabel 0 ms - Mb
hookdisplayAfterBody 0 ms - Mb
hookdisplayStoreMap 0 ms - Mb
hookdisplayBeforeLogo 0 ms - Mb
hookdisplayHomeBottomContent 0 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookdisplayDigitalBookIcon 0 ms - Mb
hooksetProductStockValue 0 ms - Mb
hookdisplayFooterProduct 0 ms - Mb
hookPackWebseregas 0 ms - Mb
hookPackWebseregascart 0 ms - Mb
hookDisplayOverrideTemplate - ms - Mb
hookactionObjectAddAfter - ms - Mb
hookdisplayLeftColumnProduct - ms - Mb
hookdisplayProductDeliveryTime - ms - Mb
hookdisplayProductPriceBlock - ms - Mb
hookactionProductOutOfStock - ms - Mb
43 hooks 2017 ms 2.00 Mb
Module Time Memory Usage
seosaproductlabels 1751 ms - Mb
oviclayoutcontrol 70 ms - Mb
pm_advancedpack 52 ms 2.00 Mb
crossselling 12 ms - Mb
advanceblog 10 ms - Mb
automaticpacketgeneration 10 ms - Mb
productcomments 9 ms - Mb
bookworks 9 ms - Mb
socialsharing 7 ms - Mb
report_product_availability 6 ms - Mb
gsnippetsreviews 6 ms - Mb
dealershippage 5 ms - Mb
productvideo 4 ms - Mb
blocknewsletter 4 ms - Mb
categoryslider 3 ms - Mb
homesliderpro 3 ms - Mb
ovicstoremap 3 ms - Mb
oviccategorysizechart 3 ms - Mb
anchorfeatures 3 ms - Mb
newsletterpro 3 ms - Mb
verticalmegamenus 2 ms - Mb
bg_prestasms 2 ms - Mb
blockbestsellers 2 ms - Mb
pm_advancedsearch4 2 ms - Mb
productscategory 2 ms - Mb
accumulative_discount 1 ms - Mb
lgtagmanager 1 ms - Mb
order_synchronization 1 ms - Mb
jsox_newgallery 1 ms - Mb
blockwishlist 1 ms - Mb
ecm_novaposhta 1 ms - Mb
jsoxActuals 1 ms - Mb
ecm_shipping_up 1 ms - Mb
tinymcepro 1 ms - Mb
gremarketing 1 ms - Mb
statsdata 1 ms - Mb
sendreviewrequest 1 ms - Mb
ganalytics 1 ms - Mb
mailalerts 1 ms - Mb
ecm_feedback 1 ms - Mb
jsoxLitresWorker 1 ms - Mb
google_recaptcha 1 ms - Mb
jsox_adminorderchat 1 ms - Mb
parsing_products 1 ms - Mb
blockcart 1 ms - Mb
ovicnewsletter 0 ms - Mb
bookworks_filters 0 ms - Mb
trackorderstatus 0 ms - Mb
jsox_ordercomplectcorrector 0 ms - Mb
bookatel 0 ms - Mb
g_ordermanager 0 ms - Mb
jsoxNeironet 0 ms - Mb
multistyle 0 ms - Mb
reviewsadv 0 ms - Mb
ba_ajax_search 0 ms - Mb
sekeywords 0 ms - Mb
relinkingblocks 0 ms - Mb
ultimateimagetool 0 ms - Mb
jsoxFids 0 ms - Mb
blocklanguages 0 ms - Mb
advancetopmenu 0 ms - Mb
promomod 0 ms - Mb
advancedfeaturesvalues 0 ms - Mb
blockstore 0 ms - Mb
additionalorders 0 ms - Mb
discountproducts 0 ms - Mb
sendsmsbystatus 0 ms - Mb
jsoxLitresSeller 0 ms - Mb
customsuppliers 0 ms - Mb
pagesnotfound 0 ms - Mb
blocksupplier 0 ms - Mb
blocktags 0 ms - Mb
blocklayered 0 ms - Mb
advancefooter 0 ms - Mb
bookproductlog 0 ms - Mb
recalculate_products_price 0 ms - Mb
jsox_ordersplitter 0 ms - Mb
blockreinsurance 0 ms - Mb
autoliqpay 0 ms - Mb
oviccustomtags 0 ms - Mb
blockspecials 0 ms - Mb
blocksocial 0 ms - Mb
blocknewproducts 0 ms - Mb
categorysearch 0 ms - Mb
oviccustombanner 0 ms - Mb
npcashdeliverystatistics 0 ms - Mb
jsox_newpost_pay_corrector 0 ms - Mb
productpaymentlogos 0 ms - Mb
importproduct 0 ms - Mb
themeconfigurator 0 ms - Mb
blockuserinfo 0 ms - Mb
wholesale_products_price 0 ms - Mb
blockcontactinfos 0 ms - Mb
competitorpricechange 0 ms - Mb
jsoxEANUpdateAndNPAddress 0 ms - Mb
blockmyaccount 0 ms - Mb
jsox_waitstate 0 ms - Mb
jsox_adminproductnamecopybutton 0 ms - Mb
homefeatured 0 ms - Mb
homeslider 0 ms - Mb
blockcontact 0 ms - Mb
jsoxCache 0 ms - Mb
blockmanufacturer 0 ms - Mb
ovicblockcms 0 ms - Mb
blockbanner 0 ms - Mb
blockhtml 0 ms - Mb
brandsslider 0 ms - Mb
107 modules 2017 ms 2.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
1653.8 123205 Yes /override/classes/ProductSale.php:131
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
678.7 394638 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE app.`id_pack`
FROM `ps_pm_advancedpack` app
19.1 54237 /modules/pm_advancedpack/AdvancedPack.php:717
SELECT SQL_NO_CACHE * FROM ps_ecm_seoredirect WHERE url_old = "/ru/detskaya-literatura/43369-rak-molochnoj-zhelezy.html" AND id_shop = "1" ORDER BY id DESC LIMIT 1
10 1 /override/classes/controller/FrontController.php:505
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)
7.4 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 75973
7.3 3 /classes/Product.php:2629
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.1 2009 /classes/Configuration.php:148
SET @@group_concat_max_len = 4096
6.7 1 /override/classes/Product.php:655
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER 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
5.3 16 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
4.3 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, 43369) 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
4.2 2 Yes /classes/SpecificPrice.php:419
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('24b95e1565cc57795e88d1bb46347dd1',"crossselling|productfooter|43369|1|1|1|1|216","", FROM_UNIXTIME(1615283585))
3.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
3.1 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 632 /classes/Hook.php:235
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER 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
3 21 Yes /override/classes/Product.php:664
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
2.9 15 Yes Yes /classes/Category.php:859
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` = 15 LIMIT 1
2.6 1 /classes/Category.php:1054
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
2.4 245 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4966
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.3 19 Yes /override/classes/Product.php:664
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
2.1 1 /classes/Product.php:760
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 94700)
2 1 /classes/Product.php:3012
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 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 <= 60
AND c.nright >= 75
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
1.8 97 Yes /classes/Tools.php:1349
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.7 159 /classes/module/Module.php:277
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 43369
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.6 13 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` = 43369 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.6 1 Yes Yes /override/classes/Product.php:398
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
1.5 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 1
1.5 6 /classes/Employee.php:452
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 43369
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-03-09 00:00:00",
INTERVAL 14 DAY
)
) > 0
1.4 0 /classes/Product.php:1286
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` = 43369
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
1.3 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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.2 159 /classes/module/Module.php:277
show tables like "ps_sesliders_slideconf"
1.2 1 /modules/homesliderpro/homesliderpro.php:1218
SHOW TABLES LIKE 'ps_order_synchronization_stores';
1.1 1 /modules/bookworks/bookworks.php:285
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` = 43369 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 = 7070
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.1 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 = 104440
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1.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 = 113090
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
1 5 Yes /override/classes/Product.php:664
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 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
1 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1
0.9 1 /classes/Image.php:471
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.9 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 = 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 `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 *, ( 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.9 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.9 1 /classes/module/Module.php:2568
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 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 (43369)
0.9 1 /modules/crossselling/crossselling.php:133
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 123331
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.9 6 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, 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 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, 12584) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes /classes/SpecificPrice.php:362
UPDATE `ps_smarty_lazy_cache`
SET filepath='crossselling/productfooter/43369/1/1/1/1/216/ea/7b/ae/ea7baef235d5836c8731c50d0dcb907cbfa11252.crossselling.tpl.php'
WHERE `template_hash`='24b95e1565cc57795e88d1bb46347dd1' AND cache_id="crossselling|productfooter|43369|1|1|1|1|216" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4966) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE 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 *
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 43369
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
0.8 1 Yes /modules/productcomments/ProductComment.php:136
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 = 4986
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
0.8 14 Yes /override/classes/Product.php:664
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` = 16
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.8 5 Yes Yes /classes/Category.php:656
SET @@group_concat_max_len = 4096
0.8 1 /override/classes/Product.php:655
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 *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayTop'
AND `id_shop` = 1 LIMIT 1
0.8 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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` = 43369 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 *, ( 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, 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, 43369) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-03-09 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.8 159 /classes/module/Module.php:277
SELECT SQL_NO_CACHE 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` = 43369 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.7 1 Yes /classes/Product.php:3612
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 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 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` = 43369
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.7 1 Yes Yes /classes/Product.php:3527
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.7 58 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE * FROM `ps_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.7 15 Yes /modules/advancetopmenu/advancetopmenu.php:1086
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` = 16
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.7 5 Yes Yes /classes/Category.php:656
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` = 43369
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
0.6 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.6 338 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 43369) 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 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` = 43369
ORDER BY i.`position`
0.6 1 Yes /classes/Product.php:5410
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` = 43369
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 COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=169 AND id_shop IN (1) LIMIT 1
0.6 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
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 ('360e9a388bdb29f565861c4a6159f620', 'https://www.bookovka.ua/ru/detskaya-literatura/43369-rak-molochnoj-zhelezy.html', 1,
1, 216, 1,'360e9a388bdb29f565861c4a6159f6201121610', 37997,
0, 1, 0, 1615283587, 'product', 43369, 0,'2021-03-09 09:53:07','')
ON DUPLICATE KEY UPDATE miss = miss + 1,
last_updated ='2021-03-09 09:53:07',
cache = '360e9a388bdb29f565861c4a6159f6201121610', cache_size = 37997,
miss_time = ((miss_time*miss) + 1615283587.369) / (miss + 1)
0.5 1 /override/classes/controller/FrontController.php:381
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` = 43369
ORDER BY `position`
0.5 1 Yes /classes/Product.php:2735
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` = 43369
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 *
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.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 294 AND `id_shop` = 1 LIMIT 1
0.5 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1)
WHERE deleted = 0
ORDER BY `name` ASC
0.5 34 Yes /classes/order/OrderState.php:127
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "jsoxActuals" LIMIT 1
0.5 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.4 1 /classes/Image.php:471
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 <= 60
AND c.nright >= 75
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.4 97 Yes /classes/Tools.php:1349
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` = 43369
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 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` = 43369
AND l.`active` = 1
0.4 1 /classes/Product.php:5027
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` = 16
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_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` = 43369) 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` = 123331) 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` = 104440) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE DISTINCT app.`id_pack`
FROM `ps_pm_advancedpack` ap
INNER JOIN `ps_pm_advancedpack_products` app ON app.`id_pack` = ap.`id_pack`
WHERE (ap.`id_shop` IN (1)) AND (app.`id_product`=43369)
0.4 1 /modules/pm_advancedpack/AdvancedPack.php:740
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4966) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12584) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
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 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.3 1 Yes /classes/shop/Shop.php:663
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` = 43369) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.bookovka.ua' OR su.domain_ssl = 'www.bookovka.ua')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.3 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1775) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4986) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 43369
0.3 1 /classes/Product.php:5707
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 75973) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 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` = 43369
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` = 43369 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
0.3 1 Yes /modules/productcomments/ProductComment.php:114
SELECT SQL_NO_CACHE *
FROM `ps_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 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` = 43369
ORDER BY `position`
0.3 1 Yes /classes/Product.php:2735
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.3 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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 = 43369
AND product_shop.active = 1 LIMIT 1
0.3 1 /override/classes/Meta.php:47
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.3 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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 *
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` = 43369) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name`
FROM `ps_product_comment_criterion` pcc
LEFT JOIN `ps_product_comment_criterion_lang` pccl
ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion)
LEFT JOIN `ps_product_comment_criterion_product` pccp
ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 43369)
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 = 43369)
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 COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=5 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.3 164 /classes/Tab.php:296
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 `id_category` FROM `ps_category_product`
WHERE `id_product` = 94700
0.2 2 /classes/Product.php:2629
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 47339434
AND `date_add` > '2021-03-09 11:23:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.2 1 /classes/Connection.php:138
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 113090 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
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` = 43369
0.2 13 /classes/Product.php:3696
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.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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`=43369
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 2
0.2 20 /classes/Employee.php:452
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 123331)
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` = 75973)
0.2 1 /classes/Product.php:3012
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_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 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 = 43369)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.2 8 /modules/seosaproductlabels/classes/ProductLabelLocation.php:104
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_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 *
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 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` = 43369
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.2 1 /modules/productcomments/ProductComment.php:168
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayBottomColumn'
AND `id_shop` = 1 LIMIT 1
0.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE *
FROM `ps_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_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` = 43369)
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` = 113090)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4966 LIMIT 1
0.2 1 /classes/Product.php:760
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 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.2 1 /classes/Language.php:892
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 = 43369
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 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` = 43369
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` = 104440)
0.2 1 /classes/Product.php:3012
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 43369
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_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 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 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 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` = 43369
AND image_shop.`cover` = 1 LIMIT 1
0.2 1 /classes/Product.php:2757
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2021-03-09 00:00:00' AND '2021-03-09 23:59:59' LIMIT 1
0.2 1 /classes/SpecificPrice.php:302
SELECT SQL_NO_CACHE *
FROM `ps_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_seosaproductlabels` WHERE 1
0.2 8 /modules/seosaproductlabels/classes/ProductLabel.php:179
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` = 16
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 @curRow := @curRow + 1 AS level,
id, from_summ, to_summ, discount
FROM
ps_level_customers_discount
JOIN (SELECT @curRow := 0) r
ORDER BY id ASC;
0.2 0 /modules/accumulative_discount/accumulative_discount.php:366
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 2
0.2 20 /classes/Employee.php:452
SELECT SQL_NO_CACHE 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 = 43369
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_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 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 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 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 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 = 43369
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:218
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 43369 AND `id_shop` = 1
0.2 2 /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.2 1 /classes/Meta.php:149
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 = 7070
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.2 1 /classes/Country.php:173
SELECT SQL_NO_CACHE 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`=43369
0.2 1 /classes/Tag.php:205
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` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
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 `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 75973
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
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 (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` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
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 *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 12584
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE 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 *
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 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 * FROM ps_product_videos WHERE id_product = 43369 AND id_shop = 1 ORDER BY position ASC
0.2 1 Yes /modules/productvideo/productvideo.php:1153
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` = 137
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`=43369
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 4966
0.2 1 /classes/Product.php:4485
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.2 8 /classes/Profile.php:57
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 = 43369
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 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.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 43369 LIMIT 1
0.2 1 /classes/Page.php:77
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 = 43369
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_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayNav'
AND `id_shop` = 1 LIMIT 1
0.2 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE 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 = 104440
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` = 136
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.2 87 /classes/Hook.php:187
SELECT SQL_NO_CACHE *
FROM `ps_feature_value_lang`
WHERE `id_feature_value` = 143709
ORDER BY `id_lang`
0.2 2 /classes/FeatureValue.php:108
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 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_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 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 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 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 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 *
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_employee`
WHERE `id_profile` = 1
0.2 6 /classes/Employee.php:452
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.2 1 /classes/shop/Shop.php:1067
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 = 43369 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`=43369
0.2 1 /classes/Tag.php:205
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.2 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` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
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 *
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 s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 134
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('24b95e1565cc57795e88d1bb46347dd1',"crossselling|productfooter|43369|1|1|1|1|216","", FROM_UNIXTIME(1615283585))
0.2 1 /classes/SmartyCustom.php:263
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 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='71e891b272d1ac80aea8f678c75946fc' AND cache_id="advancefooter|1|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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 (43369)
0.2 1 /modules/crossselling/crossselling.php:133
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 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` = 43369 AND ctg.`id_group` = 1 LIMIT 1
0.2 2 /classes/Product.php:4931
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 = 43369
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:184
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 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 `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.2 1 /classes/Country.php:173
SELECT SQL_NO_CACHE 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 * FROM ps_jsoxActualsParams WHERE pid="43369"
0.2 1 /modules/jsoxActuals/jsoxActuals.php:987
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 = 43369 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
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`=43369
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 = 4986 LIMIT 1
0.2 1 /classes/Product.php:760
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.2 1 /classes/ObjectModel.php:487
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 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`=43369
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 123331
0.2 1 /classes/Product.php:4485
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.2 1 /classes/Language.php:777
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 7070 LIMIT 1
0.2 1 /classes/Product.php:760
SELECT SQL_NO_CACHE *
FROM `ps_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 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(16,156),
sc.`id_category` = 16) AND l.active = 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:121
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4c54ecfbb4c624d1a48e94bd4fa62aa1' AND cache_id="productscategory|16|1|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE biagramm
FROM
ps_biagramms_product
WHERE
id_product = '43369' AND
id_lang = 1 LIMIT 1
0.1 2 /override/classes/Meta.php:72
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.1 1 /classes/Product.php:760
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
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.1 1 /classes/Product.php:760
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="43369"
0.1 1 /modules/report_product_availability/report_product_availability.php:87
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.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:155
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="43369"
0.1 1 /modules/report_product_availability/report_product_availability.php:107
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 6
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 *
FROM `ps_feature_value_lang`
WHERE `id_feature_value` = 132068
ORDER BY `id_lang`
0.1 2 /classes/FeatureValue.php:108
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 *
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="2|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE biagramm
FROM
ps_biagramms_product_description
WHERE
id_product = '43369' AND
id_lang = 1 LIMIT 1
0.1 2 /override/classes/Meta.php:98
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('47339434', '26500', '66035236', '', '1', '1', '2021-03-09 11:53:07')
0.1 1 /classes/ObjectModel.php:487
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.1 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE ps_customer
SET
current_level = '0',
current_discount = '0',
total_amount_orders = '0',
to_next_level = '1000'
WHERE
id_customer = '0';
0.1 1 /modules/accumulative_discount/accumulative_discount.php:182
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.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
0.1 3 /Adapter/Adapter_EntityMapper.php:68
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 * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 5
ORDER BY  `position` ASC
0.1 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayTopColumn'
AND `id_shop` = 1 LIMIT 1
0.1 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 43369) 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(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 43369 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 = 7070) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 7
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 8
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=50 AND id_shop IN (1) LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
UPDATE `ps_smarty_lazy_cache`
SET filepath='crossselling/productfooter/43369/1/1/1/1/216/ea/7b/ae/ea7baef235d5836c8731c50d0dcb907cbfa11252.crossselling.tpl.php'
WHERE `template_hash`='24b95e1565cc57795e88d1bb46347dd1' AND cache_id="crossselling|productfooter|43369|1|1|1|1|216" AND compile_id=""
0.1 1 /classes/SmartyCustom.php:183
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 (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'UAH') LIMIT 1
0.1 4 /classes/Currency.php:319
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 5
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
0.1 0 /override/classes/Manufacturer.php:239
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9e60fe123a5951d4fef6eae8b173fc1f' AND cache_id="socialsharing|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 3
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 43369) 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 `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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a42c52ba8ab3087125211a13758108f4' AND cache_id="socialsharing_header|43369|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
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` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 135
0.1 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ecm_seoredirect" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 43369
0.1 2 /classes/Product.php:2629
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea94faa84c5b896540f5a4d720839b91' AND cache_id="ovicblockcms|3|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE 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 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 *
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 *
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` = 16) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 4
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="43369"
0.1 1 /modules/report_product_availability/report_product_availability.php:107
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 out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 43369) 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9e60fe123a5951d4fef6eae8b173fc1f' AND cache_id="socialsharing|43369|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeTopColumn'
AND `id_shop` = 1 LIMIT 1
0.1 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` = 'displayHomeBottomColumn'
AND `id_shop` = 1 LIMIT 1
0.1 297 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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` = 16 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 DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 43369 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
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 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 out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 43369) 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_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.1 1 /classes/Page.php:96
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_employee`
WHERE `id_profile` = 5
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=89 AND id_shop IN (1) LIMIT 1
0.1 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:1000
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 3
0.1 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 43369) 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 = 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 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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43369) 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_image_type`
0.1 11 /classes/ImageType.php:143
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.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a42c52ba8ab3087125211a13758108f4',"socialsharing_header|43369|1|1|1|1|216","", FROM_UNIXTIME(1615283585))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_hook, conf FROM `ps_sesliders_slideconf`
WHERE `id_shop` = 1
0.1 2 /modules/homesliderpro/homesliderpro.php:402
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 4
0.1 1 /classes/Employee.php:452
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 DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 43369 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 43369 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 = 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 DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 43369 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="43369"
0.1 1 /modules/jsoxActuals/jsoxActuals.php:987
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 94700
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:196
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(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 43369
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
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` = 78 LIMIT 1
0.1 1 /classes/Category.php:1054
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 * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 4
ORDER BY  `position` ASC
0.1 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='24b95e1565cc57795e88d1bb46347dd1' AND cache_id="crossselling|productfooter|43369|1|1|1|1|216" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('24b95e1565cc57795e88d1bb46347dd1',"crossselling|productfooter|43369|1|1|1|1|216","", FROM_UNIXTIME(1615283587))
0.1 1 /classes/SmartyCustom.php:263
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` = 14 LIMIT 1
0.1 1 /classes/Category.php:1054
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 DATEDIFF(`date_add`, DATE_SUB("2021-03-09 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 43369 LIMIT 1
0.1 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:364
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4986) 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` = 1775
0.1 8 /classes/Product.php:2629