"Get Flat ₹50 OFF on Your First Order! 🎉 Use Code: FIRST50 at Checkout. Hurry, Limited Time Offer!" X

Deal of the day

New arrivals
Brands
Grocery
-₹3.00
₹125.00 ₹122.00
-₹23.00
₹253.00 ₹230.00
Home & Furniture
-₹2.00
₹40.00 ₹38.00
-₹3.00
₹116.00 ₹113.00
-₹5.00
₹105.00 ₹100.00
Household Care
-₹2.00
₹75.00 ₹73.00
-₹24.00
₹440.00 ₹416.00
-5%
₹25.00 ₹23.75
Personal & Baby Care
-15%
₹265.00 ₹225.25
-4%
₹165.00 ₹158.40
-5%
₹90.00 ₹85.50
-₹2.00
₹50.00 ₹48.00
To complete order login first or Register
SettingsRequest history2823msRequest Duration16MBMemory Usage10.x
Laravel Version
10.48.29
PHP Version
8.2.27
Environment
live
Debug Mode
Enabled
URL
ecom.brostartup.com
Timezone
Asia/Dhaka
Locale
en
GET /
status
200 OK
full_url
https://harimartwholesale.com
action_name
home
controller_action
App\Http\Controllers\Web\HomeController@index
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[00:56:24] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[00:56:24] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[00:56:24] LOG.warning: addslashes(): Passing null to parameter #1 ($string) of type string is depre...
status
200 OK
full_url
https://harimartwholesale.com
action_name
home
controller_action
App\Http\Controllers\Web\HomeController@index
uri
GET /
controller
App\Http\Controllers\Web\HomeController@index
namespace
App\Http\Controllers\Web
file
app/Http/Controllers/Web/HomeController.php:49-61
middleware
web, maintenance_mode, guestCheck
duration
833ms
peak_memory
18MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
0 of 0
array:23 [ "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 => "br" ] "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNabnN1VGdmSjlBcGxySjhkc1MwSHc9PSIsInZhbHVlIjoiVGR4STgya2dYZ2p1N3p3NXprYUwrbzZZemhEdGtSZW5LQXMwSXhuZDZBajUxOWllc25mTE9wVnlocXpQZExGV2QvaGtrRlZVUExLOWFJQ3VwTHdqRk9FKzIycDltTWthUDhzUW4yVURpZU5yZWVHeHgwSmRoLy83SVVNUW50Z0UiLCJtYWMiOiJiMGYyNmE2MzMzOGY1ODk2OGYyOWM4NzRmZDg5YjgzN2U5NGJhNjI1YjFmZWM4YWU4ZjRiYzQyZjkxYzEyMDhiIiwidGFnIjoiIn0%3D; 6valley1728108518_session=eyJpdiI6InMvdGJ2WjNXNEtiYUJjVlkyRGVjeHc9PSIsInZhbHVlIjoiaThMcnFTbVF0T1lzem44b3RUNFo4bGE2OEhwdFdVMThmSVd6RURlOUczVTJ6NjRmK0NYR0JzdWJPSjZOSVJyVEtqZnR2bmlZcU5CS0Y0R2h5dVF0UUZBa2ZvSU1yZENib1lKSFBML2UvTVhEcUhnbGE5UlcyaGJiaW5KZzJHS1MiLCJtYWMiOiJmZTRhNDJiNmU4ZjVmMmY0NTM2NDhiOTRkNGE4YmRhMmZmNjI4MmVjMDg5MDQ5NTZlMmUxZjU0MDYwODMxZThlIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IjNabnN1VGdmSjlBcGxySjhkc1MwSHc9PSIsInZhbHVlIjoiVGR4STgya2dYZ2p1N3p3NXprYUwrbzZZemhEdGtSZW5LQXMwSXhuZDZBajUxOWllc25mTE9wVnlocXpQZExGV2QvaGtrR" ] "host" => array:1 [ 0 => "harimartwholesale.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "x-forwarded-for" => array:1 [ 0 => "3.137.157.182" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "3.137.157.182" ] "x-real-port" => array:1 [ 0 => "47792" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-port" => array:1 [ 0 => "443" ] "x-lscache" => array:1 [ 0 => "1" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
request_cookies
0 of 0
array:2 [ "XSRF-TOKEN" => "lgB9ZJ5gfguvJhfAOVZ3xCIdQ6KdHniIXPW0imll" "6valley1728108518_session" => "1nqWlhW1qbf848s85fgtM1P0DktSAJ1tCryne71K" ]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 31 May 2025 00:56:24 GMT" ] ]
session_attributes
0 of 0
array:24 [ "storage_connection_type" => "public" "company_web_logo" => array:3 [ "key" => "2024-12-12-675aba996dd28.webp" "path" => "https://harimartwholesale.com/storage/app/public/company/2024-12-12-675aba996dd28.webp" "status" => 200 ] "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 0 "business_mode" => "single" "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 {#3865 #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 17:23:04" "updated_at" => "2021-06-04 18:26:38" ] #original: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2021-06-04 18:26: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" => "lgB9ZJ5gfguvJhfAOVZ3xCIdQ6KdHniIXPW0imll" "guest_id" => 74255 "toastr::messages" => array:1 [ 0 => array:4 [ "type" => "info" "title" => null "message" => "To complete order login first or Register" "options" => [] ] ] "_flash" => array:2 [ "new" => [] "old" => array:1 [ 0 => "toastr::messages" ] ] "PHPDEBUGBAR_STACK_DATA" => array:1 [ "01JWHXE0MMHXNG6MQDRGNDW6MX" => null ] "_previous" => array:1 [ "url" => "https://harimartwholesale.com/shop-cart" ] "company_name" => "Hari Mart Wholesale" "currency_symbol_position" => "left" "company_email" => "harimartwholesale@gmail.com" ]
  • Booting (102ms)time
  • Application (721ms)time
  • Routing (9.3ms)
  • Preparing Response (300ms)
  • View: web-views.homeviews
  • View: web-views.partials._home-top-sliderviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._feature-productviews
  • View: web-views.partials._category-section-homeviews
  • View: web-views.partials._deal-of-the-dayviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._inline-single-productviews
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._product-card-2views
  • View: web-views.partials._best-sellingviews
  • View: web-views.partials._top-ratedviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-wise-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._category-single-productviews
  • View: web-views.partials._company-reliabilityviews
  • View: layouts.front-end.appviews
  • View: web-views.partials._robotsMetaContentDataviews
  • View: layouts.front-end.partials._modalsviews
  • View: layouts.front-end.partials._quick-view-modalviews
  • View: layouts.front-end.partials.modal._buy-nowviews
  • View: layouts.front-end.partials._headerviews
  • View: layouts.front-end.partials._cartviews
  • View: layouts.front-end.partials._alert-messageviews
  • View: layouts.front-end.partials._footerviews
  • View: layouts.front-end.partials.modal._dynamic-modalsviews
  • 1 x Application (87.61%)
    721ms
    1 x Preparing Response (36.52%)
    300ms
    1 x Booting (12.39%)
    102ms
    1 x Routing (1.13%)
    9.30ms
    105 x View (0%)
    0μs
    105 templates were rendered
    • 1x web-views.homehome.blade.php#?blade
    • 1x web-views.partials._home-top-slider_home-top-slider.blade.php#?blade
    • 12x web-views.partials._feature-product_feature-product.blade.php#?blade
    • 1x web-views.partials._category-section-home_category-section-home.blade.php#?blade
    • 1x web-views.partials._deal-of-the-day_deal-of-the-day.blade.php#?blade
    • 8x web-views.partials._inline-single-product_inline-single-product.blade.php#?blade
    • 8x web-views.partials._product-card-2_product-card-2.blade.php#?blade
    • 1x web-views.partials._best-selling_best-selling.blade.php#?blade
    • 1x web-views.partials._top-rated_top-rated.blade.php#?blade
    • 12x web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
    • 48x web-views.partials._category-single-product_category-single-product.blade.php#?blade
    • 1x web-views.partials._company-reliability_company-reliability.blade.php#?blade
    • 1x layouts.front-end.appapp.blade.php#?blade
    • 1x web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
    • 1x layouts.front-end.partials._modals_modals.blade.php#?blade
    • 1x layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
    • 1x layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
    • 1x layouts.front-end.partials._header_header.blade.php#?blade
    • 1x layouts.front-end.partials._cart_cart.blade.php#?blade
    • 1x layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
    • 1x layouts.front-end.partials._footer_footer.blade.php#?blade
    • 1x layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
    147 statements were executed (49 duplicates)Show only duplicatesu697114821_harimart384ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 47 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • helpers.php#167u697114821_harimart580μsselect * from `business_settings` where (`type` = 'maintenance_mode') limit 1
      Bindings
      • 0: maintenance_mode
      Backtrace
      • app/Utils/helpers.php:167
      • middleware::maintenance_mode:20
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • middleware::api_lang:22
    • category-manager.php#82u697114821_harimart12.62msselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') 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 ('physical')) as `product_count` from `categories` where `position` = 0
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: 0
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart23.95msselect `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, 7, 9, 10, 11, 12, 13, 14, 33, 96) and (`added_by` = 'admin') 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 ('physical')
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart1.01msselect * from `translations` where `translations`.`translationable_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart1.05msselect * from `reviews` where `reviews`.`product_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart14.74msselect `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, 7, 9, 10, 11, 12, 13, 14, 33, 96) and `position` = 1 order by `priority` asc
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart45.72msselect `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 (5, 15, 23, 24, 27, 34, 35, 36, 37, 38, 39, 40, 41, 42, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 97, 98, 99, 100) and `position` = 2 order by `priority` asc
      Bindings
      • 0: 2
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart800μsselect * from `translations` where `translations`.`translationable_id` in (6, 16, 17, 18, 19, 20, 21, 22, 30, 31, 32, 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, 94, 95, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart550μsselect * from `translations` where `translations`.`translationable_id` in (5, 15, 23, 24, 27, 34, 35, 36, 37, 38, 39, 40, 41, 42, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 97, 98, 99, 100) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • category-manager.php#82u697114821_harimart510μsselect * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 7, 9, 10, 11, 12, 13, 14, 33, 96) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart430μsselect * from `business_settings` where (`type` = 'category_list_priority') limit 1
      Bindings
      • 0: category_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Utils/category-manager.php:82
      • app/Http/Controllers/Web/HomeController.php:65
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1318u697114821_harimart790μsselect `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-05-31' and date(`end_date`) >= '2025-05-31' limit 1
      Bindings
      • 0: flash_deal
      • 1: 1
      • 2: 2025-05-31
      • 3: 2025-05-31
      Backtrace
      • app/Utils/product-manager.php:1318
      • app/Http/Controllers/Web/HomeController.php:67
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • HomeController.php#70u697114821_harimart340μsselect * from `business_settings` where `type` = 'product_brand' limit 1
      Bindings
      • 0: product_brand
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:70
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#71u697114821_harimart560μsselect * from `categories` where `home_status` = 1 order by `priority` asc
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:71
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#71u697114821_harimart470μsselect * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 7, 9, 10, 11, 12, 13, 14, 33) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:71
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • settings.php#16u697114821_harimart350μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.53msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"14\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"14"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart21.82msselect `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 (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"14\"%' order by `order_details_count` desc limit 12 offset 0
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: admin
      • 4: 1
      • 5: 1
      • 6: 1
      • 7: approved
      • 8: admin
      • 9: 1
      • 10: physical
      • 11: %"14"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart680μsselect * from `translations` where `translations`.`translationable_id` in (12, 14, 15, 20, 39, 47, 56, 59, 61, 62, 95, 103) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart570μsselect * from `reviews` where `reviews`.`product_id` in (12, 14, 15, 20, 39, 47, 56, 59, 61, 62, 95, 103) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart530μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.54msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"2\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"2"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart510μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.62msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"3\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"3"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart520μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.7msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"11\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"11"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart5.2msselect `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 (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"11\"%' order by `order_details_count` desc limit 12 offset 0
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: admin
      • 4: 1
      • 5: 1
      • 6: 1
      • 7: approved
      • 8: admin
      • 9: 1
      • 10: physical
      • 11: %"11"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart630μsselect * from `translations` where `translations`.`translationable_id` in (130, 134, 141) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart740μsselect * from `reviews` where `reviews`.`product_id` in (130, 134, 141) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart470μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.99msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"9\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"9"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart390μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart2.39msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"12\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"12"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart470μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.46msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"10\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"10"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart410μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.39msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"1\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"1"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart380μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.39msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"33\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"33"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart4.71msselect `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 (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"33\"%' order by `order_details_count` desc limit 12 offset 0
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: admin
      • 4: 1
      • 5: 1
      • 6: 1
      • 7: approved
      • 8: admin
      • 9: 1
      • 10: physical
      • 11: %"33"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart470μsselect * from `translations` where `translations`.`translationable_id` in (36, 105, 151, 155, 162, 163) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart430μsselect * from `reviews` where `reviews`.`product_id` in (36, 105, 151, 155, 162, 163) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart360μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.4msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"4\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"4"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart310μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.31msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"7\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"7"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • settings.php#16u697114821_harimart350μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart1.48msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"13\"%'
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: %"13"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart5.2msselect `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 (`added_by` = 'admin') 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 ('physical') and `category_ids` like '%\"13\"%' order by `order_details_count` desc limit 12 offset 0
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: admin
      • 4: 1
      • 5: 1
      • 6: 1
      • 7: approved
      • 8: admin
      • 9: 1
      • 10: physical
      • 11: %"13"%
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart670μsselect * from `translations` where `translations`.`translationable_id` in (101, 102, 109, 110, 118, 119, 120, 121, 123, 124, 139, 140) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1144u697114821_harimart480μsselect * from `reviews` where `reviews`.`product_id` in (101, 102, 109, 110, 118, 119, 120, 121, 123, 124, 139, 140) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:1144
      • app/Http/Controllers/Web/HomeController.php:77
      • app/Http/Controllers/Web/HomeController.php:72
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • HomeController.php#93u697114821_harimart1.25msselect `shops`.*, (select count(*) from `products` where `shops`.`seller_id` = `products`.`user_id` and (`added_by` = 'admin') 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 ('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'))
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: seller
      • 9: 1
      • 10: 1
      • 11: approved
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:93
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#111u697114821_harimart7.37msselect `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` from `products` where (`added_by` = 'admin') 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 ('physical') and (`added_by` = 'admin')
      Bindings
      • 0: 1
      • 1: admin
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: physical
      • 9: admin
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:111
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#111u697114821_harimart1.1msselect * from `reviews` where `reviews`.`product_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:111
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#111u697114821_harimart910μsselect avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `status` = 1 group by `product_id`
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:111
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#111u697114821_harimart1.14msselect * from `translations` where `translations`.`translationable_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:111
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#115u697114821_harimart1.54msselect count(*) as aggregate from `reviews` where `status` = 1 and `product_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `status` = 1
      Bindings
      • 0: 1
      • 1: 12
      • 2: 13
      • 3: 14
      • 4: 15
      • 5: 16
      • 6: 17
      • 7: 18
      • 8: 19
      • 9: 20
      • 10: 21
      • 11: 22
      • 12: 23
      • 13: 24
      • 14: 25
      • 15: 26
      • 16: 27
      • 17: 28
      • 18: 29
      • 19: 30
      • 20: 31
      • 21: 32
      • 22: 33
      • 23: 34
      • 24: 35
      • 25: 36
      • 26: 37
      • 27: 38
      • 28: 39
      • 29: 40
      • 30: 41
      • 31: 42
      • 32: 43
      • 33: 44
      • 34: 45
      • 35: 46
      • 36: 47
      • 37: 48
      • 38: 49
      • 39: 50
      • 40: 51
      • 41: 52
      • 42: 53
      • 43: 54
      • 44: 55
      • 45: 56
      • 46: 57
      • 47: 58
      • 48: 59
      • 49: 60
      • 50: 61
      • 51: 62
      • 52: 63
      • 53: 64
      • 54: 65
      • 55: 66
      • 56: 67
      • 57: 68
      • 58: 69
      • 59: 70
      • 60: 71
      • 61: 72
      • 62: 73
      • 63: 74
      • 64: 75
      • 65: 76
      • 66: 77
      • 67: 78
      • 68: 79
      • 69: 80
      • 70: 81
      • 71: 82
      • 72: 83
      • 73: 84
      • 74: 85
      • 75: 86
      • 76: 87
      • 77: 88
      • 78: 89
      • 79: 90
      • 80: 91
      • 81: 92
      • 82: 93
      • 83: 94
      • 84: 95
      • 85: 96
      • 86: 97
      • 87: 98
      • 88: 99
      • 89: 100
      • 90: 101
      • 91: 102
      • 92: 103
      • 93: 104
      • 94: 105
      • 95: 106
      • 96: 107
      • 97: 108
      • 98: 109
      • 99: 110
      • 100: 111
      • 101: 112
      • 102: 113
      • 103: 114
      • 104: 115
      • 105: 116
      • 106: 117
      • 107: 118
      • 108: 119
      • 109: 120
      • 110: 121
      • 111: 122
      • 112: 123
      • 113: 124
      • 114: 125
      • 115: 126
      • 116: 127
      • 117: 128
      • 118: 129
      • 119: 130
      • 120: 131
      • 121: 132
      • 122: 133
      • 123: 134
      • 124: 135
      • 125: 136
      • 126: 137
      • 127: 138
      • 128: 139
      • 129: 140
      • 130: 141
      • 131: 142
      • 132: 146
      • 133: 147
      • 134: 148
      • 135: 151
      • 136: 154
      • 137: 155
      • 138: 156
      • 139: 157
      • 140: 158
      • 141: 159
      • 142: 160
      • 143: 162
      • 144: 163
      • 145: 165
      • 146: 166
      • 147: 167
      • 148: 168
      • 149: 170
      • 150: 172
      • 151: 173
      • 152: 174
      • 153: 175
      • 154: 176
      • 155: 178
      • 156: 179
      • 157: 185
      • 158: 186
      • 159: 223
      • 160: 297
      • 161: 339
      • 162: 356
      • 163: 365
      • 164: 434
      • 165: 474
      • 166: 554
      • 167: 642
      • 168: 643
      • 169: 644
      • 170: 645
      • 171: 646
      • 172: 648
      • 173: 650
      • 174: 651
      • 175: 652
      • 176: 653
      • 177: 657
      • 178: 658
      • 179: 659
      • 180: 711
      • 181: 713
      • 182: 714
      • 183: 715
      • 184: 716
      • 185: 717
      • 186: 718
      • 187: 720
      • 188: 721
      • 189: 722
      • 190: 723
      • 191: 724
      • 192: 725
      • 193: 726
      • 194: 728
      • 195: 729
      • 196: 730
      • 197: 731
      • 198: 732
      • 199: 733
      • 200: 734
      • 201: 735
      • 202: 736
      • 203: 737
      • 204: 738
      • 205: 739
      • 206: 740
      • 207: 744
      • 208: 745
      • 209: 747
      • 210: 748
      • 211: 749
      • 212: 750
      • 213: 751
      • 214: 752
      • 215: 753
      • 216: 754
      • 217: 755
      • 218: 756
      • 219: 757
      • 220: 758
      • 221: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:115
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#117u697114821_harimart1.18msselect `rating` from `reviews` where `status` = 1 and `product_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `status` = 1
      Bindings
      • 0: 1
      • 1: 12
      • 2: 13
      • 3: 14
      • 4: 15
      • 5: 16
      • 6: 17
      • 7: 18
      • 8: 19
      • 9: 20
      • 10: 21
      • 11: 22
      • 12: 23
      • 13: 24
      • 14: 25
      • 15: 26
      • 16: 27
      • 17: 28
      • 18: 29
      • 19: 30
      • 20: 31
      • 21: 32
      • 22: 33
      • 23: 34
      • 24: 35
      • 25: 36
      • 26: 37
      • 27: 38
      • 28: 39
      • 29: 40
      • 30: 41
      • 31: 42
      • 32: 43
      • 33: 44
      • 34: 45
      • 35: 46
      • 36: 47
      • 37: 48
      • 38: 49
      • 39: 50
      • 40: 51
      • 41: 52
      • 42: 53
      • 43: 54
      • 44: 55
      • 45: 56
      • 46: 57
      • 47: 58
      • 48: 59
      • 49: 60
      • 50: 61
      • 51: 62
      • 52: 63
      • 53: 64
      • 54: 65
      • 55: 66
      • 56: 67
      • 57: 68
      • 58: 69
      • 59: 70
      • 60: 71
      • 61: 72
      • 62: 73
      • 63: 74
      • 64: 75
      • 65: 76
      • 66: 77
      • 67: 78
      • 68: 79
      • 69: 80
      • 70: 81
      • 71: 82
      • 72: 83
      • 73: 84
      • 74: 85
      • 75: 86
      • 76: 87
      • 77: 88
      • 78: 89
      • 79: 90
      • 80: 91
      • 81: 92
      • 82: 93
      • 83: 94
      • 84: 95
      • 85: 96
      • 86: 97
      • 87: 98
      • 88: 99
      • 89: 100
      • 90: 101
      • 91: 102
      • 92: 103
      • 93: 104
      • 94: 105
      • 95: 106
      • 96: 107
      • 97: 108
      • 98: 109
      • 99: 110
      • 100: 111
      • 101: 112
      • 102: 113
      • 103: 114
      • 104: 115
      • 105: 116
      • 106: 117
      • 107: 118
      • 108: 119
      • 109: 120
      • 110: 121
      • 111: 122
      • 112: 123
      • 113: 124
      • 114: 125
      • 115: 126
      • 116: 127
      • 117: 128
      • 118: 129
      • 119: 130
      • 120: 131
      • 121: 132
      • 122: 133
      • 123: 134
      • 124: 135
      • 125: 136
      • 126: 137
      • 127: 138
      • 128: 139
      • 129: 140
      • 130: 141
      • 131: 142
      • 132: 146
      • 133: 147
      • 134: 148
      • 135: 151
      • 136: 154
      • 137: 155
      • 138: 156
      • 139: 157
      • 140: 158
      • 141: 159
      • 142: 160
      • 143: 162
      • 144: 163
      • 145: 165
      • 146: 166
      • 147: 167
      • 148: 168
      • 149: 170
      • 150: 172
      • 151: 173
      • 152: 174
      • 153: 175
      • 154: 176
      • 155: 178
      • 156: 179
      • 157: 185
      • 158: 186
      • 159: 223
      • 160: 297
      • 161: 339
      • 162: 356
      • 163: 365
      • 164: 434
      • 165: 474
      • 166: 554
      • 167: 642
      • 168: 643
      • 169: 644
      • 170: 645
      • 171: 646
      • 172: 648
      • 173: 650
      • 174: 651
      • 175: 652
      • 176: 653
      • 177: 657
      • 178: 658
      • 179: 659
      • 180: 711
      • 181: 713
      • 182: 714
      • 183: 715
      • 184: 716
      • 185: 717
      • 186: 718
      • 187: 720
      • 188: 721
      • 189: 722
      • 190: 723
      • 191: 724
      • 192: 725
      • 193: 726
      • 194: 728
      • 195: 729
      • 196: 730
      • 197: 731
      • 198: 732
      • 199: 733
      • 200: 734
      • 201: 735
      • 202: 736
      • 203: 737
      • 204: 738
      • 205: 739
      • 206: 740
      • 207: 744
      • 208: 745
      • 209: 747
      • 210: 748
      • 211: 749
      • 212: 750
      • 213: 751
      • 214: 752
      • 215: 753
      • 216: 754
      • 217: 755
      • 218: 756
      • 219: 757
      • 220: 758
      • 221: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:117
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • settings.php#16u697114821_harimart360μsselect * from `business_settings` where (`type` = 'vacation_add') limit 1
      Bindings
      • 0: vacation_add
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart430μsselect * from `business_settings` where (`type` = 'company_name') limit 1
      Bindings
      • 0: company_name
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart400μsselect * from `business_settings` where (`type` = 'shop_address') limit 1
      Bindings
      • 0: shop_address
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart350μsselect * from `business_settings` where (`type` = 'company_phone') limit 1
      Bindings
      • 0: company_phone
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart360μsselect * from `business_settings` where (`type` = 'company_fav_icon') limit 1
      Bindings
      • 0: company_fav_icon
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart460μsselect * from `business_settings` where (`type` = 'bottom_banner') limit 1
      Bindings
      • 0: bottom_banner
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart470μsselect * from `business_settings` where (`type` = 'offer_banner') limit 1
      Bindings
      • 0: offer_banner
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart360μsselect * from `business_settings` where (`type` = 'temporary_close') limit 1
      Bindings
      • 0: temporary_close
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart310μsselect * from `business_settings` where (`type` = 'temporary_close') limit 1
      Bindings
      • 0: temporary_close
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart340μsselect * from `business_settings` where (`type` = 'shop_banner') limit 1
      Bindings
      • 0: shop_banner
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • InHouseTrait.php#43u697114821_harimart610μsselect * from `admins` where (`id` = 1) limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Traits/InHouseTrait.php:43
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • InHouseTrait.php#43u697114821_harimart370μsselect * from `admins` where (`id` = 1) limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Traits/InHouseTrait.php:43
      • app/Http/Controllers/Web/HomeController.php:121
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • HomeController.php#126u697114821_harimart1.91msselect avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `status` = 1
      Bindings
      • 0: 1
      • 1: 12
      • 2: 13
      • 3: 14
      • 4: 15
      • 5: 16
      • 6: 17
      • 7: 18
      • 8: 19
      • 9: 20
      • 10: 21
      • 11: 22
      • 12: 23
      • 13: 24
      • 14: 25
      • 15: 26
      • 16: 27
      • 17: 28
      • 18: 29
      • 19: 30
      • 20: 31
      • 21: 32
      • 22: 33
      • 23: 34
      • 24: 35
      • 25: 36
      • 26: 37
      • 27: 38
      • 28: 39
      • 29: 40
      • 30: 41
      • 31: 42
      • 32: 43
      • 33: 44
      • 34: 45
      • 35: 46
      • 36: 47
      • 37: 48
      • 38: 49
      • 39: 50
      • 40: 51
      • 41: 52
      • 42: 53
      • 43: 54
      • 44: 55
      • 45: 56
      • 46: 57
      • 47: 58
      • 48: 59
      • 49: 60
      • 50: 61
      • 51: 62
      • 52: 63
      • 53: 64
      • 54: 65
      • 55: 66
      • 56: 67
      • 57: 68
      • 58: 69
      • 59: 70
      • 60: 71
      • 61: 72
      • 62: 73
      • 63: 74
      • 64: 75
      • 65: 76
      • 66: 77
      • 67: 78
      • 68: 79
      • 69: 80
      • 70: 81
      • 71: 82
      • 72: 83
      • 73: 84
      • 74: 85
      • 75: 86
      • 76: 87
      • 77: 88
      • 78: 89
      • 79: 90
      • 80: 91
      • 81: 92
      • 82: 93
      • 83: 94
      • 84: 95
      • 85: 96
      • 86: 97
      • 87: 98
      • 88: 99
      • 89: 100
      • 90: 101
      • 91: 102
      • 92: 103
      • 93: 104
      • 94: 105
      • 95: 106
      • 96: 107
      • 97: 108
      • 98: 109
      • 99: 110
      • 100: 111
      • 101: 112
      • 102: 113
      • 103: 114
      • 104: 115
      • 105: 116
      • 106: 117
      • 107: 118
      • 108: 119
      • 109: 120
      • 110: 121
      • 111: 122
      • 112: 123
      • 113: 124
      • 114: 125
      • 115: 126
      • 116: 127
      • 117: 128
      • 118: 129
      • 119: 130
      • 120: 131
      • 121: 132
      • 122: 133
      • 123: 134
      • 124: 135
      • 125: 136
      • 126: 137
      • 127: 138
      • 128: 139
      • 129: 140
      • 130: 141
      • 131: 142
      • 132: 146
      • 133: 147
      • 134: 148
      • 135: 151
      • 136: 154
      • 137: 155
      • 138: 156
      • 139: 157
      • 140: 158
      • 141: 159
      • 142: 160
      • 143: 162
      • 144: 163
      • 145: 165
      • 146: 166
      • 147: 167
      • 148: 168
      • 149: 170
      • 150: 172
      • 151: 173
      • 152: 174
      • 153: 175
      • 154: 176
      • 155: 178
      • 156: 179
      • 157: 185
      • 158: 186
      • 159: 223
      • 160: 297
      • 161: 339
      • 162: 356
      • 163: 365
      • 164: 434
      • 165: 474
      • 166: 554
      • 167: 642
      • 168: 643
      • 169: 644
      • 170: 645
      • 171: 646
      • 172: 648
      • 173: 650
      • 174: 651
      • 175: 652
      • 176: 653
      • 177: 657
      • 178: 658
      • 179: 659
      • 180: 711
      • 181: 713
      • 182: 714
      • 183: 715
      • 184: 716
      • 185: 717
      • 186: 718
      • 187: 720
      • 188: 721
      • 189: 722
      • 190: 723
      • 191: 724
      • 192: 725
      • 193: 726
      • 194: 728
      • 195: 729
      • 196: 730
      • 197: 731
      • 198: 732
      • 199: 733
      • 200: 734
      • 201: 735
      • 202: 736
      • 203: 737
      • 204: 738
      • 205: 739
      • 206: 740
      • 207: 744
      • 208: 745
      • 209: 747
      • 210: 748
      • 211: 749
      • 212: 750
      • 213: 751
      • 214: 752
      • 215: 753
      • 216: 754
      • 217: 755
      • 218: 756
      • 219: 757
      • 220: 758
      • 221: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:126
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#128u697114821_harimart640μsselect count(*) as aggregate from `orders` where (`seller_is` = 'admin')
      Bindings
      • 0: admin
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:128
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • settings.php#16u697114821_harimart390μsselect * from `business_settings` where (`type` = 'top_vendor_list_priority') limit 1
      Bindings
      • 0: top_vendor_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:131
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • settings.php#16u697114821_harimart380μsselect * from `business_settings` where (`type` = 'featured_product_priority') limit 1
      Bindings
      • 0: featured_product_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:133
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#836u697114821_harimart1.7msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical') and (`featured` = 1)
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: 1
      Backtrace
      • app/Utils/product-manager.php:836
      • app/Http/Controllers/Web/HomeController.php:133
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#836u697114821_harimart5.68msselect `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 (`added_by` = 'admin') 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 ('physical') and (`featured` = 1) order by `id` desc limit 12 offset 0
      Bindings
      • 0: 1
      • 1: 1
      • 2: admin
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      Backtrace
      • app/Utils/product-manager.php:836
      • app/Http/Controllers/Web/HomeController.php:133
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#836u697114821_harimart760μsselect * from `translations` where `translations`.`translationable_id` in (18, 19, 20, 53, 55, 56, 59, 60, 61, 62, 722, 723) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:836
      • app/Http/Controllers/Web/HomeController.php:133
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#836u697114821_harimart720μsselect * from `reviews` where `reviews`.`product_id` in (18, 19, 20, 53, 55, 56, 59, 60, 61, 62, 722, 723) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:836
      • app/Http/Controllers/Web/HomeController.php:133
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • HomeController.php#135u697114821_harimart1.29msselect * from `products` where (`added_by` = 'admin') 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 ('physical') order by `id` desc limit 8
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:135
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#135u697114821_harimart510μsselect * from `reviews` where `reviews`.`product_id` in (751, 752, 753, 754, 755, 756, 757, 758) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:135
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#135u697114821_harimart500μsselect * from `translations` where `translations`.`translationable_id` in (751, 752, 753, 754, 755, 756, 757, 758) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:135
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • settings.php#16u697114821_harimart480μsselect * from `business_settings` where (`type` = 'new_arrival_product_list_priority') limit 1
      Bindings
      • 0: new_arrival_product_list_priority
      Backtrace
      • app/Utils/settings.php:16
      • app/Http/Controllers/Web/HomeController.php:136
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1064u697114821_harimart1.36msselect count(*) as aggregate from `products` where (`added_by` = 'admin') 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 ('physical')
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      Backtrace
      • app/Utils/product-manager.php:1064
      • app/Http/Controllers/Web/HomeController.php:136
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1064u697114821_harimart25.74msselect `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 (`added_by` = 'admin') 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 ('physical') order by `order_details_count` desc limit 8 offset 0
      Bindings
      • 0: 1
      • 1: 1
      • 2: admin
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      Backtrace
      • app/Utils/product-manager.php:1064
      • app/Http/Controllers/Web/HomeController.php:136
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1064u697114821_harimart660μsselect * from `translations` where `translations`.`translationable_id` in (14, 20, 36, 56, 59, 62, 101, 155) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1064
      • app/Http/Controllers/Web/HomeController.php:136
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1064u697114821_harimart530μsselect * from `reviews` where `reviews`.`product_id` in (14, 20, 36, 56, 59, 62, 101, 155) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:1064
      • app/Http/Controllers/Web/HomeController.php:136
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • HomeController.php#138u697114821_harimart500μsselect * from `brands` where `status` = 1 limit 15
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:138
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#138u697114821_harimart490μsselect * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'
      Bindings
      • 0: App\Models\Brand
      • 1: en
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:138
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#148u697114821_harimart1.97msselect `product_id`, COUNT(product_id) as count from `order_details` where exists (select * from `products` where `order_details`.`product_id` = `products`.`id` and (`added_by` = 'admin') 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 ('physical') and `status` = 1) group by `product_id` order by `count` desc limit 6
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:148
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#148u697114821_harimart690μsselect * from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` = 'App\\Models\\OrderDetail'
      Bindings
      • 0: App\Models\OrderDetail
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:148
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#148u697114821_harimart980μsselect * from `products` where `status` = 1 and `products`.`id` in (14, 20, 56, 59, 62, 155)
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:148
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#148u697114821_harimart500μsselect * from `reviews` where `reviews`.`product_id` in (14, 20, 56, 59, 62, 155) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:148
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#148u697114821_harimart460μsselect * from `translations` where `translations`.`translationable_id` in (14, 20, 56, 59, 62, 155) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:148
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#158u697114821_harimart950μsselect `product_id`, AVG(rating) as count from `reviews` where exists (select * from `products` where `reviews`.`product_id` = `products`.`id` and (`added_by` = 'admin') 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 ('physical')) and `status` = 1 group by `product_id` order by `count` desc limit 6
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      • 8: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:158
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#168u697114821_harimart700μsselect `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
      Bindings
      • 0: 1
      • 1: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:168
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#168u697114821_harimart540μsselect * from `translations` where `translations`.`translationable_id` in (3) and `translations`.`translationable_type` = 'App\\Models\\DealOfTheDay' and `locale` = 'en'
      Bindings
      • 0: App\Models\DealOfTheDay
      • 1: en
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:168
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#169u697114821_harimart700μsselect * from `banners` where (`banner_type` = 'Main Banner' and `theme` = 'default' and `published` = 1) order by `created_at` desc
      Bindings
      • 0: Main Banner
      • 1: default
      • 2: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:169
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#170u697114821_harimart570μsselect * from `banners` where (`banner_type` = 'Main Section Banner' and `theme` = 'default' and `published` = 1) order by `id` desc, `created_at` desc limit 1
      Bindings
      • 0: Main Section Banner
      • 1: default
      • 2: 1
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:170
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#172u697114821_harimart4.91msselect * from `products` where (`added_by` = 'admin') 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 ('physical') order by RAND() limit 1
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: approved
      • 5: admin
      • 6: 1
      • 7: physical
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:172
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • HomeController.php#172u697114821_harimart510μsselect * from `translations` where `translations`.`translationable_id` in (356) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Http/Controllers/Web/HomeController.php:172
      • app/Http/Controllers/Web/HomeController.php:56
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • u697114821_harimart380μsselect * from `reviews` where `reviews`.`product_id` in (356) and `delivery_man_id` is null and `status` = ?
    • u697114821_harimart410μsselect * from `banners` where `banner_type` = ? and `theme` = ? and `published` = ? order by `id` desc
    • u697114821_harimart740μsselect * from `storages` where `storages`.`data_type` = ? and `storages`.`data_id` = ? and `storages`.`data_id` is not null
    • u697114821_harimart350μsselect * from `storages` where `storages`.`data_type` = ? and `storages`.`data_id` = ? and `storages`.`data_id` is not null
    • u697114821_harimart360μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart650μsselect * from `storages` where `storages`.`data_type` = ? and `storages`.`data_id` = ? and `storages`.`data_id` is not null
    • u697114821_harimart810μsselect * from `products` where `products`.`id` = ? limit 1
    • u697114821_harimart450μsselect * from `translations` where `translations`.`translationable_id` in (20) and `translations`.`translationable_type` = ? and `locale` = ?
    • u697114821_harimart410μsselect * from `reviews` where `reviews`.`product_id` in (20) and `delivery_man_id` is null and `status` = ?
    • u697114821_harimart630μsselect * from `storages` where `storages`.`data_type` = ? and `storages`.`data_id` = ? and `storages`.`data_id` is not null
    • u697114821_harimart490μsselect * from `storages` where `storages`.`data_type` = ? and `storages`.`data_id` = ? and `storages`.`data_id` is not null
    • u697114821_harimart530μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart730μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart490μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart340μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart300μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart330μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart340μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart270μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart540μsselect `cart_group_id` from `carts` where (`customer_id` = ? and `is_guest` = ?) group by `cart_group_id`
    • u697114821_harimart340μsselect * from `carts` where 0 = 1
    • u697114821_harimart340μsselect `cart_group_id` from `carts` where (`customer_id` = ? and `is_guest` = ?) group by `cart_group_id`
    • u697114821_harimart280μsselect * from `carts` where 0 = 1
    • u697114821_harimart11.53msselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = ?) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = ?)) and (`status` = ?) and (`request_status` = ?) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = ?)) or ((`added_by` = ? and `status` = ?))) and `product_type` in (?)) as `product_count` from `categories` where `position` = ?
    • u697114821_harimart29.8msselect `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, 7, 9, 10, 11, 12, 13, 14, 33, 96) and (`added_by` = ?) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = ?)) and (`status` = ?) and (`request_status` = ?) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = ?)) or ((`added_by` = ? and `status` = ?))) and `product_type` in (?)
    • u697114821_harimart1.05msselect * from `translations` where `translations`.`translationable_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `translations`.`translationable_type` = ? and `locale` = ?
    • u697114821_harimart1msselect * from `reviews` where `reviews`.`product_id` in (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, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 146, 147, 148, 151, 154, 155, 156, 157, 158, 159, 160, 162, 163, 165, 166, 167, 168, 170, 172, 173, 174, 175, 176, 178, 179, 185, 186, 223, 297, 339, 356, 365, 434, 474, 554, 642, 643, 644, 645, 646, 648, 650, 651, 652, 653, 657, 658, 659, 711, 713, 714, 715, 716, 717, 718, 720, 721, 722, 723, 724, 725, 726, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758) and `delivery_man_id` is null and `status` = ?
    • u697114821_harimart19.86msselect `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, 7, 9, 10, 11, 12, 13, 14, 33, 96) and `position` = ? order by `priority` asc
    • u697114821_harimart38.93msselect `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 (5, 15, 23, 24, 27, 34, 35, 36, 37, 38, 39, 40, 41, 42, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 97, 98, 99, 100) and `position` = ? order by `priority` asc
    • u697114821_harimart810μsselect * from `translations` where `translations`.`translationable_id` in (6, 16, 17, 18, 19, 20, 21, 22, 30, 31, 32, 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, 94, 95, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149) and `translations`.`translationable_type` = ? and `locale` = ?
    • u697114821_harimart620μsselect * from `translations` where `translations`.`translationable_id` in (5, 15, 23, 24, 27, 34, 35, 36, 37, 38, 39, 40, 41, 42, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 97, 98, 99, 100) and `translations`.`translationable_type` = ? and `locale` = ?
    • u697114821_harimart560μsselect * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 7, 9, 10, 11, 12, 13, 14, 33, 96) and `translations`.`translationable_type` = ? and `locale` = ?
    • u697114821_harimart460μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart500μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart6.66msselect `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`added_by` = ?) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = ?)) and (`status` = ?) and (`request_status` = ?) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = ?)) or ((`added_by` = ? and `status` = ?))) and `product_type` in (?)) as `brand_products_count` from `brands` where `status` = ? order by `created_at` desc
    • u697114821_harimart9.3msselect * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7) and `translations`.`translationable_type` = ? and `locale` = ?
    • u697114821_harimart1.65msselect count(*) as aggregate from `products` where (`added_by` = ?) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = ?)) and (`status` = ?) and (`request_status` = ?) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = ?)) or ((`added_by` = ? and `status` = ?))) and `product_type` in (?) and `discount` != ?
    • u697114821_harimart530μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart450μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart630μsselect * from `flash_deals` where (`status` = ? and `deal_type` = ?) and date(`start_date`) <= ? and date(`end_date`) >= ? limit 1
    • u697114821_harimart360μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart260μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart250μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart190μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart200μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart230μsselect * from `business_settings` where (`type` = ?) limit 1
    • u697114821_harimart430μsselect * from `business_settings` where (`type` = ?) limit 1
    App\Models\Product
    729Product.php#?
    App\Models\Category
    298Category.php#?
    App\Models\BusinessSetting
    43BusinessSetting.php#?
    App\Models\Brand
    14Brand.php#?
    App\Models\OrderDetail
    6OrderDetail.php#?
    App\Models\Banner
    5Banner.php#?
    App\Models\Storage
    4Storage.php#?
    App\Models\Admin
    2Admin.php#?
    App\Models\DealOfTheDay
    1DealOfTheDay.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-31 00:56:22GET/shop-cart (stacked)31
        #22025-05-31 00:56:24GET/31051471102