Brand | Bajaj |
ISIN | EEA8FA5N0Z |
Offer ID | 1014828022 |
Brand Collection Name | Fierro |
Brand Model Number | 150879 |
Brand Colour | White |
Voltage | 220 V |
Water Pressure | 8 Bar |
Inner Tank Material | Mild Steel with glass lined coating |
Body Material | ABS Plastic |
Heating Element | Copper |
Mounting Type | Vertical |
Power Consumption |
No review given yet! ![]() ![]() ![]() ![]()
More from the store
![]()
CAMON 20 PRO CK8N 8GB 256GB SERENITY BLUE
₹21,999.00
![]()
X610 TAB S9 FE PLUS (WIFI) 8GB 128GB GRAY
₹59,999.00
![]()
M558 M55s 5G 8GB 256GB CORAL GREEN
₹31,999.00
![]()
M558 M55s 5G 8GB 256GB THUNDER BLACK
₹31,999.00
![]()
T3X 5G 6GB 128GB SAPPHIRE BLUE
₹16,499.00
Similar products
₹11,500.00
₹42,300.00
₹35,300.00
₹40,600.00
₹9,100.00
₹4,200.00
₹6,400.00
₹11,000.00
₹10,800.00
₹35,000.00
Send message to Kore Mobile![]() Out of stock![]() Product added to wishlistPlease Sign inYou need to Sign in to view this feature ![]() Delete this address?This address will be removed from this list |
1 x Application (82.55%) | 943ms |
1 x Booting (17.45%) | 199ms |
insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.218.155.110', '2025-04-14 22:43:07', '2025-04-14 22:43:07')
Bindings |
|
Backtrace |
|
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `slug` = 'fierro-10l-gesyer-o5y1A0' limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (55) and (`is_active` = 1) and `added_by` in ('admin', 'vendor') and exists (select * from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` = 1 and date(`duration_start_date`) <= '2025-04-14' and date(`duration_end_date`) >= '2025-04-14' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '22:43:07' and time(`offer_active_range_end`) >= '22:43:07') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null)))
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (55) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (55) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select * from `product_seos` where `product_seos`.`product_id` = 55 limit 1
Bindings |
|
Backtrace |
|
select * from `digital_product_authors` where `digital_product_authors`.`product_id` = 55 and `digital_product_authors`.`product_id` is not null
Bindings |
|
Backtrace |
|
select * from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` = 55 and `digital_product_publishing_houses`.`product_id` is not null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `wishlists` where (`product_id` = 55)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where (`product_id` = 55) and `status` = 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin') and `user_id` = 1 and `id` not in (55)
Bindings |
|
Backtrace |
|
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin') and `user_id` = 1 and `id` not in (55) order by `id` desc limit 5 offset 0
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1936, 1937, 1938, 1939, 1940) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (1936, 1937, 1938, 1939, 1940) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin') and `user_id` = 1
Bindings |
|
Backtrace |
|
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1 and `status` = 1) as `reviews_count` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin') and `user_id` = 1 limit 25 offset 0
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `order_details` where (`product_id` = 55)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `wishlists` where (`product_id` = 55)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`category_id` = 1) and `id` not in (55)
Bindings |
|
Backtrace |
|
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`category_id` = 1) and `id` not in (55) limit 12 offset 0
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 52, 53, 54, 65, 77, 78, 79) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 52, 53, 54, 65, 77, 78, 79) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `deal_of_the_days` where (`product_id` = 55 and `status` = 1) limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 1 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 2 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 3 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 4 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 5 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 52 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 53 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 54 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 65 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 77 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 78 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` = 79 and `stock_clearance_products`.`product_id` is not null limit 1
Bindings |
|
Backtrace |
|
select * from `digital_product_variations` where `digital_product_variations`.`product_id` = 55 and `digital_product_variations`.`product_id` is not null
Bindings |
|
Backtrace |
|
select * from `sellers` where `sellers`.`id` = 1 and `sellers`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 495142 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 (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', '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 (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 495142 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 (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved') and `sellers`.`deleted_at` is null) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1 and (`is_checked` = 1)
Bindings |
|
Backtrace |
|
select * from `brands` where `status` = 1 limit 15
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `social_medias` where `active_status` = 1
Bindings |
|
Backtrace |
|
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-14' and date(`end_date`) >= '2025-04-14' limit 1
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "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" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "sysoverseas.com" ] ]
[]
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 => "Mon, 14 Apr 2025 17:13:07 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjRSbGl4NzFmL0h5RFozSThZSWtVeUE9PSIsInZhbHVlIjoiZG80RDd2VG93dGhDdUFqaGEwMTdXQzJGMmhTaldvWkE0d2dLc1cvdGFSUEpxamVrMlJKMW4rYnZINTl1NlA3cVROUWFyd05QT0R0N2lzN3ZjNkNMekEzTDVaYng2UEZZa0NDSVFLTVh2YzQ0U1o2UnhTS2Jua01qTkZEdVNkaEsiLCJtYWMiOiI5MDJkOWFkN2QyMGUxYWE0ZGMzZjkwYjJkMWQ1NTg2N2Q2YjdjMWQ4ZmEyZjNhYzY2NDkyYTE0ODkxYjYzMjgxIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 18:13:08 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRSbGl4NzFmL0h5RFozSThZSWtVeUE9PSIsInZhbHVlIjoiZG80RDd2VG93dGhDdUFqaGEwMTdXQzJGMmhTaldvWkE0d2dLc1cvdGFSUEpxamVrMlJKMW4rYnZINTl1NlA3cVROUWFyd ▶" 1 => "kore_session=eyJpdiI6Ik5MUkhDODlSejhWR3Rob29vY0ZpclE9PSIsInZhbHVlIjoiRE9EQjVlVXhLSG5kVVdVYkJjV2FxbzVrMmJ3eC85MGczL0FUbGFPVXJLTVFVWk5tZVgyVFBiNktwUDRTWTNQeXFaQXduMCsrMXVNbWpBOGFZMHVlcmQ0L1RNckRKaVp5WVh0UDUrb240V2V4THpXcW52WHF2MjBPcEZtWmRjc00iLCJtYWMiOiJhYjBmZDAwYWNiZTExYzYzMDRkNTAwMTI4OGQ3NjBjNTA4MzgzMzc1ZjAwODgwYWIzZjUyZTU3YTE1ZWIwMDk3IiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 18:13:08 GMT; Max-Age=3600; path=/; httponly ◀kore_session=eyJpdiI6Ik5MUkhDODlSejhWR3Rob29vY0ZpclE9PSIsInZhbHVlIjoiRE9EQjVlVXhLSG5kVVdVYkJjV2FxbzVrMmJ3eC85MGczL0FUbGFPVXJLTVFVWk5tZVgyVFBiNktwUDRTWTNQeXFaQXd ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjRSbGl4NzFmL0h5RFozSThZSWtVeUE9PSIsInZhbHVlIjoiZG80RDd2VG93dGhDdUFqaGEwMTdXQzJGMmhTaldvWkE0d2dLc1cvdGFSUEpxamVrMlJKMW4rYnZINTl1NlA3cVROUWFyd05QT0R0N2lzN3ZjNkNMekEzTDVaYng2UEZZa0NDSVFLTVh2YzQ0U1o2UnhTS2Jua01qTkZEdVNkaEsiLCJtYWMiOiI5MDJkOWFkN2QyMGUxYWE0ZGMzZjkwYjJkMWQ1NTg2N2Q2YjdjMWQ4ZmEyZjNhYzY2NDkyYTE0ODkxYjYzMjgxIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 18:13:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRSbGl4NzFmL0h5RFozSThZSWtVeUE9PSIsInZhbHVlIjoiZG80RDd2VG93dGhDdUFqaGEwMTdXQzJGMmhTaldvWkE0d2dLc1cvdGFSUEpxamVrMlJKMW4rYnZINTl1NlA3cVROUWFyd ▶" 1 => "kore_session=eyJpdiI6Ik5MUkhDODlSejhWR3Rob29vY0ZpclE9PSIsInZhbHVlIjoiRE9EQjVlVXhLSG5kVVdVYkJjV2FxbzVrMmJ3eC85MGczL0FUbGFPVXJLTVFVWk5tZVgyVFBiNktwUDRTWTNQeXFaQXduMCsrMXVNbWpBOGFZMHVlcmQ0L1RNckRKaVp5WVh0UDUrb240V2V4THpXcW52WHF2MjBPcEZtWmRjc00iLCJtYWMiOiJhYjBmZDAwYWNiZTExYzYzMDRkNTAwMTI4OGQ3NjBjNTA4MzgzMzc1ZjAwODgwYWIzZjUyZTU3YTE1ZWIwMDk3IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 18:13:08 GMT; path=/; httponly ◀kore_session=eyJpdiI6Ik5MUkhDODlSejhWR3Rob29vY0ZpclE9PSIsInZhbHVlIjoiRE9EQjVlVXhLSG5kVVdVYkJjV2FxbzVrMmJ3eC85MGczL0FUbGFPVXJLTVFVWk5tZVgyVFBiNktwUDRTWTNQeXFaQXd ▶" ] ]
0 of 0array:11 [▼ "system_default_currency_info" => App\Models\Currency {#8054 ▶ #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" => "i1SeopYNb6dCAMhZdXJZIJQazHwkykWWqXUKIz71" "guest_id" => 495142 "local" => "en" "direction" => "ltr" "_previous" => array:1 [▶ "url" => "https://sysoverseas.com/product/fierro-10l-gesyer-o5y1A0" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]