| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `niramoypolli_demo`.`configs` AS `Config` WHERE 1 = 1 | | 42 | 42 | 0 |
| 2 | BEGIN | | 0 | 0 | 0 |
| 3 | ROLLBACK | | 0 | 0 | 0 |
| 4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC | | 11 | 11 | 0 |
| 5 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `status` = '1' AND parent_id > 0 ORDER BY `sequence` ASC | | 5 | 5 | 0 |
| 6 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `niramoypolli_demo`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | | 0 | 0 | 0 |
| 7 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, Count(`Product`.`id`) AS item_total FROM `niramoypolli_demo`.`brands` AS `Brand` LEFT JOIN `niramoypolli_demo`.`products` AS `Product` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') GROUP BY `Brand`.`id` HAVING Count(`Product`.`id`) >0 ORDER BY `Brand`.`created` DESC | | 7 | 7 | 0 |
| 8 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC | | 11 | 11 | 0 |
| 9 | SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `niramoypolli_demo`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (1, 3, 4, 5, 6, 2, 7, 8, 9, 10, 16) | | 5 | 5 | 0 |
| 10 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id`, `Category`.`parent_id` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `sequence` ASC | | 11 | 11 | 0 |
| 11 | SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `niramoypolli_demo`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (1, 3, 4, 5, 6, 2, 7, 8, 9, 10, 16) | | 5 | 5 | 0 |
| 12 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`subtitle`, `Category`.`slug`, `Category`.`meta_key`, `Category`.`meta_description` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `slug` = 'honey' LIMIT 1 | | 1 | 1 | 0 |