Zara

نمایش 1 تا 12 از 5422 مورد

برند زارا

برند زارا زیر مجموعه ای از شرکت ایندیتکس است . این برند اسپانیایی در سال 1941 توسط آمانسیو اورتگا تاسیس شد. این برند کار خود را ابتدا از یک مغازه فروش لباس ارزان قیمت در اسپانیا شروع کرد . در همان ابتدا از این برند استقبال وسیعی گردید و به همین علت به مرور در همه جای اسپانیا شعب متعددی تاسیس کرد. از سال 1980 برند زارا فروش جهانی خود را آغاز کرد . امروزه کمتر کشوری را می توانید پیدا کنید که برند زارا در آن شعبه نداشته باشد.

محصولات زارا

برند زارا از جمله برند های فست فشن محسوب می شود . چرا که تنوع و سرعت تولید در این برند بسیار بالاست . این برند با بیش از 20 هزار مدل متنوع لباس زنانه ، لباس بچه گانه ، لباس مردانه هم محصولات خود را به صورت حضوری و هم به صورت آن آنلاین به فروش می رساند. از جمله محصولات این برند کفش زارا ، کیف زارا ، لباس زارا و عطر زارا است . محصولات زارا از لحاظ کیفیت ، سطح متوسط رو به بالا را دارند و مورد انتخاب بسیاری از شیک پوشان در سراسر دنیا هستند.

خرید محصولات زارا

تنوع محصولات زارا بسیار زیاد است .  شما با هر سلیقه ای می توانید از این برند خرید انجام دهید اما به صورت کلی می توان گفت سبک این برند رسمی ، کلاسیک ، مینیمال ، استایلیش و شیک است . اگر طرفدار استایل های هیپ هاپ و یا تینیجری هستید شاید این برند زیاد مناسب شما نباشد.

جنس محصولات زارا عمدتا از الیاف طبیعی است . این برند کیف و کفش هایی از جنس پوست طبیعی نیز دارد اما بسیاری از محصولات این برند از پارچه های چرم مصنوعی تهیه و تولید می شوند.

خرید کفش زارا

یکی از آیتم های محصولات زارا کفش زارا است. کفش زارا کیفیت بالایی دارد و از جمله برند های خوب در تولید کفش است . این برند مدل های متنوع جذابی را در نیوکالکشن خود دارد که منطبق با ترند های روز دنیا است.

خرید کتونی زارا
خرید بوت زارا
خرید صندل زارا

خرید عطر زارا

عطر زنانه زارا بسیار محبوب و مورد پسند خانم ها است. بهترین عطر زارا در زیر نوشته شده است.عطر زارا ارجینال خود برند زارا بوده و ماندگاری نسبتا مناسبی دارد. عطر زارا به دو دسته ادوپرفیوم و ادوتویلت تقسیم بندی می شود. مدل های ادو پرفیوم آن محبوبیت بالاتری دارد.

قیمت زارا ارکید
قیمت زارا گاردنیا
قیمت زارا تیوبرز
قیمت زارا فم

خرید ادکلن زارا

ادکلن مردانه زارا نیز مدل های متنوعی دارد . مدل های پرطرفدار ادکلن مردانه زارا شامل موارد زیر است:

قیمت زارا سیلور
قیمت زارا گلد

خرید کیف زارا

برند زارا مدل های متنوعی از کیف را تولید میکند. کیف زارا مدل های متنوعی دارد . برخی از مدل های کیف زارا از جنس چرم است.برخی دیگر از جنس حصیری است.

خرید لباس زارا

پالتو زارا
شلوار زارا
بلوز زارا
بافت زارا
کاپشن زارا

قیمت محصولات زارا در ایران

همانطور که اشاره شد در ابتدا برند زارا از برند های ارزان به حساب می آمد اما به خصوص در چند سال اخیر شاهد یک تغییر استراتژی در قیمت محصولات زارا هستیم .زارا که پیش از این برندی بازاری و ارزان به حساب می آمد الان در رده برند های نسبتا گران قرار گرفته است بخصوص برای ما ایرانیان که با توجه به افزایش قیمت دلار شاهد افزایش قیمت محصولات زارا هستیم.

نمایندگی زارا در ایران

متاسفانه برند زارا در ایران نمایندگی رسمی ندارد. لذا خرید و تهیه محصولات زارا کمی با دشواری رو به روست .در بازار ایران بسیار شاهد این موضوع هستیم که بعضی از تولیدی ها محصولات خود را با تگ و برند زارا به فروش می رسانند . این محصولات کاملا تقلبی هستند . برای صحت سنجی از اصالت محصولات ارجینال زارا می توانید شماره مرجع یا به اصطلاح کد محصول کالا را که هم روی تگ محصول و هم تگ دوخته شده به محصول نوشته شده است را در سایت زارا و یا گوگل جستجو کنید و عکس کالا را با محصول تطبیق دهید. در صورتی که کد رفرنس با کالا تطابق داشت محصول اصلی و ارجینال است. فروشگاه اینترنتی شیک پوش کالکشن کامل و جدید زارا را به صورت ماهانه در سایت خود به روز رسانی می کند تا بتوانید با خیال راحت محصول مورد نظر و ارجینال خود را خریداری کنید.

زارا برای کدام کشور است؟

همانگونه که بالاتر گفته شد برند زارا زیر مجموعه شرکت ایندیتکس است. این شرکت یک شرکت اسپانیایی است به همین دلیل برند زارا اسپانیایی حساب می شود.

بیشترکمتر نشان دادن

تنظیمات

منو

یک حساب کاربری رایگان برای ذخیره موارد مورد علاقه ایجاد کنید.

ورود
Load Time 1727 ms
Querying Time 928 ms
Queries 1264
Memory Peak Usage 36.3 Mb
Included Files 987 files - 14.81 Mb
PrestaShop Cache - Mb
Global vars 0.24 Mb
PrestaShop Version 8.1.2
PHP Version 8.1.27
MySQL Version 10.6.16-MariaDB-0ubuntu0.22.04.1-log
Memory Limit 2048M
Max Execution Time 1800s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 93.687 ms 93.687 ms 6.07 Mb 6.9 Mb
__construct 0.527 ms 94.214 ms - Mb 7.0 Mb
init 59.671 ms 153.885 ms 0.42 Mb 7.0 Mb
checkAccess 0.002 ms 153.887 ms - Mb 7.0 Mb
setMedia 12.738 ms 166.625 ms 0.20 Mb 7.7 Mb
postProcess 0.001 ms 166.626 ms - Mb 7.7 Mb
initHeader 0.001 ms 166.627 ms - Mb 7.7 Mb
initContent 1222 ms 1389 ms 9.80 Mb 16.5 Mb
initFooter 0.002 ms 1389 ms - Mb 16.5 Mb
display 338.352 ms 1727 ms 19.15 Mb 36.3 Mb
Hook Time Memory Usage
displayLeftColumn 158.634 ms 14.36 Mb
DisplayHeader 65.181 ms 0.65 Mb
ActionStAssemble 61.112 ms 2.09 Mb
DisplaySideBar 20.118 ms 0.22 Mb
DisplayBreadcrumb 16.686 ms 0.03 Mb
DisplayBeforeBodyClosingTag 11.886 ms 0.52 Mb
displayTop 7.189 ms 0.14 Mb
DisplayRightBar 6.484 ms 0.08 Mb
DisplayMobileBarLeft 5.817 ms 0.25 Mb
DisplayMobileBar 4.918 ms 0.04 Mb
displayMobileNav 4.773 ms 0.03 Mb
ActionFrontControllerSetMedia 4.683 ms 0.02 Mb
displayBanner 2.318 ms 0.07 Mb
Header 2.265 ms 0.01 Mb
DisplayManufacturerHeader 1.825 ms 0.02 Mb
displayFullWidthTop 1.666 ms 0.05 Mb
DisplayFooter 1.359 ms 0.09 Mb
displayBeforeBodyClosingTag 1.308 ms 0.02 Mb
DisplayTop 1.273 ms 0.07 Mb
DisplayLeftColumn 1.024 ms 0.01 Mb
DisplayFooterAfter 0.992 ms 0.02 Mb
DisplayMobileNav 0.960 ms 0.01 Mb
DisplayWrapperTop 0.714 ms 0.03 Mb
DisplayMobileBarCenter 0.698 ms - Mb
DisplayMobileBarBottom 0.647 ms - Mb
ActionProductSearchAfter 0.578 ms 0.01 Mb
displayFullWidthBottom 0.441 ms 0.04 Mb
ActionDispatcherBefore 0.398 ms 0.01 Mb
ModuleRoutes 0.360 ms 0.08 Mb
ActionOutputHTMLBefore 0.246 ms - Mb
ActionObjectAddBefore 0.162 ms 0.02 Mb
OverrideMinimalPurchasePrice 0.057 ms - Mb
displayFooterBefore 0.022 ms - Mb
ActionDispatcher 0.021 ms - Mb
OverrideLayoutTemplate 0.008 ms - Mb
DisplayFullWidthBottom 0.007 ms - Mb
FilterProductSearch 0.005 ms - Mb
37 hook(s) 386.835 ms 18.98 Mb
Module Time Memory Usage
stblog 7.572 ms - Mb
fsadvancedurl 3.473 ms 0.09 Mb
psy_paymenthelper 72.134 ms 2.13 Mb
ranginesmspresta 1.277 ms 0.07 Mb
ps_mbo 14.728 ms 0.12 Mb
ps_emailalerts 2.839 ms 0.16 Mb
pssitemap 4.359 ms 0.08 Mb
supertinymcepro 4.136 ms 0.02 Mb
stthemeeditor 28.352 ms 0.63 Mb
ps_googleanalytics 6.917 ms 0.33 Mb
stcustomersignin 7.155 ms 0.12 Mb
stmultilink 13.139 ms 0.03 Mb
stshoppingcart 12.301 ms 0.18 Mb
stswiper 21.417 ms 0.13 Mb
steasycontent 33.844 ms 0.18 Mb
stfeaturedslider 2.793 ms 0.02 Mb
stfeaturedcategories 3.190 ms 0.02 Mb
sthomenew 2.528 ms 0.03 Mb
stbanner 7.980 ms 0.03 Mb
stspecialslider 2.737 ms 0.02 Mb
stblogrecentarticles 2.603 ms 0.02 Mb
stbestsellers 2.585 ms 0.02 Mb
stblogrelatedarticles 1.955 ms 0.02 Mb
stcountdown 2.474 ms 0.02 Mb
sthoverimage 5.493 ms 0.03 Mb
stinstagram 22.445 ms 0.10 Mb
stlovedproduct 30.454 ms 0.06 Mb
stcompare 16.985 ms 0.05 Mb
stnotification 9.549 ms 0.12 Mb
stpagebanner 19.114 ms 0.05 Mb
stproductcategoriesslider 14.288 ms 0.06 Mb
strelatedproducts 2.554 ms 0.02 Mb
stsidebar 49.474 ms 0.48 Mb
ststickers 72.157 ms 1.73 Mb
stvideo 16.000 ms 0.03 Mb
stviewedproducts 11.793 ms 0.03 Mb
stblogeditor 3.129 ms 0.03 Mb
stblogfeaturedarticles 2.013 ms 0.02 Mb
stmegamenu 7.213 ms 0.18 Mb
stbrandsslider 2.292 ms 0.02 Mb
stowlcarousel 6.970 ms 0.04 Mb
spinwheel 3.500 ms - Mb
crisp 2.641 ms 0.02 Mb
stblogcomments 1.221 ms 0.07 Mb
stsearchbar 8.282 ms 0.06 Mb
psy_managerhelper 5.593 ms 0.46 Mb
referralbyphone 3.686 ms 0.09 Mb
ps_categorytree 160.501 ms 14.37 Mb
statsdata 5.504 ms 0.21 Mb
49 module(s) 745.339 ms 22.65 Mb

Stopwatch SQL - 1264 queries

# Query Time (ms) Rows Filesort Group By Location
92
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
, 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,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-02-28 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_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_manufacturer` m
ON (m.`id_manufacturer` = p.`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  )JOIN `ps_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` =1)JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_manufacturer` = 7
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY p.`date_add` desc
LIMIT 0,12
613.524 ms 63072 Yes Yes /classes/Manufacturer.php:499
329
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_manufacturer = 7 AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND EXISTS (
SELECT 1
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` =1
)
45.080 ms 347652864 /classes/Manufacturer.php:430
2
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.803 ms 3108 /classes/Configuration.php:180
599
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 293
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
4.305 ms 147 Yes /modules/ps_categorytree/ps_categorytree.php:166
105
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.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.052 ms 880 /classes/Hook.php:456
14
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
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_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` != "paymentOptions") 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`
1.890 ms 273 Yes Yes /classes/Hook.php:1233
104
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.607 ms 0 /classes/Hook.php:1292
83
SELECT SQL_NO_CACHE * 
from information_schema.TABLES 
where TABLE_SCHEMA='shikpous_p8' and TABLE_NAME like '%st_instagram_bind'
1.494 ms 0 /modules/stinstagram/stinstagram.php:3293
330
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-02-28 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (503594,503564,503556,503553,503548,503547,503546,503545,503544,503543,503506,503505)
1.343 ms 12 /classes/ProductAssembler.php:95
581
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_notification` snl
INNER JOIN ps_st_notification_shop st_notification_shop
ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = 1)
LEFT JOIN `ps_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`)
WHERE snl.`active`=1 AND snll.`id_lang` = 1 
ORDER BY snl.`position`
0.886 ms 1 Yes /modules/stnotification/classes/StNotificationClass.php:213
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
0.839 ms 1018 /classes/Hook.php:1332
582
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_sidebar` snl
INNER JOIN ps_st_sidebar_shop st_sidebar_shop
ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = 1)
LEFT JOIN `ps_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`)
WHERE snll.`id_lang` = 1 AND snl.`active`=1 
ORDER BY snl.`location`, snl.`position`
0.802 ms 7 Yes /modules/stsidebar/classes/StSidebarClass.php:116
1240
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_sidebar` snl
INNER JOIN ps_st_sidebar_shop st_sidebar_shop
ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = 1)
LEFT JOIN `ps_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`)
WHERE snll.`id_lang` = 1 AND snl.`active`=1 
ORDER BY snl.`location`, snl.`position`
0.770 ms 7 Yes /modules/stsidebar/classes/StSidebarClass.php:116
545
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` = 503564
ORDER BY `position`
0.718 ms 6 Yes /classes/Product.php:3545
548
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` = 503556
ORDER BY `position`
0.689 ms 5 Yes /classes/Product.php:3545
1263
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_notification` snl
INNER JOIN ps_st_notification_shop st_notification_shop
ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = 1)
LEFT JOIN `ps_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`)
WHERE snl.`active`=1 AND snll.`id_lang` = 1 
ORDER BY snl.`position`
0.667 ms 1 Yes /modules/stnotification/classes/StNotificationClass.php:213
86
SELECT SQL_NO_CACHE s.*, sl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `ps_st_sticker` s
LEFT JOIN `ps_st_sticker_lang` sl ON (s.`id_st_sticker` = sl.`id_st_sticker` AND sl.`id_lang` = 1)
LEFT JOIN `ps_st_sticker_shop` ss ON (s.`id_st_sticker` = ss.`id_st_sticker`)
WHERE ss.`id_shop` = 1 AND s.`active`=1  AND s.`type` IN (1,2,3,4,5,6,7)
ORDER BY s.`position` ASC, s.`id_st_sticker`
0.658 ms 6 Yes /modules/ststickers/classes/StStickersClass.php:165
589
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
0.636 ms 1 /classes/CartRule.php:418
574
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (16475910, 16475911, 16475912, 16475913, 16475914, 16475915) AND il.`id_lang` = 1 ORDER by i.`position`
0.627 ms 60 Yes /classes/Product.php:2921
1242
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.615 ms 1 /classes/ObjectModel.php:622
551
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` = 503553
ORDER BY `position`
0.605 ms 5 Yes /classes/Product.php:3545
56
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.576 ms 158 /classes/module/Module.php:345
1223
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16475910,16475911,16475912,16475913,16475914,16475915)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.563 ms 12 /classes/Product.php:2752
1249
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`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 cp.`id_product` IN (503594,503564,503556,503553,503548,503547,503546,503545,503544,503543,503506,503505) AND cl.`id_lang` = 1
ORDER BY c.`level_depth` DESC
0.558 ms 39 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
577
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (16475890, 16475891, 16475892, 16475893, 16475894) AND il.`id_lang` = 1 ORDER by i.`position`
0.538 ms 35 Yes /classes/Product.php:2921
1179
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
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` = 503594
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
0.537 ms 4 Yes Yes /classes/Product.php:2734
40
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.517 ms 2 Yes /classes/Currency.php:709
331
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 503594 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.516 ms 3 Yes /classes/Image.php:284
590
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
0.494 ms 1 /classes/CartRule.php:418
109
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503594 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503594 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.491 ms 0 /classes/Cart.php:1410
496
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 503543 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
0.491 ms 4 Yes /classes/Image.php:284
569
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` = 503543
ORDER BY `position`
0.480 ms 4 Yes /classes/Product.php:3545
0
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 = 'shikpoush.com' OR su.domain_ssl = 'shikpoush.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.467 ms 1 Yes /classes/shop/Shop.php:1364
98
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` = 503594) AND (b.`id_shop` = 1) LIMIT 1
0.460 ms 1 /src/Adapter/EntityMapper.php:71
61
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1
0.457 ms 57 /classes/CartRule.php:418
359
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 2 LIMIT 1
0.456 ms 1 /classes/Category.php:1582
25
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.441 ms 158 /classes/module/Module.php:345
1184
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
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` = 503564
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
0.441 ms 4 Yes Yes /classes/Product.php:2734
603
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 4 AND c.`nright` >= 5 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.439 ms 3 /classes/Category.php:1597
1
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.432 ms 1 Yes /classes/shop/Shop.php:715
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
0.430 ms 1018 /classes/Hook.php:1292
114
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 503594
AND pac.`id_product_attribute` = 16476500
AND agl.`id_lang` = 1
0.424 ms 1 /classes/Product.php:7506
133
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 503564
AND pac.`id_product_attribute` = 16476457
AND agl.`id_lang` = 1
0.422 ms 1 /classes/Product.php:7506
33
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.421 ms 158 /classes/module/Module.php:345
111
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 16476500
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503594 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 16476500
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503594 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.420 ms 0 /classes/Cart.php:1410
332
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` = 503594) LIMIT 1
0.420 ms 1 /src/Adapter/EntityMapper.php:71
356
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` = 503564) LIMIT 1
0.419 ms 1 /src/Adapter/EntityMapper.php:71
19
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.414 ms 158 /classes/module/Module.php:345
354
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` = 503594
ORDER BY `position`
0.411 ms 3 Yes /modules/stthemeeditor/stthemeeditor.php:5411
578
SELECT SQL_NO_CACHE s.*, sl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `ps_st_sticker` s
LEFT JOIN `ps_st_sticker_lang` sl ON (s.`id_st_sticker` = sl.`id_st_sticker` AND sl.`id_lang` = 1)
LEFT JOIN `ps_st_sticker_shop` ss ON (s.`id_st_sticker` = ss.`id_st_sticker`)
WHERE ss.`id_shop` = 1 AND s.`active`=1  AND s.`type` IN (1,2,3,4,5,6,7)
ORDER BY s.`position` ASC, s.`id_st_sticker`
0.411 ms 6 Yes /modules/ststickers/classes/StStickersClass.php:165
1180
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16476500,16476501,16476502,16476503)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.409 ms 4 /classes/Product.php:2752
26
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.406 ms 158 /classes/module/Module.php:345
482
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` = 503544) LIMIT 1
0.406 ms 1 /src/Adapter/EntityMapper.php:71
557
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` = 503547
ORDER BY `position`
0.404 ms 5 Yes /classes/Product.php:3545
566
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` = 503544
ORDER BY `position`
0.401 ms 5 Yes /classes/Product.php:3545
27
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.400 ms 67 Yes /classes/Dispatcher.php:655
572
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` = 503506
ORDER BY `position`
0.399 ms 10 Yes /classes/Product.php:3545
1246
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('793254', '17', '751324508', '', '1', '1', '2024-02-28 12:48:56')
0.399 ms 1 /classes/ObjectModel.php:622
1239
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
0.392 ms 1 /classes/CartRule.php:418
554
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` = 503548
ORDER BY `position`
0.391 ms 4 Yes /classes/Product.php:3545
1209
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16476377,16476378,16476379,16476380,16476381)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.384 ms 5 /classes/Product.php:2752
391
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 52 AND c.`nright` >= 65 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.379 ms 147 Yes /classes/Category.php:1597
93
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` = 503594
AND image_shop.`cover` = 1 LIMIT 1
0.378 ms 3 /classes/Product.php:3570
1190
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16476426,16476427,16476428,16476429,16476430,16476431,16476432,16476433)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.376 ms 8 /classes/Product.php:2752
185
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503548 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503548 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.373 ms 0 /classes/Cart.php:1410
550
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (16476426, 16476427, 16476428, 16476429, 16476430, 16476431, 16476432, 16476433) AND il.`id_lang` = 1 ORDER by i.`position`
0.368 ms 8 Yes /classes/Product.php:2921
413
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 26 AND c.`nright` >= 27 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.368 ms 14 /classes/Category.php:1597
152
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 503556
AND pac.`id_product_attribute` = 16476426
AND agl.`id_lang` = 1
0.366 ms 1 /classes/Product.php:7506
563
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` = 503545
ORDER BY `position`
0.365 ms 8 Yes /classes/Product.php:3545
1087
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 250 AND c.`nright` >= 251 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.363 ms 24 Yes /classes/Category.php:1597
378
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` = 503556) LIMIT 1
0.362 ms 1 /src/Adapter/EntityMapper.php:71
376
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` = 503564
ORDER BY `position`
0.361 ms 6 Yes /modules/stthemeeditor/stthemeeditor.php:5411
113
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
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 AND fl.id_lang = 1)
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 = 503594
ORDER BY f.position ASC
0.360 ms 1 Yes /classes/Product.php:5993
128
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503564 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503564 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.359 ms 0 /classes/Cart.php:1410
575
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` = 503505
ORDER BY `position`
0.358 ms 7 Yes /classes/Product.php:3545
1222
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
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` = 503506
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
0.356 ms 6 Yes /classes/Product.php:2734
216
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` = 503546) AND (b.`id_shop` = 1) LIMIT 1
0.356 ms 1 /src/Adapter/EntityMapper.php:71
282
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 16476371
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503543 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 16476371
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503543 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.355 ms 0 /classes/Cart.php:1410
361
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 2 AND c.`nright` >= 293 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.355 ms 1 Yes /classes/Category.php:1597
560
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` = 503546
ORDER BY `position`
0.355 ms 3 Yes /classes/Product.php:3545
204
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503547 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503547 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.353 ms 0 /classes/Cart.php:1410
1185
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16476457,16476458,16476459,16476460)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.353 ms 4 /classes/Product.php:2752
187
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 16476384
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503548 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 16476384
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503548 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.352 ms 0 /classes/Cart.php:1410
190
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 503548
AND pac.`id_product_attribute` = 16476384
AND agl.`id_lang` = 1
0.351 ms 1 /classes/Product.php:7506
121
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` = 503564) AND (b.`id_shop` = 1) LIMIT 1
0.350 ms 1 /src/Adapter/EntityMapper.php:71
1241
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
0.350 ms 1 /classes/CartRule.php:418
859
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 135 AND c.`nright` >= 136 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.349 ms 147 Yes /classes/Category.php:1597
347
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 3 AND c.`nright` >= 96 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.348 ms 2 /classes/Category.php:1597
1204
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
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` = 503547
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
0.348 ms 1 Yes Yes /classes/Product.php:2734
510
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` = 503543
ORDER BY `position`
0.347 ms 4 Yes /modules/stthemeeditor/stthemeeditor.php:5411
17
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.347 ms 158 /classes/module/Module.php:345
130
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 16476457
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503564 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 16476457
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503564 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.346 ms 0 /classes/Cart.php:1410
352
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 28 AND c.`nright` >= 29 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.346 ms 15 /classes/Category.php:1597
396
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 53 AND c.`nright` >= 54 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.344 ms 147 Yes /classes/Category.php:1597
338
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
0.343 ms 1 /classes/Category.php:2239
1214
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
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` = 503544
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
0.342 ms 1 Yes Yes /classes/Product.php:2734
1198
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
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` = 503553
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
0.341 ms 3 Yes Yes /classes/Product.php:2734
1019
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 216 AND c.`nright` >= 217 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.341 ms 147 Yes /classes/Category.php:1597
1247
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('447612', '', 'shikpoush.com/zara', '', '2024-02-28 12:48:56')
0.341 ms 1 /classes/ObjectModel.php:622
571
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (16476371, 16476372, 16476373, 16476374, 16476375) AND il.`id_lang` = 1 ORDER by i.`position`
0.340 ms 5 Yes /classes/Product.php:2921
483
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 503544 AND `id_shop` = 1
0.338 ms 1 /src/Adapter/EntityMapper.php:79
1199
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16476421,16476422,16476423)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.338 ms 3 /classes/Product.php:2752
209
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 503547
AND pac.`id_product_attribute` = 16476383
AND agl.`id_lang` = 1
0.338 ms 1 /classes/Product.php:7506
171
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 503553
AND pac.`id_product_attribute` = 16476421
AND agl.`id_lang` = 1
0.337 ms 1 /classes/Product.php:7506
811
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 111 AND c.`nright` >= 112 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.336 ms 147 Yes /classes/Category.php:1597
87
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "spinwheel" LIMIT 1
0.335 ms 1 /classes/module/Module.php:2636
739
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 75 AND c.`nright` >= 76 AND c.`nleft` >= 2 AND c.`nright` <= 293 ORDER BY `nleft` DESC
0.335 ms 147 Yes /classes/Category.php:1597
398
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` = 503556
ORDER BY `position`
0.334 ms 5 Yes /modules/stthemeeditor/stthemeeditor.php:5411
59
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
0.333 ms 1 /classes/Cart.php:4192
1217
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16476371,16476372,16476373,16476374,16476375)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.333 ms 5 /classes/Product.php:2752
223
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503546 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503546 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.332 ms 0 /classes/Cart.php:1410
206
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 16476383
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503547 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 16476383
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503547 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.331 ms 0 /classes/Cart.php:1410
1231
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (16475890,16475891,16475892,16475893,16475894)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
0.331 ms 10 /classes/Product.php:2752
525
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` = 503506
ORDER BY `position`
0.330 ms 10 Yes /modules/stthemeeditor/stthemeeditor.php:5411
63
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
0.329 ms 1 /classes/CartRule.php:418
242
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503545 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 503545 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.328 ms 0 /classes/Cart.php:1410
672
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` = 362) AND (b.`id_shop` = 1) LIMIT 1
0.328 ms 1 /src/Adapter/EntityMapper.php:71
60
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2024-02-28 00:00:00" AND date_to <= "2024-02-28 23:59:59") OR (date_from >= "2024-02-28 00:00:00" AND date_from <= "2024-02-28 23:59:59") OR (date_from < "2024-02-28 00:00:00" AND date_to > "2024-02-28 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
0.326 ms 58 /classes/CartRule.php:357