- Sat -Thr / 10:00am - 8:00pm
- 01919 442655
- info@shunfabd.com
Product Inquiry
Product Inquiry
Corporate Office: House 28, Road 4A,
Sector 15, Block B, Uttara Model Town,
Dhaka, Bangladesh
Corporate Office: House 28, Road 4A,
Sector 15, Block B, Uttara Model Town,
Dhaka, Bangladesh
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `shunfabd_main`.`configs` AS `Config` WHERE 1 = 1 | 50 | 50 | 0 | |
| 2 | BEGIN | 0 | 0 | 0 | |
| 3 | ROLLBACK | 0 | 0 | 0 | |
| 4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, COUNT(`Product`.`id`) AS total_products FROM `shunfabd_main`.`categories` AS `Category` LEFT JOIN `shunfabd_main`.`products` AS `Product` ON (`Category`.`id` = `Product`.`category_id`) WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 GROUP BY `Category`.`id`, `Category`.`name`, `Category`.`slug` ORDER BY `Category`.`sequence` ASC | 6 | 6 | 0 | |
| 5 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 1 ORDER BY `Category`.`sequence` ASC | 0 | 0 | 0 | |
| 6 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 2 ORDER BY `Category`.`sequence` ASC | 0 | 0 | 0 | |
| 7 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 3 ORDER BY `Category`.`sequence` ASC | 0 | 0 | 0 | |
| 8 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 4 ORDER BY `Category`.`sequence` ASC | 0 | 0 | 0 | |
| 9 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 5 ORDER BY `Category`.`sequence` ASC | 0 | 0 | 0 | |
| 10 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 15 ORDER BY `Category`.`sequence` ASC | 0 | 0 | 0 | |
| 11 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `shunfabd_main`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| 12 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`b_title`, `Product`.`barcode`, `Product`.`slug`, `Product`.`category_id`, `Product`.`brand_id`, `Product`.`model`, `Product`.`certificates`, `Product`.`short_description`, `Product`.`details`, `Product`.`p_price`, `Product`.`b_price`, `Product`.`a_price`, `Product`.`price`, `Product`.`special_price`, `Product`.`b_price_percentage`, `Product`.`a_price_percentage`, `Product`.`price_percentage`, `Product`.`warranty`, `Product`.`invention_year`, `Product`.`weight`, `Product`.`dimension`, `Product`.`special_focus`, `Product`.`youtube_video_code`, `Product`.`related_models`, `Product`.`similar_brand`, `Product`.`stock`, `Product`.`purchased`, `Product`.`sold`, `Product`.`min_order`, `Product`.`meta_key`, `Product`.`meta_description`, `Product`.`totalview`, `Product`.`status`, `Product`.`created`, `Product`.`modified`, (CONCAT(`Product`.`name`, " -- " , `Product`.`model`)) AS `Product__label` FROM `shunfabd_main`.`products` AS `Product` WHERE `slug` = 'intelligent-overlock-sewing-machine-model-f7-4d-ep-b-q' LIMIT 1 | 1 | 1 | 0 |