FREE DELIVERY to the Czech Republic and Germany ❤️
🎁Gift for orders over €55
Worldwide shipping 🌏
search
World
menu menu Menu
search Search
shopping-bag 0 Basket
circle Discounts
circle Cabinet
Gift Certificate Usage Terms

Current edition as of November 13, 2024

Gift Certificate Usage Terms for Sister’s Aroma Online Store

1. Definitions:

1.1. Terms: These are the terms for using gift certificates for the Sister’s Aroma online store. The current version of the Terms is available at the following link: https://eu.sistersaroma.com/certificates-up/. Any action on the Website implies that the Customer unconditionally agrees with these Terms.

1.2. Regulations: These define the procedure for purchasing, exchanging, and returning goods. The current version of the Regulations can be found at the following link: https://eu.sistersaroma.com/oferta/. Any action on the Website implies that the Customer unconditionally agrees with the Regulations.

1.3. Seller: Sister’s Aroma SP. z.o.o., headquartered at 00-831 Poland, Warsaw, ul. Twarda nr. 44 str.; KRS: 0000990359; NIP: 5273017918; REGON: 523030588. The Seller is also the owner and administrator of the Website. For additional information, the Customer can contact the Seller at +48 833 131 973.

1.4. Customer: A consumer with whom an agreement may be concluded under Article 22(1) of the Civil Code of the Republic of Poland.

1.5. Goods: "Product(s)" - "Perfume and cosmetic products", "Accessories", "Sportswear", "Sports equipment", and "Candles" as referenced throughout the Terms.

1.6. Website: https://eu.sistersaroma.com/. The Seller sells Goods to Customer s through the Website, provides information about promotions, and publishes current documentation that regulates relations with Customers.

1.7. "Gift Certificates": Electronic or physical gift certificates with a monetary value, which can be exchanged for Goods available on the Website. More details on Gift Certificates: https://eu.sistersaroma.com/certificates-up/.

2. Gift Certificate Usage Terms:

2.1. Gift certificates can only be used once when purchasing one or more Goods for an amount not exceeding the nominal value of the Gift Certificate.

2.2. Gift Certificates can be received electronically or in paper form by contacting the following email: support.eu@sistersaroma.com or any other available method on the Website. The condition for transferring the Gift Certificate to the Customer is 100% prepayment. The cost of delivering a physical Gift Certificate is borne by the Customer. If the Gift Certificate is transferred electronically, it will be sent to the specified email or another method chosen by the Customer. From the moment the Gift Certificate is transferred to the Customer, the Seller is not responsible for its unauthorized use (e.g., by a third party).

2.3. The validity period of the Gift Certificate is 12 (twelve) calendar months from the date of 100% prepayment by the Customer. After this period, the Gift Certificate becomes invalid and cannot be exchanged or returned.

2.4. The Gift Certificate can be used when purchasing Goods on the Website.

2.5. Delivery of the Good will be free within the Republic of Poland if the Customer uses the Gift Certificate to purchase Goods worth at least 190 Polish zlotys. If the Good is delivered outside the Republic of Poland, payment will be made in euros, and the minimum amount the Customer must spend with the Gift Certificate to qualify for free delivery will be displayed when placing the order.

2.6. If the Good is paid for using a Gift Certificate, the Customer cannot participate in prize draw promotions unless otherwise stated in the rules of the promotion. However, the Gift Certificate can be used to purchase promotional Goods on the Website.

2.7. Gift Certificates are non-exchangeable and non-refundable. Gift Certificates cannot be exchanged for Polish zlotys or any other currency.

3. Final Provisions:

3.1. Anything not covered by these Terms is regulated by the Regulations. If any provision of the Regulations contradicts these Terms concerning Gift Certificates, the Terms will prevail.

3.2. All definitions mentioned in these Terms but not explained in Section 1 should be interpreted in accordance with the Regulations.

3.2. The Customer understands that the amount paid for the Gift Certificate is considered an advance payment under the Polish Tax Code. In exchange, the Customer will receive a Gift Certificate, the nominal value of which can be used in accordance with these Terms. However, the advance payment is non-refundable, and the Gift Certificate cannot be exchanged or returned for real (fiat) money, regardless of whether it was used by the Customer.


🎁
Directory
Information
/ en
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.

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.

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.

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.

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

8.0.29PHP Version80.22msRequest Duration8MBMemory UsageGET {url}Route
    • Booting (11.04ms)
    • Application (69.17ms)
    • 1 x Application (86.23%)
      69.17ms
      1 x Booting (13.76%)
      11.04ms
      50 templates were rendered
      • front.pages.publicOffer (resources/views/front/pages/publicOffer.blade.php)10blade
        Params
        0
        seo_type
        1
        page_id
        2
        slag
        3
        page
        4
        delivery
        5
        countries
        6
        menu_categories
        7
        menu_pages
        8
        store
        9
        languages
      • front.shared.header (resources/views/front/shared/header.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
      • front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
      • front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
        18
        value
        19
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
        18
        value
        19
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
        18
        value
        19
        type
      • front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
      • front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
        18
        value
        19
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
        18
        value
        19
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
        18
        value
        19
        type
      • front.shared.menu (resources/views/front/shared/menu.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
      • front.shared.mobHeadLine (resources/views/front/shared/mobHeadLine.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
      • front.shared.mobBottomLine (resources/views/front/shared/mobBottomLine.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        top_text
        15
        __currentLoopData
        16
        text
        17
        loop
      • front.shared.footer (resources/views/front/shared/footer.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)26blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)26blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)26blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        type
      • front.svg.mastercard (resources/views/front/svg/mastercard.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.svg.visa (resources/views/front/svg/visa.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.shared.mobileModal (resources/views/front/shared/mobileModal.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.svg.globe (resources/views/front/svg/globe.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.shared.mobileModalTabCatalog (resources/views/front/shared/mobileModalTabCatalog.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.shared.mobileModalTabInfo (resources/views/front/shared/mobileModalTabInfo.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.shared.mobileModalTabRegion (resources/views/front/shared/mobileModalTabRegion.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)26blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)26blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)26blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        type
      • front.modals.login (resources/views/front/modals/login.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalLoginSMS (resources/views/front/modals/modalLoginSMS.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalVerificationCode (resources/views/front/modals/modalVerificationCode.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalMiles (resources/views/front/modals/modalMiles.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalPreOrder (resources/views/front/modals/modalPreOrder.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalBuyOneClick (resources/views/front/modals/modalBuyOneClick.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalReportAvailability (resources/views/front/modals/modalReportAvailability.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.passwordRecovery (resources/views/front/modals/passwordRecovery.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.yourRegion (resources/views/front/modals/yourRegion.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.cardModal (resources/views/front/modals/cardModal.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.shared.card (resources/views/front/shared/card.blade.php)27blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        sale_status
        26
        productsHistory
      • front.shared.checkont.promoInputsWrap (resources/views/front/shared/checkont/promoInputsWrap.blade.php)27blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        sale_status
        26
        productsHistory
      • front.shared.productCarouselViewedCart (resources/views/front/shared/productCarouselViewedCart.blade.php)27blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        sale_status
        26
        productsHistory
      • front.modals.giftModal (resources/views/front/modals/giftModal.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalGetDiscount (resources/views/front/modals/modalGetDiscount.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalSubscription (resources/views/front/modals/modalSubscription.blade.php)26blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
        25
        systemDescription
      • front.modals.modalSubscriptionSuccess (resources/views/front/modals/modalSubscriptionSuccess.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.modals.modalCookie (resources/views/front/modals/modalCookie.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        isNews
        15
        __currentLoopData
        16
        menu_categorie
        17
        key
        18
        loop
        19
        cheldren
        20
        menu_page
        21
        order
        22
        orderIndexes
        23
        store_countries
        24
        value
      • front.layouts.app (resources/views/front/layouts/app.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        alternate
      • front.components.canonical (resources/views/front/components/canonical.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        alternate
        15
        isDisable
        16
        locale
        17
        path
        18
        disablePaths
      • front.components.alternate (resources/views/front/components/alternate.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        page_id
        6
        slag
        7
        page
        8
        delivery
        9
        countries
        10
        menu_categories
        11
        menu_pages
        12
        store
        13
        languages
        14
        alternate
        15
        isDisable
        16
        locale
        17
        path
        18
        disablePaths
      uri
      GET {url}
      middleware
      web, ChekStore, RemoveSelfLinks, UrlRedirect
      controller
      App\Http\Controllers\CatalogController@index
      namespace
      App\Http\Controllers
      prefix
      where
      as
      catalog
      file
      app/Http/Controllers/CatalogController.php:42-169
      26 statements were executed, 2 of which were duplicated, 24 unique29.13ms
      • select `code`, `domen`, `systems_store`.`store_id`, (SELECT `code` FROM `language` WHERE `id` = systems_store.language_default) as language_default from `systems_store` left join `store_language` on `store_language`.`store_id` = `systems_store`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` where (SELECT `code` FROM `language` WHERE `id` = systems_store.language_default) <> `language`.`code` OR `systems_store`.`store_id` = 4
        3.07ms/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` = 3 and `language`.`id` = 5) limit 1
        1.06msmiddleware::ChekStore:82sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        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` = "5" AND `option_id` = `products_options`.`option_id` LIMIT 1), ":", (SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "5" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `sale_id` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "32" AND `currency_id` = "3" LIMIT 1) ), IFNULL( (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" 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` = "32" AND `currency_id` = "3" LIMIT 1), (SELECT `bonus` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" 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` = "4" LIMIT 1), IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "32" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "4" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = 3)) left join `products_store` on `products_store`.`product_id` = `products`.`id` where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 3 and `products_descriptions`.`language_id` = 5 and `products_store`.`store_id` = 3) and 1 <> 1 group by IFNULL(CONCAT(products.id,"_",products_options.option_id,"_",products_options.value_id),CONCAT(products.id,"_","_"))
        1.47ms/app/Models/Product.php:829sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        • 2. 3
        • 3. 5
        • 4. 3
        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` = 3
        680μs/app/Models/Product.php:1193sistersaroma
        Metadata
        Bindings
        • 0. 3
        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` = "3" AND `language_id` = "5" 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` = "3" AND `reviews`.`language_id` = "5" ) 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` = "3" AND `reviews`.`language_id` = "5" ) 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "32" AND `currency_id` = "3" LIMIT 1) ), IFNULL( (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND end <= "2025-04-05 14:19:19"), 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND end <= "2025-04-05 14:19:19"), "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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), "0" ) )) as sell_price, CONCAT( (SELECT `name` FROM `option_descriptions` WHERE `language_id` = "5" AND `option_id` = `products_options`.`option_id` LIMIT 1), ":", (SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "5" 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` = "4" ORDER BY qty DESC LIMIT 1), IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "32" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "4" 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` = 3)) left join `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` = 5)) where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 3 and `products_descriptions`.`language_id` = 5 and `products_store`.`store_id` = 3 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "32" AND `currency_id` = "3" LIMIT 1) ), IFNULL( (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" LIMIT 1) ) ) > 0) and 0 = 1 and (`products`.`status` = 1 and `products_descriptions`.`store_id` = 3 and `products_descriptions`.`language_id` = 5 and `products_store`.`store_id` = 3 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` = "4" LIMIT 1), (SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "4" LIMIT 1) ), 0) <> 0) order by `products_options`.`sort` asc
        1.98ms/app/Models/Product.php:959sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        • 2. 1
        • 3. 3
        • 4. 5
        • 5. 3
        • 6. 1
        • 7. 0
        • 8. 1
        • 9. 3
        • 10. 5
        • 11. 3
        • 12. 0
        Backtrace
        • 12. /app/Models/Product.php:959
        • 13. /app/Models/Product.php:1109
        • 14. middleware::ChekStore:126
        • 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 16. /app/Http/Middleware/ViewData.php:52
      • select `id`, `name`, `surname`, `patronymic`, `date_birth`, `email`, `phone`, (bonus_ball + (SELECT SUM(amount) FROM `users_bonus_ball` WHERE `user_id` = `users`.`id` AND date >= "2025-01-05")) as bonus_ball from `users` where `id` = 0 limit 1
        770μ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` = 3 and `settings_chekout_store`.`currency_id` = 3) limit 1
        740μs/app/Models/SettingsChekout.php:55sistersaroma
        Metadata
        Bindings
        • 0. 1
        • 1. 3
        • 2. 3
        Backtrace
        • 15. /app/Models/SettingsChekout.php:55
        • 16. /app/Models/Product.php:1135
        • 17. middleware::ChekStore:126
        • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 19. /app/Http/Middleware/ViewData.php:52
      • select count(*) as aggregate from `categories_store` where (`categories_store`.`store_id` = 3 and `categories_store`.`available` = 1 and `categories_store`.`url` = 'certificates-up')
        830μs/app/Http/Controllers/CatalogController.php:50sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        • 2. certificates-up
        Backtrace
        • 15. /app/Http/Controllers/CatalogController.php:50
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
        • 19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:29
      • select count(*) as aggregate from `pages_store` where (`pages_store`.`store_id` = 3 and `pages_store`.`available` = 1 and `pages_store`.`url` = 'certificates-up')
        520μs/app/Http/Controllers/CatalogController.php:125sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        • 2. certificates-up
        Backtrace
        • 15. /app/Http/Controllers/CatalogController.php:125
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
        • 19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:29
      • select * from `pages_store` left join `pages_descriptions` on `pages_descriptions`.`page_id` = `pages_store`.`page_id` where (`pages_store`.`store_id` = 3 and `pages_store`.`available` = 1 and `pages_descriptions`.`language_id` = 5 and `pages_descriptions`.`store_id` = 3 and `pages_store`.`url` = 'certificates-up') limit 1
        1.12ms/app/Http/Controllers/CatalogController.php:135sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        • 2. 5
        • 3. 3
        • 4. certificates-up
        Backtrace
        • 16. /app/Http/Controllers/CatalogController.php:135
        • 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
        • 20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:29
      • 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` = 5 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.15ms/app/Models/CountrieDescription.php:76sistersaroma
        Metadata
        Bindings
        • 0. 5
        • 1. 1
        Backtrace
        • 14. /app/Models/CountrieDescription.php:76
        • 15. /app/Http/Controllers/CatalogController.php:136
        • 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` = 3 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
        1.26ms/app/Models/Categorie.php:148sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        • 2. 1
        • 3. 0
        • 4. 3
        • 5. 60
        • 6. 21
        Backtrace
        • 14. /app/Models/Categorie.php:148
        • 15. /app/Http/Controllers/CatalogController.php:162
        • 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, 10, 12, 13, 17, 19, 20, 22, 30, 38, 40, 53, 57, 58, 67, 69, 86, 117, 119, 122, 123, 126) and (`store_id` = 3 and `type` = 'icon')
        620μs/app/Models/Categorie.php:148sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. icon
        Backtrace
        • 19. /app/Models/Categorie.php:148
        • 20. /app/Http/Controllers/CatalogController.php:162
        • 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, 10, 12, 13, 17, 19, 20, 22, 30, 38, 40, 53, 57, 58, 67, 69, 86, 117, 119, 122, 123, 126) and (`store_id` = 3 and `available` = 1)
        1.15ms/app/Models/Categorie.php:148sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        Backtrace
        • 19. /app/Models/Categorie.php:148
        • 20. /app/Http/Controllers/CatalogController.php:162
        • 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, 10, 12, 13, 17, 19, 20, 22, 30, 38, 40, 53, 57, 58, 67, 69, 86, 117, 119, 122, 123, 126) and (`store_id` = 3 and `language_id` = 5)
        970μs/app/Models/Categorie.php:148sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        Backtrace
        • 19. /app/Models/Categorie.php:148
        • 20. /app/Http/Controllers/CatalogController.php:162
        • 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` = 3 and `available` = 1)) and (`stock` is null and `status` = 1 and `parent` <> 0) and `id` <> 21
        940μs/app/Models/Categorie.php:193sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        • 2. 1
        • 3. 0
        • 4. 21
        Backtrace
        • 14. /app/Models/Categorie.php:193
        • 15. /app/Http/Controllers/CatalogController.php:162
        • 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, 46, 47, 48, 59, 62, 63, 64, 65, 66, 73, 102, 103, 104, 105, 106, 107, 111, 112, 113, 124, 125) and (`store_id` = 3 and `type` = 'icon')
        540μs/app/Models/Categorie.php:193sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. icon
        Backtrace
        • 19. /app/Models/Categorie.php:193
        • 20. /app/Http/Controllers/CatalogController.php:162
        • 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, 46, 47, 48, 59, 62, 63, 64, 65, 66, 73, 102, 103, 104, 105, 106, 107, 111, 112, 113, 124, 125) and (`store_id` = 3 and `available` = 1)
        620μs/app/Models/Categorie.php:193sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        Backtrace
        • 19. /app/Models/Categorie.php:193
        • 20. /app/Http/Controllers/CatalogController.php:162
        • 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, 46, 47, 48, 59, 62, 63, 64, 65, 66, 73, 102, 103, 104, 105, 106, 107, 111, 112, 113, 124, 125) and (`store_id` = 3 and `language_id` = 5)
        1.17ms/app/Models/Categorie.php:193sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        Backtrace
        • 19. /app/Models/Categorie.php:193
        • 20. /app/Http/Controllers/CatalogController.php:162
        • 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` = 3 and `pages_descriptions`.`store_id` = 3 and `pages_descriptions`.`language_id` = 5) order by `pages`.`id` asc
        1.37ms/app/Models/Page.php:65sistersaroma
        Metadata
        Bindings
        • 0. 1
        • 1. 0
        • 2. 1
        • 3. 3
        • 4. 3
        • 5. 5
        Backtrace
        • 14. /app/Models/Page.php:65
        • 15. /app/Http/Controllers/CatalogController.php:163
        • 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` = 3)
        820μs/app/Models/StoreLanguage.php:69sistersaroma
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 14. /app/Models/StoreLanguage.php:69
        • 15. /app/Http/Controllers/CatalogController.php:165
        • 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` = 3 and `language_id` = 5) order by `sort` desc
        620μs/app/Providers/AppServiceProvider.php:175sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        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` = "3") = 1)
        1.82ms/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` = "3" AND `language_id` = "5" 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` = "3" AND `reviews`.`language_id` = "5" ) 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` = "3" AND `reviews`.`language_id` = "5" ) 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "32" AND `currency_id` = "3" LIMIT 1) ), IFNULL( (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND end <= "2025-04-05 14:19:19"), 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND end <= "2025-04-05 14:19:19"), "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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), "0" ) )) as sell_price, CONCAT( (SELECT `name` FROM `option_descriptions` WHERE `language_id` = "5" AND `option_id` = `products_options`.`option_id` LIMIT 1), ":", (SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "5" 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` = "4" ORDER BY qty DESC LIMIT 1), IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "32" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "4" 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` = 3)) left join `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` = 5)) where (`products`.`status` = 1 and `products_descriptions`.`store_id` = 3 and `products_descriptions`.`language_id` = 5 and `products_store`.`store_id` = 3 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` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "32" AND `currency_id` = "3" LIMIT 1) ), IFNULL( (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" AND `sell_status` = 1 AND `start` <= "2025-04-05 14:19:19" AND end >= "2025-04-05 14:19:19" LIMIT 1), (SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "32" AND `currency_id` = "3" LIMIT 1) ) ) > 0) and 0 = 1 and (`products`.`status` = 1 and `products_descriptions`.`store_id` = 3 and `products_descriptions`.`language_id` = 5 and `products_store`.`store_id` = 3 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` = "4" LIMIT 1), (SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "4" LIMIT 1) ), 0) <> 0) order by `products_options`.`sort` asc
        2.32ms/app/Models/Product.php:959sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        • 2. 1
        • 3. 3
        • 4. 5
        • 5. 3
        • 6. 1
        • 7. 0
        • 8. 1
        • 9. 3
        • 10. 5
        • 11. 3
        • 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` = 3 and `language_id` = 5 and `code` = 'popup')
        620μs/app/Providers/AppServiceProvider.php:186sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        • 2. popup
        Backtrace
        • 14. /app/Providers/AppServiceProvider.php:186
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • select concat(IF(code = "ua","uk",code),IF(code = "en" and systems_store.store_id = "3","",alternate)) as hreflang, concat("https://",domen,IF(language_default = language_id,concat("/",pages_store.url,"/"),concat("/",code,"/",pages_store.url,"/"))) as href from `systems_store` left join `store_language` on `store_language`.`store_id` = `systems_store`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` left join `pages_store` on `pages_store`.`store_id` = `systems_store`.`store_id` where (`store_language`.`id` <> '472' and `pages_store`.`page_id` = 42 and `pages_store`.`available` = 1) order by `systems_store`.`store_id` asc
        900μs/app/Providers/AppServiceProvider.php:140sistersaroma
        Metadata
        Bindings
        • 0. 472
        • 1. 42
        • 2. 1
        Backtrace
        • 14. /app/Providers/AppServiceProvider.php:140
        • 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
      5
      App\Models\Page
      8
      App\Models\CategorieDescription
      49
      App\Models\CategorieStore
      57
      App\Models\CategorieImage
      45
      App\Models\Categorie
      57
      App\Models\CountrieDescription
      77
      App\Models\PageStore
      1
      App\Models\StoreLanguage
      4
      App\Models\Admin\SystemStore
      8
          _token
          dNzC4BcvAcyfJ90ke5LIHiWCXmSXeTHWhw3HKJXG
          cartOrder
          Illuminate\Support\Collection {#2275 #items: [] #escapeWhenCastingToString: false }
          check_country
          false
          _previous
          array:1 [ "url" => "https://eu.sisterscare.store/certificates-up" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /certificates-up/
          status_code
          200
          
          status_text
          OK
          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=eyJpdiI6IkRaNG44LzJwTFF3Wnp0K0dLUXNzSHc9PSIsInZhbHVlIjoiSnVPc3dOMlA3UG5ORGJWVjB0dXFxVDF4VlBIa0ZiMGhvMlFYWTRTdVNoQTZod2xrN3ZsamxsbVVXeFAwYTFjcWoyTVZyMytGUVNsYzUzRXhqVWxxNm5tVzBoMENFZlFCcnhPYkJ5d1B5V0gyYlFCM29CMjJtSDd0ckZldmlaWGgiLCJtYWMiOiJiZDc2MGQ1ODBiYzU0NTRiZTYwNDg5NDE1MDdiMzUzMDM5YTc2YjQ0ZTQ5NmEyOTBjZjE4ZWVkNzNmNDE1MmNiIiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6IkdXbURBVStkZTV4dFN6Zzl0dDNRY2c9PSIsInZhbHVlIjoid2FVSFFRdS9hczRjRzRzSXNTU2tBWFBRWk9jeTU5akR5WE11NnQ5bkRidHJ0OTliWUw2RWNTTnBqUHE4ZWttM2VoeGJsamdGNjZSeEdGM1VOOWxDdWVUVHRUWW5nZ2J2UUtrejhqLytwRzFSOVdHaXZGSDA1Q1IxRDN2ZFJPZHkiLCJtYWMiOiIyNjUzMTVlODM5NzhhMzc3NjRjYWJiMDNmNGEyNGYzYTExYmI5MDllMmRhMjYzZWQxNTJhMDg0Yjk0NzM1ZjEzIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IkRaNG44LzJwTFF3Wnp0K0dLUXNzSHc9PSIsInZhbHVlIjoiSnVPc3dOMlA3UG5ORGJWVjB0dXFxVDF4VlBIa0ZiMGhvMlFYWTRTdVNoQTZod2xrN3ZsamxsbVVXeFAwYTFjcWoyTVZyM" ] "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 => "eu.sisterscare.store" ] ]
          request_server
          0 of 0
          array:51 [ "USER" => "sisters" "HOME" => "/home/sisters" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/certificates-up/" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/certificates-up/" "REMOTE_PORT" => "64695" "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.216.21.140" "SERVER_PORT" => "443" "SERVER_ADDR" => "23.88.80.106" "SERVER_NAME" => "eu.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=eyJpdiI6IkRaNG44LzJwTFF3Wnp0K0dLUXNzSHc9PSIsInZhbHVlIjoiSnVPc3dOMlA3UG5ORGJWVjB0dXFxVDF4VlBIa0ZiMGhvMlFYWTRTdVNoQTZod2xrN3ZsamxsbVVXeFAwYTFjcWoyTVZyMytGUVNsYzUzRXhqVWxxNm5tVzBoMENFZlFCcnhPYkJ5d1B5V0gyYlFCM29CMjJtSDd0ckZldmlaWGgiLCJtYWMiOiJiZDc2MGQ1ODBiYzU0NTRiZTYwNDg5NDE1MDdiMzUzMDM5YTc2YjQ0ZTQ5NmEyOTBjZjE4ZWVkNzNmNDE1MmNiIiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6IkdXbURBVStkZTV4dFN6Zzl0dDNRY2c9PSIsInZhbHVlIjoid2FVSFFRdS9hczRjRzRzSXNTU2tBWFBRWk9jeTU5akR5WE11NnQ5bkRidHJ0OTliWUw2RWNTTnBqUHE4ZWttM2VoeGJsamdGNjZSeEdGM1VOOWxDdWVUVHRUWW5nZ2J2UUtrejhqLytwRzFSOVdHaXZGSDA1Q1IxRDN2ZFJPZHkiLCJtYWMiOiIyNjUzMTVlODM5NzhhMzc3NjRjYWJiMDNmNGEyNGYzYTExYmI5MDllMmRhMjYzZWQxNTJhMDg0Yjk0NzM1ZjEzIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IkRaNG44LzJwTFF3Wnp0K0dLUXNzSHc9PSIsInZhbHVlIjoiSnVPc3dOMlA3UG5ORGJWVjB0dXFxVDF4VlBIa0ZiMGhvMlFYWTRTdVNoQTZod2xrN3ZsamxsbVVXeFAwYTFjcWoyTVZyM" "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" => "eu.sisterscare.store" "proxy-nokeepalive" => "1" "SSL_TLS_SNI" => "eu.sisterscare.store" "HTTPS" => "on" "UNIQUE_ID" => "Z-ERt30NeshV5PSZf9eM7AAAAUE" "REDIRECT_STATUS" => "200" "REDIRECT_SSL_TLS_SNI" => "eu.sisterscare.store" "REDIRECT_HTTPS" => "on" "REDIRECT_UNIQUE_ID" => "Z-ERt30NeshV5PSZf9eM7AAAAUE" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743851959.2727 "REQUEST_TIME" => 1743851959 ]
          request_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "dNzC4BcvAcyfJ90ke5LIHiWCXmSXeTHWhw3HKJXG" "sisters_aroma_session" => "ricHchAbIft1tC3C7OHBDZkrJMjhk6ov23WprmIb" ]
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 05 Apr 2025 11:19:19 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlprUVZOU2g4Tk4wbDZXWHMyUGs5NGc9PSIsInZhbHVlIjoiU0VDaDFUdWdHSnRaMkw3QWFsQVgydU9MeDZMTXhBaDR5dHlVdHRKbTdnY2syMGxwUXdJZ0RBY2ZHZmdlVnlQblpvTjFQaU8vZFN3UFhVTlJCeGpyeUJqdkJ2YkR1RWJSdE5GZGFORHgxdEE2WnQ0YUh0WlZMSWsxUmZlWlphVysiLCJtYWMiOiIwMTIxZTk5NmYyZGM1NTdiMTM4ODZmYzc3M2NhOWU4YWMwODUxMDk4YWZiMzVlOWNkOWYxNWYxOWU0MjY0NjVjIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:39:19 GMT; Max-Age=19200; path=/; domain=.sisterscare.storeXSRF-TOKEN=eyJpdiI6IlprUVZOU2g4Tk4wbDZXWHMyUGs5NGc9PSIsInZhbHVlIjoiU0VDaDFUdWdHSnRaMkw3QWFsQVgydU9MeDZMTXhBaDR5dHlVdHRKbTdnY2syMGxwUXdJZ0RBY2ZHZmdlVnlQblpvTjFQa" 1 => "sisters_aroma_session=eyJpdiI6IjZPVU5tWUdZdmR4UGxDUFNKNTdxenc9PSIsInZhbHVlIjoiam4zTVdobGNzbENnVm1JWTFab3ljZnQ1djFzbEtwRFRBTGIwbFlORHh4WURnQmpweks2RkRYRlVGNkNzRFNCWGtmbzZ2WmFuTTYxRlRyRmdxQTFRWFFBZzd2ay9TaTQ2dmh2Njh2ZStCQVBGaXh3NnBzQUhKTmREaHgzcytjRzkiLCJtYWMiOiIyMTAwYzE3MmYyOGIxODJmNWU2MzYwZTVlMDc4ZDZiMzZiMzk3NTEyMmQ1MTYwNGU4MTdiY2I1MTA2NmRkNWI4IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:39:19 GMT; Max-Age=19200; path=/; domain=.sisterscare.store; httponlysisters_aroma_session=eyJpdiI6IjZPVU5tWUdZdmR4UGxDUFNKNTdxenc9PSIsInZhbHVlIjoiam4zTVdobGNzbENnVm1JWTFab3ljZnQ1djFzbEtwRFRBTGIwbFlORHh4WURnQmpweks2RkRYRlVGNkNzRF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlprUVZOU2g4Tk4wbDZXWHMyUGs5NGc9PSIsInZhbHVlIjoiU0VDaDFUdWdHSnRaMkw3QWFsQVgydU9MeDZMTXhBaDR5dHlVdHRKbTdnY2syMGxwUXdJZ0RBY2ZHZmdlVnlQblpvTjFQaU8vZFN3UFhVTlJCeGpyeUJqdkJ2YkR1RWJSdE5GZGFORHgxdEE2WnQ0YUh0WlZMSWsxUmZlWlphVysiLCJtYWMiOiIwMTIxZTk5NmYyZGM1NTdiMTM4ODZmYzc3M2NhOWU4YWMwODUxMDk4YWZiMzVlOWNkOWYxNWYxOWU0MjY0NjVjIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:39:19 GMT; domain=.sisterscare.store; path=/XSRF-TOKEN=eyJpdiI6IlprUVZOU2g4Tk4wbDZXWHMyUGs5NGc9PSIsInZhbHVlIjoiU0VDaDFUdWdHSnRaMkw3QWFsQVgydU9MeDZMTXhBaDR5dHlVdHRKbTdnY2syMGxwUXdJZ0RBY2ZHZmdlVnlQblpvTjFQa" 1 => "sisters_aroma_session=eyJpdiI6IjZPVU5tWUdZdmR4UGxDUFNKNTdxenc9PSIsInZhbHVlIjoiam4zTVdobGNzbENnVm1JWTFab3ljZnQ1djFzbEtwRFRBTGIwbFlORHh4WURnQmpweks2RkRYRlVGNkNzRFNCWGtmbzZ2WmFuTTYxRlRyRmdxQTFRWFFBZzd2ay9TaTQ2dmh2Njh2ZStCQVBGaXh3NnBzQUhKTmREaHgzcytjRzkiLCJtYWMiOiIyMTAwYzE3MmYyOGIxODJmNWU2MzYwZTVlMDc4ZDZiMzZiMzk3NTEyMmQ1MTYwNGU4MTdiY2I1MTA2NmRkNWI4IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 16:39:19 GMT; domain=.sisterscare.store; path=/; httponlysisters_aroma_session=eyJpdiI6IjZPVU5tWUdZdmR4UGxDUFNKNTdxenc9PSIsInZhbHVlIjoiam4zTVdobGNzbENnVm1JWTFab3ljZnQ1djFzbEtwRFRBTGIwbFlORHh4WURnQmpweks2RkRYRlVGNkNzRF" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "dNzC4BcvAcyfJ90ke5LIHiWCXmSXeTHWhw3HKJXG" "cartOrder" => Illuminate\Support\Collection {#2275 #items: [] #escapeWhenCastingToString: false } "check_country" => false "_previous" => array:1 [ "url" => "https://eu.sisterscare.store/certificates-up" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          Online help
          Upload FileCall