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

Ежедневник: Метод Глеба Архангельского (подарочный датированный 2014)

Автор: Глеб Архангельский

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

Издательство: Альпина Паблишер

10 Товары

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

Посмотреть все характеристики ↓
Это ежедневник по авторскому методу российского гуру тайм-менеджмента Глеба Архангельского, который поможет вам правильно и эффективно планировать свое время, н... далее->

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

415 грн.

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

- +

Аннотация

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

От магазина

Книгу Ежедневник: Метод Глеба Архангельского (подарочный датированный 2014) купить с доставкой по Киеву и Украине, Вы всегда сможете в интернет магазине "Bookovka". Будем рады ответить на любые Ваши вопросы.

ФИО АвтораГлеб Архангельский
ПереплетТвердый
Вес530
ЯзыкРусский
БумагаОфсетная
ИздательствоАльпина Паблишер
Иллюстрациида
ИзданиеОтдельное издание
Размер книги145х215
Написать отзыв
Ежедневник: Метод Глеба Архангельского (подарочный датированный 2014)

Ежедневник: Метод Глеба Архангельского (подарочный датированный 2014)

Мой отзыв

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    489 грн.
    Fast
    Код предмета:100697 В наличии
Вперед Назад
Перечень
Load Time790 ms - Unicorn powered webserver!
Querying Time404 ms
Queries473
Memory Peak Usage17.1 Mb
Included Files528 files - 9.89 Mb
PrestaShop Cache- Mb
Global vars2.84 Mb
PrestaShop Version1.6.1.20
PHP Version7.1.28 (OK)
MySQL Version10.3.18-MariaDB (OK)
Memory Limit8192M
Max Execution Time259200s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 80 ms 80 ms 3.21 Mb 3.23 Mb
__construct 0 ms 80 ms - Mb 3.23 Mb
init 39 ms 119 ms 1.62 Mb 4.95 Mb
checkAccess 0 ms 119 ms - Mb 4.95 Mb
setMedia 2 ms 121 ms 0.01 Mb 4.95 Mb
postProcess 0 ms 121 ms - Mb 4.95 Mb
initHeader 0 ms 121 ms - Mb 4.95 Mb
initContent 547 ms 668 ms 8.98 Mb 13.88 Mb
initFooter 15 ms 683 ms 0.34 Mb 14.66 Mb
display 107 ms 790 ms 1.79 Mb 17.13 Mb
Hook Time Memory Usage
hookdisplayRightColumnProduct 273 ms 2.00 Mb
__construct 85 ms 4.00 Mb
hookdisplayHeader 36 ms - Mb
hookproductfooter 26 ms - Mb
hookdisplayTopColumn 24 ms 2.00 Mb
hookdisplayTop 18 ms - Mb
hookdisplayFooter 15 ms - Mb
hookHeader 11 ms - Mb
hookdisplayLeftColumn 7 ms - Mb
hookdisplayProductTabContent 7 ms - Mb
hookproducttabcontent 6 ms - Mb
hookdisplayHomeBottomColumn 6 ms - Mb
hookdisplayProductTab 6 ms - Mb
hookdisplayNav 5 ms - Mb
hookdisplayCategorySlider 4 ms - Mb
hookdisplayProductButtons 3 ms - Mb
hookdisplayOvicCategorySizeChart 3 ms - Mb
hookdisplaySocialSharing 2 ms - Mb
hookproducttab 2 ms - Mb
hookdisplayHomeTopColumn 1 ms - Mb
hookdisplayVerticalMenu 1 ms - Mb
hookdisplayStoreMap 1 ms - Mb
hookdisplayContactInfo 1 ms - Mb
hookdisplayBottomColumn 1 ms - Mb
hookproductactions 1 ms - Mb
hookdisplayBeforeLogo 1 ms - Mb
hookCustomVideoHook 1 ms - Mb
hookdisplayHomeBottomContent 0 ms - Mb
hookdisplayHomeTopContent 0 ms - Mb
hookactionProductOutOfStock 0 ms - Mb
hookdisplayProductStockLabel 0 ms - Mb
hookdisplayAfterBody 0 ms - Mb
hooksetProductStockValue 0 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookDisplayOverrideTemplate 0 ms - Mb
hookPackWebseregascart 0 ms - Mb
hookdisplayFooterProduct 0 ms - Mb
hookdisplayLeftColumnProduct - ms - Mb
hookdisplayProductDeliveryTime - ms - Mb
hookdisplayProductPriceBlock - ms - Mb
hookactionObjectAddAfter - ms - Mb
hookPackWebseregas - ms - Mb
42 hooks 549 ms 8.00 Mb
Module Time Memory Usage
seosaproductlabels 270 ms 2.00 Mb
oviclayoutcontrol 92 ms 2.00 Mb
crossselling 18 ms - Mb
advanceblog 15 ms - Mb
productcomments 13 ms - Mb
bookworks 10 ms - Mb
socialsharing 10 ms - Mb
categoryslider 9 ms - Mb
blocknewsletter 8 ms 2.00 Mb
productscategory 7 ms - Mb
ovicstoremap 6 ms - Mb
oviccategorysizechart 6 ms - Mb
productvideo 6 ms - Mb
report_product_availability 6 ms - Mb
pm_advancedpack 5 ms - Mb
pm_advancedsearch4 5 ms - Mb
verticalmegamenus 4 ms - Mb
blockbestsellers 4 ms - Mb
homesliderpro 3 ms - Mb
newsletterpro 3 ms - Mb
lgtagmanager 2 ms - Mb
ecm_novaposhta 2 ms - Mb
groupcategory 2 ms - Mb
order_synchronization 1 ms - Mb
blockwishlist 1 ms - Mb
gsnippetsreviews 1 ms - Mb
prestasms 1 ms - Mb
jsoxActuals 1 ms - Mb
multistyle 1 ms - Mb
recalculate_products_price 1 ms - Mb
statsdata 1 ms - Mb
sekeywords 1 ms - Mb
blockcart 1 ms - Mb
ganalytics 1 ms - Mb
mailalerts 1 ms - Mb
tinymcepro 1 ms - Mb
ecm_feedback 1 ms - Mb
sendreviewrequest 1 ms - Mb
ovicnewsletter 1 ms - Mb
bookworks_filters 1 ms - Mb
bookproductlog 1 ms - Mb
advancetopmenu 1 ms - Mb
ba_ajax_search 1 ms - Mb
blocksocial 1 ms - Mb
autoliqpay 1 ms - Mb
trackorderstatus 1 ms - Mb
jsox_adminorderchat 1 ms - Mb
g_ordermanager 1 ms - Mb
gremarketing 1 ms - Mb
advancefooter 1 ms - Mb
themeconfigurator 1 ms - Mb
sendsmsbystatus 1 ms 2.00 Mb
blocktags 1 ms - Mb
blocklayered 1 ms - Mb
productpaymentlogos 1 ms - Mb
additionalorders 1 ms - Mb
jsox_adminproductnamecopybutton 1 ms - Mb
blockcontactinfos 1 ms - Mb
ovicblockcms 1 ms - Mb
blockcontact 1 ms - Mb
blockreinsurance 1 ms - Mb
jsoxFids 1 ms - Mb
blockhtml 1 ms - Mb
blockmanufacturer 1 ms - Mb
blockspecials 1 ms - Mb
blocksupplier 1 ms - Mb
homefeatured 1 ms - Mb
jsox_ordercomplectcorrector 0 ms - Mb
pagesnotfound 0 ms - Mb
blocknewproducts 0 ms - Mb
homeslider 0 ms - Mb
brandsslider 0 ms - Mb
discountproducts 0 ms - Mb
blockbanner 0 ms - Mb
categorysearch 0 ms - Mb
bookatel 0 ms - Mb
blockmyaccount 0 ms - Mb
blockstore 0 ms - Mb
jsox_ordersplitter 0 ms - Mb
advancedfeaturesvalues 0 ms - Mb
jsox_waitstate 0 ms - Mb
jsox_newpost_pay_corrector 0 ms - Mb
blockuserinfo 0 ms - Mb
promomod 0 ms - Mb
oviccustomtags 0 ms - Mb
reviewsadv 0 ms - Mb
jsoxEANUpdateAndNPAddress 0 ms - Mb
jsoxNeironet 0 ms - Mb
oviccustombanner 0 ms - Mb
jsoxCache 0 ms - Mb
90 modules 549 ms 8.00 Mb

Stopwatch SQL - 473 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.id_product, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`link_rewrite`, pl.`name`, pl.`description_short`, product_shop.`id_category_default`,
image_shop.`id_image` id_image, il.`legend`,
ps.`quantity` AS sales, p.`ean13`, p.`upc`, p.`reference`, cl.`link_rewrite` AS category, p.show_price, p.available_for_order, IFNULL(stock.quantity, 0) as quantity, p.customizable,
IFNULL(pa.minimal_quantity, p.minimal_quantity) as minimal_quantity, stock.out_of_stock,
product_shop.`date_add` > "2019-10-29" as new,
product_shop.`on_sale`, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM `ps_product_sale` ps
LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_attribute` pa ON (product_attribute_shop.id_product_attribute=pa.id_product_attribute)
LEFT JOIN `ps_product_lang` pl
ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN ps_jsoxActualsParams jsa ON p.`id_product` = jsa.`pid`
LEFT JOIN `ps_category_lang` cl
ON cl.`id_category` = product_shop.`id_category_default`
AND cl.`id_lang` = 1 AND cl.id_shop = 1  LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE product_shop.`active` = 1
AND jsa.`stock` IN (1,2,3,4)
AND p.`is_virtual` = 0
AND p.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`)
ORDER BY ps.quantity DESC
LIMIT 0, 12
167.2 116100 /override/classes/ProductSale.php:160
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER 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
4.9 5 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
4.9 228 Yes Yes /classes/Hook.php:355
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5720213ea87badac62b374f650d55767',"crossselling|productfooter|932|1|1|1|216","", FROM_UNIXTIME(1573547629))
4.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
4.6 1729 /classes/Configuration.php:148
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessoryz`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_jsoxActualsParams` ja ON (p.`id_product` = ja.`pid`)
WHERE `id_product_1` = 932 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`
4.6 1 Yes Yes /override/classes/Product.php:393
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10418
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
3.6 15 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3.6 245 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
3.6 1311 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
3.4 18 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4966
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
3.3 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2350
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
3.2 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
3 18 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
3 1311 /classes/SpecificPrice.php:238
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` = 932
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
2.8 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessoryz`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_jsoxActualsParams` ja ON (p.`id_product` = ja.`pid`)
WHERE `id_product_1` = 932 AND ja.`stock` != 5 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
ORDER BY product_shop.`type_of_book`
2.8 1 Yes Yes /override/classes/Product.php:393
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 7070
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.7 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 46209
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.7 8 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2349
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.7 12 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 932
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.7 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 12584
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.6 15 Yes /override/classes/Product.php:659
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` = 932
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
2.6 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
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
2.6 15 Yes /modules/advancetopmenu/advancetopmenu.php:1086
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 623
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.5 17 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 565
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.5 19 Yes /override/classes/Product.php:659
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` = 932
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
2.5 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.5 602 /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 = 1775
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.5 16 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE `name`, GROUP_CONCAT(value ORDER BY `fv`.`position` SEPARATOR ", ") AS `value`, `pf`.`id_feature`
FROM ps_feature_product `pf`
LEFT JOIN ps_feature_lang `fl` ON (`fl`.`id_feature` = `pf`.`id_feature` AND `fl`.`id_lang` = 1)
LEFT JOIN ps_feature_value_lang `fvl` ON (`fvl`.`id_feature_value` = `pf`.`id_feature_value` AND `fvl`.`id_lang` = 1)
LEFT JOIN ps_feature `f` ON `f`.`id_feature` = `pf`.`id_feature`
LEFT JOIN ps_feature_value `fv` ON `fv`.`id_feature_value` = `pf`.`id_feature_value`
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4986
GROUP BY `name`, pf.`id_feature`
ORDER BY f.`position` ASC
2.4 14 Yes /override/classes/Product.php:659
SELECT SQL_NO_CACHE hs.`id_categoryslider_slides` as id_slide,
hssl.`image`,
hss.`position`,
hss.`id_category`,
hss.`active`,
hssl.`title`,
hssl.`url`,
hssl.`legend`,
hssl.`description`
FROM ps_categoryslider hs
LEFT JOIN ps_categoryslider_slides hss ON (hs.id_categoryslider_slides = hss.id_categoryslider_slides)
LEFT JOIN ps_categoryslider_slides_lang hssl ON (hss.id_categoryslider_slides = hssl.id_categoryslider_slides)
WHERE (id_shop = 1) AND hss.`id_category` = 14
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
2.4 1 Yes /modules/categoryslider/categoryslider.php:715
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` = 932
AND p.`active` = 1
AND p.`publication_time` < now()
GROUP BY t.`id_post`
2.2 1 Yes Yes /modules/advanceblog/models/BlogPosts.php:846
INSERT INTO ps_express_cache 
(page_id, page_url, id_currency, id_language, id_country, id_shop, 
cache, cache_size, hits, miss, hit_time,
miss_time, entity_type, id_entity, is_mobile, last_updated, customer_groups)
VALUES ('7c72c757876a1caa6e7962551402d314', 'https://www.bookovka.com.ua/biznes-dengi-ekonomika/932-ezhednevnik-metod-gleba-arhangelskogo-podarochnyj-datirovannyj-2014.html', 1, 
1, 216, 1,'7c72c757876a1caa6e7962551402d3141121610', 31949,
0, 1, 0, 1573547630, 'product', 932, 0,'2019-11-12 08:33:50','')
ON DUPLICATE KEY UPDATE miss = miss + 1,
last_updated ='2019-11-12 08:33:50',
cache = '7c72c757876a1caa6e7962551402d3141121610', cache_size = 31949,
miss_time = ((miss_time*miss) + 1573547630.095) / (miss + 1)
2.1 1 /override/classes/controller/FrontController.php:280
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
2 140 /classes/module/Module.php:277
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.7 338 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.4 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 932 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.3 1 Yes /classes/Product.php:3608
SELECT SQL_NO_CACHE 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 140 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.2 140 /classes/module/Module.php:277
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` = 932
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:3523
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 10418
1 3 /classes/Product.php:2625
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 932 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.9 1 Yes /classes/Product.php:3608
SHOW TABLES LIKE 'ps_order_synchronization_stores';
0.9 1 /modules/bookworks/bookworks.php:285
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 46209) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes /classes/SpecificPrice.php:362
show tables like "ps_sesliders_slideconf"
0.8 1 /modules/homesliderpro/homesliderpro.php:1218
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` = 932
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.8 1 Yes Yes /classes/Product.php:3523
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 140 /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` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.8 1 Yes /classes/SpecificPrice.php:419
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 = 932
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.8 0 /classes/Product.php:1282
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.7 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE 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` = 932
ORDER BY `position`
0.7 1 Yes /classes/Product.php:2731
SELECT SQL_NO_CACHE distinct
id,
name,
link
FROM
ps_order_synchronization_stores;
0.7 1 /modules/bookworks/bookworks.php:296
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=40 AND id_shop IN (1) LIMIT 1
0.7 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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.7 1 /classes/shop/Shop.php:202
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` = 932) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
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 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.7 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.bookovka.com.ua' OR su.domain_ssl = 'www.bookovka.com.ua')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.7 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE 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.7 4 /classes/Currency.php:470
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.6 1 /classes/Language.php:892
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_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.6 20 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE 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` = 932
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.6 1 /modules/productcomments/ProductComment.php:168
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 = 932)
AND ll.`id_shop` = 1
AND pl.`id_lang` = 1
0.6 1725 /modules/seosaproductlabels/classes/ProductLabelLocation.php:103
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` = 932
0.6 1 /classes/Product.php:5703
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.6 194 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 1
0.6 9 /classes/Employee.php:452
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
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 = 932
AND product_shop.active = 1 LIMIT 1
0.5 1 /classes/Meta.php:259
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.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 932)
0.5 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 46209) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.5 1 Yes /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 14 Yes Yes /classes/Category.php:859
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 *
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.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10418) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 216, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 216) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-12 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 16
AND c.nright >= 53
AND c.nleft >= 2
AND c.nright <= 541
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.5 9 Yes /classes/Tools.php:1335
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1775) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 2
0.5 11 /classes/Employee.php:452
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` = 932
0.5 1 /classes/Product.php:5703
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7070) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 113090) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2350) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
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.5 1 /classes/Language.php:777
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.5 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeBottomContent'
AND `id_shop` = 1 LIMIT 1
0.4 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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` = 14) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) 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` = 623) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
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 <= 16
AND c.nright >= 53
AND c.nleft >= 2
AND c.nright <= 541
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.4 9 Yes /classes/Tools.php:1335
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2349) AND (b.`id_shop` = 1) LIMIT 1
0.4 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.4 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` = 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.4 1 /Adapter/Adapter_EntityMapper.php:61
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.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 10) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "expresscache" LIMIT 1
0.4 1 /classes/module/Module.php:2568
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` = 14
AND cscl.id_lang = 1 AND csc.`active` = 1
ORDER BY csc.position
0.4 1 Yes /modules/oviccategorysizechart/oviccategorysizechart.php:610
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayHomeTopContent'
AND `id_shop` = 1 LIMIT 1
0.4 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayBeforeLogo'
AND `id_shop` = 1 LIMIT 1
0.4 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "product" LIMIT 1
0.4 1 /classes/Theme.php:275
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 = 932 LIMIT 1
0.4 1 /classes/Product.php:756
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.4 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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` = 932) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9405c352066b2fe7282158bd9de91622' AND cache_id="socialsharing_header|932|1|1|1|216" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
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.4 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` = 932)
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 = 932)
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.4 1 Yes /modules/productcomments/ProductCommentCriterion.php:176
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.4 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 565) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 932
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.4 0 /classes/Product.php:1282
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` = 932 AND ctg.`id_group` = 1 LIMIT 1
0.4 8 /classes/Product.php:4927
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.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pc.`id_product_comment`,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, 
IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `ps_product_comment` pc
LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 932 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
0.4 1 Yes /modules/productcomments/ProductComment.php:114
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='decdf88a4a788b4af162c7152c7c751a' AND cache_id="module|1|166|product" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
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`=932
0.4 1 /classes/Tag.php:205
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.4 1 /classes/Product.php:3008
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.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.4 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.4 87 /classes/Hook.php:187
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.4 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.4 1 /classes/ObjectModel.php:1458
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` = 932
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.4 1 /modules/productcomments/ProductComment.php:168
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.4 1 /classes/Meta.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 46209 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:5043
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` = 932
ORDER BY `position`
0.4 1 Yes /classes/Product.php:2731
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.4 2 /modules/seosaproductlabels/classes/ProductLabelLocation.php:137
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 915998
AND `date_add` > '2019-11-12 10:03:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.4 1 Yes /classes/Connection.php:138
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 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d6cb5f10cdad1ace4033e7df4cfe2e33' AND cache_id="2|1|1|1|216" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
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.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayNav'
AND `id_shop` = 1 LIMIT 1
0.3 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2019-11-12 00:00:00' AND '2019-11-12 23:59:59' LIMIT 1
0.3 1 /classes/SpecificPrice.php:302
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.3 1 /classes/Product.php:4481
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3504601f8762180cfa264dc585bac135' AND cache_id="blockbestsellers-col|1|1|1|216" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10418)
0.3 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 1
0.3 9 /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` = 2350)
0.3 1 /classes/Product.php:3008
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.3 1 /classes/Product.php:4481
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 = 2350
0.3 1 /classes/Product.php:4481
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.3 1 /classes/Theme.php:275
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 = 932
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.3 0 /classes/Product.php:1282
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.3 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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 (932)
0.3 1 /modules/crossselling/crossselling.php:133
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE p.`id_profile`, `name`
FROM `ps_profile` p
LEFT JOIN `ps_profile_lang` pl ON (p.`id_profile` = pl.`id_profile` AND `id_lang` = 1)
ORDER BY `id_profile` ASC
0.3 7 /classes/Profile.php:57
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 113090)
0.3 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 6
0.3 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 623)
0.3 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
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.3 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 = 113090
0.3 1 /classes/Product.php:4481
SELECT SQL_NO_CACHE e.`id_included_product`, pl.`name`
FROM `ps_seosaproductlabels_included` e
JOIN `ps_product` p ON e.`id_included_product` = p.`id_product`
JOIN `ps_product_lang` pl ON pl.`id_product` = p.`id_product`
WHERE e.`id_product_label` = 25 AND pl.`id_lang` = 1
0.3 1 /modules/seosaproductlabels/classes/ProductLabel.php:226
SELECT SQL_NO_CACHE 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`=932
0.3 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 113090 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4986)
0.3 1 /classes/Product.php:3008
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 = 932
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.3 0 /classes/Product.php:1282
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`=932
0.3 1 /classes/Tag.php:205
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.3 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE app.`id_pack`
FROM `ps_pm_advancedpack` app
0.3 298 /modules/pm_advancedpack/AdvancedPack.php:717
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.3 1 /classes/Country.php:173
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 7070)
0.3 1 /classes/Product.php:3008
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.3 5 /modules/seosaproductlabels/classes/ProductLabelLocation.php:205
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `left` FROM `ps_ovic_options_sidebar` WHERE `page` ='product' AND `id_shop`=1 LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:528
SELECT SQL_NO_CACHE *
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 932
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
0.3 1 Yes /modules/productcomments/ProductComment.php:136
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 = 2349 LIMIT 1
0.3 1 /classes/Product.php:756
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 4
0.3 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.3 1 /classes/Country.php:173
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` = 46209)
0.3 1 /classes/Product.php:3008
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.3 1 /classes/Product.php:3008
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 2
0.3 11 /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` = 565)
0.3 1 /classes/Product.php:3008
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 (932)
0.3 1 /modules/crossselling/crossselling.php:133
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 32) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product_videos WHERE id_product = 932 AND id_shop = 1 ORDER BY position ASC
0.3 1 Yes /modules/productvideo/productvideo.php:1153
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(14,31,32,33,49,86,111,156),
sc.`id_category` = 14) AND l.active = 1
0.3 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:120
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` = 2349)
0.3 1 /classes/Product.php:3008
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.3 22 Yes /modules/themeconfigurator/themeconfigurator.php:375
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 4986
0.3 1 /classes/Product.php:4481
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 = 932
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.3 0 /classes/Product.php:1282
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 25) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE (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` = 932
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.3 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2019-11-12 00:00:00' AND '2019-11-12 23:59:59' LIMIT 1
0.3 1 /classes/SpecificPrice.php:306
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.3 1 Yes /classes/Language.php:717
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=41 AND id_shop IN (1) LIMIT 1
0.3 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=144 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE l.*, ss.id_supplier, sl.text
FROM ps_seosaproductlabels_supplier ss
LEFT JOIN `ps_seosaproductlabels` AS l ON l.id_product_label = ss.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl ON l.id_product_label = sl.id_product_label
WHERE l.active = 1 AND sl.id_lang = 1
0.3 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:154
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.3 1 /classes/Image.php:471
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=245 AND id_shop IN (1) LIMIT 1
0.3 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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` = 33) AND (b.`id_shop` = 1) LIMIT 1
0.3 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 = 565
0.3 1 /classes/Product.php:4481
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 = 10418 LIMIT 1
0.3 1 /classes/Product.php:756
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.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 932
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=142 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2a8b85a36dcd9f24acdad9b38a80b6e7' AND cache_id="productscategory|932|14|1|1|1|216" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 2350 LIMIT 1
0.3 1 /classes/Product.php:756
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.3 287 /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` = 932
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.3 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="932"
0.3 1 /modules/jsoxActuals/jsoxActuals.php:960
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.3 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 = 46209
0.3 1 /classes/Product.php:4481
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 = 932
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-12 00:00:00",
INTERVAL 14 DAY
)
) > 0
0.3 0 /classes/Product.php:1282
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 = 2349
0.3 1 /classes/Product.php:4481
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=262 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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 = 10418
0.3 1 /classes/Product.php:4481
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 234 AND `id_shop` = 1 LIMIT 1
0.3 1 /classes/module/Module.php:2218
UPDATE `ps_smarty_lazy_cache`
SET filepath='crossselling/productfooter/932/1/1/1/216/aa/47/d9/aa47d9bf0230474685f2e2b9a4363005036ece33.crossselling.tpl.php'
WHERE `template_hash`='5720213ea87badac62b374f650d55767' AND cache_id="crossselling|productfooter|932|1|1|1|216" AND compile_id=""
0.3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=98 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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 = 623
0.3 1 /classes/Product.php:4481
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` = 137) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 156) AND (b.`id_shop` = 1) LIMIT 1
0.3 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` = 17 AND
id_lang = 1 AND active = 1
ORDER BY  ti.`position` ASC
0.3 34 Yes /modules/advancetopmenu/advancetopmenu.php:1064
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` = 20 AND
id_lang = 1 AND active = 1
ORDER BY  ti.`position` ASC
0.3 34 Yes /modules/advancetopmenu/advancetopmenu.php:1064
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=225 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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.3 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
0.3 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` = 19 AND
id_lang = 1 AND active = 1
ORDER BY  ti.`position` ASC
0.3 34 Yes /modules/advancetopmenu/advancetopmenu.php:1064
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.3 1 /classes/Product.php:756
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:672
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.3 1 /classes/Product.php:756
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d6cb5f10cdad1ace4033e7df4cfe2e33' AND cache_id="5|1|1|1|216" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=263 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 3
0.3 1 /classes/Employee.php:452
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`=932
0.3 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=226 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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.3 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 16) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_product_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.3 1 /classes/Product.php:4481
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 932 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 138
0.3 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_items` ti
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (ti.`id_item` = til.`id_item`)
WHERE `id_block` = 18 AND
id_lang = 1 AND active = 1
ORDER BY  ti.`position` ASC
0.3 34 Yes /modules/advancetopmenu/advancetopmenu.php:1064
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.3 1 /Adapter/Adapter_EntityMapper.php:61
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.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 932 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 932
AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=67 AND id_shop IN (1) LIMIT 1
0.3 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=189 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.3 1 /classes/Country.php:173
SELECT SQL_NO_CACHE * FROM `ps_seosaproductlabels` WHERE 1
0.3 7 /modules/seosaproductlabels/classes/ProductLabel.php:173
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 = 932
0.3 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:183
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=69 AND id_shop IN (1) LIMIT 1
0.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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.3 1 /classes/Product.php:4481
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.3 153 /classes/Tab.php:296
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` = 932
AND image_shop.`cover` = 1 LIMIT 1
0.3 1 /classes/Product.php:2753
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 5
0.3 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`='da94bb4019a72806a5645b6cc213274d' AND cache_id="socialsharing|932|1|1|1|216" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
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.3 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = 'PS_LOCALE_LANGUAGE'
0.3 1 /modules/prestasms/includes/model/hooks.php:1
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`=932
0.3 1 /classes/Tag.php:205
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`=932
0.3 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE id_hook, conf FROM `ps_sesliders_slideconf`
WHERE `id_shop` = 1
0.3 2 /modules/homesliderpro/homesliderpro.php:402
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 5
0.3 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`='9c0255de0bab8c3575d241741c3ec678' AND cache_id="ovicstoremap|1|1|1|216" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_ovic_options_hook_module` ohm
WHERE ohm.`id_option` = 1 AND ohm.`hookname` = 'displayTop'
AND `id_shop` = 1 LIMIT 1
0.3 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
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 = 623 LIMIT 1
0.3 1 /classes/Product.php:756
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 932
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
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`=932)
0.2 1 /modules/pm_advancedpack/AdvancedPack.php:740
SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 932 AND `validate` = 1
AND `grade` > 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:260
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 *
FROM `ps_employee`
WHERE `id_profile` = 7
0.2 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="932"
0.2 1 /modules/jsoxActuals/jsoxActuals.php:960
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_image_type`
0.2 11 /classes/ImageType.php:143
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 `id_category` FROM `ps_category_product`
WHERE `id_product` = 4966
0.2 24 /classes/Product.php:2625
SELECT SQL_NO_CACHE COUNT(`id_option`) FROM `ps_ovic_options` WHERE `id_option` = 1 LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:355
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 932
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 932 AND `id_shop` = 1
0.2 1 /Adapter/Adapter_EntityMapper.php:68
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_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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='67903573c48e5f6d9e5f1de5c2db99cd' AND cache_id="ovicblockcms|3|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9af9b650934813ef9489f7016891fc43' AND cache_id="brandsslider|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 135
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
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:175
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.2 1 /classes/Group.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` = 136
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1
0.2 1 /classes/Image.php:471
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 COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=37 AND id_shop IN (1) LIMIT 1
0.2 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2019-11-12 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 932 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:327
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.2 287 /modules/oviclayoutcontrol/oviclayoutcontrol.php:594
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 6
0.2 1 /classes/Employee.php:452
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 = 565 LIMIT 1
0.2 1 /classes/Product.php:756
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.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 2350
0.2 9 /classes/Product.php:2625
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:756
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="932"
0.2 1 /modules/report_product_availability/report_product_availability.php:87
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.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 7
0.2 1 /classes/Employee.php:452
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 c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'UAH') LIMIT 1
0.2 4 /classes/Currency.php:319
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 932 LIMIT 1
0.2 1 /classes/Page.php:77
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.2 1 /classes/Image.php:471
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'cart_default' LIMIT 1
0.2 1 /classes/Image.php:471
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:756
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 932 AND `validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 932
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 = 4986 LIMIT 1
0.2 1 /classes/Product.php:756
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="932"
0.2 1 /modules/report_product_availability/report_product_availability.php:107
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 5
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 1775 LIMIT 1
0.2 1 /classes/Product.php:756
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 = 46209 LIMIT 1
0.2 1 /classes/Product.php:756
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 4
0.2 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=245 AND id_shop IN (1) LIMIT 1
0.2 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 113090
0.2 3 /classes/Product.php:2625
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 294 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 8
0.2 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 932 AND `validate` = 1
AND `grade` > 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:260
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "jsoxActuals" LIMIT 1
0.2 1 /classes/module/Module.php:2568
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` = 932
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE s.*, til.`title` FROM `ps_advance_topmenu_sub` s
LEFT JOIN `ps_advance_topmenu_items_lang` til ON (s.`id_parent` = til.`id_item`)
LEFT JOIN `ps_advance_topmenu_main_shop` tms ON (s.`id_parent` = tms.`id_item`)
WHERE til.`id_lang` = 1
AND id_shop = 1 AND active = 1 AND s.`id_parent` = 134
0.2 7 /modules/advancetopmenu/advancetopmenu.php:1047
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2350) 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 `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 2388 LIMIT 1
0.2 1 /classes/Category.php:1054
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('915998', '1142', '65261721', '', '1', '1', '2019-11-12 10:33:49')
0.2 1 /classes/ObjectModel.php:487
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10418) 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 avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 932
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=69 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='1922ad2240c4a1b8b28fa7b3e931bb97' AND cache_id="advancefooter|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `index_image_css` `index`, `product_image_css` `product`, `category_image_css` `category`
FROM `ps_seosaproductlabels` WHERE `id_product_label` = 25 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabel.php:207
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=169 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2350
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 14
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5720213ea87badac62b374f650d55767',"crossselling|productfooter|932|1|1|1|216","", FROM_UNIXTIME(1573547629))
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`='5720213ea87badac62b374f650d55767' AND cache_id="crossselling|productfooter|932|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=70 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 1775
0.2 8 /classes/Product.php:2625
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=169 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=245 AND id_shop IN (1) LIMIT 1
0.2 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 3
0.2 1 /classes/Employee.php:452
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.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4966
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 2349
0.2 5 /classes/Product.php:2625
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.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10418 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2019-11-12 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 932 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:327
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 623) 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 id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.2 1 /classes/Page.php:96
SELECT SQL_NO_CACHE *
FROM `ps_employee`
WHERE `id_profile` = 8
0.2 1 /classes/Employee.php:452
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10418
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_excluded_product`
FROM `ps_seosaproductlabels_excluded`
WHERE `id_product_label` = 25 AND `id_excluded_product` = 932 LIMIT 1
0.2 0 /modules/seosaproductlabels/classes/ProductLabel.php:233
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=68 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 216
0.2 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 113090 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 14 LIMIT 1
0.2 0 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 565) 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 cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 19 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 113090
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2019-11-12 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 932 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:327
SELECT SQL_NO_CACHE `id_product_download`
FROM `ps_product_download`
WHERE `id_product` = 932
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1
0.2 0 /classes/ProductDownload.php:183
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 46209
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE * FROM ps_jsoxActualsParams WHERE pid="932"
0.2 1 /modules/report_product_availability/report_product_availability.php:107
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=134 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
UPDATE `ps_smarty_lazy_cache`
SET filepath='crossselling/productfooter/932/1/1/1/216/aa/47/d9/aa47d9bf0230474685f2e2b9a4363005036ece33.crossselling.tpl.php'
WHERE `template_hash`='5720213ea87badac62b374f650d55767' AND cache_id="crossselling|productfooter|932|1|1|1|216" AND compile_id=""
0.2 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=91 AND id_shop IN (1) LIMIT 1
0.2 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=63 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4966 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 12584
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 7070
0.2 5 /classes/Product.php:2625
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 159 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2218
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` = 13 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 932
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2349
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2019-11-12 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 932 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:327
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2349) 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 `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2350 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=26 AND id_shop IN (1) LIMIT 1
0.2 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 4986
0.2 11 /classes/Product.php:2625
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d6cb5f10cdad1ace4033e7df4cfe2e33' AND cache_id="6|1|1|1|216" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4986 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2019-11-12 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 932 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:327
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 4
ORDER BY  `position` ASC
0.2 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4966 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
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.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 623
0.2 11 /classes/Product.php:2625
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
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.2 1 /classes/stock/StockAvailable.php:380
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.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 7070
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 932
0.2 8 /classes/Product.php:2625
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=262 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4986
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 10
AND `active` = 1 LIMIT 1
0.2 1 /override/classes/Manufacturer.php:239
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 5
ORDER BY  `position` ASC
0.2 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 46209
0.2 8 /classes/Product.php:2625
SELECT SQL_NO_CACHE DATEDIFF(`date_add`, DATE_SUB("2019-11-12 00:00:00",
INTERVAL 14 DAY)) > 0 AS new
FROM `ps_product_shop` WHERE id_product = 932 LIMIT 1
0.2 1 /modules/seosaproductlabels/classes/ProductLabelLocation.php:327
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 565
0.2 7 /classes/Product.php:2625
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=91 AND id_shop IN (1) LIMIT 1
0.2 0 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 14 LIMIT 1
0.2 1 /classes/Category.php:1477
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=28 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 18 LIMIT 1
0.2 1 /classes/Category.php:1054
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
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 623
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
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.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 46209) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5720213ea87badac62b374f650d55767',"crossselling|productfooter|932|1|1|1|216","", FROM_UNIXTIME(1573547629))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 12584
0.2 5 /classes/Product.php:2625
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 7
ORDER BY  `position` ASC
0.2 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2349 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=28 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 565
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1775
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 3 LIMIT 1
0.2 1 /classes/Supplier.php:192
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=69 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=72 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 623 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=169 AND id_shop IN (1) LIMIT 1
0.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
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.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 3
ORDER BY  `position` ASC
0.2 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
0.2 1 /classes/Category.php:1477
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 104 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 1
ORDER BY  `position` ASC
0.2 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5720213ea87badac62b374f650d55767',"crossselling|productfooter|932|1|1|1|216","", FROM_UNIXTIME(1573547629))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2350 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE * FROM `ps_advance_topmenu_blocks`
WHERE `id_sub` = 2
ORDER BY  `position` ASC
0.2 6 Yes /modules/advancetopmenu/advancetopmenu.php:1028
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 932) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 623 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1775 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 565 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 12584 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 7070 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5043
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10418 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 7070 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1775 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.2 1 /classes/ObjectModel.php:1376
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 565 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
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.2 1 /modules/oviclayoutcontrol/oviclayoutcontrol.php:995
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 46209 AND `id_group` = 1 LIMIT 1
0.2 0