| 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 `Slider`.`id`, `Slider`.`title`, `Slider`.`color_code`, `Slider`.`content`, `Slider`.`product_id`, `Product`.`slug` FROM `acurebd_uat`.`sliders` AS `Slider` LEFT JOIN `acurebd_uat`.`products` AS `Product` ON (`Slider`.`product_id` = `Product`.`id`) WHERE `Slider`.`status` = '1' ORDER BY `Slider`.`sequence` ASC | | 7 | 7 | 0 |
| 8 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug` FROM `acurebd_uat`.`brands` AS `Brand` WHERE `status` = '1' | | 149 | 149 | 0 |
| 9 | SELECT `Flashphoto`.`id`, `Flashphoto`.`product_id`, `Flashphoto`.`title_one`, `Flashphoto`.`title_two`, `Flashphoto`.`sequence`, `Flashphoto`.`status`, `Flashphoto`.`created`, `Flashphoto`.`modified` FROM `acurebd_uat`.`flashphotos` AS `Flashphoto` WHERE `status` = '1' ORDER BY `sequence` ASC LIMIT 2 | | 2 | 2 | 0 |
| 10 | SELECT `Category`.`id`, `Category`.`slug` FROM `acurebd_uat`.`categories` AS `Category` WHERE `status` = '1' | | 54 | 54 | 0 |
