Esse site utiliza cookies para melhorar a sua experiência de navegação. Consulte nossa política de privacidade.
1.47sRequest Duration8MBMemory UsageGET categorias/{categorySlug}Route
    • Booting (419.87ms)
    • Application (1.16s)
      78 templates were rendered
      • category (resources/themes/befit/desktop/views/category.blade.php)8blade
        Params
        0
        category
        1
        products
        2
        filter
        3
        sortBy
        4
        query
        5
        bannersGroup
        6
        seo
        7
        showCases
      • common.themes.breadcrumb.breadcrumb (resources/views/common/themes/breadcrumb/breadcrumb.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
      • common.themes.breadcrumb.partials.breadcrumb-item (resources/views/common/themes/breadcrumb/partials/breadcrumb-item.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
      • common.themes.breadcrumb.partials.breadcrumb-item (resources/views/common/themes/breadcrumb/partials/breadcrumb-item.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
      • common.themes.filter.filter (resources/views/common/themes/filter/filter.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        pageName
        15
        dlUser
      • common.themes.filter.sort-by (resources/views/common/themes/filter/sort-by.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
      • partials.content-product (resources/themes/befit/desktop/partials/content-product.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        pageName
        16
        dlUser
      • partials.content-product (resources/themes/befit/desktop/partials/content-product.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        pageName
        16
        dlUser
      • partials.content-product (resources/themes/befit/desktop/partials/content-product.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        pageName
        16
        dlUser
      • partials.content-product (resources/themes/befit/desktop/partials/content-product.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        pageName
        16
        dlUser
      • partials.content-product (resources/themes/befit/desktop/partials/content-product.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        pageName
        16
        dlUser
      • partials.content-product (resources/themes/befit/desktop/partials/content-product.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        pageName
        16
        dlUser
      • layouts.master (resources/themes/befit/desktop/layouts/master.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
      • common.themes.layouts.master (resources/views/common/themes/layouts/master.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
      • common.themes.dataLayer.global (resources/views/common/themes/dataLayer/global.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        pageName
        16
        dlUser
      • common.themes.scripts.script-head (resources/views/common/themes/scripts/script-head.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        script_header
      • common.themes.meta-tags.facebook-og (resources/views/common/themes/meta-tags/facebook-og.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
      • common.themes.styles.style-body (resources/views/common/themes/styles/style-body.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        style_body
        16
        style_checkout_cart
      • partials.header (resources/themes/befit/desktop/partials/header.blade.php)21blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        socialMedia
        16
        sections
        17
        cartTotalPrice
        18
        categories
        19
        pageName
        20
        dlUser
      • partials.menu (resources/themes/befit/desktop/partials/menu.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        socialMedia
        16
        sections
        17
        cartTotalPrice
        18
        categories
        19
        pageName
        20
        dlUser
        21
        featuredStores
        22
        menuItems
        23
        brands
      • common.themes.megamenu.megamenu (resources/views/common/themes/megamenu/megamenu.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        socialMedia
        16
        sections
        17
        cartTotalPrice
        18
        categories
        19
        pageName
        20
        dlUser
        21
        featuredStores
        22
        menuItems
        23
        brands
      • partials.menu-stores-list (resources/themes/befit/desktop/partials/menu-stores-list.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        socialMedia
        16
        sections
        17
        cartTotalPrice
        18
        categories
        19
        pageName
        20
        dlUser
        21
        featuredStores
        22
        menuItems
        23
        brands
      • partials.menu-brand-list (resources/themes/befit/desktop/partials/menu-brand-list.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        socialMedia
        16
        sections
        17
        cartTotalPrice
        18
        categories
        19
        pageName
        20
        dlUser
        21
        featuredStores
        22
        menuItems
        23
        brands
      • partials.header.menu.main-category (resources/themes/befit/desktop/partials/header/menu/main-category.blade.php)4blade
        Params
        0
        key
        1
        category
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category-children (resources/themes/befit/desktop/partials/header/menu/sub-category-children.blade.php)4blade
        Params
        0
        key
        1
        subCategoryChildren
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.main-category (resources/themes/befit/desktop/partials/header/menu/main-category.blade.php)4blade
        Params
        0
        key
        1
        category
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.main-category (resources/themes/befit/desktop/partials/header/menu/main-category.blade.php)4blade
        Params
        0
        key
        1
        category
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.main-category (resources/themes/befit/desktop/partials/header/menu/main-category.blade.php)4blade
        Params
        0
        key
        1
        category
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category-children (resources/themes/befit/desktop/partials/header/menu/sub-category-children.blade.php)4blade
        Params
        0
        key
        1
        subCategoryChildren
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.main-category (resources/themes/befit/desktop/partials/header/menu/main-category.blade.php)4blade
        Params
        0
        key
        1
        category
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.header.menu.sub-category (resources/themes/befit/desktop/partials/header/menu/sub-category.blade.php)4blade
        Params
        0
        key
        1
        subCategory
        2
        pageName
        3
        dlUser
      • partials.footer (resources/themes/befit/desktop/partials/footer.blade.php)20blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        sections
        16
        categories
        17
        socialMedia
        18
        pageName
        19
        dlUser
      • partials.newsletter (resources/themes/befit/desktop/partials/newsletter.blade.php)20blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        sections
        16
        categories
        17
        socialMedia
        18
        pageName
        19
        dlUser
      • common.partials.cookies-alert (resources/views/common/partials/cookies-alert.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
      • common.themes.styles.checkout-cart-styles (resources/views/common/themes/styles/checkout-cart-styles.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        style_checkout_cart
      • common.themes.scripts.script-body (resources/views/common/themes/scripts/script-body.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        script_body
        16
        trackingCode
      • common.themes.styles.checkout-cart-styles (resources/views/common/themes/styles/checkout-cart-styles.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        marketplace
        5
        loggedUser
        6
        seo
        7
        category
        8
        products
        9
        filter
        10
        sortBy
        11
        query
        12
        bannersGroup
        13
        showCases
        14
        product
        15
        style_checkout_cart
      uri
      GET categorias/{categorySlug}
      as
      store.category
      middleware
      geo.restriction, category.auth
      controller
      App\Http\Controllers\CategoriesController@index
      file
      app/Http/Controllers/CategoriesController.php:30-62
      45 statements were executed, 5 of which were duplicated, 40 unique184.41ms
      • select * from `cad_category` where `cad_category`.`deleted_at` is null and `slug` = 'esportes' and `status` = '1' order by `sequence` asc limit 11.66mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. esportes
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('147') order by `sequence` asc1.11mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 147
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_banner_group` where `cad_banner_group`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_banner_group` on `cad_category`.`id` = `cad_category_banner_group`.`category_id` where `cad_category_banner_group`.`banner_group_id` = `cad_banner_group`.`id` and `id` = '147' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc1.66mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 147
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cad_product`.`id` from `cad_product` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_sku` on `cad_product`.`id` = `cad_sku`.`product_id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_product`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `category_id` in ('147') and `cad_category`.`deleted_at` is null) >= 1 and (`cad_product`.`publish` = '1' and `cad_product`.`deleted_at` is null) and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `status` = '1' and `cad_category`.`deleted_at` is null) >= 1 and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1 and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `status` = '1' and `percent` >= '6.5' and `cad_store`.`deleted_at` is null) >= 1 and `cad_sku`.`status` = '1' and (`cad_price_table_sku`.`retail` > '0' or `cad_price_table_sku`.`wholesale` > '0') group by `cad_sku`.`product_id` order by (SELECT -sequence from cad_product_category where category_id = 147 and product_id = cad_product.id LIMIT 1) desc, CASE WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0) THEN cad_price_table_sku.wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0) THEN cad_price_table_sku.wholesale END desc55.57mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 147
        • 1. 1
        • 2. 1
        • 3. 0
        • 4. 1
        • 5. 0
        • 6. B2C
        • 7. B2BB2C
        • 8. 0
        • 9. B2B
        • 10. B2BB2C
        • 11. 1
        • 12. 6.5
        • 13. 1
        • 14. 0
        • 15. 0
      • select `id`, `name`, `parent_id`, `slug`, `sequence` from `cad_category` where `cad_category`.`deleted_at` is null and (select count(*) from `cad_product` inner join `cad_product_category` on `cad_product`.`id` = `cad_product_category`.`product_id` where `cad_product_category`.`category_id` = `cad_category`.`id` and `product_id` in ('3975', '2573', '980', '3010', '3469', '2094') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'16.15mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        • 6. 1
      • select distinct `id`, `name` from `cad_brand` where `cad_brand`.`deleted_at` is null and (select count(*) from `cad_product` where `cad_product`.`brand_id` = `cad_brand`.`id` and `id` in ('3975', '2573', '980', '3010', '3469', '2094') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc1.5mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
      • select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3975', '2573', '980', '3010', '3469', '2094') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`2.05mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        • 6. 1
        • 7. 0
        • 8. B2B
        • 9. B2BB2C
      • select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3975', '2573', '980', '3010', '3469', '2094') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`1.85mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        • 6. 1
        • 7. 0
        • 8. B2C
        • 9. B2BB2C
      • select `id`, `name`, `main_id` from `cad_variant` where `cad_variant`.`deleted_at` is null and (select count(*) from `cad_sku` inner join `cad_sku_variant` on `cad_sku`.`id` = `cad_sku_variant`.`sku_id` where `cad_sku_variant`.`variant_id` = `cad_variant`.`id` and `cad_sku`.`product_id` in ('3975', '2573', '980', '3010', '3469', '2094') and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 143.52mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        • 6. 0
        • 7. 1
        • 8. 0
        • 9. B2C
        • 10. B2BB2C
        • 11. 0
        • 12. B2B
        • 13. B2BB2C
      • select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_8c843b8b118576483989ed03cbb064f4` where `cad_attribute`.`deleted_at` is null and `self_8c843b8b118576483989ed03cbb064f4`.`main_id` = `cad_attribute`.`id` and (select count(*) from `cad_product` inner join `cad_product_attributes` on `cad_product`.`id` = `cad_product_attributes`.`product_id` where `cad_product_attributes`.`attribute_id` = `self_8c843b8b118576483989ed03cbb064f4`.`id` and `product_id` in ('3975', '2573', '980', '3010', '3469', '2094') and `cad_product`.`deleted_at` is null) >= 1 and `cad_attribute`.`deleted_at` is null) >= 1 and `main_id` is null order by `name` asc1.79mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        Hints
        • Use SELECT * only if you need all columns from table
      • select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3975', '2573', '980', '3010', '3469', '2094')1.35mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
      • select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3975', '2573', '980', '3010', '3469', '2094') order by FIELD(id, 3975,2573,980,3010,3469,2094) limit 20 offset 02.45mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('3975', '2573', '980', '3010', '3469', '2094') order by `sequence` asc1.74mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cad_sku`.* from `cad_sku` inner join `cad_product` on `cad_sku`.`product_id` = `cad_product`.`id` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_sku`.`deleted_at` is null and `cad_sku`.`product_id` in ('3975', '2573', '980', '3010', '3469', '2094') and `cad_sku`.`status` = '1' and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 order by cad_price_table_sku.retail = 0, cad_price_table_sku.wholesale = 0, CASE WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0) THEN cad_price_table_sku.wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0) THEN cad_price_table_sku.wholesale END asc3.91mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
        • 6. 1
        • 7. 0
        • 8. 1
        • 9. 0
        • 10. B2C
        • 11. B2BB2C
        • 12. 0
        • 13. B2B
        • 14. B2BB2C
      • select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('2094', '980', '3469', '3010', '2573', '3975')1.59mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 2094
        • 1. 980
        • 2. 3469
        • 3. 3010
        • 4. 2573
        • 5. 3975
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('358', '965', '1057', '1214', '1605')1.62mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 358
        • 1. 965
        • 2. 1057
        • 3. 1214
        • 4. 1605
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_price_table_sku` where `cad_price_table_sku`.`deleted_at` is null and `cad_price_table_sku`.`sku_id` in ('2891', '1254', '4633', '4038', '3512', '5227')1.28mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 2891
        • 1. 1254
        • 2. 4633
        • 3. 4038
        • 4. 3512
        • 5. 5227
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` in ('3975', '2573', '980', '3010', '3469', '2094')1.83mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
        • 1. 2573
        • 2. 980
        • 3. 3010
        • 4. 3469
        • 5. 2094
      • select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1605', '1057', '358', '1214', '965')1.5mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1605
        • 1. 1057
        • 2. 358
        • 3. 1214
        • 4. 965
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_show_case` where `cad_show_case`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_show_case` on `cad_category`.`id` = `cad_category_show_case`.`category_id` where `cad_category_show_case`.`show_case_id` = `cad_show_case`.`id` and `category_id` = '147' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc2.54mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 147
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '41' limit 11.07mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 41
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 11.13mssmp_mercadoblackmoney
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `cad_payment_installment_settings` where `cad_payment_installment_settings`.`deleted_at` is null and `cad_payment_installment_settings`.`id` = '3' limit 11.1mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3975'1.33mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3975
      • select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1605' and `cad_payment_recipient`.`store_id` is not null1.31mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1605
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '2573'1.2mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 2573
      • select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1057' and `cad_payment_recipient`.`store_id` is not null1.24mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1057
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '980'1.46mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 980
      • select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '358' and `cad_payment_recipient`.`store_id` is not null1.09mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 358
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3010'1.39mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3010
      • select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1214' and `cad_payment_recipient`.`store_id` is not null1.62mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1214
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3469'1.34mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 3469
      • select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '2094'1.37mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 2094
      • select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '965' and `cad_payment_recipient`.`store_id` is not null1.22mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 965
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 11.17mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. cssEditor
        • 1. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'910μssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. cssEditor
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_social_media` where `status` = '1' order by `sequence` asc930μssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_page_mkt_section` where `cad_page_mkt_section`.`deleted_at` is null order by `sequence` asc3.05mssmp_mercadoblackmoney
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_page_mkt` where `cad_page_mkt`.`deleted_at` is null and `cad_page_mkt`.`section_id` in ('1', '2', '3') and `status` = '1' and `hide` = '0' and `requires_authentication` <= '0' order by `sequence` asc3.13mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1
        • 1. 2
        • 2. 3
        • 3. 1
        • 4. 0
        • 5. 0
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'1.08mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_brand` where `cad_brand`.`deleted_at` is null and (select count(*) from `cad_product` where `cad_product`.`brand_id` = `cad_brand`.`id` and (`cad_product`.`publish` = '1' and `cad_product`.`deleted_at` is null) and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `status` = '1' and `cad_category`.`deleted_at` is null) >= 1 and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1 and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `status` = '1' and `percent` >= '6.5' and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc3.22mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 0
        • 3. 1
        • 4. 0
        • 5. B2C
        • 6. B2BB2C
        • 7. 0
        • 8. B2B
        • 9. B2BB2C
        • 10. 1
        • 11. 6.5
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_store` where `cad_store`.`deleted_at` is null and `status` = '1' and `percent` >= '6.5' and (select count(*) from `cad_product` where `cad_product`.`store_id` = `cad_store`.`id` and (`cad_product`.`publish` = '1' and `cad_product`.`deleted_at` is null) and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `status` = '1' and `cad_category`.`deleted_at` is null) >= 1 and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1 and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `status` = '1' and `percent` >= '6.5' and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `featured` = '1' order by `featured_sequence` asc limit 02.31mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1
        • 1. 6.5
        • 2. 1
        • 3. 1
        • 4. 0
        • 5. 1
        • 6. 0
        • 7. B2C
        • 8. B2BB2C
        • 9. 0
        • 10. B2B
        • 11. B2BB2C
        • 12. 1
        • 13. 6.5
        • 14. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_social_media` where `status` = '1' order by `sequence` asc1.55mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'1.41mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. cssEditor
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'1.11mssmp_mercadoblackmoney
        Metadata
        Bindings
        • 0. cssEditor
        Hints
        • Use SELECT * only if you need all columns from table
        _token
        esFB8HAXFmGxCJK9tRkiX72Wlp3hPOqSCUtS3Ese
        device
        desktop
        cartsMap
        Illuminate\Support\Collection {#2359 #items: [] }
        PHPDEBUGBAR_STACK_DATA
        []
        format
        html
        content_type
        text/html; charset=UTF-8
        status_text
        OK
        status_code
        200
        request_query
        []
        request_request
        []
        request_headers
        array:17 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 =>...
        request_server
        array:41 [ "USER" => "smp" "HOME" => "/home/smp" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_EN...
        request_cookies
        []
        response_headers
        array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Thu...
        path_info
        /categorias/esportes
        session_attributes
        array:4 [ "_token" => "esFB8HAXFmGxCJK9tRkiX72Wlp3hPOqSCUtS3Ese" "device" => "desktop" "cartsM...