2=3 на всі креми для рук 🌷

-20% на кожен другий товар в чеку ❤️

SALE до -65% ✨

Безкоштовна доставка від 1200 грн ✨

Україна

Меню

Пошук

0 Кошик

Знижки

Кабінет

Головна

Догляд за обличчям

Креми для обличчя

3 товарів

-60%

(4)

Крем для обличчя Rich Moisture

950 ₴

-20% на кожен другий товар в чеку

Сонцезахисний крем SPF 30 PA+++

850 ₴

-20% на кожен другий товар в чеку

Зволожувальний гель-крем Boosting Hydrator X10

(17)

Зволожувальний гель-крем Boosting Hydrator X10

990 ₴

Креми для обличчя

Правильний догляд – ключовий фактор у підтримці здорової та молодої шкіри. Крем – головний компонент догляду. Він зволожує або живить, а також є ефективним захисним бар'єром від факторів навколишнього середовища. Ще одне завдання гарного крему – профілактика проти старіння, зменшення мімічних зморшок та інших ознак передчасного старіння.

Це все може бути один склад чи кілька засобів вузькопрофільного призначення.

Ключ до вибору найкращого крему для обличчя полягає в інгредієнтах. Вибирати потрібний засіб необхідно з урахуванням конкретних потреб. Те, що підходить вашій подрузі, може не підходити вам. Ми допоможемо вам розібратися, як вибрати потрібний крем для обличчя з урахуванням типу та стану шкіри, віку, косметичних проблем.

Подивитись повну версію тексту

Як вибрати відповідний крем для обличчя

Є кілька критеріїв вибору хорошого крему для обличчя.

Тип шкіри

Підбирати крем для догляду за обличчям потрібно з урахуванням типу шкіри. Вона може бути:

сухою;
чутливою;
жирною, схильною до проблем;
комбінованою.

Виробники пропонують для кожного типу шкіри окремі склади, що відрізняються інгредієнтами. Наприклад, для сухої шкіри добре підходять зволожуючі креми для обличчя. Для чутливої – засоби зі щадними інгредієнтами, які не викликають алергії та подразнення. Дівчатам із жирною проблемною шкірою потрібен крем, який регулюватиме виділення шкірного сала, пригнічуватиме патогенну мікрофлору. Людям з комбінованим типом шкіри рекомендовано використання відповідних засобів на різних зонах обличчя.

Вік

Перш ніж купити крем для обличчя, переконайтеся, що він схожий вам за віком. Дівчатам у 20 років потрібні одні засоби. Для них важливе зволоження. А зрілим жінкам у 45-50 років – інші. Шкіра з ознаками в'янення потребує посиленого живлення- у складі повинні бути корисні поживні компоненти.

Проблеми

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

Для в'ялої шкіри, що в'яне, підійде професійний крем для обличчя на основі гіалуронової кислоти.
Тим, чия шкіра схильна до прищів, рекомендують уникати покупки зволожуючих засобів із комедогенними інгредієнтами, які закупорюють пори. Замість них вибирайте склади, які дезінфікують шкіру, знижуючи ризик появи прищів.
При виражених мімічних та вікових зморшках потрібен крем, який поверне шкірі тонус.

Пора року

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

Час доби

Денні креми захищають, нічні косметичні засоби – живлять та відновлюють. Вони мають різні завдання, тому використовуйте їх з урахуванням призначення.

Склад

Не менш важливим є вибір інгредієнтів. Навчіться читати етикетку. Так ви зможете за кілька хвилин зрозуміти, як працюватиме крем. Наприклад, гіалуронова кислота зволожує, а антиоксиданти допомагають шкірі виглядати свіжою та здоровою. Важливо уникати агресивних хімікатів, синтетичних ароматизаторів та спиртів, які можуть пересушувати шкірний покрив, викликати подразнення. Загалом пріоритет – натуральні компоненти. Інноваційні технології дозволяють отримати висококонцентровані екстракти із природної сировини. Вони безпечніші, краще працюють, ніж синтетичні аналоги.

На що ще звернути увагу при виборі крему для обличчя

Важливим є аромат. Після нанесення крем буде буквально поруч із вашим носом весь день. Тому його аромат дуже важливий.

Який крем найкращий?

Найкращим вважається правильно підібраний крем гарної якості. Нішеві виробники, на відміну від мас маркету, пропонують склади з ексклюзивними дорогими компонентами. І хоч ціна її вища, така косметика краще "працює", виконуючи свої завдання, тому це вибір людей, для яких справді важливе здоров'я та краса шкіри.

Важливо: Дуже часто жінки через нетерпіння викидають хороший крем. Щоб побачити видимі результати від нового крему для обличчя, може знадобитися від шести до восьми тижнів. Тому не поспішайте робити висновки після кількох використань. При цьому обов'язково варто змінити крем якнайшвидше, якщо після використання косметичного засобу ви відчуваєте поколювання, свербіж, спостерігаєте почервоніння.

Деякі рекомендації щодо використання крему для обличчя

Щоб крем міг проникнути у шкіру та почати працювати, його потрібно наносити на свіжовимиту, вологу шкіру. Косметику краще наносити м'якими масажними рухами. Зверніть увагу до правил зберігання відкритої банки, їх виробник прописує на етикетці.

Крем для обличчя від Sister's Aroma: особливості

Бренд нішевої косметики та парфумерії Sister's Aroma пропонує кілька ефективних засобів для догляду за шкірою обличчя. Популярні засоби лінійки:

Зволожуючий гель-крем Boosting Hydrator x10 50 ml

Цей крем відразу після нанесення зволожує шкіру на 58%. Цей склад підходить всім типів шкіри. Він швидко і глибоко поглинається, впливаючи на шкірний покрив на клітинному рівні. Суху шкіру зволожує крем, зменшуючи втрату вологи. Для нормальної шкіри він може працювати як базова косметика. Крем покращить стан жирної шкіри без навантаження, зменшуючи виділення шкірного сала. На віковій шкірі крем активує вироблення колагену. На чутливій він відновлює шкірний бар'єр.

Крем Rich Moisture Cream 50 ml

Цей крем інтенсивно зволожує, посилює захисний бар'єр, підвищує пружність та еластичність шкірного покриву. ферментовані лактобактерії, що входять до складу, відновлюють місцевий імунітет, попереджаючи появу прищів. Комплекс гіалуронової кислоти утримує вологу, попереджаючи сухість та лущення. Олія Ши інтенсивно живить шкірний покрив, попереджаючи передчасне старіння. Засіб добре підходить дівчатам із сухою та комбінованою шкірою.

Сонцезахисний крем Daily SUN CREAM SPF 30PA+++

Цей засіб може бути використаний як повноцінна база під макіяж. Його особливість він не просто зволожує, але захищає шкіру від УФ, при цьому не перешкоджаючи засмагу. Рейтинг засобу у категорії професійних кремів SPF дуже високий.

Будь-який із перерахованих засобів ви можете замовити в офіційному інтернет-магазині бренду. При купівлі оптом пропонуємо хорошу знижку. Доставка по Києву кур'єрською службою, по Україні - поштовою компанією.

Приховати повну версію тексту

Каталог

Інформація

/ ua

Каталог

SALE

НОВИНКИ

Бестселери

Ключові категоріі

2=3 на аромати для дому та рефіли

Парфуми

Парфуми 100 мл

Парфуми 50 мл

Парфуми 10 мл

Колекція парфумів Fresh Drop

Всі парфуми

Святкові подарункові набори

Набори на новосілля

Набори для неї

Набори для нього

Набори в подорож

Набори на день народження

Всі набори

SISTER’S SPORT

Спортивний одяг

Спортивний інвентар

SS x Green Chef

Аксесуари для волосся

Всі спортивні товари

PERFUME MARKET

Догляд за обличчям до -65%

Парфуми для дому

Аромати для дому

Колекція парфумів для дому Voyage

Alcohol collection

Room Spray

Рефіли

Міні парфуми

Догляд за тілом

Креми для рук

Лосьйони для тіла

Гелі для душу

Інтим догляд

Мило для рук

Всі товари по догляду за тілом

Догляд за обличчям

Креми для обличчя

Сироватки і місти

Гелі для вмивання

Всі товари для догляду за обличчям

Декоративна косметика

Догляд за губами

Догляд за бровами

Туші для вій

Вся декортивна косметика

Аксесуари

Догляд для тварин

Сертифікати

Регіон

Україна

Світ

Польща

Мова

Українська

Русский

ВАШ РЕГІОН

YOUR COOKIE PREFERENCES

Continue without accepting

WELCOME TO eu.sistersaroma.com

Sister's Aroma Malletier use cookies, including third-party cookies, for functional reasons, for statistical analysis, to personalise your experience, offer you content that targets your particular interests and analyse the performance of our advertising campaigns.

You can either accept these cookies by clicking "Accept and Continue’, or click "Set cookie preferences’ to set your preferences.

What is a cookie?

A cookie is a small text file that is stored in a dedicated location on your computer, tablet, smartphone or other device when you use your browser to visit an online service. A cookie allows its sender to identify the device on which it is stored during the period of validity of consent, which does not exceed 13 months.

You may accept or reject the cookies listed below using the check box provided.

Functional cookies(non-optional)

These cookies are required for optimum operation of the website, and cannot be configured. They allow us to offer you the key functions of the website (language used, display resolution, account access, shopping bag, wish list, etc.), provide you with online advice and secure our website against any attempted fraud.

Statistical analysis cookies

These cookies are used to measure and analyse our website audience (visitor volume, pages viewed, average browsing time, etc.) to help us improve its performance. By accepting these cookies, you are helping us to improve our website.

Cookies to personalise the Sister's Aroma experience

These cookies allow us to provide you with online or in-store recommendations of products, services and content that match your expectations and preferences. By accepting these cookies, you are opting for an enriched and personalised experience.

Advertising and social media cookies

These cookies are used for Sister's Aroma advertisements displayed on third-party websites, including social media, and are tailored to your preferences and to help us measure the effectiveness of our advertising campaigns. If you refuse these cookies, advertising (including ours) will continue to be displayed as you browse the Internet, although they will not be specific to your personal interests, and will therefore be less relevant.

You can change your preferences at any time by going to the "Cookies" module or to the "Privacy Policy" sub-section of the "LEGAL & PRIVACY" section. They are accessible through links at the bottom of any eu.sistersaroma.com website page.

See the list of cookies used on our site

For more information on our cookie policy, please click here

Messages Timeline Exceptions Views79 Route Queries31 Models345 Mails Gate Session Request

8.0.29100ms9MBGET {url}

Booting (9.8ms)
Application (90.32ms)
1 x Application (90.2%)
90.32ms
1 x Booting (9.79%)
9.80ms

79 templates were rendered

front.pages.catalog (resources/views/front/pages/catalog.blade.php)15blade


seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory

front.shared.header (resources/views/front/shared/header.blade.php)20blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text

front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)23blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop

front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)23blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop
value
type

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop
value
type

front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)23blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop

front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)23blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop
value
type

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop
value
type

front.shared.menu (resources/views/front/shared/menu.blade.php)23blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop

front.shared.mobHeadLine (resources/views/front/shared/mobHeadLine.blade.php)23blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop

front.shared.mobBottomLine (resources/views/front/shared/mobBottomLine.blade.php)23blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
top_text
__currentLoopData
text
loop

front.components.catalogHeader (resources/views/front/components/catalogHeader.blade.php)19blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory

front.components.productList (resources/views/front/components/productList.blade.php)19blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory

front.shared.cardItem (resources/views/front/shared/cardItem.blade.php)2blade
Params
0
key
1
item
front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.btnFavorites (resources/views/front/shared/cardItem/btnFavorites.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.photo (resources/views/front/shared/cardItem/photo.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.reviews (resources/views/front/shared/cardItem/reviews.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.prise (resources/views/front/shared/cardItem/prise.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.label (resources/views/front/shared/cardItem/label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.buttonBay (resources/views/front/shared/cardItem/buttonBay.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem (resources/views/front/shared/cardItem.blade.php)2blade
Params
0
key
1
item
front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.btnFavorites (resources/views/front/shared/cardItem/btnFavorites.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.photo (resources/views/front/shared/cardItem/photo.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.reviews (resources/views/front/shared/cardItem/reviews.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.prise (resources/views/front/shared/cardItem/prise.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.label (resources/views/front/shared/cardItem/label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.buttonBay (resources/views/front/shared/cardItem/buttonBay.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem (resources/views/front/shared/cardItem.blade.php)2blade
Params
0
key
1
item
front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.btnFavorites (resources/views/front/shared/cardItem/btnFavorites.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.photo (resources/views/front/shared/cardItem/photo.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.reviews (resources/views/front/shared/cardItem/reviews.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.prise (resources/views/front/shared/cardItem/prise.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.label (resources/views/front/shared/cardItem/label.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item
front.shared.cardItem.buttonBay (resources/views/front/shared/cardItem/buttonBay.blade.php)6blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
key
5
item

front.shared.productCarouselViewed (resources/views/front/shared/productCarouselViewed.blade.php)19blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory

front.shared.seoText (resources/views/front/shared/seoText.blade.php)19blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory

front.components.catalogFilter (resources/views/front/components/catalogFilter.blade.php)19blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory

front.shared.footer (resources/views/front/shared/footer.blade.php)20blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
type

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
type

front.svg.mastercard (resources/views/front/svg/mastercard.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.svg.visa (resources/views/front/svg/visa.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.svg.privat (resources/views/front/svg/privat.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.shared.mobileModal (resources/views/front/shared/mobileModal.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.svg.globe (resources/views/front/svg/globe.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.shared.mobileModalTabCatalog (resources/views/front/shared/mobileModalTabCatalog.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.shared.mobileModalTabInfo (resources/views/front/shared/mobileModalTabInfo.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.shared.mobileModalTabRegion (resources/views/front/shared/mobileModalTabRegion.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
type

front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
type

front.modals.login (resources/views/front/modals/login.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalLoginSMS (resources/views/front/modals/modalLoginSMS.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalVerificationCode (resources/views/front/modals/modalVerificationCode.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalMiles (resources/views/front/modals/modalMiles.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalPreOrder (resources/views/front/modals/modalPreOrder.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalBuyOneClick (resources/views/front/modals/modalBuyOneClick.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalReportAvailability (resources/views/front/modals/modalReportAvailability.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.passwordRecovery (resources/views/front/modals/passwordRecovery.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.yourRegion (resources/views/front/modals/yourRegion.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.cardModal (resources/views/front/modals/cardModal.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.shared.card (resources/views/front/shared/card.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
sale_status

front.shared.checkont.promoInputsWrap (resources/views/front/shared/checkont/promoInputsWrap.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
sale_status

front.shared.productCarouselViewedCart (resources/views/front/shared/productCarouselViewedCart.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
sale_status

front.modals.giftModal (resources/views/front/modals/giftModal.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalGetDiscount (resources/views/front/modals/modalGetDiscount.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalSubscription (resources/views/front/modals/modalSubscription.blade.php)31blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
systemDescription

front.modals.modalSubscriptionSuccess (resources/views/front/modals/modalSubscriptionSuccess.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.modals.modalCookie (resources/views/front/modals/modalCookie.blade.php)30blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

front.layouts.app (resources/views/front/layouts/app.blade.php)20blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
alternate

front.components.canonical (resources/views/front/components/canonical.blade.php)24blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
alternate
isDisable
locale
path
disablePaths

front.components.alternate (resources/views/front/components/alternate.blade.php)24blade


__env
app
errors
__sentry_tracing_view_name
seo_type
parent
slag
banner
catalog
categorie_id
filter
catalogSlid
products
menu_categories
menu_pages
store
countries
languages
productsHistory
alternate
isDisable
locale
path
disablePaths

uri: GET {url}
middleware: web, ChekStore, RemoveSelfLinks, UrlRedirect
controller: App\Http\Controllers\CatalogController@index
namespace: App\Http\Controllers
prefix
where
as: catalog
file: app/Http/Controllers/CatalogController.php:42-169

31 statements were executed, 3 of which were duplicated, 28 unique46.29ms

select `code`, `domen`, `systems_store`.`store_id`, (SELECT `code` FROM `language` WHERE `id` = systems_store.language_default) as language_default from `systems_store` left join `store_language` on `store_language`.`store_id` = `systems_store`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` where (SELECT `code` FROM `language` WHERE `id` = systems_store.language_default) <> `language`.`code` OR `systems_store`.`store_id`  = 4

3.43ms/app/Services/SiteDetector/FakeSiteDetector.php:34sistersaroma

Metadata
Backtrace	14. /app/Services/SiteDetector/FakeSiteDetector.php:34 15. /app/Providers/AppServiceProvider.php:42 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:873 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851

select distinct `language_id`, IF(language_default = language.id,"/",CONCAT("/",code,"/")) as url from `store_language` left join `systems_store` on `systems_store`.`store_id` = `store_language`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` where (`store_language`.`store_id` = 1 and `language`.`id` = 1) limit 1

790μsmiddleware::ChekStore:82sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	15. middleware::ChekStore:82 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 19. middleware::ChekStore:83 20. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167

select IFNULL(CONCAT(products.id,"_",products_options.option_id,"_",products_options.value_id),CONCAT(products.id,"_","_")) as id, IFNULL(CONCAT(products.id,"_",products_options.option_id,"_",products_options.value_id),CONCAT(products.id,"_","_")) as product_id, `products_descriptions`.`name`, `products_options`.`option_id`, `products_options`.`value_id`, `products`.`type_product`, IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, `products`.`sort` as `index`, `products_descriptions`.`name` as `alt`, IFNULL(products_options.articl,(SELECT vendor FROM `products_store` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` LIMIT 1)) as articl , concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) LIMIT 1),"/",`products_store`.`url`,"/") as link, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as category, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as item_list_name, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) as category_id, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) as item_list_id, (SELECT `pl_available` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) LIMIT 1) as pl_available, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` =  "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, "0" as quantity, "₴" as currency, IFNULL(
(SELECT `sell_id` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `sale_id` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1)
) as sell_id, IFNULL(products_options.weight,products_store.weight) as weight, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price, IFNULL(
(SELECT `bonus` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1),
(SELECT `bonus` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
) as bonus, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax, ROUND(IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
)) as sell_price, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "cart" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"") as cart, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover from `products` left join `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` left join `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` = 1)) left join `products_store` on `products_store`.`product_id` = `products`.`id` where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1) and 1 <> 1 group by IFNULL(CONCAT(products.id,"_",products_options.option_id,"_",products_options.value_id),CONCAT(products.id,"_","_"))

1.6ms/app/Models/Product.php:829sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1
Backtrace	12. /app/Models/Product.php:829 13. /app/Models/Product.php:1107 14. middleware::ChekStore:126 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 16. /app/Http/Middleware/ViewData.php:52

select `cross_sale` from `products_store` where 0 = 1 and `products_store`.`store_id` = 1

500μs/app/Models/Product.php:1193sistersaroma

Metadata
Bindings	0. 1
Backtrace	14. /app/Models/Product.php:1193 15. /app/Models/Product.php:1109 16. middleware::ChekStore:126 17. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 18. /app/Http/Middleware/ViewData.php:52

select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product = 4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECT COUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as item_list_name, (SELECT AVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECT COUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` =  "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  ORDER BY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` left join `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` left join `products_store` on `products_store`.`product_id` = `products`.`id` left join `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` = 1)) left join `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` = 1)) where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1 and `products_store`.`available` = 1 and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) > 0) and 0 = 1 and (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1 and IFNUll( IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1)
), 0) <> 0) order by `products_options`.`sort` asc

1.74ms/app/Models/Product.php:959sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1 5. 1 6. 1 7. 0 8. 1 9. 1 10. 1 11. 1 12. 0
Backtrace	12. /app/Models/Product.php:959 13. /app/Models/Product.php:1109 14. middleware::ChekStore:126 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 16. /app/Http/Middleware/ViewData.php:52

select `id`, `name`, `surname`, `patronymic`, `date_birth`, `email`, `phone`, (bonus_ball + (SELECT SUM(amount) FROM `users_bonus_ball` WHERE `user_id` = `users`.`id`  AND date >= "2025-01-05")) as bonus_ball from `users` where `id` = 0 limit 1

680μs/app/Models/User.php:159sistersaroma

Metadata
Bindings	0. 0
Backtrace	15. /app/Models/User.php:159 16. /app/Models/Product.php:1113 17. middleware::ChekStore:126 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. /app/Http/Middleware/ViewData.php:52

select * from `settings_chekout` left join `settings_chekout_store` on `settings_chekout`.`id` = `settings_chekout_store`.`settings_chekout_id` where (`settings_chekout`.`status` = 1 and `settings_chekout_store`.`store_id` = 1 and `settings_chekout_store`.`currency_id` = 2) limit 1

500μs/app/Models/SettingsChekout.php:55sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 2
Backtrace	15. /app/Models/SettingsChekout.php:55 16. /app/Models/Product.php:1135 17. middleware::ChekStore:126 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. /app/Http/Middleware/ViewData.php:52

select count(*) as aggregate from `categories_store` where (`categories_store`.`store_id` = 1 and `categories_store`.`available` = 1 and `categories_store`.`url` = 'krem-dlya-oblichchya')

860μs/app/Http/Controllers/CatalogController.php:50sistersaroma

Metadata

Bindings

0. 1
1. 1
2. krem-dlya-oblichchya

Backtrace

15. /app/Http/Controllers/CatalogController.php:50
16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:29

select *, `categories`.`parent`, `categories_store`.`type` as `type`, `categories_descriptions`.`title` as `title`, `categories_store`.`categorie_id` as `categorie_id`, (SELECT `url` FROM `categories_images` WHERE `type` = "mobail" AND `store_id` = categories_store.store_id AND `categorie_id` = `categories_store`.`categorie_id` LIMIT 1) as urlMobile, (SELECT `url` FROM `categories_images` WHERE `type` = "seo" AND `store_id` = categories_store.store_id AND `categorie_id` = `categories_store`.`categorie_id` LIMIT 1) as seo_url from `categories_store` left join `categories` on `categories`.`id` = `categories_store`.`categorie_id` left join `categories_descriptions` on `categories_descriptions`.`categorie_id` = `categories_store`.`categorie_id` left join `categories_images` on ((`categories_images`.`categorie_id` = categories_store.categorie_id and `categories_images`.`store_id` = 1 and `categories_images`.`type` LIKE 'main')) where (`categories_store`.`store_id` = 1 and `categories_store`.`available` = 1 and `categories_descriptions`.`language_id` = 1 and `categories_descriptions`.`store_id` = 1 and `categories_store`.`url` LIKE 'krem-dlya-oblichchya') limit 1

1.39ms/app/Models/CategorieStore.php:95sistersaroma

Metadata
Bindings	0. 1 1. main 2. 1 3. 1 4. 1 5. 1 6. krem-dlya-oblichchya
Backtrace	16. /app/Models/CategorieStore.php:95 17. /app/Http/Controllers/CatalogController.php:58 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select `categories_descriptions`.`name`, `categories_store`.`url` from `categories_store` left join `categories_descriptions` on `categories_descriptions`.`categorie_id` = `categories_store`.`categorie_id` where `categories_store`.`categorie_id` = 5 and (`categories_store`.`store_id` = 1 and `categories_store`.`available` = 1 and `categories_descriptions`.`language_id` = 1 and `categories_descriptions`.`store_id` = 1) limit 1

490μs/app/Http/Controllers/CatalogController.php:70sistersaroma

Metadata

Bindings

0. 5
1. 1
2. 1
3. 1
4. 1

Backtrace

15. /app/Http/Controllers/CatalogController.php:70
16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:29

select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product = 4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECT COUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as item_list_name, (SELECT AVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECT COUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` =  "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  ORDER BY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` left join `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` left join `products_store` on `products_store`.`product_id` = `products`.`id` left join `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` = 1)) left join `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` = 1)) where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1 and `products_store`.`available` = 1 and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) > 0) and `products`.`id` IN (SELECT `product_id` FROM `products_categories` WHERE `categorie_id` = "27") AND IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) = 0 order by IF(products_status <> 2,IF(
IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  ORDER BY qty DESC LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1)
),0) > 0,1,0),0) ASC, IFNULL(`products_descriptions`.`sort`,99999999) ASC, `products_options`.`sort` asc

13.65ms/app/Models/Product.php:349sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1 5. 1 6. 1 7. 0
Backtrace	12. /app/Models/Product.php:349 13. /app/Http/Controllers/CatalogController.php:72 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select `banners`.`id`, " " as product_id, "1" as sort, "0" as notAddToCard, " " as date, " " as name, " " as item_list_name, " " as item_list_id, " " as title_description, " " as labelType, " " as labelText, " " as value_id, (SELECT url FROM `banners_descriptions` WHERE `banner_id` = banners.id AND `store_id` = "1" AND `language_id` = "1") as link, IF(banners.type = 2,"1","2") as type, (banners_store.sort) as sort_banner, " " as alt, " " as currency, " " as price, " " as sell_price, "1" as quantityMax, (SELECT `image` FROM `banners_images` WHERE `banner_id` = `banners_store`.`banner_id` AND `store_id` = `banners_store`.`store_id` AND `language_id` = 1 AND `type` = "pc" LIMIT 1) as url, (SELECT `image` FROM `banners_images` WHERE `banner_id` = `banners_store`.`banner_id` AND `store_id` = `banners_store`.`store_id` AND `language_id` = 1 AND `type` = "tablet" LIMIT 1) as hover from `banners_store` left join `banners` on `banners_store`.`banner_id` = `banners`.`id` where (`categorie` = 27 and `banners_store`.`status` = 1 and `banners`.`status` = 1 and `banners_store`.`date_start` <= '2025.04.05 14:36' and `banners_store`.`date_finish` >= '2025.04.05 14:36' and `store_id` = 1 and `banners`.`type` = 2) or (`categorie` = 27 and `banners_store`.`status` = 1 and `banners`.`status` = 1 and `banners_store`.`date_start` <= '2025.04.05 14:36' and `banners_store`.`date_finish` >= '2025.04.05 14:36' and `store_id` = 1 and `banners`.`type` = 3)

1.04ms/app/Models/Product.php:400sistersaroma

Metadata
Bindings	0. 27 1. 1 2. 1 3. 2025.04.05 14:36 4. 2025.04.05 14:36 5. 1 6. 2 7. 27 8. 1 9. 1 10. 2025.04.05 14:36 11. 2025.04.05 14:36 12. 1 13. 3
Backtrace	12. /app/Models/Product.php:400 13. /app/Http/Controllers/CatalogController.php:72 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select distinct `banners_images`.`image` as `url` from `banners` left join `banners_store` on `banners_store`.`banner_id` = `banners`.`id` left join `banners_images` on `banners_images`.`banner_id` = `banners`.`id` where (`categorie` = 27 and `banners_store`.`status` = 1 and `banners`.`status` = 1 and `banners_store`.`date_start` <= '2025.04.05 14:36' and `banners_store`.`date_finish` >= '2025.04.05 14:36' and `banners_store`.`store_id` = 1 and `banners_images`.`store_id` = 1 and `banners_images`.`language_id` = 1 and `banners`.`type` = 4 and `banners_images`.`type` = 'pc') order by `banners_store`.`sort` asc limit 1

780μs/app/Models/Banner.php:69sistersaroma

Metadata
Bindings	0. 27 1. 1 2. 1 3. 2025.04.05 14:36 4. 2025.04.05 14:36 5. 1 6. 1 7. 1 8. 4 9. pc
Backtrace	15. /app/Models/Banner.php:69 16. /app/Http/Controllers/CatalogController.php:73 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select distinct `filter_id`, `value_id`, (SELECT `name` FROM `filter_descriptions` WHERE `filter_id` = `products_filter`.`filter_id` AND `language_id` = "1") as filter_name, (SELECT `name` FROM `filter_value_descriptions` WHERE `value_id` = `products_filter`.`value_id` AND `language_id` = "1") as value_name from `products_filter` where (`products_filter`.`status` = 1 and `products_filter`.`store_id` = 1) and `products_filter`.`product_id` IN (SELECT `product_id` FROM `products_categories` WHERE `categorie_id` = "27" AND (SELECT `available` FROM `products_store` WHERE `product_id` = `products_categories`.`product_id` AND `store_id` = "1") = 1)

820μs/app/Models/Filter.php:72sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Models/Filter.php:72 15. /app/Http/Controllers/CatalogController.php:102 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select `id` from `categories` where exists (select * from `categories_store` where `categories`.`id` = `categories_store`.`categorie_id` and (`store_id` = 1 and `available` = 1)) and (`stock` is null and `status` = 1 and `parent` = 0) and `id` not in (select `categories_id` from `categories_role` where `role` = 3 or `role` = '60') and `id` <> 21

670μs/app/Models/Categorie.php:148sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 0 4. 3 5. 60 6. 21
Backtrace	14. /app/Models/Categorie.php:148 15. /app/Http/Controllers/CatalogController.php:114 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `categories_images` where `categories_images`.`categorie_id` in (5, 6, 7, 8, 9, 12, 17, 18, 19, 20, 22, 30, 38, 40, 58, 60, 67, 82, 109, 118, 119, 122, 123, 126) and (`store_id` = 1 and `type` = 'icon')

960μs/app/Models/Categorie.php:148sistersaroma

Metadata
Bindings	0. 1 1. icon
Backtrace	19. /app/Models/Categorie.php:148 20. /app/Http/Controllers/CatalogController.php:114 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `categories_store` where `categories_store`.`categorie_id` in (5, 6, 7, 8, 9, 12, 17, 18, 19, 20, 22, 30, 38, 40, 58, 60, 67, 82, 109, 118, 119, 122, 123, 126) and (`store_id` = 1 and `available` = 1)

550μs/app/Models/Categorie.php:148sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:148 20. /app/Http/Controllers/CatalogController.php:114 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `categories_descriptions` where `categories_descriptions`.`categorie_id` in (5, 6, 7, 8, 9, 12, 17, 18, 19, 20, 22, 30, 38, 40, 58, 60, 67, 82, 109, 118, 119, 122, 123, 126) and (`store_id` = 1 and `language_id` = 1)

1.28ms/app/Models/Categorie.php:148sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:148 20. /app/Http/Controllers/CatalogController.php:114 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select `id`, `parent` from `categories` where exists (select * from `categories_store` where `categories`.`id` = `categories_store`.`categorie_id` and (`store_id` = 1 and `available` = 1)) and (`stock` is null and `status` = 1 and `parent` <> 0) and `id` <> 21

900μs/app/Models/Categorie.php:193sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 0 4. 21
Backtrace	14. /app/Models/Categorie.php:193 15. /app/Http/Controllers/CatalogController.php:114 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `categories_images` where `categories_images`.`categorie_id` in (27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 59, 62, 63, 64, 65, 66, 70, 71, 73, 74, 80, 102, 103, 104, 105, 106, 107, 111, 112, 113, 114, 115, 116, 124, 125) and (`store_id` = 1 and `type` = 'icon')

670μs/app/Models/Categorie.php:193sistersaroma

Metadata
Bindings	0. 1 1. icon
Backtrace	19. /app/Models/Categorie.php:193 20. /app/Http/Controllers/CatalogController.php:114 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `categories_store` where `categories_store`.`categorie_id` in (27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 59, 62, 63, 64, 65, 66, 70, 71, 73, 74, 80, 102, 103, 104, 105, 106, 107, 111, 112, 113, 114, 115, 116, 124, 125) and (`store_id` = 1 and `available` = 1)

1ms/app/Models/Categorie.php:193sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:193 20. /app/Http/Controllers/CatalogController.php:114 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `categories_descriptions` where `categories_descriptions`.`categorie_id` in (27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 59, 62, 63, 64, 65, 66, 70, 71, 73, 74, 80, 102, 103, 104, 105, 106, 107, 111, 112, 113, 114, 115, 116, 124, 125) and (`store_id` = 1 and `language_id` = 1)

2.22ms/app/Models/Categorie.php:193sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:193 20. /app/Http/Controllers/CatalogController.php:114 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select distinct `pages`.`id`, `pages_store`.`url`, `pages_descriptions`.`name` from `pages` left join `pages_store` on `pages_store`.`page_id` = `pages`.`id` left join `pages_descriptions` on `pages_descriptions`.`page_id` = `pages`.`id` where (`pages`.`status` = 1 and `pages_store`.`menu` = 0 and `pages_store`.`available` = 1 and `pages_store`.`store_id` = 1 and `pages_descriptions`.`store_id` = 1 and `pages_descriptions`.`language_id` = 1) order by `pages`.`id` asc

820μs/app/Models/Page.php:65sistersaroma

Metadata
Bindings	0. 1 1. 0 2. 1 3. 1 4. 1 5. 1
Backtrace	14. /app/Models/Page.php:65 15. /app/Http/Controllers/CatalogController.php:115 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select `countries_store`.`id` as `countries_store_id`, `countries`.`id`, `countries_descriptions`.`language_id`, `name`, `name` as `text`, `domen`, `cod`, `systems_store`.`store_id` from `countries_descriptions` left join `countries` on `countries`.`id` = `countries_descriptions`.`country_id` left join `countries_store` on `countries_store`.`country_id` = `countries_descriptions`.`country_id` left join `systems_store` on `systems_store`.`store_id` = `countries_store`.`store_id` where (`countries_descriptions`.`language_id` = 1 and `countries`.`status` = 1 and `countries_store`.`id` <> (SELECT `id` FROM `countries_store` WHERE `country_id` = 68 AND `store_id` = 3)) order by `name` asc

1.29ms/app/Models/CountrieDescription.php:76sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Models/CountrieDescription.php:76 15. /app/Http/Controllers/CatalogController.php:117 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select distinct `language_id`, `name`, `code`, "0" as home, IF(language_default = language.id,1,0) as language_default, IF(language_default = language.id,"",CONCAT("/",code,"/")) as url from `store_language` left join `systems_store` on `systems_store`.`store_id` = `store_language`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` where (`store_language`.`store_id` = 1)

610μs/app/Models/StoreLanguage.php:69sistersaroma

Metadata
Bindings	0. 1
Backtrace	14. /app/Models/StoreLanguage.php:69 15. /app/Http/Controllers/CatalogController.php:118 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product = 4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECT COUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as item_list_name, (SELECT AVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECT COUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` =  "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  ORDER BY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` left join `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` left join `products_store` on `products_store`.`product_id` = `products`.`id` left join `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` = 1)) left join `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` = 1)) where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1 and `products_store`.`available` = 1 and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) > 0) and 0 = 1 and (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1 and IFNUll( IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1)
), 0) <> 0) order by `products_options`.`sort` asc

1.92ms/app/Models/Product.php:959sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1 5. 1 6. 1 7. 0 8. 1 9. 1 10. 1 11. 1 12. 0
Backtrace	12. /app/Models/Product.php:959 13. /app/Http/Controllers/CatalogController.php:119 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `top_texts` where (`store_id` = 1 and `language_id` = 1) order by `sort` desc

650μs/app/Providers/AppServiceProvider.php:175sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Providers/AppServiceProvider.php:175 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91

select count(*) as aggregate from `categories` where (`id` = 17 and `status` = 1 and (SELECT `available` FROM `categories_store` WHERE `categorie_id` = 17 AND `store_id` = "1") = 1)

840μs/app/Providers/AppServiceProvider.php:212sistersaroma

Metadata
Bindings	0. 17 1. 1 2. 1
Backtrace	15. /app/Providers/AppServiceProvider.php:212 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 20. /vendor/laravel/framework/src/Illuminate/View/View.php:120 21. /vendor/laravel/framework/src/Illuminate/View/View.php:91

select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product = 4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECT COUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as item_list_name, (SELECT AVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECT COUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` = 1 AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND  categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` = 1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47"  LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDER BY start DESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND end <= "2025-04-05 14:36:47"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
IFNULL(
(SELECT IF(`type` = 1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` =  "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  ORDER BY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` left join `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` left join `products_store` on `products_store`.`product_id` = `products`.`id` left join `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` = 1)) left join `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` = 1)) where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1 and `products_store`.`available` = 1 and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:36:47" AND end >= "2025-04-05 14:36:47" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) > 0) and 0 = 1 and (`products`.`status` = 1 and `products_descriptions`.`store_id` = 1 and `products_descriptions`.`language_id` = 1 and `products_store`.`store_id` = 1 and IFNUll( IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1"  LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id`  AND `partner_id` = "1" LIMIT 1)
), 0) <> 0) order by `products_options`.`sort` asc

2.05ms/app/Models/Product.php:959sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1 5. 1 6. 1 7. 0 8. 1 9. 1 10. 1 11. 1 12. 0
Backtrace	12. /app/Models/Product.php:959 13. /app/Providers/AppServiceProvider.php:213 14. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120

select * from `systems_descriptions` where (`store_id` = 1 and `language_id` = 1 and `code` = 'popup')

640μs/app/Providers/AppServiceProvider.php:186sistersaroma

Metadata
Bindings	0. 1 1. 1 2. popup
Backtrace	14. /app/Providers/AppServiceProvider.php:186 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91

select concat(IF(code = "ua","uk",code),IF(code = "en" and systems_store.store_id = "3","",alternate)) as hreflang, concat("https://",domen,IF(language_default = language_id,concat("/",categories_store.url,"/"),concat("/",code,"/",categories_store.url,"/"))) as href from `systems_store` left join `store_language` on `store_language`.`store_id` = `systems_store`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` left join `categories_store` on `categories_store`.`store_id` = `systems_store`.`store_id` where (`store_language`.`id` <> '472' and `categories_store`.`categorie_id` = 27 and `categories_store`.`available` = 1) order by `systems_store`.`store_id` asc

950μs/app/Providers/AppServiceProvider.php:123sistersaroma

Metadata
Bindings	0. 472 1. 27 2. 1
Backtrace	14. /app/Providers/AppServiceProvider.php:123 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91

App\Models\SystemDescription: 7
App\Models\System\TopText: 4
App\Models\CountrieDescription: 77
App\Models\Page: 10
App\Models\CategorieDescription: 59
App\Models\CategorieImage: 52
App\Models\Categorie: 59
App\Models\CategorieStore: 61
App\Models\StoreLanguage: 3
App\Models\Admin\SystemStore: 13

_token: lINBYMggkOqS1mP20zihJtK5Z7UTTpwvfA093vhl
cartOrder: Illuminate\Support\Collection {#2275 #items: [] #escapeWhenCastingToString: false }
check_country: false
_previous: array:1 [ "url" => "https://sisterscare.store/krem-dlya-oblichchya" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/krem-dlya-oblichchya/

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im5vOVltUllyYkJWMENVczJYOVRrdXc9PSIsInZhbHVlIjoicVYvZEtZajRMQlpLamFtVUR2Y0NZNEZFRFdaNDlPbkQ5MSs2UjZHOFRucFRJbDRCaUp5ZitTMVJtZ0ZIWVROb0YvT3BTY1YrZWhZdUV6djVabFY2dmZUTWpEcHhKK2hYd3BvbzRFVHJlRHRHS09ITkg3N1A0UWxvdnZXdThkOEgiLCJtYWMiOiJlZDEzZmEzNzA5NDBjZDcxNzhmNzQ5MTk0Mzk2NGVkNjMyY2QzZTJjMzIxNzM4MjEwYjdhZjYwNzhmOWI3ZTc5IiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6ImE2OVFJRWMrbFpEckl6cmJZRUNOVlE9PSIsInZhbHVlIjoiOHRBZ293VUtRaDVkRkkvZ2dtdkMvUkZ1Y1dsVXJrZzRVMFA1R1V5bWJDMlYxQWhFRXk3azZLR1luZ0hkRTdwT0dTS0szUmNUSEtvVUcrQmR6WHloai9JVWUxSk1QL0ZLdHBtSFVBOG8vbG4zOTM2UDFZaVJ4bjB0YWhaNUFmRlkiLCJtYWMiOiIzZDgxNzNiOTZmOTk0NDIzYzI2YmJhYWI5NWMzNjExMGEzOGM4MmI2MDUxNjA3ZGQ2Yjk0ZDgxYzdmYzg2YjA1IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Im5vOVltUllyYkJWMENVczJYOVRrdXc9PSIsInZhbHVlIjoicVYvZEtZajRMQlpLamFtVUR2Y0NZNEZFRFdaNDlPbkQ5MSs2UjZHOFRucFRJbDRCaUp5ZitTMVJtZ0ZIWVROb0YvT3BTY ▶"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "sisterscare.store"
  ]
]

request_server

  0 of 0   
array:51 [▼
  "USER" => "sisters"
  "HOME" => "/home/sisters"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/krem-dlya-oblichchya/"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/krem-dlya-oblichchya/"
  "REMOTE_PORT" => "36850"
  "SCRIPT_FILENAME" => "/home/sisters/www/public/index.php"
  "SERVER_ADMIN" => "admin@sisterscare.store"
  "CONTEXT_DOCUMENT_ROOT" => "/home/sisters/www/public"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/home/sisters/www/public"
  "REMOTE_ADDR" => "3.19.213.242"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "23.88.80.106"
  "SERVER_NAME" => "sisterscare.store"
  "SERVER_SOFTWARE" => "Apache/2.4.37 (centos) OpenSSL/1.1.1k"
  "SERVER_SIGNATURE" => ""
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6Im5vOVltUllyYkJWMENVczJYOVRrdXc9PSIsInZhbHVlIjoicVYvZEtZajRMQlpLamFtVUR2Y0NZNEZFRFdaNDlPbkQ5MSs2UjZHOFRucFRJbDRCaUp5ZitTMVJtZ0ZIWVROb0YvT3BTY1YrZWhZdUV6djVabFY2dmZUTWpEcHhKK2hYd3BvbzRFVHJlRHRHS09ITkg3N1A0UWxvdnZXdThkOEgiLCJtYWMiOiJlZDEzZmEzNzA5NDBjZDcxNzhmNzQ5MTk0Mzk2NGVkNjMyY2QzZTJjMzIxNzM4MjEwYjdhZjYwNzhmOWI3ZTc5IiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6ImE2OVFJRWMrbFpEckl6cmJZRUNOVlE9PSIsInZhbHVlIjoiOHRBZ293VUtRaDVkRkkvZ2dtdkMvUkZ1Y1dsVXJrZzRVMFA1R1V5bWJDMlYxQWhFRXk3azZLR1luZ0hkRTdwT0dTS0szUmNUSEtvVUcrQmR6WHloai9JVWUxSk1QL0ZLdHBtSFVBOG8vbG4zOTM2UDFZaVJ4bjB0YWhaNUFmRlkiLCJtYWMiOiIzZDgxNzNiOTZmOTk0NDIzYzI2YmJhYWI5NWMzNjExMGEzOGM4MmI2MDUxNjA3ZGQ2Yjk0ZDgxYzdmYzg2YjA1IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Im5vOVltUllyYkJWMENVczJYOVRrdXc9PSIsInZhbHVlIjoicVYvZEtZajRMQlpLamFtVUR2Y0NZNEZFRFdaNDlPbkQ5MSs2UjZHOFRucFRJbDRCaUp5ZitTMVJtZ0ZIWVROb0YvT3BTY ▶"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "sisterscare.store"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "sisterscare.store"
  "HTTPS" => "on"
  "UNIQUE_ID" => "Z-EVz8FbuxsElerWuFMPYwAAAE0"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "sisterscare.store"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_UNIQUE_ID" => "Z-EVz8FbuxsElerWuFMPYwAAAE0"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743853007.3883
  "REQUEST_TIME" => 1743853007
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "lINBYMggkOqS1mP20zihJtK5Z7UTTpwvfA093vhl"
  "sisters_aroma_session" => "pJwu3v1NHC91YUa6oAEQuOEjG09rNIHGOr3gorhe"
]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 05 Apr 2025 11:36:47 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImdyM1BnNFhFUk9aV0JRNlUxRVlWL0E9PSIsInZhbHVlIjoiS0o0cjdFdmFlSytGbEVZQzMyako0djVLcXV2VGs1Wi9XKzljd3JMSmZHSG5KWnZRVnRDYXVGR2FXVDFra0IzL0dGWUdxWDJIM2Y0Rmx5cWpUTEFJSTlTVFllSHZYUXlJaFpwMXp3dmNEY25OQi8wRVV1bWExeWMzTjNhbzI5U3AiLCJtYWMiOiIxN2MyYmRjYzIxN2MzZTg0NTM2MmNjZGE3MDQwYTA2NjQ1OGNiMWU4NjE0MDU3NzkzZTdjMGY0ZjdjYmM0MGUzIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:56:47 GMT; Max-Age=19200; path=/; domain=.sisterscare.store ◀XSRF-TOKEN=eyJpdiI6ImdyM1BnNFhFUk9aV0JRNlUxRVlWL0E9PSIsInZhbHVlIjoiS0o0cjdFdmFlSytGbEVZQzMyako0djVLcXV2VGs1Wi9XKzljd3JMSmZHSG5KWnZRVnRDYXVGR2FXVDFra0IzL0dGWUdxW ▶"
    1 => "sisters_aroma_session=eyJpdiI6InpBSVRjcVNmelM5TGNsN0tnT2NUOFE9PSIsInZhbHVlIjoiUGNPSDdLSDFZckNKMlh0cXA3QWdNeTNQZUtHOXJRZFpyeGVhVFBHV0l1THFDallNUFFUMjJ2ckJxalNpUXV1dERQbXhKOXdDTFNkRk01QWtyU3h4QVBKYXFVeTEwYmZhVFo2am5OZzhQd2NIMnFMc0QrSUx5VVQxQ0ZXeXNJeGYiLCJtYWMiOiJlMGFlNjNjMzMxMDU3Mzg4YmI4M2I5Y2E0ZmY0ODQ1ZGM1MmJmMzRmZmJkODU0NjY1ZjBhZTE0MzY1NTMxZmJkIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:56:47 GMT; Max-Age=19200; path=/; domain=.sisterscare.store; httponly ◀sisters_aroma_session=eyJpdiI6InpBSVRjcVNmelM5TGNsN0tnT2NUOFE9PSIsInZhbHVlIjoiUGNPSDdLSDFZckNKMlh0cXA3QWdNeTNQZUtHOXJRZFpyeGVhVFBHV0l1THFDallNUFFUMjJ2ckJxalNpUX ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImdyM1BnNFhFUk9aV0JRNlUxRVlWL0E9PSIsInZhbHVlIjoiS0o0cjdFdmFlSytGbEVZQzMyako0djVLcXV2VGs1Wi9XKzljd3JMSmZHSG5KWnZRVnRDYXVGR2FXVDFra0IzL0dGWUdxWDJIM2Y0Rmx5cWpUTEFJSTlTVFllSHZYUXlJaFpwMXp3dmNEY25OQi8wRVV1bWExeWMzTjNhbzI5U3AiLCJtYWMiOiIxN2MyYmRjYzIxN2MzZTg0NTM2MmNjZGE3MDQwYTA2NjQ1OGNiMWU4NjE0MDU3NzkzZTdjMGY0ZjdjYmM0MGUzIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:56:47 GMT; domain=.sisterscare.store; path=/ ◀XSRF-TOKEN=eyJpdiI6ImdyM1BnNFhFUk9aV0JRNlUxRVlWL0E9PSIsInZhbHVlIjoiS0o0cjdFdmFlSytGbEVZQzMyako0djVLcXV2VGs1Wi9XKzljd3JMSmZHSG5KWnZRVnRDYXVGR2FXVDFra0IzL0dGWUdxW ▶"
    1 => "sisters_aroma_session=eyJpdiI6InpBSVRjcVNmelM5TGNsN0tnT2NUOFE9PSIsInZhbHVlIjoiUGNPSDdLSDFZckNKMlh0cXA3QWdNeTNQZUtHOXJRZFpyeGVhVFBHV0l1THFDallNUFFUMjJ2ckJxalNpUXV1dERQbXhKOXdDTFNkRk01QWtyU3h4QVBKYXFVeTEwYmZhVFo2am5OZzhQd2NIMnFMc0QrSUx5VVQxQ0ZXeXNJeGYiLCJtYWMiOiJlMGFlNjNjMzMxMDU3Mzg4YmI4M2I5Y2E0ZmY0ODQ1ZGM1MmJmMzRmZmJkODU0NjY1ZjBhZTE0MzY1NTMxZmJkIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:56:47 GMT; domain=.sisterscare.store; path=/; httponly ◀sisters_aroma_session=eyJpdiI6InpBSVRjcVNmelM5TGNsN0tnT2NUOFE9PSIsInZhbHVlIjoiUGNPSDdLSDFZckNKMlh0cXA3QWdNeTNQZUtHOXJRZFpyeGVhVFBHV0l1THFDallNUFFUMjJ2ckJxalNpUX ▶"
  ]
]

session_attributes

  0 of 0   
array:6 [▼
  "_token" => "lINBYMggkOqS1mP20zihJtK5Z7UTTpwvfA093vhl"
  "cartOrder" => Illuminate\Support\Collection {#2275 ▶
    #items: []
    #escapeWhenCastingToString: false
  }
  "check_country" => false
  "_previous" => array:1 [▶
    "url" => "https://sisterscare.store/krem-dlya-oblichchya"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Віртуальна АТС

КНОПКА
ЗВ'ЯЗКУ

Params
0	`seo_type`
1	`parent`
2	`slag`
3	`banner`
4	`catalog`
5	`categorie_id`
6	`filter`
7	`catalogSlid`
8	`products`
9	`menu_categories`
10	`menu_pages`
11	`store`
12	`countries`
13	`languages`
14	`productsHistory`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`seo_type`
5	`parent`
6	`slag`
7	`banner`
8	`catalog`
9	`categorie_id`
10	`filter`
11	`catalogSlid`
12	`products`
13	`menu_categories`
14	`menu_pages`
15	`store`
16	`countries`
17	`languages`
18	`productsHistory`
19	`top_text`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`seo_type`
5	`parent`
6	`slag`
7	`banner`
8	`catalog`
9	`categorie_id`
10	`filter`
11	`catalogSlid`
12	`products`
13	`menu_categories`
14	`menu_pages`
15	`store`
16	`countries`
17	`languages`
18	`productsHistory`
19	`top_text`
20	`__currentLoopData`
21	`text`
22	`loop`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`seo_type`
5	`parent`
6	`slag`
7	`banner`
8	`catalog`
9	`categorie_id`
10	`filter`
11	`catalogSlid`
12	`products`
13	`menu_categories`
14	`menu_pages`
15	`store`
16	`countries`
17	`languages`
18	`productsHistory`
19	`top_text`
20	`__currentLoopData`
21	`text`
22	`loop`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`seo_type`
5	`parent`
6	`slag`
7	`banner`
8	`catalog`
9	`categorie_id`
10	`filter`
11	`catalogSlid`
12	`products`
13	`menu_categories`
14	`menu_pages`
15	`store`
16	`countries`
17	`languages`
18	`productsHistory`
19	`top_text`
20	`__currentLoopData`
21	`text`
22	`loop`
23	`value`
24	`type`

1 x Application (90.2%)	90.32ms
1 x Booting (9.79%)	9.80ms

Params
0	`key`
1	`item`

Params
0	`key`
1	`item`

Params
0	`key`
1	`item`