Your cart is empty.
Product Name
We’ll notify you once it’s available at your nearest store.
You need to Sign in to view this feature
This address will be removed from this list
1 x Application (51.2%) | 751ms |
1 x Booting (48.8%) | 716ms |
select * from `delivery_zip_codes` where `zipcode` != ''
Bindings | |
Backtrace |
select * from `blog_category`
Backtrace |
select * from `news_category`
Backtrace |
select * from `video_category`
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` = 1476587
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` = 1476587 and `is_guest` = 1) group by `cart_group_id`
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
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` = 1476587 and `is_guest` = 1) group by `cart_group_id`
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)
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` = 1476587
Bindings | |
Backtrace |
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-22' and date(`end_date`) >= '2025-07-22' limit 1
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` = 1476587
Bindings | |
Backtrace |
200
[]
[]
0 of 0array:23 [▼ "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [▶ 0 => "br" ] "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InVGYTJVdlVTVFJwMGtSSGNMSDdDMEE9PSIsInZhbHVlIjoidWRPVXkybExaZzFSNi9PMEdUUVppVy9PVjBXTGNwcTNxQWQrZ0Z3OFhWVjdMNkhuSHRWVW5WYlRoSEpIcFVhSTd4VzhhRjBqV29Sa2FEaGVkTGRqNXV1Rkc0R2lsQkJjVC9jTUVjc053Snp4djdOeGJEMEVTZUdUY3hwM3J3OFIiLCJtYWMiOiIyN2JlYmIyNzgwNmU0OTViYWVkZmVjMmJjZTA3MGZiZjNmMTIyNWJiMmM4NmFmY2I2OWRjZjJjYWI3YjE0Y2YzIiwidGFnIjoiIn0%3D; pureorganiczone_session=eyJpdiI6ImpveEZUaE1OWXk4Q3k3SEoyT25GaWc9PSIsInZhbHVlIjoid0VxZC92NmZhaEloRHNvOFdrb1IwKzRHTWNhQTVjdjVXS2YzU01iZFl6UWRlMzhjbE1NT0x0TSsrM1VJM0ZQZUlKOGovcVZSOXkvd1JKaVFEeFFGTVpBNUo0Vjl3QmYzM3Zwb0luV2lvam14MGV0SUdBRlIzY1VBeWpNdmt4bUIiLCJtYWMiOiI4MzgwZTE5M2M5YWQ3MmM1Njk2NGZiYTg4Njk1MTA1MDYwMzQxMjk5YTUyZjdhNTZkODcwOWFmMDJkYWE0NjU5IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InVGYTJVdlVTVFJwMGtSSGNMSDdDMEE9PSIsInZhbHVlIjoidWRPVXkybExaZzFSNi9PMEdUUVppVy9PVjBXTGNwcTNxQWQrZ0Z3OFhWVjdMNkhuSHRWVW5WYlRoSEpIcFVhSTd4VzhhR ▶" ] "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.247" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "216.73.216.247" ] "x-real-port" => array:1 [▶ 0 => "11681" ] "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:2 [▼ "XSRF-TOKEN" => "aCZlLAhwviVLEPrt5NLzp4qbCXmWaBDXCSZ1Gx4I" "pureorganiczone_session" => "I0yBvlzg8QnY7NoqHDGluowcGYmx1uwVtN7YjTdp" ]
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 => "Tue, 22 Jul 2025 03:56:13 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im05RUpJaElUYmoyWVkyL0lNVnd1V2c9PSIsInZhbHVlIjoiMDNBUzVQV3lzMTY4THdEYVRVR2lEaFo1aUZzNytRa0h4bkxtaVQ3aHp3Q0NCRWVXOVZlSWtBQnR3MnkrWiswOXN1dXUwaXRzK3ZHSk1qL01TM09CQWJwalA2RTliV0NOYWhtM1AvajRqbHpSeGZTYUUzd3JBbDJQMlhnU1B2MEwiLCJtYWMiOiI2ODcxODZkYmZmMTlmOGIxNTBjNDU0MDVkZDZmMTZjN2MwZTkzMjViYzI0MzhiNjNkYjJiMWZlZWIwODI2ZjMyIiwidGFnIjoiIn0%3D; expires=Wed, 22 Jul 2026 03:56:14 GMT; Max-Age=31536000; path=/ ◀XSRF-TOKEN=eyJpdiI6Im05RUpJaElUYmoyWVkyL0lNVnd1V2c9PSIsInZhbHVlIjoiMDNBUzVQV3lzMTY4THdEYVRVR2lEaFo1aUZzNytRa0h4bkxtaVQ3aHp3Q0NCRWVXOVZlSWtBQnR3MnkrWiswOXN1dXUwa ▶" 1 => "pureorganiczone_session=eyJpdiI6ImtmRlRYUjUrMm1HM2tGTUdPZm5mYlE9PSIsInZhbHVlIjoiZ2ZzdjVhcjYwSlg0N1l1TWxYWHZHM0pRNnFBT1NJNEpkYjMwa1FJb2xMVDlCNFNnUG1ScCt5Wmk4cFBFRGJzRUpWOGlzYytEZlRTekdzZUg5SXFXNU9pMS9jTnhIRytJVGxxQ0szb0VmOThoeTJCZ2dXN2htTHRMUnp2UnN1VEoiLCJtYWMiOiJlYTQyODZhY2VmYmY2MjU1NWQ0YzU5OTRiYjg1MjZmYTllNTNiYzc4MTQ4YTZjZGJlYWNjNGNhNjVkMzY2YWJkIiwidGFnIjoiIn0%3D; expires=Wed, 22 Jul 2026 03:56:14 GMT; Max-Age=31536000; path=/; httponly ◀pureorganiczone_session=eyJpdiI6ImtmRlRYUjUrMm1HM2tGTUdPZm5mYlE9PSIsInZhbHVlIjoiZ2ZzdjVhcjYwSlg0N1l1TWxYWHZHM0pRNnFBT1NJNEpkYjMwa1FJb2xMVDlCNFNnUG1ScCt5Wmk4cFBF ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im05RUpJaElUYmoyWVkyL0lNVnd1V2c9PSIsInZhbHVlIjoiMDNBUzVQV3lzMTY4THdEYVRVR2lEaFo1aUZzNytRa0h4bkxtaVQ3aHp3Q0NCRWVXOVZlSWtBQnR3MnkrWiswOXN1dXUwaXRzK3ZHSk1qL01TM09CQWJwalA2RTliV0NOYWhtM1AvajRqbHpSeGZTYUUzd3JBbDJQMlhnU1B2MEwiLCJtYWMiOiI2ODcxODZkYmZmMTlmOGIxNTBjNDU0MDVkZDZmMTZjN2MwZTkzMjViYzI0MzhiNjNkYjJiMWZlZWIwODI2ZjMyIiwidGFnIjoiIn0%3D; expires=Wed, 22-Jul-2026 03:56:14 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im05RUpJaElUYmoyWVkyL0lNVnd1V2c9PSIsInZhbHVlIjoiMDNBUzVQV3lzMTY4THdEYVRVR2lEaFo1aUZzNytRa0h4bkxtaVQ3aHp3Q0NCRWVXOVZlSWtBQnR3MnkrWiswOXN1dXUwa ▶" 1 => "pureorganiczone_session=eyJpdiI6ImtmRlRYUjUrMm1HM2tGTUdPZm5mYlE9PSIsInZhbHVlIjoiZ2ZzdjVhcjYwSlg0N1l1TWxYWHZHM0pRNnFBT1NJNEpkYjMwa1FJb2xMVDlCNFNnUG1ScCt5Wmk4cFBFRGJzRUpWOGlzYytEZlRTekdzZUg5SXFXNU9pMS9jTnhIRytJVGxxQ0szb0VmOThoeTJCZ2dXN2htTHRMUnp2UnN1VEoiLCJtYWMiOiJlYTQyODZhY2VmYmY2MjU1NWQ0YzU5OTRiYjg1MjZmYTllNTNiYzc4MTQ4YTZjZGJlYWNjNGNhNjVkMzY2YWJkIiwidGFnIjoiIn0%3D; expires=Wed, 22-Jul-2026 03:56:14 GMT; path=/; httponly ◀pureorganiczone_session=eyJpdiI6ImtmRlRYUjUrMm1HM2tGTUdPZm5mYlE9PSIsInZhbHVlIjoiZ2ZzdjVhcjYwSlg0N1l1TWxYWHZHM0pRNnFBT1NJNEpkYjMwa1FJb2xMVDlCNFNnUG1ScCt5Wmk4cFBF ▶" ] ]
0 of 0array:12 [▼ "system_default_currency_info" => App\Models\Currency {#23601 ▶ #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" => "aCZlLAhwviVLEPrt5NLzp4qbCXmWaBDXCSZ1Gx4I" "guest_id" => 1476587 "_previous" => array:1 [▶ "url" => "https://orzanist.com/customer/auth/login" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "keep_return_url" => "https://orzanist.com/products?brand_id=45&data_from=brand&page=1" "local" => "en" "direction" => "ltr" ]