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
Certificates
Certificates
3 products
30 €
50 €
100 €

Certificates

Filters
Show
🎁
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 Version104msRequest Duration8MBMemory UsageGET {url}Route
    • Booting (16.47ms)
    • Application (87.7ms)
    • 1 x Application (84.18%)
      87.70ms
      1 x Booting (15.81%)
      16.47ms
      82 templates were rendered
      • front.pages.catalog (resources/views/front/pages/catalog.blade.php)15blade
        Params
        0
        seo_type
        1
        parent
        2
        slag
        3
        banner
        4
        catalog
        5
        categorie_id
        6
        filter
        7
        catalogSlid
        8
        products
        9
        menu_categories
        10
        menu_pages
        11
        store
        12
        countries
        13
        languages
        14
        productsHistory
      • front.shared.header (resources/views/front/shared/header.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
      • front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
      • front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
        23
        value
        24
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
        23
        value
        24
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
        23
        value
        24
        type
      • front.shared.customSelectLocaleWrap (resources/views/front/shared/customSelectLocaleWrap.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
      • front.shared.customSelectLangWrap (resources/views/front/shared/customSelectLangWrap.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
        23
        value
        24
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
        23
        value
        24
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
        23
        value
        24
        type
      • front.shared.menu (resources/views/front/shared/menu.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
      • front.shared.mobHeadLine (resources/views/front/shared/mobHeadLine.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
      • front.shared.mobBottomLine (resources/views/front/shared/mobBottomLine.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        top_text
        20
        __currentLoopData
        21
        text
        22
        loop
      • front.components.catalogHeader (resources/views/front/components/catalogHeader.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
      • front.components.productList (resources/views/front/components/productList.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
      • front.shared.cardItem (resources/views/front/shared/cardItem.blade.php)2blade
        Params
        0
        key
        1
        item
      • front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.btnFavorites (resources/views/front/shared/cardItem/btnFavorites.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.photo (resources/views/front/shared/cardItem/photo.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.reviews (resources/views/front/shared/cardItem/reviews.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.prise (resources/views/front/shared/cardItem/prise.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.label (resources/views/front/shared/cardItem/label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.buttonBay (resources/views/front/shared/cardItem/buttonBay.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem (resources/views/front/shared/cardItem.blade.php)2blade
        Params
        0
        key
        1
        item
      • front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.btnFavorites (resources/views/front/shared/cardItem/btnFavorites.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.photo (resources/views/front/shared/cardItem/photo.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.reviews (resources/views/front/shared/cardItem/reviews.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.prise (resources/views/front/shared/cardItem/prise.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.label (resources/views/front/shared/cardItem/label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.buttonBay (resources/views/front/shared/cardItem/buttonBay.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem (resources/views/front/shared/cardItem.blade.php)2blade
        Params
        0
        key
        1
        item
      • front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.custom_label (resources/views/front/shared/cardItem/custom_label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.btnFavorites (resources/views/front/shared/cardItem/btnFavorites.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.photo (resources/views/front/shared/cardItem/photo.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.reviews (resources/views/front/shared/cardItem/reviews.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.prise (resources/views/front/shared/cardItem/prise.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.label (resources/views/front/shared/cardItem/label.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.cardItem.buttonBay (resources/views/front/shared/cardItem/buttonBay.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        key
        5
        item
      • front.shared.productCarouselViewed (resources/views/front/shared/productCarouselViewed.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
      • front.shared.seoText (resources/views/front/shared/seoText.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
      • front.components.catalogFilter (resources/views/front/components/catalogFilter.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
      • front.shared.footer (resources/views/front/shared/footer.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        type
      • front.svg.mastercard (resources/views/front/svg/mastercard.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.svg.visa (resources/views/front/svg/visa.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.shared.mobileModal (resources/views/front/shared/mobileModal.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.svg.globe (resources/views/front/svg/globe.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.shared.mobileModalTabCatalog (resources/views/front/shared/mobileModalTabCatalog.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.shared.mobileModalTabInfo (resources/views/front/shared/mobileModalTabInfo.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.shared.mobileModalTabRegion (resources/views/front/shared/mobileModalTabRegion.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        type
      • front.components.check.checkLinks (resources/views/front/components/check/checkLinks.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        type
      • front.modals.login (resources/views/front/modals/login.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalLoginSMS (resources/views/front/modals/modalLoginSMS.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalVerificationCode (resources/views/front/modals/modalVerificationCode.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalMiles (resources/views/front/modals/modalMiles.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalPreOrder (resources/views/front/modals/modalPreOrder.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalBuyOneClick (resources/views/front/modals/modalBuyOneClick.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalReportAvailability (resources/views/front/modals/modalReportAvailability.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.passwordRecovery (resources/views/front/modals/passwordRecovery.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.yourRegion (resources/views/front/modals/yourRegion.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.cardModal (resources/views/front/modals/cardModal.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.shared.card (resources/views/front/shared/card.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        sale_status
      • front.shared.checkont.promoInputsWrap (resources/views/front/shared/checkont/promoInputsWrap.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        sale_status
      • front.shared.productCarouselViewedCart (resources/views/front/shared/productCarouselViewedCart.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        sale_status
      • front.modals.giftModal (resources/views/front/modals/giftModal.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalGetDiscount (resources/views/front/modals/modalGetDiscount.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalSubscription (resources/views/front/modals/modalSubscription.blade.php)31blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
        30
        systemDescription
      • front.modals.modalSubscriptionSuccess (resources/views/front/modals/modalSubscriptionSuccess.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.modals.modalCookie (resources/views/front/modals/modalCookie.blade.php)30blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        isNews
        20
        __currentLoopData
        21
        menu_categorie
        22
        key
        23
        loop
        24
        cheldren
        25
        menu_page
        26
        order
        27
        orderIndexes
        28
        store_countries
        29
        value
      • front.layouts.app (resources/views/front/layouts/app.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        alternate
      • front.components.canonical (resources/views/front/components/canonical.blade.php)24blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        alternate
        20
        isDisable
        21
        locale
        22
        path
        23
        disablePaths
      • front.components.alternate (resources/views/front/components/alternate.blade.php)24blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        __sentry_tracing_view_name
        4
        seo_type
        5
        parent
        6
        slag
        7
        banner
        8
        catalog
        9
        categorie_id
        10
        filter
        11
        catalogSlid
        12
        products
        13
        menu_categories
        14
        menu_pages
        15
        store
        16
        countries
        17
        languages
        18
        productsHistory
        19
        alternate
        20
        isDisable
        21
        locale
        22
        path
        23
        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
      30 statements were executed, 3 of which were duplicated, 27 unique40.75ms
      • 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.23ms/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
        830μsmiddleware::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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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,"_","_"))
        3.04ms/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
        490μ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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01"), 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-03 19:21:01"), "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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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.78ms/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-03")) as bonus_ball from `users` where `id` = 0 limit 1
        660μ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
        440μ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` = 'sertifikaty')
        720μs/app/Http/Controllers/CatalogController.php:50sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        • 2. sertifikaty
        Backtrace
        • 15. /app/Http/Controllers/CatalogController.php:50
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
        • 19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:29
      • select *, `categories`.`parent`, `categories_store`.`type` as `type`, `categories_descriptions`.`title` as `title`, `categories_store`.`categorie_id` as `categorie_id`, (SELECT `url` FROM `categories_images` WHERE `type` = "mobail" AND `store_id` = categories_store.store_id AND `categorie_id` = `categories_store`.`categorie_id` LIMIT 1) as urlMobile, (SELECT `url` FROM `categories_images` WHERE `type` = "seo" AND `store_id` = categories_store.store_id AND `categorie_id` = `categories_store`.`categorie_id` LIMIT 1) as seo_url from `categories_store` left join `categories` on `categories`.`id` = `categories_store`.`categorie_id` left join `categories_descriptions` on `categories_descriptions`.`categorie_id` = `categories_store`.`categorie_id` left join `categories_images` on ((`categories_images`.`categorie_id` = categories_store.categorie_id and `categories_images`.`store_id` = 3 and `categories_images`.`type` LIKE 'main')) where (`categories_store`.`store_id` = 3 and `categories_store`.`available` = 1 and `categories_descriptions`.`language_id` = 5 and `categories_descriptions`.`store_id` = 3 and `categories_store`.`url` LIKE 'sertifikaty') limit 1
        730μs/app/Models/CategorieStore.php:95sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. main
        • 2. 3
        • 3. 1
        • 4. 5
        • 5. 3
        • 6. sertifikaty
        Backtrace
        • 16. /app/Models/CategorieStore.php:95
        • 17. /app/Http/Controllers/CatalogController.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01"), 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-03 19:21:01"), "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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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 `products`.`id` IN (SELECT `product_id` FROM `products_categories` WHERE `categorie_id` = "12") AND IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) = 0 order by IF(products_status <> 2,IF( IFNULL(IFNULL( (SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "4" ORDER BY qty DESC LIMIT 1), (SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "4" LIMIT 1) ),0) > 0,1,0),0) ASC, IFNULL(`products_descriptions`.`sort`,99999999) ASC, `products_options`.`sort` asc
        10.53ms/app/Models/Product.php:349sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        • 2. 1
        • 3. 3
        • 4. 5
        • 5. 3
        • 6. 1
        • 7. 0
        Backtrace
        • 12. /app/Models/Product.php:349
        • 13. /app/Http/Controllers/CatalogController.php:72
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select `banners`.`id`, " " as product_id, "1" as sort, "0" as notAddToCard, " " as date, " " as name, " " as item_list_name, " " as item_list_id, " " as title_description, " " as labelType, " " as labelText, " " as value_id, (SELECT url FROM `banners_descriptions` WHERE `banner_id` = banners.id AND `store_id` = "3" AND `language_id` = "5") as link, IF(banners.type = 2,"1","2") as type, (banners_store.sort) as sort_banner, " " as alt, " " as currency, " " as price, " " as sell_price, "1" as quantityMax, (SELECT `image` FROM `banners_images` WHERE `banner_id` = `banners_store`.`banner_id` AND `store_id` = `banners_store`.`store_id` AND `language_id` = 5 AND `type` = "pc" LIMIT 1) as url, (SELECT `image` FROM `banners_images` WHERE `banner_id` = `banners_store`.`banner_id` AND `store_id` = `banners_store`.`store_id` AND `language_id` = 5 AND `type` = "tablet" LIMIT 1) as hover from `banners_store` left join `banners` on `banners_store`.`banner_id` = `banners`.`id` where (`categorie` = 12 and `banners_store`.`status` = 1 and `banners`.`status` = 1 and `banners_store`.`date_start` <= '2025.04.03 19:21' and `banners_store`.`date_finish` >= '2025.04.03 19:21' and `store_id` = 3 and `banners`.`type` = 2) or (`categorie` = 12 and `banners_store`.`status` = 1 and `banners`.`status` = 1 and `banners_store`.`date_start` <= '2025.04.03 19:21' and `banners_store`.`date_finish` >= '2025.04.03 19:21' and `store_id` = 3 and `banners`.`type` = 3)
        980μs/app/Models/Product.php:400sistersaroma
        Metadata
        Bindings
        • 0. 12
        • 1. 1
        • 2. 1
        • 3. 2025.04.03 19:21
        • 4. 2025.04.03 19:21
        • 5. 3
        • 6. 2
        • 7. 12
        • 8. 1
        • 9. 1
        • 10. 2025.04.03 19:21
        • 11. 2025.04.03 19:21
        • 12. 3
        • 13. 3
        Backtrace
        • 12. /app/Models/Product.php:400
        • 13. /app/Http/Controllers/CatalogController.php:72
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select distinct `banners_images`.`image` as `url` from `banners` left join `banners_store` on `banners_store`.`banner_id` = `banners`.`id` left join `banners_images` on `banners_images`.`banner_id` = `banners`.`id` where (`categorie` = 12 and `banners_store`.`status` = 1 and `banners`.`status` = 1 and `banners_store`.`date_start` <= '2025.04.03 19:21' and `banners_store`.`date_finish` >= '2025.04.03 19:21' and `banners_store`.`store_id` = 3 and `banners_images`.`store_id` = 3 and `banners_images`.`language_id` = 5 and `banners`.`type` = 4 and `banners_images`.`type` = 'pc') order by `banners_store`.`sort` asc limit 1
        810μs/app/Models/Banner.php:69sistersaroma
        Metadata
        Bindings
        • 0. 12
        • 1. 1
        • 2. 1
        • 3. 2025.04.03 19:21
        • 4. 2025.04.03 19:21
        • 5. 3
        • 6. 3
        • 7. 5
        • 8. 4
        • 9. pc
        Backtrace
        • 15. /app/Models/Banner.php:69
        • 16. /app/Http/Controllers/CatalogController.php:73
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select distinct `filter_id`, `value_id`, (SELECT `name` FROM `filter_descriptions` WHERE `filter_id` = `products_filter`.`filter_id` AND `language_id` = "5") as filter_name, (SELECT `name` FROM `filter_value_descriptions` WHERE `value_id` = `products_filter`.`value_id` AND `language_id` = "5") as value_name from `products_filter` where (`products_filter`.`status` = 1 and `products_filter`.`store_id` = 3) and `products_filter`.`product_id` IN (SELECT `product_id` FROM `products_categories` WHERE `categorie_id` = "12" AND (SELECT `available` FROM `products_store` WHERE `product_id` = `products_categories`.`product_id` AND `store_id` = "3") = 1)
        760μs/app/Models/Filter.php:72sistersaroma
        Metadata
        Bindings
        • 0. 1
        • 1. 3
        Backtrace
        • 14. /app/Models/Filter.php:72
        • 15. /app/Http/Controllers/CatalogController.php:102
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select `id` from `categories` where exists (select * from `categories_store` where `categories`.`id` = `categories_store`.`categorie_id` and (`store_id` = 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
        700μs/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:114
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select * from `categories_images` where `categories_images`.`categorie_id` in (5, 6, 7, 8, 9, 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')
        750μ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:114
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select * from `categories_store` where `categories_store`.`categorie_id` in (5, 6, 7, 8, 9, 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)
        690μs/app/Models/Categorie.php:148sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        Backtrace
        • 19. /app/Models/Categorie.php:148
        • 20. /app/Http/Controllers/CatalogController.php:114
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select * from `categories_descriptions` where `categories_descriptions`.`categorie_id` in (5, 6, 7, 8, 9, 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)
        1.12ms/app/Models/Categorie.php:148sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        Backtrace
        • 19. /app/Models/Categorie.php:148
        • 20. /app/Http/Controllers/CatalogController.php:114
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select `id`, `parent` from `categories` where exists (select * from `categories_store` where `categories`.`id` = `categories_store`.`categorie_id` and (`store_id` = 3 and `available` = 1)) and (`stock` is null and `status` = 1 and `parent` <> 0) and `id` <> 21
        770μ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:114
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select * from `categories_images` where `categories_images`.`categorie_id` in (27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 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')
        670μ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:114
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select * from `categories_store` where `categories_store`.`categorie_id` in (27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 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)
        790μ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:114
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select * from `categories_descriptions` where `categories_descriptions`.`categorie_id` in (27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 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)
        720μs/app/Models/Categorie.php:193sistersaroma
        Metadata
        Bindings
        • 0. 3
        • 1. 5
        Backtrace
        • 19. /app/Models/Categorie.php:193
        • 20. /app/Http/Controllers/CatalogController.php:114
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select distinct `pages`.`id`, `pages_store`.`url`, `pages_descriptions`.`name` from `pages` left join `pages_store` on `pages_store`.`page_id` = `pages`.`id` left join `pages_descriptions` on `pages_descriptions`.`page_id` = `pages`.`id` where (`pages`.`status` = 1 and `pages_store`.`menu` = 0 and `pages_store`.`available` = 1 and `pages_store`.`store_id` = 3 and `pages_descriptions`.`store_id` = 3 and `pages_descriptions`.`language_id` = 5) order by `pages`.`id` asc
        690μs/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:115
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select `countries_store`.`id` as `countries_store_id`, `countries`.`id`, `countries_descriptions`.`language_id`, `name`, `name` as `text`, `domen`, `cod`, `systems_store`.`store_id` from `countries_descriptions` left join `countries` on `countries`.`id` = `countries_descriptions`.`country_id` left join `countries_store` on `countries_store`.`country_id` = `countries_descriptions`.`country_id` left join `systems_store` on `systems_store`.`store_id` = `countries_store`.`store_id` where (`countries_descriptions`.`language_id` = 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.38ms/app/Models/CountrieDescription.php:76sistersaroma
        Metadata
        Bindings
        • 0. 5
        • 1. 1
        Backtrace
        • 14. /app/Models/CountrieDescription.php:76
        • 15. /app/Http/Controllers/CatalogController.php:117
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select distinct `language_id`, `name`, `code`, "0" as home, IF(language_default = language.id,1,0) as language_default, IF(language_default = language.id,"",CONCAT("/",code,"/")) as url from `store_language` left join `systems_store` on `systems_store`.`store_id` = `store_language`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` where (`store_language`.`store_id` = 3)
        720μs/app/Models/StoreLanguage.php:69sistersaroma
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 14. /app/Models/StoreLanguage.php:69
        • 15. /app/Http/Controllers/CatalogController.php:118
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product = 4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01"), 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-03 19:21:01"), "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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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.74ms/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/Http/Controllers/CatalogController.php:119
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • select * from `top_texts` where (`store_id` = 3 and `language_id` = 5) order by `sort` desc
        560μ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)
        920μs/app/Providers/AppServiceProvider.php:212sistersaroma
        Metadata
        Bindings
        • 0. 17
        • 1. 1
        • 2. 1
        Backtrace
        • 15. /app/Providers/AppServiceProvider.php:212
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show = 1, 1,(SELECT COUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product = 4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01"), 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-03 19:21:01"), "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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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-03 19:21:01" AND end >= "2025-04-03 19:21:01" 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.96ms/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')
        760μ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("/",categories_store.url,"/"),concat("/",code,"/",categories_store.url,"/"))) as href from `systems_store` left join `store_language` on `store_language`.`store_id` = `systems_store`.`store_id` left join `language` on `language`.`id` = `store_language`.`language_id` left join `categories_store` on `categories_store`.`store_id` = `systems_store`.`store_id` where (`store_language`.`id` <> '472' and `categories_store`.`categorie_id` = 12 and `categories_store`.`available` = 1) order by `systems_store`.`store_id` asc
        810μs/app/Providers/AppServiceProvider.php:123sistersaroma
        Metadata
        Bindings
        • 0. 472
        • 1. 12
        • 2. 1
        Backtrace
        • 14. /app/Providers/AppServiceProvider.php:123
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      App\Models\SystemDescription
      7
      App\Models\System\TopText
      5
      App\Models\CountrieDescription
      77
      App\Models\Page
      8
      App\Models\CategorieDescription
      49
      App\Models\CategorieImage
      45
      App\Models\Categorie
      57
      App\Models\CategorieStore
      58
      App\Models\StoreLanguage
      4
      App\Models\Admin\SystemStore
      13
          _token
          tFWv4TezOLUYjfRjojBsfuZN4XNOtSURi1ExJ3Z8
          cartOrder
          Illuminate\Support\Collection {#2275 #items: [] #escapeWhenCastingToString: false }
          check_country
          false
          _previous
          array:1 [ "url" => "https://eu.sisterscare.store/sertifikaty" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /sertifikaty/
          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=eyJpdiI6IncrRUFncERycERNbGJ6dTA3QVpGRmc9PSIsInZhbHVlIjoiTUswb2VnZFZIY0NSbGhWZktVVU5lNXNsbHo4UUlhWERVdVdOYjRQbC8rN1FuWmQ1dVh3dHJaVEEwOWNNWGI3alpPanhoS21Ja0pWc3dKOFhFSXlEZjRnS05ISXFVWnVkQ1BBdjF2SUN5Y3d5TWt0L1Vmdk9UN280Wi9keEE5SFIiLCJtYWMiOiI3ZjNiMmRiYWU0MGU4NDgxNDU3Y2ExNWE5NjVhYzczZGJiODMwNzEwNTRhMTFlNGRkNTg1NDIyYjg0NWU0NThhIiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6IjhKbG1xK05NeU5EUzc1RXZhWS91NEE9PSIsInZhbHVlIjoiUGlnWVVubDBnb3luMVJ5Z0NVV1lPTndmMVV3a0VYaUd5dW5aTWJjbmVGOTRpUEcxS0xGK1NKbW1qcDZGTVYycnR0czc3NTl3RStySWV6OHJ5RkVsRXMzVjNKd0VtSzE0ek43U3Q2OUxxUG1KM0RzcjQybGY3ZWd6TTBrMkVXaUIiLCJtYWMiOiJiZmY5N2M1MTdjZmUyNzU1ODU3ZjJmODY5ZWYwN2QwYTNjMzZlZWFlY2VhNDRiYTU2MTI4MzVmMTkwZDE3YjgzIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IncrRUFncERycERNbGJ6dTA3QVpGRmc9PSIsInZhbHVlIjoiTUswb2VnZFZIY0NSbGhWZktVVU5lNXNsbHo4UUlhWERVdVdOYjRQbC8rN1FuWmQ1dVh3dHJaVEEwOWNNWGI3alpPanhoS" ] "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" => "/sertifikaty/" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/sertifikaty/" "REMOTE_PORT" => "1679" "SCRIPT_FILENAME" => "/home/sisters/www/public/index.php" "SERVER_ADMIN" => "admin@sisterscare.store" "CONTEXT_DOCUMENT_ROOT" => "/home/sisters/www/public" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/sisters/www/public" "REMOTE_ADDR" => "18.191.112.81" "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=eyJpdiI6IncrRUFncERycERNbGJ6dTA3QVpGRmc9PSIsInZhbHVlIjoiTUswb2VnZFZIY0NSbGhWZktVVU5lNXNsbHo4UUlhWERVdVdOYjRQbC8rN1FuWmQ1dVh3dHJaVEEwOWNNWGI3alpPanhoS21Ja0pWc3dKOFhFSXlEZjRnS05ISXFVWnVkQ1BBdjF2SUN5Y3d5TWt0L1Vmdk9UN280Wi9keEE5SFIiLCJtYWMiOiI3ZjNiMmRiYWU0MGU4NDgxNDU3Y2ExNWE5NjVhYzczZGJiODMwNzEwNTRhMTFlNGRkNTg1NDIyYjg0NWU0NThhIiwidGFnIjoiIn0%3D; sisters_aroma_session=eyJpdiI6IjhKbG1xK05NeU5EUzc1RXZhWS91NEE9PSIsInZhbHVlIjoiUGlnWVVubDBnb3luMVJ5Z0NVV1lPTndmMVV3a0VYaUd5dW5aTWJjbmVGOTRpUEcxS0xGK1NKbW1qcDZGTVYycnR0czc3NTl3RStySWV6OHJ5RkVsRXMzVjNKd0VtSzE0ek43U3Q2OUxxUG1KM0RzcjQybGY3ZWd6TTBrMkVXaUIiLCJtYWMiOiJiZmY5N2M1MTdjZmUyNzU1ODU3ZjJmODY5ZWYwN2QwYTNjMzZlZWFlY2VhNDRiYTU2MTI4MzVmMTkwZDE3YjgzIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IncrRUFncERycERNbGJ6dTA3QVpGRmc9PSIsInZhbHVlIjoiTUswb2VnZFZIY0NSbGhWZktVVU5lNXNsbHo4UUlhWERVdVdOYjRQbC8rN1FuWmQ1dVh3dHJaVEEwOWNNWGI3alpPanhoS" "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@61bcFbuxsElerWuFMN6QAAAEs" "REDIRECT_STATUS" => "200" "REDIRECT_SSL_TLS_SNI" => "eu.sisterscare.store" "REDIRECT_HTTPS" => "on" "REDIRECT_UNIQUE_ID" => "Z@61bcFbuxsElerWuFMN6QAAAEs" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743697261.2743 "REQUEST_TIME" => 1743697261 ]
          request_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "tFWv4TezOLUYjfRjojBsfuZN4XNOtSURi1ExJ3Z8" "sisters_aroma_session" => "uvtnAucEqoKSVJKNUVcGcMtPkyFHoeZ38A3Th3U3" ]
          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 => "Thu, 03 Apr 2025 16:21:01 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InQzV0dzczNEbnNvaVBTVzBuckdrYkE9PSIsInZhbHVlIjoiN1dBUmxJTVVGUEtjMnVibGdVbGRUOEpxZFNIWDRZc3NNQUV6TDVHcUJjbFcrVEt3U25UaHJVVkdwb0thYnF3UWp2a0JyZGZwR283Y2ttaFA3ai96UzR2akNuMFI4N05YNGNVd2dqK2toQWhPRnlqY2JiZmxCK241ZGFwNExQTUgiLCJtYWMiOiIxYWUxOWJiZmU2NTk1ZDM3NjAyMDZmMmM0NmY3MTlhMjIyMzc5NzIwMmE5ODg3ODdkYzI2YzZiNTFjYjUwYjBhIiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 21:41:01 GMT; Max-Age=19200; path=/; domain=.sisterscare.storeXSRF-TOKEN=eyJpdiI6InQzV0dzczNEbnNvaVBTVzBuckdrYkE9PSIsInZhbHVlIjoiN1dBUmxJTVVGUEtjMnVibGdVbGRUOEpxZFNIWDRZc3NNQUV6TDVHcUJjbFcrVEt3U25UaHJVVkdwb0thYnF3UWp2a0JyZ" 1 => "sisters_aroma_session=eyJpdiI6Iml2VlpqcUtpelE0Mkw0Vks5Z0JYcnc9PSIsInZhbHVlIjoidU1IeEs5UDkzMldhRkNLVy94bkhJKzRpazdpWHJseHUxM2pON0tkamFWQ0cvdkF6TWN4Rmt2dFhocmtCZjBQWjQxZFBVN1BLOWhIelpKaFoxNUsrTFNNY0NOQ2dNYlRia3AxcHNlZ1VrRVN5bkdRamFvbXJHZ1VxSjI1SWQ2RWwiLCJtYWMiOiJjMWFlODZhN2YyODVmMGViMjcyNjQ3MDg3MTMxODUzOGYwMjc3NzNkZDljOTc3NzQyNzg3MjI4YTNhMjI1NWY1IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 21:41:01 GMT; Max-Age=19200; path=/; domain=.sisterscare.store; httponlysisters_aroma_session=eyJpdiI6Iml2VlpqcUtpelE0Mkw0Vks5Z0JYcnc9PSIsInZhbHVlIjoidU1IeEs5UDkzMldhRkNLVy94bkhJKzRpazdpWHJseHUxM2pON0tkamFWQ0cvdkF6TWN4Rmt2dFhocmtCZj" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InQzV0dzczNEbnNvaVBTVzBuckdrYkE9PSIsInZhbHVlIjoiN1dBUmxJTVVGUEtjMnVibGdVbGRUOEpxZFNIWDRZc3NNQUV6TDVHcUJjbFcrVEt3U25UaHJVVkdwb0thYnF3UWp2a0JyZGZwR283Y2ttaFA3ai96UzR2akNuMFI4N05YNGNVd2dqK2toQWhPRnlqY2JiZmxCK241ZGFwNExQTUgiLCJtYWMiOiIxYWUxOWJiZmU2NTk1ZDM3NjAyMDZmMmM0NmY3MTlhMjIyMzc5NzIwMmE5ODg3ODdkYzI2YzZiNTFjYjUwYjBhIiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 21:41:01 GMT; domain=.sisterscare.store; path=/XSRF-TOKEN=eyJpdiI6InQzV0dzczNEbnNvaVBTVzBuckdrYkE9PSIsInZhbHVlIjoiN1dBUmxJTVVGUEtjMnVibGdVbGRUOEpxZFNIWDRZc3NNQUV6TDVHcUJjbFcrVEt3U25UaHJVVkdwb0thYnF3UWp2a0JyZ" 1 => "sisters_aroma_session=eyJpdiI6Iml2VlpqcUtpelE0Mkw0Vks5Z0JYcnc9PSIsInZhbHVlIjoidU1IeEs5UDkzMldhRkNLVy94bkhJKzRpazdpWHJseHUxM2pON0tkamFWQ0cvdkF6TWN4Rmt2dFhocmtCZjBQWjQxZFBVN1BLOWhIelpKaFoxNUsrTFNNY0NOQ2dNYlRia3AxcHNlZ1VrRVN5bkdRamFvbXJHZ1VxSjI1SWQ2RWwiLCJtYWMiOiJjMWFlODZhN2YyODVmMGViMjcyNjQ3MDg3MTMxODUzOGYwMjc3NzNkZDljOTc3NzQyNzg3MjI4YTNhMjI1NWY1IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 21:41:01 GMT; domain=.sisterscare.store; path=/; httponlysisters_aroma_session=eyJpdiI6Iml2VlpqcUtpelE0Mkw0Vks5Z0JYcnc9PSIsInZhbHVlIjoidU1IeEs5UDkzMldhRkNLVy94bkhJKzRpazdpWHJseHUxM2pON0tkamFWQ0cvdkF6TWN4Rmt2dFhocmtCZj" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "tFWv4TezOLUYjfRjojBsfuZN4XNOtSURi1ExJ3Z8" "cartOrder" => Illuminate\Support\Collection {#2275 #items: [] #escapeWhenCastingToString: false } "check_country" => false "_previous" => array:1 [ "url" => "https://eu.sisterscare.store/sertifikaty" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          Online help
          Upload FileCall