You need to Sign in to view this feature
This address will be removed from this list
1 x Application (60.87%) | 100ms |
1 x Booting (39.13%) | 64.59ms |
select * from `business_settings` where (`type` = 'maintenance_mode') limit 1
Bindings |
|
Backtrace |
|
insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.167', '2025-07-12 06:05:06', '2025-07-12 06:05:06')
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` = 0
Bindings |
|
Backtrace |
|
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (140, 146, 147, 148, 149, 157, 165, 169) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (869, 870, 871, 872, 873, 874, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (869, 870, 871, 872, 873, 874, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (140, 146, 147, 148, 149, 157, 165, 169) and `position` = 1 order by `priority` asc
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (141, 142, 143, 144, 145, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 166, 167, 168) and `position` = 2 order by `priority` asc
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (141, 142, 143, 144, 145, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 166, 167, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (140, 146, 147, 148, 149, 157, 165, 169) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'category_list_priority') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'brand_list_priority') limit 1
Bindings |
|
Backtrace |
|
select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1, 2, 9) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'featured_product_priority') limit 1
Bindings |
|
Backtrace |
|
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`featured` = 1) and (`featured` = 1) order by `id` desc, `id` desc
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (869, 873, 877, 879) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (869, 873, 877, 879) and `status` = 1 group by `product_id`
Bindings |
|
Backtrace |
|
select * from `sellers` where `sellers`.`id` in (2)
Backtrace |
|
select * from `wishlists` where `wishlists`.`product_id` in (869, 873, 877, 879) and `customer_id` = 0
Bindings |
|
Backtrace |
|
select * from `product_compares` where `product_compares`.`product_id` in (869, 873, 877, 879) and `user_id` = 0
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (869, 873, 877, 879) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'google_search_console_code') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'bing_webmaster_code') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'baidu_webmaster_code') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'yandex_webmaster_code') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'pixel_analytics') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'announcement') limit 1
Bindings |
|
Backtrace |
|
select `cart_group_id` from `carts` where (`customer_id` = 425658 and `is_guest` = 1) group by `cart_group_id`
Bindings |
|
Backtrace |
|
select * from `carts` where 0 = 1
Backtrace |
|
select `cart_group_id` from `carts` where (`customer_id` = 425658 and `is_guest` = 1) group by `cart_group_id`
Bindings |
|
Backtrace |
|
select * from `carts` where 0 = 1
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` = 0
Bindings |
|
Backtrace |
|
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (140, 146, 147, 148, 149, 157, 165, 169) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (869, 870, 871, 872, 873, 874, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (869, 870, 871, 872, 873, 874, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (140, 146, 147, 148, 149, 157, 165, 169) and `position` = 1 order by `priority` asc
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (141, 142, 143, 144, 145, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 166, 167, 168) and `position` = 2 order by `priority` asc
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (141, 142, 143, 144, 145, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 166, 167, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (140, 146, 147, 148, 149, 157, 165, 169) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'category_list_priority') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'brand_list_priority') limit 1
Bindings |
|
Backtrace |
|
select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1, 2, 9) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `discount` != 0
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'seller_registration') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'loader_gif') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'country_code') limit 1
Bindings |
|
Backtrace |
|
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-12' and date(`end_date`) >= '2025-07-12' limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'refund-policy') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'return-policy') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'company_phone') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'company_email') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'shop_address') limit 1
Bindings |
|
Backtrace |
|
select * from `business_settings` where (`type` = 'whatsapp') limit 1
Bindings |
|
Backtrace |
|
200
0 of 0array:2 [▼ "data_from" => "featured" "page" => "1" ]
[]
0 of 0array: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 => "www.purvamart.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.167" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "216.73.216.167" ] "x-real-port" => array:1 [▶ 0 => "11770" ] "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" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 12 Jul 2025 00:20:06 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBvek4rSGU4a3d0NWQvcXFoMkQ2UUE9PSIsInZhbHVlIjoidEpscTMzR2FyU01aRHlZY0NFdXVVSUd2MVU5MHlSR1c1MXZQaGIrNlc1QkpXdVROcXJNZi9BNzdBaWVLWjZIOUMxcDNmamRhRVcxRkYrMEJGZkQ0MmsyZ0kxTE9FdktNTSs1NXpFUlV4MEFJVUp5cEhvOHltblRRdGtKMlpFM3oiLCJtYWMiOiIyOTNlNWU4MWMzNmU4NDEwZmY0MDY4MjY5ZDQ3ODk4OWU4ZjlmYTM5ZjdmMmMxNzcxYmFiZjk2ODRkYmJhNDViIiwidGFnIjoiIn0%3D; expires=Sat, 12 Jul 2025 01:20:06 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBvek4rSGU4a3d0NWQvcXFoMkQ2UUE9PSIsInZhbHVlIjoidEpscTMzR2FyU01aRHlZY0NFdXVVSUd2MVU5MHlSR1c1MXZQaGIrNlc1QkpXdVROcXJNZi9BNzdBaWVLWjZIOUMxcDNma ▶" 1 => "6valley1725364683_session=eyJpdiI6InF2S0NXYnZycEpGMkVrZUxKRW02RVE9PSIsInZhbHVlIjoieVpRNEZlUkloVmNMQWVXOUN6N1BBNGRwbzhoR1JlNnNqZkNrWUpka3hMd2RxNmw4S1VvdEpSTHQ2ZUdGL29OWko1RktuSHYzRFRnUDZ3bkRoVEhpdnlGTlozaHB0YTN1bmxQc21XREtFZmh0S1JwSWFlV0FmRTBMV2x5T3dwcngiLCJtYWMiOiIwMGIwYjJjZDU5ZDg4MDdmZTcyN2ZmMzFiNjdiZGY1YzQ1NjEyYjhjOWY4NTFjMDNlYzQwOGI5MjVhNmU5MDdmIiwidGFnIjoiIn0%3D; expires=Sat, 12 Jul 2025 01:20:06 GMT; Max-Age=3600; path=/; httponly ◀6valley1725364683_session=eyJpdiI6InF2S0NXYnZycEpGMkVrZUxKRW02RVE9PSIsInZhbHVlIjoieVpRNEZlUkloVmNMQWVXOUN6N1BBNGRwbzhoR1JlNnNqZkNrWUpka3hMd2RxNmw4S1VvdEpSTHQ2ZU ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBvek4rSGU4a3d0NWQvcXFoMkQ2UUE9PSIsInZhbHVlIjoidEpscTMzR2FyU01aRHlZY0NFdXVVSUd2MVU5MHlSR1c1MXZQaGIrNlc1QkpXdVROcXJNZi9BNzdBaWVLWjZIOUMxcDNmamRhRVcxRkYrMEJGZkQ0MmsyZ0kxTE9FdktNTSs1NXpFUlV4MEFJVUp5cEhvOHltblRRdGtKMlpFM3oiLCJtYWMiOiIyOTNlNWU4MWMzNmU4NDEwZmY0MDY4MjY5ZDQ3ODk4OWU4ZjlmYTM5ZjdmMmMxNzcxYmFiZjk2ODRkYmJhNDViIiwidGFnIjoiIn0%3D; expires=Sat, 12-Jul-2025 01:20:06 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBvek4rSGU4a3d0NWQvcXFoMkQ2UUE9PSIsInZhbHVlIjoidEpscTMzR2FyU01aRHlZY0NFdXVVSUd2MVU5MHlSR1c1MXZQaGIrNlc1QkpXdVROcXJNZi9BNzdBaWVLWjZIOUMxcDNma ▶" 1 => "6valley1725364683_session=eyJpdiI6InF2S0NXYnZycEpGMkVrZUxKRW02RVE9PSIsInZhbHVlIjoieVpRNEZlUkloVmNMQWVXOUN6N1BBNGRwbzhoR1JlNnNqZkNrWUpka3hMd2RxNmw4S1VvdEpSTHQ2ZUdGL29OWko1RktuSHYzRFRnUDZ3bkRoVEhpdnlGTlozaHB0YTN1bmxQc21XREtFZmh0S1JwSWFlV0FmRTBMV2x5T3dwcngiLCJtYWMiOiIwMGIwYjJjZDU5ZDg4MDdmZTcyN2ZmMzFiNjdiZGY1YzQ1NjEyYjhjOWY4NTFjMDNlYzQwOGI5MjVhNmU5MDdmIiwidGFnIjoiIn0%3D; expires=Sat, 12-Jul-2025 01:20:06 GMT; path=/; httponly ◀6valley1725364683_session=eyJpdiI6InF2S0NXYnZycEpGMkVrZUxKRW02RVE9PSIsInZhbHVlIjoieVpRNEZlUkloVmNMQWVXOUN6N1BBNGRwbzhoR1JlNnNqZkNrWUpka3hMd2RxNmw4S1VvdEpSTHQ2ZU ▶" ] ]
0 of 0array:22 [▼ "storage_connection_type" => "public" "company_web_logo" => array:3 [▶ "key" => "2024-09-11-66e15d7da50e7.webp" "path" => "https://www.purvamart.com/storage/app/public/company/2024-09-11-66e15d7da50e7.webp" "status" => 200 ] "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 1 "business_mode" => "multi" "currency_model" => "single_currency" "language" => array:1 [▶ 0 => array:6 [▶ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 8 "system_default_currency_info" => App\Models\Currency {#3602 ▶ #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" => 8 "name" => "Nepalese Rupees" "symbol" => "NPR" "code" => "NPR" "exchange_rate" => "1" "status" => 0 "created_at" => "2024-09-04 12:26:17" "updated_at" => "2024-09-11 14:17:52" ] #original: array:8 [▶ "id" => 8 "name" => "Nepalese Rupees" "symbol" => "NPR" "code" => "NPR" "exchange_rate" => "1" "status" => 0 "created_at" => "2024-09-04 12:26:17" "updated_at" => "2024-09-11 14:17:52" ] #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" => "NPR" "currency_symbol" => "NPR" "currency_exchange_rate" => "1" "_token" => "sMoCwi2IyQ1SD6Qfr5roEY6uyKlvbmhT9tj2W105" "guest_id" => 425658 "currency_symbol_position" => "left" "company_email" => "Support@purvamart.com" "_previous" => array:1 [▶ "url" => "https://www.purvamart.com/products?data_from=featured&page=1" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]