Need help? Chat with us
Click one of our representatives below
Lil-mo
Tech. Support
I'm Online
Ibrahim Kajidu
Logistics Support
I will be back soon
Omar_kay
Sales Support
will be back shortly
Abba
Sales Support
I will be back soon
Request history8.3.15PHP Version2.68sRequest Duration10MBMemory UsageGET brand/{brand_slug}Route
  • infolog[22:53:46] LOG.info: IP-API Location: { "status": "success", "country": "United States", ...
  • infolog[22:53:46] LOG.info: Determined Currency Code: [ "USD" ]
  • infolog[22:53:46] LOG.info: Currency and country set in session: [ "USD", "United States" ]
  • Booting (75.14ms)time
  • Application (2.6s)time
  • 1 x Application (97.19%)
    2.60s
    1 x Booting (2.81%)
    75.14ms
    34 templates were rendered
    • frontend.product_listingproduct_listing.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
    • pagination::bootstrap-4bootstrap-4.blade.php#?blade
    • frontend.layouts.appapp.blade.php#?blade
    • frontend.inc.navnav.blade.php#?blade
    • frontend.partials.cart.cartcart.blade.php#?blade
    • frontend.megamart.partials.category_menucategory_menu.blade.php#?blade
    • frontend.inc.footerfooter.blade.php#?blade
    • frontend.partials.modalmodal.blade.php#?blade
    • frontend.partials.login_modallogin_modal.blade.php#?blade
    • frontend.partials.account_delete_modalaccount_delete_modal.blade.php#?blade
    uri
    GET brand/{brand_slug}
    middleware
    web
    controller
    App\Http\Controllers\SearchController@listingByBrand
    namespace
    prefix
    where
    as
    products.brand
    file
    app/Http/Controllers/SearchController.php:233-240
    71 statements were executed (17 duplicates)Show only duplicates110ms
    • select * from `currencies` where `code` = 'USD' limit 1
      3.48mspharmacyAutoCurrencyMiddleware.php#138
      Bindings
      • 0: USD
      Backtrace
      • app/Http/Middleware/AutoCurrencyMiddleware.php:138
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • app/Http/Middleware/HttpsProtocol.php:20
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • middleware::app_language:35
    • select * from `brands` where `slug` = 'demo-brand1' limit 1
      740μspharmacySearchController.php#235
      Bindings
      • 0: demo-brand1
      Backtrace
      • app/Http/Controllers/SearchController.php:235
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `brand_translations` where `brand_translations`.`brand_id` in (2)
      630μspharmacySearchController.php#235
      Backtrace
      • app/Http/Controllers/SearchController.php:235
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `attributes`
      750μspharmacySearchController.php#29
      Backtrace
      • app/Http/Controllers/SearchController.php:29
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (1, 2, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 29, 30, 48, 49, 50, 51, 52, 53, 54)
      920μspharmacySearchController.php#29
      Backtrace
      • app/Http/Controllers/SearchController.php:29
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `colors`
      1.37mspharmacySearchController.php#31
      Backtrace
      • app/Http/Controllers/SearchController.php:31
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `categories` where `level` = 0 order by `order_level` desc
      1.48mspharmacySearchController.php#145
      Bindings
      • 0: 0
      Backtrace
      • app/Http/Controllers/SearchController.php:145
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `category_translations` where `category_translations`.`category_id` in (253, 254, 255, 256, 257, 258, 259, 260, 261, 264, 270, 300, 354, 355, 393, 419, 424, 428, 435, 438)
      1.07mspharmacySearchController.php#145
      Backtrace
      • app/Http/Controllers/SearchController.php:145
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `categories` where `categories`.`parent_id` in (253, 254, 255, 256, 257, 258, 259, 260, 261, 264, 270, 300, 354, 355, 393, 419, 424, 428, 435, 438)
      2.7mspharmacySearchController.php#145
      Backtrace
      • app/Http/Controllers/SearchController.php:145
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `category_translations` where `category_translations`.`category_id` in (262, 263, 265, 267, 268, 271, 273, 274, 275, 276, 277, 278, 279, 280, 281, 284, 285, 287, 288, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 356, 357, 358, 359, 361, 362, 363, 364, 365, 366, 367, 368, 369, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 385, 386, 387, 388, 389, 390, 391, 392, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 408, 413, 414, 415, 416, 417, 418, 420, 421, 425, 426, 429, 430, 431, 432, 433, 434, 437)
      1.54mspharmacySearchController.php#145
      Backtrace
      • app/Http/Controllers/SearchController.php:145
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `categories` where `categories`.`parent_id` in (262, 263, 265, 267, 268, 271, 273, 274, 275, 276, 277, 278, 279, 280, 281, 284, 285, 287, 288, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 356, 357, 358, 359, 361, 362, 363, 364, 365, 366, 367, 368, 369, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 385, 386, 387, 388, 389, 390, 391, 392, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 408, 413, 414, 415, 416, 417, 418, 420, 421, 425, 426, 429, 430, 431, 432, 433, 434, 437)
      1.73mspharmacySearchController.php#145
      Backtrace
      • app/Http/Controllers/SearchController.php:145
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `category_translations` where `category_translations`.`category_id` in (266, 272, 282, 283, 286, 313, 314, 409, 410, 411, 412, 423, 436)
      930μspharmacySearchController.php#145
      Backtrace
      • app/Http/Controllers/SearchController.php:145
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `uploads` where `uploads`.`id` in (52, 625, 1944, 24879, 25038, 25039, 25040, 25042, 25046, 25047, 25049, 25050, 57601, 61322, 77754) and `uploads`.`deleted_at` is null
      1.02mspharmacySearchController.php#145
      Backtrace
      • app/Http/Controllers/SearchController.php:145
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select count(*) as aggregate from `products` where (`brand_id` = 2) and `approved` = '1' and `published` = 1 and `auction_product` = 0 and (`added_by` = 'admin' or (`user_id` in (11, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 35, 42, 48, 97, 98, 106, 107, 111, 114, 120, 127, 238, 257, 295, 317, 349, 364, 367, 369, 425, 427, 428, 432, 436, 437, 470, 482, 485, 488, 489, 490, 491, 492, 493, 494, 495, 497, 501, 502, 505, 506, 514, 515, 516, 519, 521, 523, 524, 526, 534, 535, 554, 561, 562, 563, 564, 572, 573, 576, 578, 581, 585, 589, 599, 607, 608, 613, 614, 616, 617, 618, 619, 628, 636, 651, 654, 655, 671, 676, 681, 696, 709, 746, 749, 777, 779, 782, 795, 803, 812, 827, 840, 870, 877, 879, 902, 903, 947, 961, 968, 998, 1001, 1002, 1019, 1043, 1051, 1119, 1133, 1167, 1173, 3227, 3797, 6174, 6397, 7034)))
      3.71mspharmacySearchController.php#213
      Bindings
      • 0: 2
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: admin
      • 5: 11
      • 6: 14
      • 7: 15
      • 8: 16
      • 9: 17
      • 10: 18
      • 11: 19
      • 12: 20
      • 13: 21
      • 14: 22
      • 15: 23
      • 16: 35
      • 17: 42
      • 18: 48
      • 19: 97
      • 20: 98
      • 21: 106
      • 22: 107
      • 23: 111
      • 24: 114
      • 25: 120
      • 26: 127
      • 27: 238
      • 28: 257
      • 29: 295
      • 30: 317
      • 31: 349
      • 32: 364
      • 33: 367
      • 34: 369
      • 35: 425
      • 36: 427
      • 37: 428
      • 38: 432
      • 39: 436
      • 40: 437
      • 41: 470
      • 42: 482
      • 43: 485
      • 44: 488
      • 45: 489
      • 46: 490
      • 47: 491
      • 48: 492
      • 49: 493
      • 50: 494
      • 51: 495
      • 52: 497
      • 53: 501
      • 54: 502
      • 55: 505
      • 56: 506
      • 57: 514
      • 58: 515
      • 59: 516
      • 60: 519
      • 61: 521
      • 62: 523
      • 63: 524
      • 64: 526
      • 65: 534
      • 66: 535
      • 67: 554
      • 68: 561
      • 69: 562
      • 70: 563
      • 71: 564
      • 72: 572
      • 73: 573
      • 74: 576
      • 75: 578
      • 76: 581
      • 77: 585
      • 78: 589
      • 79: 599
      • 80: 607
      • 81: 608
      • 82: 613
      • 83: 614
      • 84: 616
      • 85: 617
      • 86: 618
      • 87: 619
      • 88: 628
      • 89: 636
      • 90: 651
      • 91: 654
      • 92: 655
      • 93: 671
      • 94: 676
      • 95: 681
      • 96: 696
      • 97: 709
      • 98: 746
      • 99: 749
      • 100: 777
      • 101: 779
      • 102: 782
      • 103: 795
      • 104: 803
      • 105: 812
      • 106: 827
      • 107: 840
      • 108: 870
      • 109: 877
      • 110: 879
      • 111: 902
      • 112: 903
      • 113: 947
      • 114: 961
      • 115: 968
      • 116: 998
      • 117: 1001
      • 118: 1002
      • 119: 1019
      • 120: 1043
      • 121: 1051
      • 122: 1119
      • 123: 1133
      • 124: 1167
      • 125: 1173
      • 126: 3227
      • 127: 3797
      • 128: 6174
      • 129: 6397
      • 130: 7034
      Backtrace
      • app/Http/Controllers/SearchController.php:213
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `products` where (`brand_id` = 2) and `approved` = '1' and `published` = 1 and `auction_product` = 0 and (`added_by` = 'admin' or (`user_id` in (11, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 35, 42, 48, 97, 98, 106, 107, 111, 114, 120, 127, 238, 257, 295, 317, 349, 364, 367, 369, 425, 427, 428, 432, 436, 437, 470, 482, 485, 488, 489, 490, 491, 492, 493, 494, 495, 497, 501, 502, 505, 506, 514, 515, 516, 519, 521, 523, 524, 526, 534, 535, 554, 561, 562, 563, 564, 572, 573, 576, 578, 581, 585, 589, 599, 607, 608, 613, 614, 616, 617, 618, 619, 628, 636, 651, 654, 655, 671, 676, 681, 696, 709, 746, 749, 777, 779, 782, 795, 803, 812, 827, 840, 870, 877, 879, 902, 903, 947, 961, 968, 998, 1001, 1002, 1019, 1043, 1051, 1119, 1133, 1167, 1173, 3227, 3797, 6174, 6397, 7034))) order by `id` desc limit 24 offset 264
      6.99mspharmacySearchController.php#213
      Bindings
      • 0: 2
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: admin
      • 5: 11
      • 6: 14
      • 7: 15
      • 8: 16
      • 9: 17
      • 10: 18
      • 11: 19
      • 12: 20
      • 13: 21
      • 14: 22
      • 15: 23
      • 16: 35
      • 17: 42
      • 18: 48
      • 19: 97
      • 20: 98
      • 21: 106
      • 22: 107
      • 23: 111
      • 24: 114
      • 25: 120
      • 26: 127
      • 27: 238
      • 28: 257
      • 29: 295
      • 30: 317
      • 31: 349
      • 32: 364
      • 33: 367
      • 34: 369
      • 35: 425
      • 36: 427
      • 37: 428
      • 38: 432
      • 39: 436
      • 40: 437
      • 41: 470
      • 42: 482
      • 43: 485
      • 44: 488
      • 45: 489
      • 46: 490
      • 47: 491
      • 48: 492
      • 49: 493
      • 50: 494
      • 51: 495
      • 52: 497
      • 53: 501
      • 54: 502
      • 55: 505
      • 56: 506
      • 57: 514
      • 58: 515
      • 59: 516
      • 60: 519
      • 61: 521
      • 62: 523
      • 63: 524
      • 64: 526
      • 65: 534
      • 66: 535
      • 67: 554
      • 68: 561
      • 69: 562
      • 70: 563
      • 71: 564
      • 72: 572
      • 73: 573
      • 74: 576
      • 75: 578
      • 76: 581
      • 77: 585
      • 78: 589
      • 79: 599
      • 80: 607
      • 81: 608
      • 82: 613
      • 83: 614
      • 84: 616
      • 85: 617
      • 86: 618
      • 87: 619
      • 88: 628
      • 89: 636
      • 90: 651
      • 91: 654
      • 92: 655
      • 93: 671
      • 94: 676
      • 95: 681
      • 96: 696
      • 97: 709
      • 98: 746
      • 99: 749
      • 100: 777
      • 101: 779
      • 102: 782
      • 103: 795
      • 104: 803
      • 105: 812
      • 106: 827
      • 107: 840
      • 108: 870
      • 109: 877
      • 110: 879
      • 111: 902
      • 112: 903
      • 113: 947
      • 114: 961
      • 115: 968
      • 116: 998
      • 117: 1001
      • 118: 1002
      • 119: 1019
      • 120: 1043
      • 121: 1051
      • 122: 1119
      • 123: 1133
      • 124: 1167
      • 125: 1173
      • 126: 3227
      • 127: 3797
      • 128: 6174
      • 129: 6397
      • 130: 7034
      Backtrace
      • app/Http/Controllers/SearchController.php:213
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `product_translations` where `product_translations`.`product_id` in (602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625)
      1.27mspharmacySearchController.php#213
      Backtrace
      • app/Http/Controllers/SearchController.php:213
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `product_taxes` where `product_taxes`.`product_id` in (602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625)
      3.95mspharmacySearchController.php#213
      Backtrace
      • app/Http/Controllers/SearchController.php:213
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `uploads` where `uploads`.`id` in (74346, 74351, 74356, 74361, 74366, 74371, 74376, 74381, 74386, 74391, 74396, 74401, 74406, 74411, 74416, 74421, 74426, 74431, 74436, 74441, 74446, 74451, 74456, 74461) and `uploads`.`deleted_at` is null
      1.31mspharmacySearchController.php#213
      Backtrace
      • app/Http/Controllers/SearchController.php:213
      • app/Http/Controllers/SearchController.php:237
      • 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
    • select * from `brands` where `brands`.`id` = 2 limit 1
      1.06mspharmacyHelpers.php#1929
      Bindings
      • 0: 2
      Backtrace
      • app/Http/Helpers.php:1929
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `brand_translations` where `brand_translations`.`brand_id` in (2)
      680μspharmacyHelpers.php#1929
      Backtrace
      • app/Http/Helpers.php:1929
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `brands` where `brands`.`id` = 2 limit 1
      570μspharmacyHelpers.php#1929
      Bindings
      • 0: 2
      Backtrace
      • app/Http/Helpers.php:1929
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `brand_translations` where `brand_translations`.`brand_id` in (2)
      560μspharmacyHelpers.php#1929
      Backtrace
      • app/Http/Helpers.php:1929
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select count(*) as aggregate from `products` where `approved` = '1' and `published` = 1
      3.3mspharmacyHelpers.php#1706
      Bindings
      • 0: 1
      • 1: 1
      Backtrace
      • app/Http/Helpers.php:1706
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select min(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
      2.72mspharmacyHelpers.php#1718
      Bindings
      • 0: 1
      • 1: 1
      Backtrace
      • app/Http/Helpers.php:1718
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select max(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
      2.43mspharmacyHelpers.php#1730
      Bindings
      • 0: 1
      • 1: 1
      Backtrace
      • app/Http/Helpers.php:1730
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 1 and `attribute_values`.`attribute_id` is not null
      2.21mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 1
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 2 and `attribute_values`.`attribute_id` is not null
      1.63mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 2
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 5 and `attribute_values`.`attribute_id` is not null
      1.65mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 5
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 6 and `attribute_values`.`attribute_id` is not null
      1.54mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 6
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 7 and `attribute_values`.`attribute_id` is not null
      1.2mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 7
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 8 and `attribute_values`.`attribute_id` is not null
      1.29mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 8
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 9 and `attribute_values`.`attribute_id` is not null
      1.87mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 9
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 10 and `attribute_values`.`attribute_id` is not null
      1.48mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 10
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 11 and `attribute_values`.`attribute_id` is not null
      1.7mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 11
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 12 and `attribute_values`.`attribute_id` is not null
      1.52mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 12
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 13 and `attribute_values`.`attribute_id` is not null
      1.46mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 13
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 15 and `attribute_values`.`attribute_id` is not null
      1.69mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 15
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 17 and `attribute_values`.`attribute_id` is not null
      1.62mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 17
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 18 and `attribute_values`.`attribute_id` is not null
      1.48mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 18
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 19 and `attribute_values`.`attribute_id` is not null
      1.48mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 19
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 20 and `attribute_values`.`attribute_id` is not null
      1.57mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 20
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 21 and `attribute_values`.`attribute_id` is not null
      1.72mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 21
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 22 and `attribute_values`.`attribute_id` is not null
      1.4mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 22
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 23 and `attribute_values`.`attribute_id` is not null
      1.25mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 23
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 24 and `attribute_values`.`attribute_id` is not null
      1.04mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 24
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 25 and `attribute_values`.`attribute_id` is not null
      960μspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 25
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 26 and `attribute_values`.`attribute_id` is not null
      1.07mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 26
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 29 and `attribute_values`.`attribute_id` is not null
      1.05mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 29
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 30 and `attribute_values`.`attribute_id` is not null
      1.14mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 30
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 48 and `attribute_values`.`attribute_id` is not null
      2.16mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 48
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 49 and `attribute_values`.`attribute_id` is not null
      1.62mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 49
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 50 and `attribute_values`.`attribute_id` is not null
      1.62mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 50
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 51 and `attribute_values`.`attribute_id` is not null
      1.26mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 51
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 52 and `attribute_values`.`attribute_id` is not null
      910μspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 52
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 53 and `attribute_values`.`attribute_id` is not null
      1.01mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 53
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `attribute_values` where `attribute_values`.`attribute_id` = 54 and `attribute_values`.`attribute_id` is not null
      1.46mspharmacyproduct_listing.blade.php#280
      Bindings
      • 0: 54
      Backtrace
      • view::frontend.product_listing:280
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `languages` where `code` = 'en' limit 1
      910μspharmacyHelpers.php#1653
      Bindings
      • 0: en
      Backtrace
      • app/Http/Helpers.php:1653
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '22131' and `uploads`.`deleted_at` is null limit 1
      1.98mspharmacyHelpers.php#1160
      Bindings
      • 0: 22131
      Backtrace
      • app/Http/Helpers.php:1160
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '22131' and `uploads`.`deleted_at` is null limit 1
      560μspharmacyHelpers.php#1160
      Bindings
      • 0: 22131
      Backtrace
      • app/Http/Helpers.php:1160
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `languages` where `code` = 'en' limit 1
      770μspharmacyHelpers.php#1634
      Bindings
      • 0: en
      Backtrace
      • app/Http/Helpers.php:1634
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1
      760μspharmacyHelpers.php#1160
      Backtrace
      • app/Http/Helpers.php:1160
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `languages` where `status` = 1
      1.04mspharmacyHelpers.php#1644
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Helpers.php:1644
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `currencies` where `code` = 'USD' limit 1
      840μspharmacyHelpers.php#1667
      Bindings
      • 0: USD
      Backtrace
      • app/Http/Helpers.php:1667
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `currencies` where `status` = 1
      980μspharmacyHelpers.php#1677
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Helpers.php:1677
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `level` = 0 order by `order_level` desc
      1.88mspharmacyHelpers.php#1973
      Bindings
      • 0: 0
      Backtrace
      • app/Http/Helpers.php:1973
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `category_translations` where `category_translations`.`category_id` in (253, 254, 255, 256, 257, 258, 259, 260, 261, 264, 270, 300, 354, 355, 393, 419, 424, 428, 435, 438)
      890μspharmacyHelpers.php#1973
      Backtrace
      • app/Http/Helpers.php:1973
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` in (52, 625, 1944, 24879, 25038, 25039, 25040, 25042, 25046, 25047, 25049, 25050, 57601, 61322, 77754) and `uploads`.`deleted_at` is null
      1.03mspharmacyHelpers.php#1973
      Backtrace
      • app/Http/Helpers.php:1973
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` in (5, 7, 8, 9, 11, 12, 13, 14, 17, 1932, 2680, 3024, 4620, 9774, 77754) and `uploads`.`deleted_at` is null
      1.13mspharmacyHelpers.php#1973
      Backtrace
      • app/Http/Helpers.php:1973
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `custom_alerts` where `status` = 1 order by `id` desc
      1.15mspharmacyapp.blade.php#289
      Bindings
      • 0: 1
      Backtrace
      • view::frontend.layouts.app:289
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `dynamic_popups` where `status` = 1 order by `id` asc
      1.2mspharmacyapp.blade.php#330
      Bindings
      • 0: 1
      Backtrace
      • view::frontend.layouts.app:330
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `countries` where `status` = '1'
      2.86mspharmacyHelpers.php#123
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Helpers.php:123
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • vendor/laravel/framework/src/Illuminate/View/View.php:195
    App\Models\AttributeValue
    784AttributeValue.php#?
    App\Models\Country
    246Country.php#?
    App\Models\Category
    196Category.php#?
    App\Models\Color
    143Color.php#?
    App\Models\CategoryTranslation
    108CategoryTranslation.php#?
    App\Models\Currency
    104Currency.php#?
    App\Models\Upload
    63Upload.php#?
    App\Models\Attribute
    31Attribute.php#?
    App\Models\Product
    24Product.php#?
    App\Models\AttributeTranslation
    11AttributeTranslation.php#?
    App\Models\Language
    5Language.php#?
    App\Models\Brand
    3Brand.php#?
        _token
        irIi7gzoV3M2DJrPzmQZCV0qlKOB1Q0NfZDIPuew
        locale
        en
        currency_code
        USD
        currency_symbol
        $
        currency_exchange_rate
        1.00000
        country
        United States
        path_info
        /brand/demo-brand1
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "12" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "kanemtrade.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] "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" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 26 Apr 2025 22:53:47 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=irIi7gzoV3M2DJrPzmQZCV0qlKOB1Q0NfZDIPuew; expires=Sun, 27-Apr-2025 00:53:49 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=irIi7gzoV3M2DJrPzmQZCV0qlKOB1Q0NfZDIPuew; expires=Sun, 27-Apr-2025 00:53:49 GMT; path=/" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "irIi7gzoV3M2DJrPzmQZCV0qlKOB1Q0NfZDIPuew" "locale" => "en" "currency_code" => "USD" "currency_symbol" => "$" "currency_exchange_rate" => "1.00000" "country" => "United States" ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-26 22:53:49GET/brand/demo-brand1?page=12334711718