Your cart is empty.
Find your favourite brands and products
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
Share your location to find the nearest store
1 x Application (60.65%) | 1.14s |
1 x Booting (39.35%) | 738ms |
insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.143.144.209', '2025-04-25 00:51:38', '2025-04-25 00:51:38')
Bindings | |
Backtrace |
select * from `robots_meta_contents` where (`page_name` = 'brands') limit 1
Bindings | |
Backtrace |
select * from `robots_meta_contents` where (`page_name` = 'default') limit 1
Bindings | |
Backtrace |
select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` 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 `brand_products_count` from `brands` where `status` = 1
Bindings | |
Backtrace |
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` 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 `products`.`brand_id` in (3, 5, 6, 7, 9, 18, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 70, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 82)
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (17945, 17947, 17964, 17965, 17966, 17967, 17968, 17969, 17970, 17971, 17972, 17973, 17974, 17975, 17977, 17978, 17979, 17984, 17986, 17987, 17988, 17991, 17993, 17994, 17995, 17996, 17997, 17998, 17999, 18000, 18001, 18002, 18003, 18004, 18005, 18006, 18007, 18008, 18009, 18010, 18011, 18012, 18013, 18014, 18015, 18016, 18017, 18018, 18019, 18020, 18021, 18025, 18026, 18027, 18028, 18029, 18030, 18031, 18033, 18034, 18035, 18036, 18037, 18038, 18039, 18040, 18041, 18042, 18043, 18044, 18045, 18049, 18052, 18053, 18054, 18055, 18056, 18057, 18058, 18059, 18060, 18061, 18062, 18063, 18064, 18065, 18066, 18067, 18070, 18071, 18072, 18073, 18074, 18075, 18077, 18081, 18097, 18098, 18099, 18100, 18101, 18102, 18103, 18104, 18105, 18106, 18107, 18108, 18109, 18110) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `reviews` where `reviews`.`product_id` in (17945, 17947, 17964, 17965, 17966, 17967, 17968, 17969, 17970, 17971, 17972, 17973, 17974, 17975, 17977, 17978, 17979, 17984, 17986, 17987, 17988, 17991, 17993, 17994, 17995, 17996, 17997, 17998, 17999, 18000, 18001, 18002, 18003, 18004, 18005, 18006, 18007, 18008, 18009, 18010, 18011, 18012, 18013, 18014, 18015, 18016, 18017, 18018, 18019, 18020, 18021, 18025, 18026, 18027, 18028, 18029, 18030, 18031, 18033, 18034, 18035, 18036, 18037, 18038, 18039, 18040, 18041, 18042, 18043, 18044, 18045, 18049, 18052, 18053, 18054, 18055, 18056, 18057, 18058, 18059, 18060, 18061, 18062, 18063, 18064, 18065, 18066, 18067, 18070, 18071, 18072, 18073, 18074, 18075, 18077, 18081, 18097, 18098, 18099, 18100, 18101, 18102, 18103, 18104, 18105, 18106, 18107, 18108, 18109, 18110) and `delivery_man_id` is null and `status` = 1
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (3, 5, 6, 7, 9, 18, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 70, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 82) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'
Bindings | |
Backtrace |
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')) 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` = 728913
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')) 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` = 728913 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')) 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')) 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` = 728913 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')) 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')) 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` = 728913
Bindings | |
Backtrace |
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-25' and date(`end_date`) >= '2025-04-25' limit 1
Bindings | |
Backtrace |
200
[]
[]
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 => "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 => "3.143.144.209" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "3.143.144.209" ] "x-real-port" => array:1 [▶ 0 => "9963" ] "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 => ""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" ] "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 => "Thu, 24 Apr 2025 19:21:39 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkVpUWZTOVNtYnFvQ2IvZGdZT00wbHc9PSIsInZhbHVlIjoibmJndzFrcmV6UFByNWo2VGJPSFVNSkRJbjNYaXBySlVoZ3hTVHJTY2xTb0xYRUVwajNJYlBOWUpRbElYa1JBV0xKeTNCL2N6bUlHK2JNTThhWkdpTkJJUUZzMGkvVzBPMGYwS1h2VjRDdW1CTnR5TWNUNUlMZzNIWUpVOEVDSVAiLCJtYWMiOiIzZDFjNGQyZDYzZGI2YzBmN2I1M2Y5YjNhYzk0YjE2YzYzNDI3MTNkODMwYmUyNDhmZTM2NWY1YzZlMjczMDAyIiwidGFnIjoiIn0%3D; expires=Fri, 24 Apr 2026 19:21:39 GMT; Max-Age=31536000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkVpUWZTOVNtYnFvQ2IvZGdZT00wbHc9PSIsInZhbHVlIjoibmJndzFrcmV6UFByNWo2VGJPSFVNSkRJbjNYaXBySlVoZ3hTVHJTY2xTb0xYRUVwajNJYlBOWUpRbElYa1JBV0xKeTNCL ▶" 1 => "pureorganiczone_session=eyJpdiI6InBsL2ZHcFpqN1k4UGxSVnRzc0IxcUE9PSIsInZhbHVlIjoieE13dlNsT25kSEoveGRBVHlMQlR6T2dTcFZGd2pHdXd4M1Uyc3c4MVVGRk55MmdzcHpuaFVidWw1Y21jc2RveW1nTm1KV1Y2MXE1aGpTZU1BN3dReENiQ3lxSlhHSE4wUHZPSXh2YVBGSVNuS0JpY0hmbFBCNldzSGNqTW1aT2UiLCJtYWMiOiJlMjNiNmZhNDM4MDMwYjlkMTViOGJiNzQ5OGYyNjZkNzI2ODE5YzhjNDdiNjYxMTlkN2ViZDU2MjA1NDkyNWVjIiwidGFnIjoiIn0%3D; expires=Fri, 24 Apr 2026 19:21:39 GMT; Max-Age=31536000; path=/; httponly ◀pureorganiczone_session=eyJpdiI6InBsL2ZHcFpqN1k4UGxSVnRzc0IxcUE9PSIsInZhbHVlIjoieE13dlNsT25kSEoveGRBVHlMQlR6T2dTcFZGd2pHdXd4M1Uyc3c4MVVGRk55MmdzcHpuaFVidWw1Y21j ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkVpUWZTOVNtYnFvQ2IvZGdZT00wbHc9PSIsInZhbHVlIjoibmJndzFrcmV6UFByNWo2VGJPSFVNSkRJbjNYaXBySlVoZ3hTVHJTY2xTb0xYRUVwajNJYlBOWUpRbElYa1JBV0xKeTNCL2N6bUlHK2JNTThhWkdpTkJJUUZzMGkvVzBPMGYwS1h2VjRDdW1CTnR5TWNUNUlMZzNIWUpVOEVDSVAiLCJtYWMiOiIzZDFjNGQyZDYzZGI2YzBmN2I1M2Y5YjNhYzk0YjE2YzYzNDI3MTNkODMwYmUyNDhmZTM2NWY1YzZlMjczMDAyIiwidGFnIjoiIn0%3D; expires=Fri, 24-Apr-2026 19:21:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkVpUWZTOVNtYnFvQ2IvZGdZT00wbHc9PSIsInZhbHVlIjoibmJndzFrcmV6UFByNWo2VGJPSFVNSkRJbjNYaXBySlVoZ3hTVHJTY2xTb0xYRUVwajNJYlBOWUpRbElYa1JBV0xKeTNCL ▶" 1 => "pureorganiczone_session=eyJpdiI6InBsL2ZHcFpqN1k4UGxSVnRzc0IxcUE9PSIsInZhbHVlIjoieE13dlNsT25kSEoveGRBVHlMQlR6T2dTcFZGd2pHdXd4M1Uyc3c4MVVGRk55MmdzcHpuaFVidWw1Y21jc2RveW1nTm1KV1Y2MXE1aGpTZU1BN3dReENiQ3lxSlhHSE4wUHZPSXh2YVBGSVNuS0JpY0hmbFBCNldzSGNqTW1aT2UiLCJtYWMiOiJlMjNiNmZhNDM4MDMwYjlkMTViOGJiNzQ5OGYyNjZkNzI2ODE5YzhjNDdiNjYxMTlkN2ViZDU2MjA1NDkyNWVjIiwidGFnIjoiIn0%3D; expires=Fri, 24-Apr-2026 19:21:39 GMT; path=/; httponly ◀pureorganiczone_session=eyJpdiI6InBsL2ZHcFpqN1k4UGxSVnRzc0IxcUE9PSIsInZhbHVlIjoieE13dlNsT25kSEoveGRBVHlMQlR6T2dTcFZGd2pHdXd4M1Uyc3c4MVVGRk55MmdzcHpuaFVidWw1Y21j ▶" ] ]
0 of 0array:12 [▼ "system_default_currency_info" => App\Models\Currency {#3428 ▶ #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" => "xa5tANFnxOq4ybPYNFAYTIKGLCwcG6fCUfqkGsum" "guest_id" => 728913 "product_brand" => "1" "local" => "en" "direction" => "ltr" "_previous" => array:1 [▶ "url" => "https://orzanist.com/brands" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]