7 Bahar Orange Blossom Honey
৳ 1240
Brand: 7 Bahar
| কুরিয়ার ডেলিভারি খরচ | |
|---|---|
| ঢাকার ভিতরে | ৳ 60 |
| ঢাকার বাহিরে | ৳ 130 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `acurebd_uat`.`configs` AS `Config` WHERE 1 = 1 | 67 | 67 | 0 | |
| 2 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id` FROM `acurebd_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC | 12 | 12 | 0 | |
| 3 | SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `acurebd_uat`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (73, 4, 9, 29, 28, 21, 30, 24, 20, 26, 6, 15) | 40 | 40 | 0 | |
| 4 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `acurebd_uat`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| 5 | BEGIN | 0 | 0 | 0 | |
| 6 | ROLLBACK | 0 | 0 | 0 | |
| 7 | SELECT `Product`.`totalview`, `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`meta_title`, `Product`.`specification`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`category_id`, `Product`.`details`, `Product`.`offer_type`, `Product`.`model`, `Product`.`meta_key`, `Product`.`meta_description` FROM `acurebd_uat`.`products` AS `Product` WHERE `slug` = '7-bahar-orange-blossom-honey-500-gram' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') LIMIT 1 | 1 | 1 | 3 | |
| 8 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `acurebd_uat`.`categories` AS `Category` WHERE id IN(0,15,29,46,0) | 3 | 3 | 0 | |
| 9 | BEGIN | 0 | 0 | 0 | |
| 10 | SELECT COUNT(*) AS `count` FROM `acurebd_uat`.`products` AS `Product` WHERE `Product`.`id` = 3994 | 1 | 1 | 0 | |
| 11 | SELECT COUNT(*) AS `count` FROM `acurebd_uat`.`products` AS `Product` WHERE `Product`.`id` = 3994 | 1 | 1 | 0 | |
| 12 | UPDATE `acurebd_uat`.`products` SET `totalview` = 732, `modified` = '2026-05-11 12:13:43' WHERE `acurebd_uat`.`products`.`id` = '3994' | 1 | 1 | 0 | |
| 13 | COMMIT | 0 | 0 | 0 | |
| 14 | SELECT `ProductImg`.`id`, `ProductImg`.`product_id`, `ProductImg`.`title`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3994 | 1 | 1 | 1 | |
| 15 | SELECT AVG(score) AS scr FROM `acurebd_uat`.`ratings` AS `Rating` WHERE `product_id` = 3994 LIMIT 1 | 1 | 1 | 0 | |
| 16 | SELECT COUNT(rating) AS tot, AVG(rating) AS scr FROM `acurebd_uat`.`reviews` AS `Review` WHERE `product_id` = 3994 LIMIT 1 | 1 | 1 | 0 | |
| 17 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug` FROM `acurebd_uat`.`brands` AS `Brand` WHERE `status` = '1' | 149 | 149 | 0 | |
| 18 | SELECT `Product`.`slug`, `Tag`.`title` FROM `acurebd_uat`.`tags` AS `Tag` LEFT JOIN `acurebd_uat`.`products` AS `Product` ON (`Tag`.`product_id` = `Product`.`id`) WHERE `Tag`.`status` = '1' | 12 | 12 | 0 | |
| 19 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id` FROM `acurebd_uat`.`products` AS `Product` WHERE `Product`.`status` = '1' AND `Product`.`category_id` = 0 AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') ORDER BY `Product`.`id` DESC LIMIT 10 | 10 | 10 | 0 |
