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

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

SALE до -65% ✨

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

Україна

Меню

Пошук

0 Кошик

Знижки

Кабінет

Pеєстрація

Реєструйтеся та отримуйте 100 бонусних S-coins на рахунок

Код висланий на

Змінити

Отримати новий код

При вході або реєстрації, я погоджуюсь з правилами публічної оферти

Каталог

Інформація

/ 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 Queries22 Models335 Mails Gate Session Request

8.0.2974.62ms8MBGET register

Booting (10.28ms)
Application (64.32ms)
1 x Application (86.2%)
64.32ms
1 x Booting (13.78%)
10.28ms

48 templates were rendered

front.pages.registration (resources/views/front/pages/registration.blade.php)5blade
Params
0
menu_categories
1
menu_pages
2
store
3
countries
4
languages

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
top_text

front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)13blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
menu_categories
5
menu_pages
6
store
7
countries
8
languages
9
top_text
10
__currentLoopData
11
text
12
loop
front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)13blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
menu_categories
5
menu_pages
6
store
7
countries
8
languages
9
top_text
10
__currentLoopData
11
text
12
loop

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


__env
app
errors
__sentry_tracing_view_name
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)15blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop
value
type

front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)13blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
menu_categories
5
menu_pages
6
store
7
countries
8
languages
9
top_text
10
__currentLoopData
11
text
12
loop
front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)13blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
menu_categories
5
menu_pages
6
store
7
countries
8
languages
9
top_text
10
__currentLoopData
11
text
12
loop

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


__env
app
errors
__sentry_tracing_view_name
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)15blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop
value
type

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
top_text
__currentLoopData
text
loop

front.components.registrationForm (resources/views/front/components/registrationForm.blade.php)10blade
Params
0
__env
1
app
2
errors
3
__sentry_tracing_view_name
4
menu_categories
5
menu_pages
6
store
7
countries
8
languages
9
isRegistration

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
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)21blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
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)20blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
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)21blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
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)21blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
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)20blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
sale_status
productsHistory

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
sale_status
productsHistory

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value
sale_status
productsHistory

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
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)20blade


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
isNews
__currentLoopData
menu_categorie
key
loop
cheldren
menu_page
order
orderIndexes
store_countries
value

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
alternate

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
alternate
isDisable
locale
path
disablePaths

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


__env
app
errors
__sentry_tracing_view_name
menu_categories
menu_pages
store
countries
languages
alternate
isDisable
locale
path
disablePaths

uri: GET register
middleware: web, ChekStore, RemoveSelfLinks
controller: App\Http\Controllers\Auth\RegisterController@showRegistrationForm
namespace: App\Http\Controllers
prefix
where
as: register
file: app/Http/Controllers/Auth/RegisterController.php:70-79

22 statements were executed, 2 of which were duplicated, 20 unique25.23ms

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

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

860μ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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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.56ms/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

620μ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-06 14:37:39" AND end >= "2025-04-06 14:37:39"  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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39"  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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39"  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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39"),
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-06 14:37:39"),
"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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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

2ms/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-06")) as bonus_ball from `users` where `id` = 0 limit 1

790μ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

470μ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 `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

820μ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/Auth/RegisterController.php:73 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')

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

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

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

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:148 20. /app/Http/Controllers/Auth/RegisterController.php:73 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.72ms/app/Models/Categorie.php:148sistersaroma

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

850μ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/Auth/RegisterController.php:73 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')

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

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

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

Metadata
Bindings	0. 1 1. 1
Backtrace	19. /app/Models/Categorie.php:193 20. /app/Http/Controllers/Auth/RegisterController.php:73 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.37ms/app/Models/Categorie.php:193sistersaroma

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

610μ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/Auth/RegisterController.php:74 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.13ms/app/Models/CountrieDescription.php:76sistersaroma

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

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

Metadata
Bindings	0. 1
Backtrace	14. /app/Models/StoreLanguage.php:69 15. /app/Http/Controllers/Auth/RegisterController.php:77 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

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

660μ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-06 14:37:39" AND end >= "2025-04-06 14:37:39"  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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39"  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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39"  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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39"),
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-06 14:37:39"),
"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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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-06 14:37:39" AND end >= "2025-04-06 14:37:39" 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.95ms/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')

660μ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

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\StoreLanguage: 3
App\Models\Admin\SystemStore: 5

_token: XbZ1CKI4trVWet63wMs3dl9mpwIwFZ18ySOv0P6s
cartOrder: Illuminate\Support\Collection {#2284 #items: [] #escapeWhenCastingToString: false }
check_country: false
_previous: array:1 [ "url" => "https://sisterscare.store/register" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/register/

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=eyJpdiI6ImNBV1BsQzFVNFFDNFlmcmp1RE82NWc9PSIsInZhbHVlIjoickFhclhKMVZURjNHRnFuV0FOMSt1YkVFTjFobEpnR0ZiZW42Mk9Bam5BeWh3NGpLV1pJNHZsanBBYWpSL1N4R05JOE1Kc0xraXY0SmZ4d09nRWc0eEZZNE85R2hKeDR6ZFNTZWdJQ3NWdU5RM3o0akRvOHJnR0ZOdWdxM29EbGYiLCJtYWMiOiJhODY4NTUxYjk3Y2JmZDIzODVmN2QyNTdmYWMzOTgzODkzNjU1NGYyY2ZjNTRlZTA1ODhiNDA0MTM4YmVmOGJiIiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6Im82QUFsM1ZoVklnWi9Vd3ZmclRubkE9PSIsInZhbHVlIjoiTTRGTTh3OHhZZkxEM2ViUDBrSkx5ejRWMkhjcS9Hc2tuZ1BWQkt0em1PL2phOXZ4cGxwK25yWlNRd0ErOVdITm9ybTl4N1lVQU11RFRvS1FqVnZLbXFNSElmU1dlcWEvNlJnamRnN0JUc0t2d2x6VW1sL1RrVCtGeDkxb1VhaUMiLCJtYWMiOiJhZWEyMWNkYmY2OTFiMTUzYzY1ZDE4Yzk4ZjQ1ZTViOTBmYjE4YTNiZGE5NGE1OTA1MzE1YTRiZmE3Y2Q4MmJiIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImNBV1BsQzFVNFFDNFlmcmp1RE82NWc9PSIsInZhbHVlIjoickFhclhKMVZURjNHRnFuV0FOMSt1YkVFTjFobEpnR0ZiZW42Mk9Bam5BeWh3NGpLV1pJNHZsanBBYWpSL1N4R05JOE1Kc ▶"
  ]
  "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" => "/register/"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/register/"
  "REMOTE_PORT" => "7034"
  "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.224.64.19"
  "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=eyJpdiI6ImNBV1BsQzFVNFFDNFlmcmp1RE82NWc9PSIsInZhbHVlIjoickFhclhKMVZURjNHRnFuV0FOMSt1YkVFTjFobEpnR0ZiZW42Mk9Bam5BeWh3NGpLV1pJNHZsanBBYWpSL1N4R05JOE1Kc0xraXY0SmZ4d09nRWc0eEZZNE85R2hKeDR6ZFNTZWdJQ3NWdU5RM3o0akRvOHJnR0ZOdWdxM29EbGYiLCJtYWMiOiJhODY4NTUxYjk3Y2JmZDIzODVmN2QyNTdmYWMzOTgzODkzNjU1NGYyY2ZjNTRlZTA1ODhiNDA0MTM4YmVmOGJiIiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6Im82QUFsM1ZoVklnWi9Vd3ZmclRubkE9PSIsInZhbHVlIjoiTTRGTTh3OHhZZkxEM2ViUDBrSkx5ejRWMkhjcS9Hc2tuZ1BWQkt0em1PL2phOXZ4cGxwK25yWlNRd0ErOVdITm9ybTl4N1lVQU11RFRvS1FqVnZLbXFNSElmU1dlcWEvNlJnamRnN0JUc0t2d2x6VW1sL1RrVCtGeDkxb1VhaUMiLCJtYWMiOiJhZWEyMWNkYmY2OTFiMTUzYzY1ZDE4Yzk4ZjQ1ZTViOTBmYjE4YTNiZGE5NGE1OTA1MzE1YTRiZmE3Y2Q4MmJiIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImNBV1BsQzFVNFFDNFlmcmp1RE82NWc9PSIsInZhbHVlIjoickFhclhKMVZURjNHRnFuV0FOMSt1YkVFTjFobEpnR0ZiZW42Mk9Bam5BeWh3NGpLV1pJNHZsanBBYWpSL1N4R05JOE1Kc ▶"
  "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-Jngi9RWXHR4JD3MWbiSAAAAMw"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "sisterscare.store"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_UNIQUE_ID" => "Z-Jngi9RWXHR4JD3MWbiSAAAAMw"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743939458.98
  "REQUEST_TIME" => 1743939458
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "XbZ1CKI4trVWet63wMs3dl9mpwIwFZ18ySOv0P6s"
  "sisters_aroma_session" => "AMHfzqLnvdRvxcDw94l49Ah9jjUDk4iw57JD1R7w"
]

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 => "Sun, 06 Apr 2025 11:37:39 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFnSm1PTVVtZUtLMU1OQmxxWDFJR2c9PSIsInZhbHVlIjoicmN1Q053RzFLRmR2OU5YNHJlQTI2VDdTK3QyeTdPUzU1OVluTjdCZGloZ3BTNnlnbmR1KzJXNVpVTmF0SGdUT1h0OFpxaEQ1THRaYWFiT3hCK0x4VkI3bUlxRzdxN20xRmNyVDFTelErWFdEWU0rcm53eEg4cEtyYnBXbnV1elYiLCJtYWMiOiJmNjdiMzNiZGM4YWU5MzNlNmRjNmZiNDg5OWE5NzEzNTM3Nzg1OGMxMGU2ZGFiMjEyN2I2YjY5Zjk4YzRkNTM2IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 16:57:39 GMT; Max-Age=19200; path=/; domain=.sisterscare.store ◀XSRF-TOKEN=eyJpdiI6InFnSm1PTVVtZUtLMU1OQmxxWDFJR2c9PSIsInZhbHVlIjoicmN1Q053RzFLRmR2OU5YNHJlQTI2VDdTK3QyeTdPUzU1OVluTjdCZGloZ3BTNnlnbmR1KzJXNVpVTmF0SGdUT1h0OFpxa ▶"
    1 => "sisters_aroma_session=eyJpdiI6Im9JcEpQUXdsYXJVczcwTzRISWFZM1E9PSIsInZhbHVlIjoiR014YVZ3WHp6YzE0NkE1bUwwWnlSSklvUEVPaE1lMFlXYVdYYW5EWmcvTU9EeUQyUHlocWtaWVczanVFeW5ORVl5Y3VCR0RvTXpzNDJVVGFkcmJvWlAzdUtuVzUwc3B6RnhlWmJsSWNJR2dFekhtRzQ1cUZaU2NSVXNWanh2Z3giLCJtYWMiOiI5YTU1Mzc2ZmU0MThhNzkwYjFlMWQ2NDZhNTAwYzg2YjBhOTkwZjBmYmRjYjYwYjNiOGVkZTEzM2Q1NTE1ODhjIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 16:57:39 GMT; Max-Age=19200; path=/; domain=.sisterscare.store; httponly ◀sisters_aroma_session=eyJpdiI6Im9JcEpQUXdsYXJVczcwTzRISWFZM1E9PSIsInZhbHVlIjoiR014YVZ3WHp6YzE0NkE1bUwwWnlSSklvUEVPaE1lMFlXYVdYYW5EWmcvTU9EeUQyUHlocWtaWVczanVFeW ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFnSm1PTVVtZUtLMU1OQmxxWDFJR2c9PSIsInZhbHVlIjoicmN1Q053RzFLRmR2OU5YNHJlQTI2VDdTK3QyeTdPUzU1OVluTjdCZGloZ3BTNnlnbmR1KzJXNVpVTmF0SGdUT1h0OFpxaEQ1THRaYWFiT3hCK0x4VkI3bUlxRzdxN20xRmNyVDFTelErWFdEWU0rcm53eEg4cEtyYnBXbnV1elYiLCJtYWMiOiJmNjdiMzNiZGM4YWU5MzNlNmRjNmZiNDg5OWE5NzEzNTM3Nzg1OGMxMGU2ZGFiMjEyN2I2YjY5Zjk4YzRkNTM2IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 16:57:39 GMT; domain=.sisterscare.store; path=/ ◀XSRF-TOKEN=eyJpdiI6InFnSm1PTVVtZUtLMU1OQmxxWDFJR2c9PSIsInZhbHVlIjoicmN1Q053RzFLRmR2OU5YNHJlQTI2VDdTK3QyeTdPUzU1OVluTjdCZGloZ3BTNnlnbmR1KzJXNVpVTmF0SGdUT1h0OFpxa ▶"
    1 => "sisters_aroma_session=eyJpdiI6Im9JcEpQUXdsYXJVczcwTzRISWFZM1E9PSIsInZhbHVlIjoiR014YVZ3WHp6YzE0NkE1bUwwWnlSSklvUEVPaE1lMFlXYVdYYW5EWmcvTU9EeUQyUHlocWtaWVczanVFeW5ORVl5Y3VCR0RvTXpzNDJVVGFkcmJvWlAzdUtuVzUwc3B6RnhlWmJsSWNJR2dFekhtRzQ1cUZaU2NSVXNWanh2Z3giLCJtYWMiOiI5YTU1Mzc2ZmU0MThhNzkwYjFlMWQ2NDZhNTAwYzg2YjBhOTkwZjBmYmRjYjYwYjNiOGVkZTEzM2Q1NTE1ODhjIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 16:57:39 GMT; domain=.sisterscare.store; path=/; httponly ◀sisters_aroma_session=eyJpdiI6Im9JcEpQUXdsYXJVczcwTzRISWFZM1E9PSIsInZhbHVlIjoiR014YVZ3WHp6YzE0NkE1bUwwWnlSSklvUEVPaE1lMFlXYVdYYW5EWmcvTU9EeUQyUHlocWtaWVczanVFeW ▶"
  ]
]

session_attributes

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

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

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

Params
0	`menu_categories`
1	`menu_pages`
2	`store`
3	`countries`
4	`languages`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`menu_categories`
5	`menu_pages`
6	`store`
7	`countries`
8	`languages`
9	`top_text`

1 x Application (86.2%)	64.32ms
1 x Booting (13.78%)	10.28ms

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`menu_categories`
5	`menu_pages`
6	`store`
7	`countries`
8	`languages`
9	`isNews`
10	`__currentLoopData`
11	`menu_categorie`
12	`key`
13	`loop`
14	`cheldren`
15	`menu_page`
16	`order`
17	`orderIndexes`
18	`store_countries`
19	`value`
20	`type`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`menu_categories`
5	`menu_pages`
6	`store`
7	`countries`
8	`languages`
9	`isNews`
10	`__currentLoopData`
11	`menu_categorie`
12	`key`
13	`loop`
14	`cheldren`
15	`menu_page`
16	`order`
17	`orderIndexes`
18	`store_countries`
19	`value`
20	`type`

Params
0	`__env`
1	`app`
2	`errors`
3	`__sentry_tracing_view_name`
4	`menu_categories`
5	`menu_pages`
6	`store`
7	`countries`
8	`languages`
9	`isNews`
10	`__currentLoopData`
11	`menu_categorie`
12	`key`
13	`loop`
14	`cheldren`
15	`menu_page`
16	`order`
17	`orderIndexes`
18	`store_countries`
19	`value`