Category Products

Messages Timeline Exceptions Views57 Route Queries50 Models172 Mails Gate Session Request

Request history8.1.322.31s1GBGET products

Booting (765ms)time
Application (1.55s)time
1 x Application (66.88%)
1.55s
1 x Booting (33.12%)
765ms

57 templates were rendered

1x web-views.products.viewview.blade.php#?blade
1x web-views.products._ajax-products_ajax-products.blade.php#?blade
20x web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
20x web-views.partials._first_variation_price_first_variation_price.blade.php#?blade
1x pagination::bootstrap-4bootstrap-4.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._customer_auth_check_customer_auth_check.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._footer-go-to-checkout-one_footer-go-to-checkout-one.blade.php#?blade
1x layouts.front-end.partials._footer-go-to-checkout-two_footer-go-to-checkout-two.blade.php#?blade
1x layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
1x layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade

uri: GET products
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\ProductListController@products
namespace: App\Http\Controllers\Web
prefix
where
as: products
file: app/Http/Controllers/Web/ProductListController.php:43-106

50 statements were executed (17 duplicates)Show only duplicates45.64ms

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.13', '2025-07-20 07:10:48', '2025-07-20 07:10:48')
270μsu185689791_orgnaist19juneGuestMiddleware.php#26
Bindings
Backtrace
select * from `categories` where `categories`.`id` = 13 limit 1
310μsu185689791_orgnaist19juneProductListController.php#117
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (13) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
290μsu185689791_orgnaist19juneProductListController.php#117
Bindings
Backtrace
select `publishing_houses`.*, (select count(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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 `publishing_house_products_count` from `publishing_houses` where exists (select * from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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')))
1.09msu185689791_orgnaist19juneproduct-manager.php#1867
Bindings
Backtrace
select `id` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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 (`product_type` = 'digital') and 1 = 1
350μsu185689791_orgnaist19juneproduct-manager.php#1876
Bindings
Backtrace
select `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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 `digital_product_author_count` from `authors`
490μsu185689791_orgnaist19juneproduct-manager.php#1882
Bindings
Backtrace
select `id` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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 (`product_type` = 'digital') and 1 = 1
310μsu185689791_orgnaist19juneproduct-manager.php#1890
Bindings
Backtrace
select * from `categories` where `id` in ('13')
170μsu185689791_orgnaist19juneproduct-manager.php#1933
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (13) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
210μsu185689791_orgnaist19juneproduct-manager.php#1933
Bindings
Backtrace
select * from `categories` where `id` in (null)
120μsu185689791_orgnaist19juneproduct-manager.php#1934
Bindings
Backtrace
select * from `categories` where `id` in (null)
170μsu185689791_orgnaist19juneproduct-manager.php#1935
Bindings
Backtrace
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select sum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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_id` in (13) or (`category_id` in (13) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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')) or (0 = 1 and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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')) or (0 = 1 and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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
13.85msu185689791_orgnaist19juneproduct-manager.php#1262
Bindings
Backtrace
select * from `categories` where `categories`.`id` in (13)
210μsu185689791_orgnaist19juneproduct-manager.php#1262
Backtrace
select * from `translations` where `translations`.`translationable_id` in (13) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
220μsu185689791_orgnaist19juneproduct-manager.php#1262
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (405, 406, 407, 408, 409, 828, 829, 830, 831, 832, 843, 905, 931, 1047, 1258, 1259, 1260, 1261, 1262, 1287, 1337, 15004, 15009, 16004, 16005, 16006, 16007, 16011, 16013, 16014, 16015, 16016, 16018, 16019, 16021, 16022, 16023, 16024, 16025, 16026, 16027, 16045, 16052, 16059, 16060, 16061, 16062, 16063, 16064, 16065, 16066, 16067, 16074, 16083, 16084, 16086, 16088, 16096, 16101, 16170, 16251, 16252, 16253, 16279, 16365, 16480, 16481, 16482, 16483, 16484, 16512, 16513, 16514, 16515, 16609, 16655, 16656, 17133, 17286, 17287, 17288, 17368, 17369, 17370, 17371, 17372, 17653, 17654, 17655, 17656, 17657, 17658, 17684, 17707, 18370, 18372, 18540, 18752, 18753, 18754, 18909, 18910, 18999, 19087, 19153, 19227, 19228, 19229) and `delivery_man_id` is null and `status` = 1
260μsu185689791_orgnaist19juneproduct-manager.php#1262
Bindings
Backtrace
select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (405, 406, 407, 408, 409, 828, 829, 830, 831, 832, 843, 905, 931, 1047, 1258, 1259, 1260, 1261, 1262, 1287, 1337, 15004, 15009, 16004, 16005, 16006, 16007, 16011, 16013, 16014, 16015, 16016, 16018, 16019, 16021, 16022, 16023, 16024, 16025, 16026, 16027, 16045, 16052, 16059, 16060, 16061, 16062, 16063, 16064, 16065, 16066, 16067, 16074, 16083, 16084, 16086, 16088, 16096, 16101, 16170, 16251, 16252, 16253, 16279, 16365, 16480, 16481, 16482, 16483, 16484, 16512, 16513, 16514, 16515, 16609, 16655, 16656, 17133, 17286, 17287, 17288, 17368, 17369, 17370, 17371, 17372, 17653, 17654, 17655, 17656, 17657, 17658, 17684, 17707, 18370, 18372, 18540, 18752, 18753, 18754, 18909, 18910, 18999, 19087, 19153, 19227, 19228, 19229) and `status` = 1 group by `product_id`
280μsu185689791_orgnaist19juneproduct-manager.php#1262
Bindings
Backtrace
select * from `sellers` where `sellers`.`id` in (6, 16, 27, 30, 32, 37, 38, 42, 44, 46, 54, 62, 64, 65, 70, 73, 81, 89, 91, 102, 103, 115, 116, 122, 123)
500μsu185689791_orgnaist19juneproduct-manager.php#1262
Backtrace
select * from `shops` where `shops`.`seller_id` in (6, 16, 27, 30, 32, 37, 38, 42, 44, 46, 54, 62, 64, 65, 70, 73, 81, 89, 91, 102, 103, 115, 116, 122, 123)
1.7msu185689791_orgnaist19juneproduct-manager.php#1262
Backtrace
select * from `translations` where `translations`.`translationable_id` in (405, 406, 407, 408, 409, 828, 829, 830, 831, 832, 843, 905, 931, 1047, 1258, 1259, 1260, 1261, 1262, 1287, 1337, 15004, 15009, 16004, 16005, 16006, 16007, 16011, 16013, 16014, 16015, 16016, 16018, 16019, 16021, 16022, 16023, 16024, 16025, 16026, 16027, 16045, 16052, 16059, 16060, 16061, 16062, 16063, 16064, 16065, 16066, 16067, 16074, 16083, 16084, 16086, 16088, 16096, 16101, 16170, 16251, 16252, 16253, 16279, 16365, 16480, 16481, 16482, 16483, 16484, 16512, 16513, 16514, 16515, 16609, 16655, 16656, 17133, 17286, 17287, 17288, 17368, 17369, 17370, 17371, 17372, 17653, 17654, 17655, 17656, 17657, 17658, 17684, 17707, 18370, 18372, 18540, 18752, 18753, 18754, 18909, 18910, 18999, 19087, 19153, 19227, 19228, 19229) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
600μsu185689791_orgnaist19juneproduct-manager.php#1262
Bindings
Backtrace
select * from `categories` where `id` = '13' limit 1
170μsu185689791_orgnaist19juneview.blade.php#31
Bindings
Backtrace
select * from `categories` where `id` is null limit 1
120μsu185689791_orgnaist19juneview.blade.php#32
Backtrace
select * from `categories` where `id` is null limit 1
100μsu185689791_orgnaist19juneview.blade.php#33
Backtrace
select * from `categories` where `parent_id` = '13'
380μsu185689791_orgnaist19juneview.blade.php#434
Bindings
Backtrace
select * from `categories` where `parent_id` is null
130μsu185689791_orgnaist19juneview.blade.php#435
Backtrace
select * from `categories`
640μsu185689791_orgnaist19juneview.blade.php#444
Backtrace
select * from `categories` where `id` = '13' limit 1
210μsu185689791_orgnaist19juneview.blade.php#558
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and `customer_id` = 1469603
690μsu185689791_orgnaist19juneproduct.php#24
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 6 and `storages`.`data_id` is not null
1.98msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 30 and `storages`.`data_id` is not null
1.48msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 54 and `storages`.`data_id` is not null
1.24msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 64 and `storages`.`data_id` is not null
1.29msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 38 and `storages`.`data_id` is not null
1.69msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 73 and `storages`.`data_id` is not null
1.41msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 91 and `storages`.`data_id` is not null
2.15msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 123 and `storages`.`data_id` is not null
1.47msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 65 and `storages`.`data_id` is not null
1.54msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 115 and `storages`.`data_id` is not null
1.68msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 27 and `storages`.`data_id` is not null
1.54msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select * from `delivery_zip_codes` where `zipcode` != ''
500μsu185689791_orgnaist19juneapp.blade.php#215
Bindings
Backtrace
select * from `blog_category`
190μsu185689791_orgnaist19june_header.blade.php#16
Backtrace
select * from `news_category`
150μsu185689791_orgnaist19june_header.blade.php#17
Backtrace
select * from `video_category`
180μsu185689791_orgnaist19june_header.blade.php#18
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and `customer_id` = 1469603
590μsu185689791_orgnaist19juneproduct.php#24
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and (`customer_id` = 1469603 and `is_guest` = 1) group by `cart_group_id`
500μsu185689791_orgnaist19junecart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and 0 = 1
360μsu185689791_orgnaist19junecart-manager.php#65
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and (`customer_id` = 1469603 and `is_guest` = 1) group by `cart_group_id`
400μsu185689791_orgnaist19junecart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and 0 = 1 and (`is_checked` = 1)
310μsu185689791_orgnaist19junecart-manager.php#65
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and `customer_id` = 1469603
560μsu185689791_orgnaist19juneproduct.php#24
Bindings
Backtrace
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-20' and date(`end_date`) >= '2025-07-20' limit 1
190μsu185689791_orgnaist19june_footer.blade.php#122
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') 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) and `customer_id` = 1469603
400μsu185689791_orgnaist19juneproduct.php#24
Bindings
Backtrace

App\Models\Product: 108Product.php#?
App\Models\Seller: 25Seller.php#?
App\Models\Shop: 25Shop.php#?
App\Models\Storage: 11Storage.php#?
App\Models\Category: 3Category.php#?

system_default_currency_info: App\Models\Currency {#21756 #connection: "mysql" #table: "currencies" #primaryKey: "id" #key...
currency_code: INR
currency_symbol: ₹
currency_exchange_rate: 60
usd: 1
_token: Cw61TCfercuxoMyzOYSpOMucqugX7a53rDIlwWxv
guest_id: 1469603
local: en
direction: ltr
_previous: array:1 [ "url" => "https://orzanist.com/products?category_id=13&data_from=category&page=1" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:3 [▼
  "category_id" => "13"
  "data_from" => "category"
  "page" => "1"
]

request_request

[]

request_headers

  0 of 0   
array:22 [▼
  "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"
  ]
  "host" => array:1 [▶
    0 => "orzanist.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 => "216.73.216.13"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-real-ip" => array:1 [▶
    0 => "216.73.216.13"
  ]
  "x-real-port" => array:1 [▶
    0 => "5266"
  ]
  "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

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 20 Jul 2025 01:40:49 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikx2dUREN0VTY0pCWHVQZXcrTExhRHc9PSIsInZhbHVlIjoiT1dodldNb2RiM3lrVXFGOEwrRnRUekl5QXU1cTc3UUdKbllKd0pyd0ZZajRNbDNNRkJQbWRoZGZBTVpvWHJvU1NvMHhnbDJoQjJzM2t4YnNYNEpMblJKSVd6NFNCemJvcGFxd1hHcmkyRk8zRFdsQm1najJ6ckNtSUtRbUwvMFAiLCJtYWMiOiIzMGVkZjNiZWVkMmRhMjRkMjAwMDAwYjBjMDllYmM4YjQxYTBiNjNkMTgyNTk4ZTQwOTA3MjM4YTFmNDYwMzBhIiwidGFnIjoiIn0%3D; expires=Mon, 20 Jul 2026 01:40:50 GMT; Max-Age=31536000; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikx2dUREN0VTY0pCWHVQZXcrTExhRHc9PSIsInZhbHVlIjoiT1dodldNb2RiM3lrVXFGOEwrRnRUekl5QXU1cTc3UUdKbllKd0pyd0ZZajRNbDNNRkJQbWRoZGZBTVpvWHJvU1NvMHhnb ▶"
    1 => "pureorganiczone_session=eyJpdiI6IjBnUXRmaXVxUG10U0c2aXBZR2JaSHc9PSIsInZhbHVlIjoiQmk3T2NhUmx5MXVWSTBUN3FHMUhDYmVaRWJQd21abFViRkQ3Mk9WaHF4Wnpka21HVDRPZmw4eENweDZXbzFRbGk0dHBHWlA0UEpmTGpsNEw0OFpLTzdxTU9yNFRoK0V3QnN0R3ZLZk1kditHUkxaUm9qZDFlODBuK0c2VVRGOXgiLCJtYWMiOiIyMGM5Y2JmZGRjYmY3NGJhNzVjNmZlNTJlNjY4OGFjNDQxOWFjYWI3ZDk4YTlhMWViNzgxMWRjYTU2MjcyOWFiIiwidGFnIjoiIn0%3D; expires=Mon, 20 Jul 2026 01:40:50 GMT; Max-Age=31536000; path=/; httponly ◀pureorganiczone_session=eyJpdiI6IjBnUXRmaXVxUG10U0c2aXBZR2JaSHc9PSIsInZhbHVlIjoiQmk3T2NhUmx5MXVWSTBUN3FHMUhDYmVaRWJQd21abFViRkQ3Mk9WaHF4Wnpka21HVDRPZmw4eENweDZX ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikx2dUREN0VTY0pCWHVQZXcrTExhRHc9PSIsInZhbHVlIjoiT1dodldNb2RiM3lrVXFGOEwrRnRUekl5QXU1cTc3UUdKbllKd0pyd0ZZajRNbDNNRkJQbWRoZGZBTVpvWHJvU1NvMHhnbDJoQjJzM2t4YnNYNEpMblJKSVd6NFNCemJvcGFxd1hHcmkyRk8zRFdsQm1najJ6ckNtSUtRbUwvMFAiLCJtYWMiOiIzMGVkZjNiZWVkMmRhMjRkMjAwMDAwYjBjMDllYmM4YjQxYTBiNjNkMTgyNTk4ZTQwOTA3MjM4YTFmNDYwMzBhIiwidGFnIjoiIn0%3D; expires=Mon, 20-Jul-2026 01:40:50 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikx2dUREN0VTY0pCWHVQZXcrTExhRHc9PSIsInZhbHVlIjoiT1dodldNb2RiM3lrVXFGOEwrRnRUekl5QXU1cTc3UUdKbllKd0pyd0ZZajRNbDNNRkJQbWRoZGZBTVpvWHJvU1NvMHhnb ▶"
    1 => "pureorganiczone_session=eyJpdiI6IjBnUXRmaXVxUG10U0c2aXBZR2JaSHc9PSIsInZhbHVlIjoiQmk3T2NhUmx5MXVWSTBUN3FHMUhDYmVaRWJQd21abFViRkQ3Mk9WaHF4Wnpka21HVDRPZmw4eENweDZXbzFRbGk0dHBHWlA0UEpmTGpsNEw0OFpLTzdxTU9yNFRoK0V3QnN0R3ZLZk1kditHUkxaUm9qZDFlODBuK0c2VVRGOXgiLCJtYWMiOiIyMGM5Y2JmZGRjYmY3NGJhNzVjNmZlNTJlNjY4OGFjNDQxOWFjYWI3ZDk4YTlhMWViNzgxMWRjYTU2MjcyOWFiIiwidGFnIjoiIn0%3D; expires=Mon, 20-Jul-2026 01:40:50 GMT; path=/; httponly ◀pureorganiczone_session=eyJpdiI6IjBnUXRmaXVxUG10U0c2aXBZR2JaSHc9PSIsInZhbHVlIjoiQmk3T2NhUmx5MXVWSTBUN3FHMUhDYmVaRWJQd21abFViRkQ3Mk9WaHF4Wnpka21HVDRPZmw4eENweDZX ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#21756 ▶
    #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"
  "usd" => 1
  "_token" => "Cw61TCfercuxoMyzOYSpOMucqugX7a53rDIlwWxv"
  "guest_id" => 1469603
  "local" => "en"
  "direction" => "ltr"
  "_previous" => array:1 [▶
    "url" => "https://orzanist.com/products?category_id=13&data_from=category&page=1"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-07-20 07:10:50	GET	/products?category_id=13&data_from=category&page=1	57 50 172

1 x Application (66.88%)	1.55s
1 x Booting (33.12%)	765ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Pure Organic Zone - Your Marketplace for 100% Natural & Organic Products. ||

Shopping cart

Category Products (Tea, Coffee & Nutrition Drinks)

Out of stock

Product added to wishlist

Please Sign in

Delete this address?