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

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

SALE до -65% ✨

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

Україна

Меню

Пошук

0 Кошик

Знижки

Кабінет

Блог

2024-11-22 12:00:07

Як правильно і куди наносити парфум?

2024-10-12 14:01:20

Кислоти у догляді за шкірою обличчя: що потрібно знати?

2024-10-12 12:09:28

Резинки для фітнесу: твій персональний тренер вдома та в залі

2024-07-21 13:14:46

Як використовувати гель для вмивання?

2024-07-21 12:50:39

Як визначити стійкість парфумів?

2024-07-21 12:16:14

Бальзам для губ: навіщо потрібен і який вибрати?

Каталог

Інформація

/ 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 Views48 Route Queries27 Models355 Mails Gate Session Request

8.0.29185ms11MBGET blog/{url}

Booting (9.59ms)
Application (175ms)
1 x Application (94.81%)
175ms
1 x Booting (5.18%)
9.59ms

48 templates were rendered

front.pages.blog (resources/views/front/pages/blog.blade.php)10blade
Params
0
seo_type
1
slag
2
seo
3
articles
4
categories
5
menu_categories
6
menu_pages
7
store
8
countries
9
languages

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop
value
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop
value
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop
value
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop
value
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

pagination::tailwind (resources/views/vendor/pagination/tailwind.blade.php)2blade
Params
0
paginator
1
elements

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
type

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
sale_status
productsHistory

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
sale_status
productsHistory

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
sale_status
productsHistory

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries
systemDescription

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
isNews
menu_categorie
key
cheldren
menu_page
order
orderIndexes
store_countries

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
alternate

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
alternate
isDisable
locale
path
disablePaths

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


__env
app
errors
__sentry_tracing_view_name
seo_type
slag
seo
articles
categories
menu_categories
menu_pages
store
countries
languages
__currentLoopData
cat
loop
value
alternate
isDisable
locale
path
disablePaths

uri: GET blog/{url}
middleware: web, ChekStore, RemoveSelfLinks
controller: App\Http\Controllers\BlogController@catalog
namespace: App\Http\Controllers
prefix
where
as: web.blog.catalog
file: app/Http/Controllers/BlogController.php:61-74

27 statements were executed, 2 of which were duplicated, 25 unique129ms

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

5.85ms/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

1.19msmiddleware::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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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.44ms/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

830μ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-08 20:57:14" AND end >= "2025-04-08 20:57:14"  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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14"  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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14"  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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14"),
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-08 20:57:14"),
"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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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.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-08")) as bonus_ball from `users` where `id` = 0 limit 1

1.26ms/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

530μ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 `blogs_store` left join `blogs_descriptions` on `blogs_descriptions`.`blog_id` = `blogs_store`.`blog_id` left join `blogs` on `blogs`.`id` = `blogs_store`.`blog_id` left join `blogs_categories` on `blogs_categories`.`blog_id` = `blogs_store`.`blog_id` where (`blogs_store`.`store_id` = 1 and `blogs_store`.`status` = 1 and `blogs`.`status` = 1 and `blogs_descriptions`.`store_id` = 1 and `blogs_descriptions`.`language_id` = 1 and (SELECT `slag` FROM `blogs_categories_descriptions` WHERE `store_id` = `blogs_store`.`store_id` AND `language_id` = `blogs_descriptions`.`language_id` AND  `categorie_id` = `blogs_categories`.`blog_categorie_id`) <> '' and (SELECT `slag` FROM `blogs_categories_descriptions` WHERE `store_id` = `blogs_store`.`store_id` AND `language_id` = `blogs_descriptions`.`language_id` AND  `categorie_id` = `blogs_categories`.`blog_categorie_id`) = 'beauty-poradi')

42.55ms/app/Models/Blog.php:79sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1 5. 6. beauty-poradi
Backtrace	15. /app/Models/Blog.php:79 16. /app/Http/Controllers/BlogController.php:66 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 `blogs`.`date_add`, `blogs_store`.`url`, `blogs_descriptions`.`name`, `blogs_store`.`url` as `url`, (SELECT `slag` FROM `blogs_categories_descriptions` WHERE `store_id` = `blogs_store`.`store_id` AND `language_id` = `blogs_descriptions`.`language_id` AND  `categorie_id` = `blogs_categories`.`blog_categorie_id`) as cat_url, (SELECT `image` FROM `blogs_images` WHERE `blog_id` = `blogs_store`.`blog_id` AND `store_id` = `blogs_store`.`store_id` AND `language_id` = `blogs_descriptions`.`language_id` AND `type` = "main" LIMIT 1) as image, (SELECT `alt` FROM `blogs_images` WHERE `blog_id` = `blogs_store`.`blog_id` AND `store_id` = `blogs_store`.`store_id` AND `language_id` = `blogs_descriptions`.`language_id` AND `type` = "main" LIMIT 1) as alt from `blogs_store` left join `blogs_descriptions` on `blogs_descriptions`.`blog_id` = `blogs_store`.`blog_id` left join `blogs` on `blogs`.`id` = `blogs_store`.`blog_id` left join `blogs_categories` on `blogs_categories`.`blog_id` = `blogs_store`.`blog_id` where (`blogs_store`.`store_id` = 1 and `blogs_store`.`status` = 1 and `blogs`.`status` = 1 and `blogs_descriptions`.`store_id` = 1 and `blogs_descriptions`.`language_id` = 1 and (SELECT `slag` FROM `blogs_categories_descriptions` WHERE `store_id` = `blogs_store`.`store_id` AND `language_id` = `blogs_descriptions`.`language_id` AND  `categorie_id` = `blogs_categories`.`blog_categorie_id`) <> '' and (SELECT `slag` FROM `blogs_categories_descriptions` WHERE `store_id` = `blogs_store`.`store_id` AND `language_id` = `blogs_descriptions`.`language_id` AND  `categorie_id` = `blogs_categories`.`blog_categorie_id`) = 'beauty-poradi') order by `blogs_store`.`sort` desc limit 6 offset 6

48.62ms/app/Models/Blog.php:79sistersaroma

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1 5. 6. beauty-poradi
Backtrace	15. /app/Models/Blog.php:79 16. /app/Http/Controllers/BlogController.php:66 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 * from `blogs_categories_descriptions` where (`blogs_categories_descriptions`.`store_id` = 1 and `blogs_categories_descriptions`.`language_id` = 1)

1.39ms/app/Models/BlogCategoriesDescription.php:56sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Models/BlogCategoriesDescription.php:56 15. /app/Http/Controllers/BlogController.php:67 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

860μ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/BlogController.php:68 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')

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

Metadata
Bindings	0. 1 1. icon
Backtrace	19. /app/Models/Categorie.php:148 20. /app/Http/Controllers/BlogController.php:68 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)

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

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:148 20. /app/Http/Controllers/BlogController.php:68 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)

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

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:148 20. /app/Http/Controllers/BlogController.php:68 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

1.36ms/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/BlogController.php:68 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')

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

Metadata
Bindings	0. 1 1. icon
Backtrace	19. /app/Models/Categorie.php:193 20. /app/Http/Controllers/BlogController.php:68 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)

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

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:193 20. /app/Http/Controllers/BlogController.php:68 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)

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

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:193 20. /app/Http/Controllers/BlogController.php:68 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

1.15ms/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/BlogController.php:69 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.31ms/app/Models/CountrieDescription.php:76sistersaroma

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Models/CountrieDescription.php:76 15. /app/Http/Controllers/BlogController.php:71 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)

1.05ms/app/Models/StoreLanguage.php:69sistersaroma

Metadata
Bindings	0. 1
Backtrace	14. /app/Models/StoreLanguage.php:69 15. /app/Http/Controllers/BlogController.php:72 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 `top_texts` where (`store_id` = 1 and `language_id` = 1) order by `sort` desc

800μ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)

710μ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-08 20:57:14" AND end >= "2025-04-08 20:57:14"  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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14"  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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14"  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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14"),
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-08 20:57:14"),
"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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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-08 20:57:14" AND end >= "2025-04-08 20:57:14" 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.41ms/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')

960μ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 * from `blogs_categories_descriptions` where (`blogs_categories_descriptions`.`store_id` = 1 and `blogs_categories_descriptions`.`language_id` = 1 and `blogs_categories_descriptions`.`slag` LIKE 'beauty-poradi') limit 1

940μs/app/Models/BlogCategoriesDescription.php:65sistersaroma

Metadata
Bindings	0. 1 1. 1 2. beauty-poradi
Backtrace	15. /app/Models/BlogCategoriesDescription.php:65 16. /app/Providers/AppServiceProvider.php:101 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 21. /vendor/laravel/framework/src/Illuminate/View/View.php:120

select concat(IF(code = "ua","uk",code),IF(code = "en","",alternate)) as hreflang, concat("https://",domen,IF(language_default = store_language.language_id,concat("/blog/",blogs_categories_descriptions.slag,"/"),concat("/",code,"/blog/",blogs_categories_descriptions.slag,"/"))) 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 `blogs_categories_descriptions` on ((`blogs_categories_descriptions`.`store_id` = systems_store.store_id and `blogs_categories_descriptions`.`language_id` = language.id)) where (`store_language`.`id` <> '472' and `blogs_categories_descriptions`.`categorie_id` = 3) order by `systems_store`.`store_id` asc

890μs/app/Models/BlogCategoriesDescription.php:87sistersaroma

Metadata
Bindings	0. 472 1. 3
Backtrace	14. /app/Models/BlogCategoriesDescription.php:87 15. /app/Providers/AppServiceProvider.php:101 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

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

_token: ys3sMcJ9NOG2bhO3ATB5WwctX6zrP1sU3ibBH8CN
cartOrder: Illuminate\Support\Collection {#1260 #items: [] #escapeWhenCastingToString: false }
check_country: false
_previous: array:1 [ "url" => "https://sisterscare.store/blog/beauty-poradi?page=2" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/blog/beauty-poradi

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "2"
]

request_request

  0 of 0   
array:1 [▼
  "page" => "2"
]

request_headers

  0 of 0   
array:15 [▼
  "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" => "/blog/beauty-poradi?page=2"
  "QUERY_STRING" => "page=2"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "page=2"
  "REDIRECT_URL" => "/blog/beauty-poradi"
  "REMOTE_PORT" => "39660"
  "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" => "18.191.44.99"
  "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_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-VjegjquQExbfrLBGYUdQAAARE"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "sisterscare.store"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_UNIQUE_ID" => "Z-VjegjquQExbfrLBGYUdQAAARE"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744135034.4873
  "REQUEST_TIME" => 1744135034
]

request_cookies

[]

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 => "Tue, 08 Apr 2025 17:57:14 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlRRXp6ZW1tMXA0M29tNnVQQXBWOEE9PSIsInZhbHVlIjoiNitkOEFOUGJ1R0JSOHVCZTNreHJlM3hidE13dkNIZmZMRVBIZVpPbFV1U28rRjRGMFJBYlRiL2FrUFhDMEFtRko3M2ViQ0VTL1d5VlBDTjA2TWRUZTFEZTRiTXZwN1FIcFgxc1FGdFpldWZ2Z2IyTTh6c3hJdUVkbjhqRlZ1V0wiLCJtYWMiOiI2ZmYxOTcwOWQ2NGNlZTRjMWY3NGNjMzRkYmY2ZTYwMjFkYjZhNzg2YWYzZjM2M2E1MjJiYjM5OWY3NGQ5NWUxIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 23:17:14 GMT; Max-Age=19200; path=/; domain=.sisterscare.store ◀XSRF-TOKEN=eyJpdiI6InlRRXp6ZW1tMXA0M29tNnVQQXBWOEE9PSIsInZhbHVlIjoiNitkOEFOUGJ1R0JSOHVCZTNreHJlM3hidE13dkNIZmZMRVBIZVpPbFV1U28rRjRGMFJBYlRiL2FrUFhDMEFtRko3M2ViQ ▶"
    1 => "sisters_aroma_session=eyJpdiI6Imp2eGdwSXR4OE9ac0l1Z3FYdlV0ZGc9PSIsInZhbHVlIjoiUG9BVk5HdEFhK0NTcUJNTjA5Wk4zRUVkeUtlRitMU0xBdnZ3VGYxdFJoVHMxVm1GTUExcC9OY0RvSitxa1lIeU9zL1BnK0FFbjdUUGJmQjBGTlAyL2pIemt0NWhNNGxuOFRZZ0dmN1hjaXV4ZEI1WmZJRzQzcUlLV0huMnJWbVoiLCJtYWMiOiJlMmY3ZDE4MzZlZTU3MzZjYTlmMWRhMDQzNzA1NTMxYTIwYzlhZTllMGQ5MTRiMWM5ZTczMWE1Y2RmOTViMTNlIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 23:17:14 GMT; Max-Age=19200; path=/; domain=.sisterscare.store; httponly ◀sisters_aroma_session=eyJpdiI6Imp2eGdwSXR4OE9ac0l1Z3FYdlV0ZGc9PSIsInZhbHVlIjoiUG9BVk5HdEFhK0NTcUJNTjA5Wk4zRUVkeUtlRitMU0xBdnZ3VGYxdFJoVHMxVm1GTUExcC9OY0RvSitxa1 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlRRXp6ZW1tMXA0M29tNnVQQXBWOEE9PSIsInZhbHVlIjoiNitkOEFOUGJ1R0JSOHVCZTNreHJlM3hidE13dkNIZmZMRVBIZVpPbFV1U28rRjRGMFJBYlRiL2FrUFhDMEFtRko3M2ViQ0VTL1d5VlBDTjA2TWRUZTFEZTRiTXZwN1FIcFgxc1FGdFpldWZ2Z2IyTTh6c3hJdUVkbjhqRlZ1V0wiLCJtYWMiOiI2ZmYxOTcwOWQ2NGNlZTRjMWY3NGNjMzRkYmY2ZTYwMjFkYjZhNzg2YWYzZjM2M2E1MjJiYjM5OWY3NGQ5NWUxIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 23:17:14 GMT; domain=.sisterscare.store; path=/ ◀XSRF-TOKEN=eyJpdiI6InlRRXp6ZW1tMXA0M29tNnVQQXBWOEE9PSIsInZhbHVlIjoiNitkOEFOUGJ1R0JSOHVCZTNreHJlM3hidE13dkNIZmZMRVBIZVpPbFV1U28rRjRGMFJBYlRiL2FrUFhDMEFtRko3M2ViQ ▶"
    1 => "sisters_aroma_session=eyJpdiI6Imp2eGdwSXR4OE9ac0l1Z3FYdlV0ZGc9PSIsInZhbHVlIjoiUG9BVk5HdEFhK0NTcUJNTjA5Wk4zRUVkeUtlRitMU0xBdnZ3VGYxdFJoVHMxVm1GTUExcC9OY0RvSitxa1lIeU9zL1BnK0FFbjdUUGJmQjBGTlAyL2pIemt0NWhNNGxuOFRZZ0dmN1hjaXV4ZEI1WmZJRzQzcUlLV0huMnJWbVoiLCJtYWMiOiJlMmY3ZDE4MzZlZTU3MzZjYTlmMWRhMDQzNzA1NTMxYTIwYzlhZTllMGQ5MTRiMWM5ZTczMWE1Y2RmOTViMTNlIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 23:17:14 GMT; domain=.sisterscare.store; path=/; httponly ◀sisters_aroma_session=eyJpdiI6Imp2eGdwSXR4OE9ac0l1Z3FYdlV0ZGc9PSIsInZhbHVlIjoiUG9BVk5HdEFhK0NTcUJNTjA5Wk4zRUVkeUtlRitMU0xBdnZ3VGYxdFJoVHMxVm1GTUExcC9OY0RvSitxa1 ▶"
  ]
]

session_attributes

  0 of 0   
array:6 [▼
  "_token" => "ys3sMcJ9NOG2bhO3ATB5WwctX6zrP1sU3ibBH8CN"
  "cartOrder" => Illuminate\Support\Collection {#1260 ▶
    #items: []
    #escapeWhenCastingToString: false
  }
  "check_country" => false
  "_previous" => array:1 [▶
    "url" => "https://sisterscare.store/blog/beauty-poradi?page=2"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

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

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

Params
0	`seo_type`
1	`slag`
2	`seo`
3	`articles`
4	`categories`
5	`menu_categories`
6	`menu_pages`
7	`store`
8	`countries`
9	`languages`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`seo_type`
5	`slag`
6	`seo`
7	`articles`
8	`categories`
9	`menu_categories`
10	`menu_pages`
11	`store`
12	`countries`
13	`languages`
14	`top_text`

1 x Application (94.81%)	175ms
1 x Booting (5.18%)	9.59ms

Params
0	`paginator`
1	`elements`