Wants to explore Upcoming Deals on Weekends?

FIND A PERFECT GIFT

For all your needs

Order Now

  • Birthday

  • Anniversary

  • Wedding

  • Cakes

  • flowers

  • Personal

  • Plants

  • Chocolates

  • Occassion

Find The Perect Gift

Discover Gifts by
Recipient, Relationsships $ Occasions

Find Gifts

Worldwide Delivery

We deliver gifts to over 70 countries

100% Safe $ Secure

Pay using secure Payment Methods

Dedicated Help Center

24/7Support Service

Shopimic: India's Best Gift Portal. Send Cakes, Gifts & Flowers Online

Shopimic is India’s best gift portal, making every occasion special by offering a wide variety of cakes, gifts, and flowers that you can send online to your loved ones. Whether it's a birthday, anniversary, festival, or any special event, we ensure your emotions are delivered with care and style. Choose from an extensive collection of personalized gifts, beautifully arranged flower bouquets, and delicious cakes to make your moments unforgettable. Shopimic is your trusted partner for spreading joy across India, with seamless delivery options and unbeatable quality.

Request history8.2.26PHP Version1.31sRequest Duration17MBMemory UsageGET /Route
  • warninglog[14:44:26] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[14:44:26] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • Booting (658ms)time
  • Application (653ms)time
  • 1 x Booting (50.21%)
    658ms
    1 x Application (49.79%)
    653ms
    6 templates were rendered
    • web-views.homehome.blade.php#?blade
    • web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
    • web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
    • layouts.front-end.appapp.blade.php#?blade
    • layouts.front-end.partials._header_header.blade.php#?blade
    • layouts.front-end.partials._footer_footer.blade.php#?blade
    uri
    GET /
    middleware
    web, maintenance_mode, guestCheck
    controller
    App\Http\Controllers\Web\HomeController@index
    namespace
    App\Http\Controllers\Web
    prefix
    where
    as
    home
    file
    app/Http/Controllers/Web/HomeController.php:50-60
    88 statements were executed, 26 of which were duplicates, 62 unique. Show only duplicated152ms
    • select * from `business_settings` where (`type` = 'maintenance_mode') limit 1
      890μsshopimic_newstorehelpers.php#167
      Bindings
      • 0: maintenance_mode
      Backtrace
      • 16. app/Utils/helpers.php:167
      • 17. middleware::maintenance_mode:20
      • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 19. middleware::api_lang:22
      • 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.222.188.129', '2025-04-03 14:44:26', '2025-04-03 14:44:26')
      4.76msshopimic_newstoreGuestMiddleware.php#24
      Bindings
      • 0: 18.222.188.129
      • 1: 2025-04-03 14:44:26
      • 2: 2025-04-03 14:44:26
      Backtrace
      • 22. middleware::guestCheck:24
      • 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 24. middleware::maintenance_mode:27
      • 25. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 26. middleware::api_lang:22
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` = 0
      2.76msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: 0
      Backtrace
      • 15. app/Utils/category-manager.php:82
      • 16. app/Http/Controllers/Web/HomeController.php:64
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2, 3, 4, 5, 6, 7, 8) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
      6.42msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. app/Http/Controllers/Web/HomeController.php:64
      • 22. app/Http/Controllers/Web/HomeController.php:55
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      1.59msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:64
      • 27. app/Http/Controllers/Web/HomeController.php:55
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `delivery_man_id` is null and `status` = 1
      1.05msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:64
      • 27. app/Http/Controllers/Web/HomeController.php:55
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `position` = 1 order by `priority` asc
      5.75msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. app/Http/Controllers/Web/HomeController.php:64
      • 22. app/Http/Controllers/Web/HomeController.php:55
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92) and `position` = 2 order by `priority` asc
      4.08msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 2
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:64
      • 27. app/Http/Controllers/Web/HomeController.php:55
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      1.05msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 30. app/Utils/category-manager.php:82
      • 31. app/Http/Controllers/Web/HomeController.php:64
      • 32. app/Http/Controllers/Web/HomeController.php:55
      • 33. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 34. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      1.18msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:64
      • 27. app/Http/Controllers/Web/HomeController.php:55
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      780μsshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. app/Http/Controllers/Web/HomeController.php:64
      • 22. app/Http/Controllers/Web/HomeController.php:55
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'category_list_priority') limit 1
      870μsshopimic_newstoresettings.php#16
      Bindings
      • 0: category_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Utils/category-manager.php:82
      • 19. app/Http/Controllers/Web/HomeController.php:64
      • 20. app/Http/Controllers/Web/HomeController.php:55
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `flash_deals`.*, (select count(*) from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id`) as `products_count` from `flash_deals` where (`deal_type` = 'flash_deal' and `status` = 1) and date(`start_date`) <= '2025-04-03' and date(`end_date`) >= '2025-04-03' limit 1
      990μsshopimic_newstoreproduct-manager.php#1318
      Bindings
      • 0: flash_deal
      • 1: 1
      • 2: 2025-04-03
      • 3: 2025-04-03
      Backtrace
      • 16. app/Utils/product-manager.php:1318
      • 17. app/Http/Controllers/Web/HomeController.php:67
      • 18. app/Http/Controllers/Web/HomeController.php:55
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where `type` = 'product_brand' limit 1
      910μsshopimic_newstoreHomeController.php#70
      Bindings
      • 0: product_brand
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:70
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `categories` where `home_status` = 1 order by `priority` asc
      980μsshopimic_newstoreHomeController.php#71
      Bindings
      • 0: 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:71
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (1, 3) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      870μsshopimic_newstoreHomeController.php#71
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:71
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      1.05msshopimic_newstoresettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:78
      • 23. app/Http/Controllers/Web/HomeController.php:73
      • 24. app/Http/Controllers/Web/HomeController.php:55
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"1\"%'
      1.87msshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"1"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:78
      • 22. app/Http/Controllers/Web/HomeController.php:73
      • 23. app/Http/Controllers/Web/HomeController.php:55
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"1\"%' order by `order_details_count` desc limit 12 offset 0
      4.8msshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: digital
      • 10: physical
      • 11: %"1"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:78
      • 22. app/Http/Controllers/Web/HomeController.php:73
      • 23. app/Http/Controllers/Web/HomeController.php:55
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (1, 11, 19, 20, 21, 22, 23, 24, 52, 53, 54, 55) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      950μsshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:78
      • 27. app/Http/Controllers/Web/HomeController.php:73
      • 28. app/Http/Controllers/Web/HomeController.php:55
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (1, 11, 19, 20, 21, 22, 23, 24, 52, 53, 54, 55) and `delivery_man_id` is null and `status` = 1
      720μsshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:78
      • 27. app/Http/Controllers/Web/HomeController.php:73
      • 28. app/Http/Controllers/Web/HomeController.php:55
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      1.04msshopimic_newstoresettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:78
      • 23. app/Http/Controllers/Web/HomeController.php:73
      • 24. app/Http/Controllers/Web/HomeController.php:55
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"3\"%'
      1.86msshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"3"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:78
      • 22. app/Http/Controllers/Web/HomeController.php:73
      • 23. app/Http/Controllers/Web/HomeController.php:55
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"3\"%' order by `order_details_count` desc limit 12 offset 0
      3.85msshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: digital
      • 10: physical
      • 11: %"3"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:78
      • 22. app/Http/Controllers/Web/HomeController.php:73
      • 23. app/Http/Controllers/Web/HomeController.php:55
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (12, 25, 26, 58, 59, 60) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      910μsshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:78
      • 27. app/Http/Controllers/Web/HomeController.php:73
      • 28. app/Http/Controllers/Web/HomeController.php:55
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (12, 25, 26, 58, 59, 60) and `delivery_man_id` is null and `status` = 1
      640μsshopimic_newstoreproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:78
      • 27. app/Http/Controllers/Web/HomeController.php:73
      • 28. app/Http/Controllers/Web/HomeController.php:55
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `shops`.*, (select count(*) from `products` where `shops`.`seller_id` = `products`.`user_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'seller' and `status` = 1 and `request_status` = 1)) as `products_count` from `shops` where exists (select * from `sellers` where `shops`.`seller_id` = `sellers`.`id` and (`status` = 'approved'))
      2.17msshopimic_newstoreHomeController.php#94
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: seller
      • 9: 1
      • 10: 1
      • 11: approved
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:94
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin')
      5.89msshopimic_newstoreHomeController.php#112
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: digital
      • 8: physical
      • 9: admin
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:112
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `reviews` where `reviews`.`product_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `delivery_man_id` is null and `status` = 1
      1.06msshopimic_newstoreHomeController.php#112
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:112
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `status` = 1 group by `product_id`
      910μsshopimic_newstoreHomeController.php#112
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:112
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      1.49msshopimic_newstoreHomeController.php#112
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:112
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select count(*) as aggregate from `reviews` where `status` = 1 and `product_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `status` = 1
      1.2msshopimic_newstoreHomeController.php#116
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11
      • 3: 12
      • 4: 13
      • 5: 14
      • 6: 15
      • 7: 16
      • 8: 17
      • 9: 18
      • 10: 19
      • 11: 20
      • 12: 21
      • 13: 22
      • 14: 23
      • 15: 24
      • 16: 25
      • 17: 26
      • 18: 27
      • 19: 28
      • 20: 29
      • 21: 30
      • 22: 31
      • 23: 32
      • 24: 33
      • 25: 34
      • 26: 35
      • 27: 36
      • 28: 37
      • 29: 38
      • 30: 39
      • 31: 40
      • 32: 41
      • 33: 42
      • 34: 43
      • 35: 44
      • 36: 45
      • 37: 46
      • 38: 47
      • 39: 48
      • 40: 49
      • 41: 50
      • 42: 51
      • 43: 52
      • 44: 53
      • 45: 54
      • 46: 55
      • 47: 56
      • 48: 57
      • 49: 58
      • 50: 59
      • 51: 60
      • 52: 61
      • 53: 62
      • 54: 63
      • 55: 64
      • 56: 65
      • 57: 66
      • 58: 67
      • 59: 68
      • 60: 69
      • 61: 70
      • 62: 71
      • 63: 72
      • 64: 73
      • 65: 74
      • 66: 75
      • 67: 76
      • 68: 77
      • 69: 78
      • 70: 79
      • 71: 80
      • 72: 81
      • 73: 82
      • 74: 83
      • 75: 84
      • 76: 85
      • 77: 86
      • 78: 87
      • 79: 88
      • 80: 89
      • 81: 90
      • 82: 91
      • 83: 92
      • 84: 93
      • 85: 94
      • 86: 95
      • 87: 96
      • 88: 97
      • 89: 98
      • 90: 99
      • 91: 100
      • 92: 101
      • 93: 102
      • 94: 103
      • 95: 104
      • 96: 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:116
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `rating` from `reviews` where `status` = 1 and `product_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `status` = 1
      970μsshopimic_newstoreHomeController.php#118
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11
      • 3: 12
      • 4: 13
      • 5: 14
      • 6: 15
      • 7: 16
      • 8: 17
      • 9: 18
      • 10: 19
      • 11: 20
      • 12: 21
      • 13: 22
      • 14: 23
      • 15: 24
      • 16: 25
      • 17: 26
      • 18: 27
      • 19: 28
      • 20: 29
      • 21: 30
      • 22: 31
      • 23: 32
      • 24: 33
      • 25: 34
      • 26: 35
      • 27: 36
      • 28: 37
      • 29: 38
      • 30: 39
      • 31: 40
      • 32: 41
      • 33: 42
      • 34: 43
      • 35: 44
      • 36: 45
      • 37: 46
      • 38: 47
      • 39: 48
      • 40: 49
      • 41: 50
      • 42: 51
      • 43: 52
      • 44: 53
      • 45: 54
      • 46: 55
      • 47: 56
      • 48: 57
      • 49: 58
      • 50: 59
      • 51: 60
      • 52: 61
      • 53: 62
      • 54: 63
      • 55: 64
      • 56: 65
      • 57: 66
      • 58: 67
      • 59: 68
      • 60: 69
      • 61: 70
      • 62: 71
      • 63: 72
      • 64: 73
      • 65: 74
      • 66: 75
      • 67: 76
      • 68: 77
      • 69: 78
      • 70: 79
      • 71: 80
      • 72: 81
      • 73: 82
      • 74: 83
      • 75: 84
      • 76: 85
      • 77: 86
      • 78: 87
      • 79: 88
      • 80: 89
      • 81: 90
      • 82: 91
      • 83: 92
      • 84: 93
      • 85: 94
      • 86: 95
      • 87: 96
      • 88: 97
      • 89: 98
      • 90: 99
      • 91: 100
      • 92: 101
      • 93: 102
      • 94: 103
      • 95: 104
      • 96: 1
      Backtrace
      • 14. app/Http/Controllers/Web/HomeController.php:118
      • 15. app/Http/Controllers/Web/HomeController.php:55
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `business_settings` where (`type` = 'vacation_add') limit 1
      860μsshopimic_newstoresettings.php#16
      Bindings
      • 0: vacation_add
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'company_name') limit 1
      890μsshopimic_newstoresettings.php#16
      Bindings
      • 0: company_name
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'shop_address') limit 1
      890μsshopimic_newstoresettings.php#16
      Bindings
      • 0: shop_address
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'company_phone') limit 1
      880μsshopimic_newstoresettings.php#16
      Bindings
      • 0: company_phone
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'company_fav_icon') limit 1
      940μsshopimic_newstoresettings.php#16
      Bindings
      • 0: company_fav_icon
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'bottom_banner') limit 1
      870μsshopimic_newstoresettings.php#16
      Bindings
      • 0: bottom_banner
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'offer_banner') limit 1
      840μsshopimic_newstoresettings.php#16
      Bindings
      • 0: offer_banner
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      690μsshopimic_newstoresettings.php#16
      Bindings
      • 0: temporary_close
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      730μsshopimic_newstoresettings.php#16
      Bindings
      • 0: temporary_close
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'shop_banner') limit 1
      740μsshopimic_newstoresettings.php#16
      Bindings
      • 0: shop_banner
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:122
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `admins` where (`id` = 1) limit 1
      2.67msshopimic_newstoreInHouseTrait.php#43
      Bindings
      • 0: 1
      Backtrace
      • 16. app/Traits/InHouseTrait.php:43
      • 17. app/Http/Controllers/Web/HomeController.php:122
      • 18. app/Http/Controllers/Web/HomeController.php:55
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `admins` where (`id` = 1) limit 1
      970μsshopimic_newstoreInHouseTrait.php#43
      Bindings
      • 0: 1
      Backtrace
      • 16. app/Traits/InHouseTrait.php:43
      • 17. app/Http/Controllers/Web/HomeController.php:122
      • 18. app/Http/Controllers/Web/HomeController.php:55
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `status` = 1
      950μsshopimic_newstoreHomeController.php#127
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11
      • 3: 12
      • 4: 13
      • 5: 14
      • 6: 15
      • 7: 16
      • 8: 17
      • 9: 18
      • 10: 19
      • 11: 20
      • 12: 21
      • 13: 22
      • 14: 23
      • 15: 24
      • 16: 25
      • 17: 26
      • 18: 27
      • 19: 28
      • 20: 29
      • 21: 30
      • 22: 31
      • 23: 32
      • 24: 33
      • 25: 34
      • 26: 35
      • 27: 36
      • 28: 37
      • 29: 38
      • 30: 39
      • 31: 40
      • 32: 41
      • 33: 42
      • 34: 43
      • 35: 44
      • 36: 45
      • 37: 46
      • 38: 47
      • 39: 48
      • 40: 49
      • 41: 50
      • 42: 51
      • 43: 52
      • 44: 53
      • 45: 54
      • 46: 55
      • 47: 56
      • 48: 57
      • 49: 58
      • 50: 59
      • 51: 60
      • 52: 61
      • 53: 62
      • 54: 63
      • 55: 64
      • 56: 65
      • 57: 66
      • 58: 67
      • 59: 68
      • 60: 69
      • 61: 70
      • 62: 71
      • 63: 72
      • 64: 73
      • 65: 74
      • 66: 75
      • 67: 76
      • 68: 77
      • 69: 78
      • 70: 79
      • 71: 80
      • 72: 81
      • 73: 82
      • 74: 83
      • 75: 84
      • 76: 85
      • 77: 86
      • 78: 87
      • 79: 88
      • 80: 89
      • 81: 90
      • 82: 91
      • 83: 92
      • 84: 93
      • 85: 94
      • 86: 95
      • 87: 96
      • 88: 97
      • 89: 98
      • 90: 99
      • 91: 100
      • 92: 101
      • 93: 102
      • 94: 103
      • 95: 104
      • 96: 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:127
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select count(*) as aggregate from `orders` where (`seller_is` = 'admin')
      1.71msshopimic_newstoreHomeController.php#129
      Bindings
      • 0: admin
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:129
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `business_settings` where (`type` = 'top_vendor_list_priority') limit 1
      810μsshopimic_newstoresettings.php#16
      Bindings
      • 0: top_vendor_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:132
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'featured_product_priority') limit 1
      810μsshopimic_newstoresettings.php#16
      Bindings
      • 0: featured_product_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:134
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`featured` = 1)
      1.54msshopimic_newstoreproduct-manager.php#836
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: 1
      Backtrace
      • 16. app/Utils/product-manager.php:836
      • 17. app/Http/Controllers/Web/HomeController.php:134
      • 18. app/Http/Controllers/Web/HomeController.php:55
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') order by `id` desc limit 8
      1.65msshopimic_newstoreHomeController.php#136
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:136
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `reviews` where `reviews`.`product_id` in (97, 98, 99, 100, 101, 102, 103, 104) and `delivery_man_id` is null and `status` = 1
      730μsshopimic_newstoreHomeController.php#136
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:136
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (97, 98, 99, 100, 101, 102, 103, 104) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      1.1msshopimic_newstoreHomeController.php#136
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:136
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `business_settings` where (`type` = 'new_arrival_product_list_priority') limit 1
      830μsshopimic_newstoresettings.php#16
      Bindings
      • 0: new_arrival_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:137
      • 19. app/Http/Controllers/Web/HomeController.php:55
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
      1.54msshopimic_newstoreproduct-manager.php#1064
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      Backtrace
      • 16. app/Utils/product-manager.php:1064
      • 17. app/Http/Controllers/Web/HomeController.php:137
      • 18. app/Http/Controllers/Web/HomeController.php:55
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') order by `order_details_count` desc limit 8 offset 0
      7.6msshopimic_newstoreproduct-manager.php#1064
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: digital
      • 9: physical
      Backtrace
      • 16. app/Utils/product-manager.php:1064
      • 17. app/Http/Controllers/Web/HomeController.php:137
      • 18. app/Http/Controllers/Web/HomeController.php:55
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (1, 58, 70, 71, 72, 73, 74, 80) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      930μsshopimic_newstoreproduct-manager.php#1064
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Utils/product-manager.php:1064
      • 22. app/Http/Controllers/Web/HomeController.php:137
      • 23. app/Http/Controllers/Web/HomeController.php:55
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (1, 58, 70, 71, 72, 73, 74, 80) and `delivery_man_id` is null and `status` = 1
      800μsshopimic_newstoreproduct-manager.php#1064
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1064
      • 22. app/Http/Controllers/Web/HomeController.php:137
      • 23. app/Http/Controllers/Web/HomeController.php:55
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `brands` where `status` = 1 limit 15
      1.28msshopimic_newstoreHomeController.php#139
      Bindings
      • 0: 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:139
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
      750μsshopimic_newstoreHomeController.php#139
      Bindings
      • 0: App\Models\Brand
      • 1: en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:139
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `schools` limit 4
      2.33msshopimic_newstoreHomeController.php#141
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:141
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `product_id`, COUNT(product_id) as count from `order_details` where exists (select * from `products` where `order_details`.`product_id` = `products`.`id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) group by `product_id` order by `count` desc limit 6
      1.3msshopimic_newstoreHomeController.php#153
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:153
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` = 'App\Models\OrderDetail'
      1.01msshopimic_newstoreHomeController.php#153
      Bindings
      • 0: App\Models\OrderDetail
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:153
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `products` where `status` = 1 and `products`.`id` in (1, 58)
      1.21msshopimic_newstoreHomeController.php#153
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:153
      • 21. app/Http/Controllers/Web/HomeController.php:55
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `reviews` where `reviews`.`product_id` in (1, 58) and `delivery_man_id` is null and `status` = 1
      750μsshopimic_newstoreHomeController.php#153
      Bindings
      • 0: 1
      Backtrace
      • 25. app/Http/Controllers/Web/HomeController.php:153
      • 26. app/Http/Controllers/Web/HomeController.php:55
      • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (1, 58) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      810μsshopimic_newstoreHomeController.php#153
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 25. app/Http/Controllers/Web/HomeController.php:153
      • 26. app/Http/Controllers/Web/HomeController.php:55
      • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `product_id`, AVG(rating) as count from `reviews` where exists (select * from `products` where `reviews`.`product_id` = `products`.`id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) and `status` = 1 group by `product_id` order by `count` desc limit 6
      1msshopimic_newstoreHomeController.php#163
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:163
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `deal_of_the_days`.*, `products`.`unit_price` from `deal_of_the_days` inner join `products` on `products`.`id` = `deal_of_the_days`.`product_id` where `products`.`status` = 1 and `deal_of_the_days`.`status` = 1 limit 1
      1.48msshopimic_newstoreHomeController.php#173
      Bindings
      • 0: 1
      • 1: 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:173
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `banners` where (`banner_type` = 'Main Banner' and `theme` = 'default' and `published` = 1) order by `created_at` desc
      860μsshopimic_newstoreHomeController.php#174
      Bindings
      • 0: Main Banner
      • 1: default
      • 2: 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:174
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `banners` where (`banner_type` = 'Main Section Banner' and `theme` = 'default' and `published` = 1) order by `id` desc, `created_at` desc limit 1
      1.01msshopimic_newstoreHomeController.php#175
      Bindings
      • 0: Main Section Banner
      • 1: default
      • 2: 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:175
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') order by RAND() limit 1
      5.02msshopimic_newstoreHomeController.php#177
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:177
      • 17. app/Http/Controllers/Web/HomeController.php:55
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (33) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      980μsshopimic_newstoreHomeController.php#177
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Http/Controllers/Web/HomeController.php:177
      • 22. app/Http/Controllers/Web/HomeController.php:55
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `reviews` where `reviews`.`product_id` in (33) and `delivery_man_id` is null and `status` = 1
      760μsshopimic_newstoreHomeController.php#177
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Http/Controllers/Web/HomeController.php:177
      • 22. app/Http/Controllers/Web/HomeController.php:55
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc
      760μsshopimic_newstoreHomeController.php#178
      Bindings
      • 0: Footer Banner
      • 1: default
      • 2: 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:178
      • 16. app/Http/Controllers/Web/HomeController.php:55
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `vendor_banner`
      1.29msshopimic_newstoreHomeController.php#180
      Backtrace
      • 13. app/Http/Controllers/Web/HomeController.php:180
      • 14. app/Http/Controllers/Web/HomeController.php:55
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `business_settings` where (`type` = 'company_reliability') limit 1
      810μsshopimic_newstoresettings.php#16
      Bindings
      • 0: company_reliability
      Backtrace
      • 16. app/Utils/settings.php:16
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'announcement') limit 1
      930μsshopimic_newstoresettings.php#16
      Bindings
      • 0: announcement
      Backtrace
      • 16. app/Utils/settings.php:16
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` = 0
      3.45msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: 0
      Backtrace
      • 15. app/Utils/category-manager.php:82
      • 16. view::layouts.front-end.partials._header:101
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2, 3, 4, 5, 6, 7, 8) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
      5.65msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. view::layouts.front-end.partials._header:101
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select * from `translations` where `translations`.`translationable_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      1.18msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. view::layouts.front-end.partials._header:101
      • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select * from `reviews` where `reviews`.`product_id` in (1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104) and `delivery_man_id` is null and `status` = 1
      850μsshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. view::layouts.front-end.partials._header:101
      • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `position` = 1 order by `priority` asc
      7.06msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. view::layouts.front-end.partials._header:101
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92) and `position` = 2 order by `priority` asc
      4.29msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: 2
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. view::layouts.front-end.partials._header:101
      • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select * from `translations` where `translations`.`translationable_id` in (53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      1.35msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 30. app/Utils/category-manager.php:82
      • 31. view::layouts.front-end.partials._header:101
      • 33. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 34. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select * from `translations` where `translations`.`translationable_id` in (9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      1.46msshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. view::layouts.front-end.partials._header:101
      • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      890μsshopimic_newstorecategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. view::layouts.front-end.partials._header:101
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select * from `business_settings` where (`type` = 'category_list_priority') limit 1
      890μsshopimic_newstoresettings.php#16
      Bindings
      • 0: category_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Utils/category-manager.php:82
      • 19. view::layouts.front-end.partials._header:101
      • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `business_settings` where (`type` = 'country_code') limit 1
      1.02msshopimic_newstoresettings.php#16
      Bindings
      • 0: country_code
      Backtrace
      • 16. app/Utils/settings.php:16
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    App\Models\Product
    320Product.php#?
    App\Models\Category
    182Category.php#?
    App\Models\BusinessSetting
    19BusinessSetting.php#?
    App\Models\Brand
    9Brand.php#?
    App\Models\Banner
    3Banner.php#?
    App\Models\Admin
    2Admin.php#?
    App\Models\OrderDetail
    2OrderDetail.php#?
        storage_connection_type
        public
        company_web_logo
        array:3 [ "key" => "2021-05-25-60ad1b313a9d4.png" "path" => null "status" => 404 ]
        decimal_point_settings
        2
        product_brand
        1
        digital_product
        1
        business_mode
        multi
        currency_model
        single_currency
        language
        array:1 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "cod...
        local
        en
        direction
        ltr
        system_default_currency
        3
        system_default_currency_info
        App\Models\Currency {#3834 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
        currency_code
        INR
        currency_symbol
        currency_exchange_rate
        60
        _token
        u21N00NgizeANXcyEMNECcz2ewDO6SetDuvMWhjl
        guest_id
        35794
        company_name
        Shopimic
        _previous
        array:1 [ "url" => "https://shopimic.com" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "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" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "cache-control" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "shopimic.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] ]
        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 => "Thu, 03 Apr 2025 14:44:26 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZhOUt1Yy9qQTNyaFB5N2RiaG9nMEE9PSIsInZhbHVlIjoiVzhFYjg0MmhLR1ZVVVVVeEZ2ZFZmcGZsOS9qZHhJdnlVdUUwR1pOazJLYWtxNVY3MlF4S1B0eExlU2loS2F1MXBmQnFKNDRSTUJhVjRaK3F5RHlYRVlxaTZoQlFlWlVsRitLS0o4Skx0RGI0NndZeGpzbzJ2dFFhMkVwd0dINE8iLCJtYWMiOiI4Yzg1OGI0NmU5ZmUzNWUzZDYyZjI1YTYzNDBhZDBkZjZlMGNjMDllM2E3YjZjMjRjMWY4NWEwYmMwODUzNDU2IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 15:44:27 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6IkZhOUt1Yy9qQTNyaFB5N2RiaG9nMEE9PSIsInZhbHVlIjoiVzhFYjg0MmhLR1ZVVVVVeEZ2ZFZmcGZsOS9qZHhJdnlVdUUwR1pOazJLYWtxNVY3MlF4S1B0eExlU2loS2F1MXBmQnFKN" 1 => "6valley1725789276_session=eyJpdiI6IlgvaHAxZENBV1NMQnlGNndWOXRPUnc9PSIsInZhbHVlIjoiRXNXY0laM0N3bEZFazFJZlhPQkZEOXYwOEc4bTArOTVSbXdSY0gweXdnbk9Gd1pHa09BR01UR0dFbnIvY21pVkdJVGxCa2E5dlN4aHpDYXJYZFZkdUk2eVE2ajVQRmJwVHJVazQ1dldKN25PcTJtdy9sQ2NNemF2VFlPTm1BUGkiLCJtYWMiOiI0NzYxOTdhMjc2NzMzNTE1MWYzM2VmY2YyZTRmMWQ3NzE4ZTc1YzQ4ZWUxZjNmY2FjMmU4N2Y3YzU3YzU0OWEyIiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 15:44:27 GMT; Max-Age=3600; path=/; httponly6valley1725789276_session=eyJpdiI6IlgvaHAxZENBV1NMQnlGNndWOXRPUnc9PSIsInZhbHVlIjoiRXNXY0laM0N3bEZFazFJZlhPQkZEOXYwOEc4bTArOTVSbXdSY0gweXdnbk9Gd1pHa09BR01UR0dFbn" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZhOUt1Yy9qQTNyaFB5N2RiaG9nMEE9PSIsInZhbHVlIjoiVzhFYjg0MmhLR1ZVVVVVeEZ2ZFZmcGZsOS9qZHhJdnlVdUUwR1pOazJLYWtxNVY3MlF4S1B0eExlU2loS2F1MXBmQnFKNDRSTUJhVjRaK3F5RHlYRVlxaTZoQlFlWlVsRitLS0o4Skx0RGI0NndZeGpzbzJ2dFFhMkVwd0dINE8iLCJtYWMiOiI4Yzg1OGI0NmU5ZmUzNWUzZDYyZjI1YTYzNDBhZDBkZjZlMGNjMDllM2E3YjZjMjRjMWY4NWEwYmMwODUzNDU2IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 15:44:27 GMT; path=/XSRF-TOKEN=eyJpdiI6IkZhOUt1Yy9qQTNyaFB5N2RiaG9nMEE9PSIsInZhbHVlIjoiVzhFYjg0MmhLR1ZVVVVVeEZ2ZFZmcGZsOS9qZHhJdnlVdUUwR1pOazJLYWtxNVY3MlF4S1B0eExlU2loS2F1MXBmQnFKN" 1 => "6valley1725789276_session=eyJpdiI6IlgvaHAxZENBV1NMQnlGNndWOXRPUnc9PSIsInZhbHVlIjoiRXNXY0laM0N3bEZFazFJZlhPQkZEOXYwOEc4bTArOTVSbXdSY0gweXdnbk9Gd1pHa09BR01UR0dFbnIvY21pVkdJVGxCa2E5dlN4aHpDYXJYZFZkdUk2eVE2ajVQRmJwVHJVazQ1dldKN25PcTJtdy9sQ2NNemF2VFlPTm1BUGkiLCJtYWMiOiI0NzYxOTdhMjc2NzMzNTE1MWYzM2VmY2YyZTRmMWQ3NzE4ZTc1YzQ4ZWUxZjNmY2FjMmU4N2Y3YzU3YzU0OWEyIiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 15:44:27 GMT; path=/; httponly6valley1725789276_session=eyJpdiI6IlgvaHAxZENBV1NMQnlGNndWOXRPUnc9PSIsInZhbHVlIjoiRXNXY0laM0N3bEZFazFJZlhPQkZEOXYwOEc4bTArOTVSbXdSY0gweXdnbk9Gd1pHa09BR01UR0dFbn" ] ]
        session_attributes
        0 of 0
        array:21 [ "storage_connection_type" => "public" "company_web_logo" => array:3 [ "key" => "2021-05-25-60ad1b313a9d4.png" "path" => null "status" => 404 ] "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 1 "business_mode" => "multi" "currency_model" => "single_currency" "language" => array:1 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 3 "system_default_currency_info" => App\Models\Currency {#3834 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 22:53:04" "updated_at" => "2021-06-04 23:56:38" ] #original: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 22:53:04" "updated_at" => "2021-06-04 23:56:38" ] #changes: [] #casts: array:4 [ "id" => "integer" "status" => "boolean" "created_at" => "datetime" "updated_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true +usesUniqueIds: false #hidden: [] #visible: [] #fillable: array:5 [ 0 => "name" 1 => "symbol" 2 => "code" 3 => "exchange_rate" 4 => "status" ] #guarded: array:1 [ 0 => "*" ] } "currency_code" => "INR" "currency_symbol" => "" "currency_exchange_rate" => "60" "_token" => "u21N00NgizeANXcyEMNECcz2ewDO6SetDuvMWhjl" "guest_id" => 35794 "company_name" => "Shopimic" "_previous" => array:1 [ "url" => "https://shopimic.com" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-03 14:44:27GET/2688537