Locations MY STORE: Select your location

0 Cart

Your Cart Is Empty!

Shop all

Shop Our Featured Deals!

65" 4K ANDROID SMART TV
$32/per week
View deal
60" 4K ULTRA HD WEBOS HDR
$32/per week
View deal

Be the first to know about our best deals.

Enter your email to receive a special coupon offer now!

8.1.27PHP Version453msRequest Duration29MBMemory UsageGET {url}Route
    • Booting (269ms)
    • Application (185ms)
    • 1 x Booting (59.25%)
      268.65ms
      1 x Application (40.69%)
      184.51ms
      9 templates were rendered
      • frontend.themes.national.products.index (resources/views/frontend/themes/national/products/index.blade.php)28blade
        Params
        0
        products
        1
        category
        2
        parent
        3
        url
        4
        show_all
        5
        featured_category
        6
        count
        7
        breadcrumb
        8
        per_page
        9
        brand_id
        10
        sort_by
        11
        price_from
        12
        price_to
        13
        brands_filtered
        14
        minPrice
        15
        maxPrice
        16
        new_swiper
        17
        account
        18
        savingbar
        19
        default_store
        20
        state_list
        21
        stores
        22
        spotlight
        23
        clearance_bar
        24
        menu_main
        25
        menu_top
        26
        menu_footer
        27
        theme_content
      • frontend.themes.national.partials.banner (resources/views/frontend/themes/national/partials/banner.blade.php)34blade
        Params
        0
        __env
        1
        app
        2
        subdomain
        3
        errors
        4
        products
        5
        category
        6
        parent
        7
        url
        8
        show_all
        9
        featured_category
        10
        count
        11
        breadcrumb
        12
        per_page
        13
        brand_id
        14
        sort_by
        15
        price_from
        16
        price_to
        17
        brands_filtered
        18
        minPrice
        19
        maxPrice
        20
        new_swiper
        21
        account
        22
        savingbar
        23
        default_store
        24
        state_list
        25
        stores
        26
        spotlight
        27
        clearance_bar
        28
        menu_main
        29
        menu_top
        30
        menu_footer
        31
        theme_content
        32
        main_category
        33
        child_category
      • frontend.themes.national.partials.popups.23.aug (resources/views/frontend/themes/national/partials/popups/23/aug.blade.php)34blade
        Params
        0
        __env
        1
        app
        2
        subdomain
        3
        errors
        4
        products
        5
        category
        6
        parent
        7
        url
        8
        show_all
        9
        featured_category
        10
        count
        11
        breadcrumb
        12
        per_page
        13
        brand_id
        14
        sort_by
        15
        price_from
        16
        price_to
        17
        brands_filtered
        18
        minPrice
        19
        maxPrice
        20
        new_swiper
        21
        account
        22
        savingbar
        23
        default_store
        24
        state_list
        25
        stores
        26
        spotlight
        27
        clearance_bar
        28
        menu_main
        29
        menu_top
        30
        menu_footer
        31
        theme_content
        32
        main_category
        33
        child_category
      • frontend.themes.national.products.list (resources/views/frontend/themes/national/products/list.blade.php)34blade
        Params
        0
        __env
        1
        app
        2
        subdomain
        3
        errors
        4
        products
        5
        category
        6
        parent
        7
        url
        8
        show_all
        9
        featured_category
        10
        count
        11
        breadcrumb
        12
        per_page
        13
        brand_id
        14
        sort_by
        15
        price_from
        16
        price_to
        17
        brands_filtered
        18
        minPrice
        19
        maxPrice
        20
        new_swiper
        21
        account
        22
        savingbar
        23
        default_store
        24
        state_list
        25
        stores
        26
        spotlight
        27
        clearance_bar
        28
        menu_main
        29
        menu_top
        30
        menu_footer
        31
        theme_content
        32
        main_category
        33
        child_category
      • pagination::default (resources/views/vendor/pagination/default.blade.php)13blade
        Params
        0
        paginator
        1
        elements
        2
        account
        3
        savingbar
        4
        default_store
        5
        state_list
        6
        stores
        7
        spotlight
        8
        clearance_bar
        9
        menu_main
        10
        menu_top
        11
        menu_footer
        12
        theme_content
      • frontend.themes.national.layout.app (resources/views/frontend/themes/national/layout/app.blade.php)34blade
        Params
        0
        __env
        1
        app
        2
        subdomain
        3
        errors
        4
        products
        5
        category
        6
        parent
        7
        url
        8
        show_all
        9
        featured_category
        10
        count
        11
        breadcrumb
        12
        per_page
        13
        brand_id
        14
        sort_by
        15
        price_from
        16
        price_to
        17
        brands_filtered
        18
        minPrice
        19
        maxPrice
        20
        new_swiper
        21
        account
        22
        savingbar
        23
        default_store
        24
        state_list
        25
        stores
        26
        spotlight
        27
        clearance_bar
        28
        menu_main
        29
        menu_top
        30
        menu_footer
        31
        theme_content
        32
        main_category
        33
        child_category
      • frontend.themes.national.partials.header (resources/views/frontend/themes/national/partials/header.blade.php)38blade
        Params
        0
        __env
        1
        app
        2
        subdomain
        3
        errors
        4
        products
        5
        category
        6
        parent
        7
        url
        8
        show_all
        9
        featured_category
        10
        count
        11
        breadcrumb
        12
        per_page
        13
        brand_id
        14
        sort_by
        15
        price_from
        16
        price_to
        17
        brands_filtered
        18
        minPrice
        19
        maxPrice
        20
        new_swiper
        21
        account
        22
        savingbar
        23
        default_store
        24
        state_list
        25
        stores
        26
        spotlight
        27
        clearance_bar
        28
        menu_main
        29
        menu_top
        30
        menu_footer
        31
        theme_content
        32
        main_category
        33
        child_category
        34
        sections
        35
        lang_map
        36
        current_lang
        37
        defaults
      • frontend.themes.national.partials.mini-cart (resources/views/frontend/themes/national/partials/mini-cart.blade.php)38blade
        Params
        0
        __env
        1
        app
        2
        subdomain
        3
        errors
        4
        products
        5
        category
        6
        parent
        7
        url
        8
        show_all
        9
        featured_category
        10
        count
        11
        breadcrumb
        12
        per_page
        13
        brand_id
        14
        sort_by
        15
        price_from
        16
        price_to
        17
        brands_filtered
        18
        minPrice
        19
        maxPrice
        20
        new_swiper
        21
        account
        22
        savingbar
        23
        default_store
        24
        state_list
        25
        stores
        26
        spotlight
        27
        clearance_bar
        28
        menu_main
        29
        menu_top
        30
        menu_footer
        31
        theme_content
        32
        main_category
        33
        child_category
        34
        sections
        35
        lang_map
        36
        current_lang
        37
        defaults
      • frontend.themes.national.partials.footer (resources/views/frontend/themes/national/partials/footer.blade.php)38blade
        Params
        0
        __env
        1
        app
        2
        subdomain
        3
        errors
        4
        products
        5
        category
        6
        parent
        7
        url
        8
        show_all
        9
        featured_category
        10
        count
        11
        breadcrumb
        12
        per_page
        13
        brand_id
        14
        sort_by
        15
        price_from
        16
        price_to
        17
        brands_filtered
        18
        minPrice
        19
        maxPrice
        20
        new_swiper
        21
        account
        22
        savingbar
        23
        default_store
        24
        state_list
        25
        stores
        26
        spotlight
        27
        clearance_bar
        28
        menu_main
        29
        menu_top
        30
        menu_footer
        31
        theme_content
        32
        main_category
        33
        child_category
        34
        sections
        35
        lang_map
        36
        current_lang
        37
        defaults
      uri
      GET {url}
      middleware
      web
      controller
      App\Http\Controllers\RoutingController@routeIt
      namespace
      prefix
      where
      as
      product.show
      file
      app/Http/Controllers/RoutingController.php:13-55
      65 statements were executed, 26 of which were duplicated, 39 unique58.03ms
      • select exists(select * from `contents` where `url` = 'appliances/other-7712' and `contents`.`deleted_at` is null and `contents`.`account_id` = 37) as `exists`710μsr20_original
        Metadata
        Bindings
        • 0. appliances/other-7712
        • 1. 37
      • select exists(select * from `stores` where `url` = 'appliances/other-7712' and `stores`.`account_id` = 37 and `stores`.`deleted_at` is null) as `exists`520μsr20_original
        Metadata
        Bindings
        • 0. appliances/other-7712
        • 1. 37
      • select exists(select * from `categories` where `url` = 'appliances' and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null) as `exists`2.48msr20_original
        Metadata
        Bindings
        • 0. appliances
        • 1. 37
      • select * from `categories` where `url` = 'appliances' and `active` = 1 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 16.41msr20_original
        Metadata
        Bindings
        • 0. appliances
        • 1. 1
        • 2. 37
        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 `categories` where `url` = 'other-7712' and `active` = 1 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 16.59msr20_original
        Metadata
        Bindings
        • 0. other-7712
        • 1. 1
        • 2. 37
        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 `categories` where `categories`.`id` = 7712 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1470μsr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. 37
        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 `categories` where `categories`.`id` = 7558 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1430μsr20_original
        Metadata
        Bindings
        • 0. 7558
        • 1. 37
        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 `categories` where `categories`.`id` = 7558 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1420μsr20_original
        Metadata
        Bindings
        • 0. 7558
        • 1. 37
        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 `categories` where `categories`.`id` = 7558 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1440μsr20_original
        Metadata
        Bindings
        • 0. 7558
        • 1. 37
        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 `categories` where `categories`.`id` = 7712 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1430μsr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. 37
        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 `brand_id` from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 7712 and `is_available_on_site` = 'Yes' and `products`.`account_id` = 37 and `products`.`deleted_at` is null750μsr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. Yes
        • 2. 37
      • select `name`, `id` from `brands` where `id` in (1302, 1302, 1307, 1307, 1337, 1302, 1299, 1373, 1334, 1364, 1369, 1302, 1302, 1299, 1312) and `brands`.`deleted_at` is null and `brands`.`account_id` = 37600μsr20_original
        Metadata
        Bindings
        • 0. 1302
        • 1. 1302
        • 2. 1307
        • 3. 1307
        • 4. 1337
        • 5. 1302
        • 6. 1299
        • 7. 1373
        • 8. 1334
        • 9. 1364
        • 10. 1369
        • 11. 1302
        • 12. 1302
        • 13. 1299
        • 14. 1312
        • 15. 37
      • select max(`weekly_price`) as aggregate from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 7712 and `is_available_on_site` = 'Yes' and `brand_id` in ('1307') and `products`.`account_id` = 37 and `products`.`deleted_at` is null660μsr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. Yes
        • 2. 1307
        • 3. 37
      • select min(`weekly_price`) as aggregate from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 7712 and `is_available_on_site` = 'Yes' and `brand_id` in ('1307') and `products`.`account_id` = 37 and `products`.`deleted_at` is null590μsr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. Yes
        • 2. 1307
        • 3. 37
      • select count(*) as aggregate from (select `products`.*, `product_categories`.`category_id` as `pivot_category_id`, `product_categories`.`product_id` as `pivot_product_id` from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 7712 and `is_available_on_site` = 'Yes' and `brand_id` in ('1307') and `products`.`account_id` = 37 and `products`.`deleted_at` is null group by `products`.`id`) as `aggregate_table`2.13msr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. Yes
        • 2. 1307
        • 3. 37
      • select `products`.*, `product_categories`.`category_id` as `pivot_category_id`, `product_categories`.`product_id` as `pivot_product_id` from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 7712 and `is_available_on_site` = 'Yes' and `brand_id` in ('1307') and `products`.`account_id` = 37 and `products`.`deleted_at` is null group by `products`.`id` order by `first_page` desc, `sort` desc limit 12 offset 01.56msr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. Yes
        • 2. 1307
        • 3. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `product_images` where `product_images`.`product_id` in (45295, 45307) and `product_images`.`deleted_at` is null and `product_images`.`account_id` = 37 order by `sort_order` asc680μsr20_original
        Metadata
        Bindings
        • 0. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `promotional_prices` where `promotional_prices`.`product_id` in (45295, 45307) and `promotional_prices`.`deleted_at` is null and `promotional_prices`.`account_id` = 37490μsr20_original
        Metadata
        Bindings
        • 0. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `theme_settings` where `theme_id` = 17 and `account_id` = 37 and `theme_settings`.`deleted_at` is null limit 1810μsr20_original
        Metadata
        Bindings
        • 0. 17
        • 1. 37
        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 `theme_attributes` where `name` = 'homepage_category' and `theme_id` = 17 and `account_id` = 37 limit 11.46msr20_original
        Metadata
        Bindings
        • 0. homepage_category
        • 1. 17
        • 2. 37
        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 count(*) as aggregate from `theme_attributes`770μsr20_original
        Metadata
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
      • select * from `categories` where `id` = '7575' and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1430μsr20_original
        Metadata
        Bindings
        • 0. 7575
        • 1. 37
        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 `categories` where `categories`.`id` = 7558 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1490μsr20_original
        Metadata
        Bindings
        • 0. 7558
        • 1. 37
        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 `categories` where `categories`.`id` = 7558 and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1430μsr20_original
        Metadata
        Bindings
        • 0. 7558
        • 1. 37
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1380μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `top_bars` where `top_bars`.`account_id` = 37 limit 1420μsr20_original
        Metadata
        Bindings
        • 0. 37
        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 `bars` where `name` = 'clearance' and `bars`.`account_id` = 37 limit 1450μsr20_original
        Metadata
        Bindings
        • 0. clearance
        • 1. 37
        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 `stores` where `hidden` <> 1 and `stores`.`account_id` = 37 and `stores`.`deleted_at` is null order by `name` asc1.79msr20_original
        Metadata
        Bindings
        • 0. 1
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `categories` where `name` = 'In The Spotlight' and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null limit 1480μsr20_original
        Metadata
        Bindings
        • 0. In The Spotlight
        • 1. 37
        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 `menus` where `name` = 'Main Menu' and `menus`.`account_id` = 37 limit 1410μsr20_original
        Metadata
        Bindings
        • 0. Main Menu
        • 1. 37
        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 `menu_items` where `parent_id` = '0' and `menu_items`.`menu_id` in (73) and `menu_items`.`account_id` = 37720μsr20_original
        Metadata
        Bindings
        • 0. 0
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `menu_items` where `menu_items`.`parent_id` in (72224, 72244, 72257, 72271, 72276, 72282) and `menu_items`.`account_id` = 37660μsr20_original
        Metadata
        Bindings
        • 0. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `menu_items` where `menu_items`.`parent_id` in (72225, 72230, 72242, 72245, 72250, 72253, 72258, 72261, 72265, 72266, 72270, 72272, 72273, 72274, 72275, 72277, 72278, 72279, 72280, 72281) and `menu_items`.`account_id` = 37730μsr20_original
        Metadata
        Bindings
        • 0. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `menu_items` where `menu_items`.`parent_id` in (72226, 72227, 72228, 72229, 72231, 72232, 72233, 72234, 72235, 72236, 72237, 72238, 72239, 72240, 72241, 72243, 72246, 72247, 72248, 72249, 72251, 72252, 72254, 72255, 72256, 72259, 72260, 72262, 72263, 72264, 72267, 72268, 72269) and `menu_items`.`account_id` = 37720μsr20_original
        Metadata
        Bindings
        • 0. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `menus` where `name` = 'Top Menu' and `menus`.`account_id` = 37 limit 1440μsr20_original
        Metadata
        Bindings
        • 0. Top Menu
        • 1. 37
        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 `menus` where `name` = 'Footer Menu' and `menus`.`account_id` = 37 limit 1430μsr20_original
        Metadata
        Bindings
        • 0. Footer Menu
        • 1. 37
        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 `menu_items` where `parent_id` = '0' and `menu_items`.`menu_id` in (75) and `menu_items`.`account_id` = 37590μsr20_original
        Metadata
        Bindings
        • 0. 0
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `menu_items` where `menu_items`.`parent_id` in (72146, 72155) and `menu_items`.`account_id` = 37660μsr20_original
        Metadata
        Bindings
        • 0. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `menu_items` where `menu_items`.`parent_id` in (72147, 72148, 72149, 72150, 72151, 72152, 72153, 72154, 72156, 72157, 72158, 72159, 72160, 72161, 72162, 72163, 72164, 72165, 72166) and `menu_items`.`account_id` = 37620μsr20_original
        Metadata
        Bindings
        • 0. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select `value`, `name` from `theme_attributes` where `theme_id` = 17 and `account_id` = 37 order by `created_at` desc1.38msr20_original
        Metadata
        Bindings
        • 0. 17
        • 1. 37
      • select * from `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1460μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1400μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1390μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1370μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1370μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1400μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1380μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1360μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `categories` where `categories`.`parent_id` = 7712 and `categories`.`parent_id` is not null and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null order by `position` asc3.17msr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `categories` where `categories`.`parent_id` = 7712 and `categories`.`parent_id` is not null and `categories`.`account_id` = 37 and `categories`.`deleted_at` is null order by `position` asc, `name` asc3.58msr20_original
        Metadata
        Bindings
        • 0. 7712
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `product_images` where `product_id` = 45295 and `product_images`.`deleted_at` is null and `product_images`.`account_id` = 37 order by `sort_order` asc540μsr20_original
        Metadata
        Bindings
        • 0. 45295
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `product_images` where `product_id` = 45295 and `product_images`.`deleted_at` is null and `product_images`.`account_id` = 37 order by `sort_order` asc490μsr20_original
        Metadata
        Bindings
        • 0. 45295
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `product_images` where `product_id` = 45307 and `product_images`.`deleted_at` is null and `product_images`.`account_id` = 37 order by `sort_order` asc540μsr20_original
        Metadata
        Bindings
        • 0. 45307
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `product_images` where `product_id` = 45307 and `product_images`.`deleted_at` is null and `product_images`.`account_id` = 37 order by `sort_order` asc470μsr20_original
        Metadata
        Bindings
        • 0. 45307
        • 1. 37
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1430μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1380μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1370μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `home_menu_product` where `home_menu_product`.`menu_items_id` = 72224 and `home_menu_product`.`menu_items_id` is not null and `home_menu_product`.`deleted_at` is null and `home_menu_product`.`account_id` = 37 limit 1470μsr20_original
        Metadata
        Bindings
        • 0. 72224
        • 1. 37
        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 `home_menu_product` where `home_menu_product`.`menu_items_id` = 72244 and `home_menu_product`.`menu_items_id` is not null and `home_menu_product`.`deleted_at` is null and `home_menu_product`.`account_id` = 37 limit 1420μsr20_original
        Metadata
        Bindings
        • 0. 72244
        • 1. 37
        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 `home_menu_product` where `home_menu_product`.`menu_items_id` = 72257 and `home_menu_product`.`menu_items_id` is not null and `home_menu_product`.`deleted_at` is null and `home_menu_product`.`account_id` = 37 limit 1420μsr20_original
        Metadata
        Bindings
        • 0. 72257
        • 1. 37
        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 `home_menu_product` where `home_menu_product`.`menu_items_id` = 72271 and `home_menu_product`.`menu_items_id` is not null and `home_menu_product`.`deleted_at` is null and `home_menu_product`.`account_id` = 37 limit 1440μsr20_original
        Metadata
        Bindings
        • 0. 72271
        • 1. 37
        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 `home_menu_product` where `home_menu_product`.`menu_items_id` = 72276 and `home_menu_product`.`menu_items_id` is not null and `home_menu_product`.`deleted_at` is null and `home_menu_product`.`account_id` = 37 limit 1410μsr20_original
        Metadata
        Bindings
        • 0. 72276
        • 1. 37
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1370μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1380μsr20_original
        Metadata
        Bindings
        • 0. 17
        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 `themes` where `id` = 17 and `themes`.`deleted_at` is null limit 1390μsr20_original
        Metadata
        Bindings
        • 0. 17
        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
      App\Models\MenuItems
      80
      App\Models\Menu
      2
      App\Models\Store
      19
      App\Models\Theme
      15
      App\Models\ThemeAttributes
      1
      App\Models\ProductImage
      6
      App\Models\Product
      2
      App\Models\Category
      16
      _token
      WUtO2zLchuIqwHXMOnR5oZfqEvTeAZgT0Ep1UprL
      theme
      national
      _previous
      array:1 [ "url" => "http://national.r20dev.com/appliances/other-7712?brand_id=1307" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /appliances/other-7712
      status_code
      200
      
      status_text
      OK
      format
      html
      content_type
      text/html; charset=UTF-8
      request_query
      0 of 0
      array:1 [ "brand_id" => "1307" ]
      request_request
      []
      
      request_headers
      0 of 0
      array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "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" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "national.r20dev.com" ] ]
      request_server
      0 of 0
      array:40 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/appliances/other-7712?brand_id=1307" "QUERY_STRING" => "brand_id=1307" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "brand_id=1307" "REDIRECT_URL" => "/appliances/other-7712" "REMOTE_PORT" => "53675" "SCRIPT_FILENAME" => "/var/www/r20/public/index.php" "SERVER_ADMIN" => "root@localhost" "CONTEXT_DOCUMENT_ROOT" => "/var/www/r20/public/" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "http" "DOCUMENT_ROOT" => "/var/www/r20/public/" "REMOTE_ADDR" => "18.224.31.7" "SERVER_PORT" => "80" "SERVER_ADDR" => "10.0.0.98" "SERVER_NAME" => "national.r20dev.com" "SERVER_SOFTWARE" => "Apache/2.4.62 () OpenSSL/1.0.2k-fips" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "HTTP_ACCEPT_ENCODING" => "gzip, deflate" "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_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "national.r20dev.com" "proxy-nokeepalive" => "1" "UNIQUE_ID" => "Z3sBWO1DrSOHGbT8mpHJ5QAAAAg" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z3sBWO1DrSOHGbT8mpHJ5QAAAAg" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1736114520.7273 "REQUEST_TIME" => 1736114520 ]
      request_cookies
      []
      
      response_headers
      0 of 0
      array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 05 Jan 2025 22:02:01 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJjK2tvN3ZYUGZodkdxVGsvbjRqNEE9PSIsInZhbHVlIjoic01hN05rVlYydm5MWG9TTTFUL3hrTDZmc0VMNXVQRFVrYUN5MEJPbkVhZkNLQk11VEdydjdPeVRDM3NRNVdJVzhZYnJxekhDSDZ4cHhubFA0eWpKUVRSMDVsT1lDSnROWnBlQ0tkcHNKMTNaMmU5cGVROXRlaDBNU3FzZjd0QTUiLCJtYWMiOiI2OGU1YmQ4OWNkYjJmMzM0ZGE3MzM1MzljNDFjMGRlNTc1MjI4ZDU0YTY2ZjRjMTVhMzM4OGNiMTAxMzljYTg4IiwidGFnIjoiIn0%3D; expires=Mon, 10 Nov 2031 22:02:01 GMT; Max-Age=216000000; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IkJjK2tvN3ZYUGZodkdxVGsvbjRqNEE9PSIsInZhbHVlIjoic01hN05rVlYydm5MWG9TTTFUL3hrTDZmc0VMNXVQRFVrYUN5MEJPbkVhZkNLQk11VEdydjdPeVRDM3NRNVdJVzhZYnJxe" 1 => "r20_session=eyJpdiI6IlM0SElVNEwzOTBsMEJaQ3QreGE2OFE9PSIsInZhbHVlIjoiWWcranN2YjNHTkJLRm83WDRWbFk5S2tFR2c0RFhXWXR3RHNLKzdTZC9qdDJtQWo2NnhMdkwxS1lUT3g2a1FVcXhZZlFqandwcUxGOTdXNTA4Z2V0RzZ0ek9TWThnWENYTGFSZ2xtWWJDQklVVDdPYXhsUTlObWZlZXpTVmZwdUkiLCJtYWMiOiJlNmU3OGViODgzZDA1MzgyMTg0YzUyMzBlNGUwZjFlYzM0ZGUxMzFhY2UwMjEwZTg3MGYwMWYyOWFjMzRiZDUwIiwidGFnIjoiIn0%3D; expires=Mon, 10 Nov 2031 22:02:01 GMT; Max-Age=216000000; path=/; httponly; samesite=laxr20_session=eyJpdiI6IlM0SElVNEwzOTBsMEJaQ3QreGE2OFE9PSIsInZhbHVlIjoiWWcranN2YjNHTkJLRm83WDRWbFk5S2tFR2c0RFhXWXR3RHNLKzdTZC9qdDJtQWo2NnhMdkwxS1lUT3g2a1FVcXhZZlFq" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJjK2tvN3ZYUGZodkdxVGsvbjRqNEE9PSIsInZhbHVlIjoic01hN05rVlYydm5MWG9TTTFUL3hrTDZmc0VMNXVQRFVrYUN5MEJPbkVhZkNLQk11VEdydjdPeVRDM3NRNVdJVzhZYnJxekhDSDZ4cHhubFA0eWpKUVRSMDVsT1lDSnROWnBlQ0tkcHNKMTNaMmU5cGVROXRlaDBNU3FzZjd0QTUiLCJtYWMiOiI2OGU1YmQ4OWNkYjJmMzM0ZGE3MzM1MzljNDFjMGRlNTc1MjI4ZDU0YTY2ZjRjMTVhMzM4OGNiMTAxMzljYTg4IiwidGFnIjoiIn0%3D; expires=Mon, 10-Nov-2031 22:02:01 GMT; path=/XSRF-TOKEN=eyJpdiI6IkJjK2tvN3ZYUGZodkdxVGsvbjRqNEE9PSIsInZhbHVlIjoic01hN05rVlYydm5MWG9TTTFUL3hrTDZmc0VMNXVQRFVrYUN5MEJPbkVhZkNLQk11VEdydjdPeVRDM3NRNVdJVzhZYnJxe" 1 => "r20_session=eyJpdiI6IlM0SElVNEwzOTBsMEJaQ3QreGE2OFE9PSIsInZhbHVlIjoiWWcranN2YjNHTkJLRm83WDRWbFk5S2tFR2c0RFhXWXR3RHNLKzdTZC9qdDJtQWo2NnhMdkwxS1lUT3g2a1FVcXhZZlFqandwcUxGOTdXNTA4Z2V0RzZ0ek9TWThnWENYTGFSZ2xtWWJDQklVVDdPYXhsUTlObWZlZXpTVmZwdUkiLCJtYWMiOiJlNmU3OGViODgzZDA1MzgyMTg0YzUyMzBlNGUwZjFlYzM0ZGUxMzFhY2UwMjEwZTg3MGYwMWYyOWFjMzRiZDUwIiwidGFnIjoiIn0%3D; expires=Mon, 10-Nov-2031 22:02:01 GMT; path=/; httponlyr20_session=eyJpdiI6IlM0SElVNEwzOTBsMEJaQ3QreGE2OFE9PSIsInZhbHVlIjoiWWcranN2YjNHTkJLRm83WDRWbFk5S2tFR2c0RFhXWXR3RHNLKzdTZC9qdDJtQWo2NnhMdkwxS1lUT3g2a1FVcXhZZlFq" ] ]
      session_attributes
      0 of 0
      array:5 [ "_token" => "WUtO2zLchuIqwHXMOnR5oZfqEvTeAZgT0Ep1UprL" "theme" => "national" "_previous" => array:1 [ "url" => "http://national.r20dev.com/appliances/other-7712?brand_id=1307" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]