| 1 | SELECT `Lang`.`id`, `Lang`.`key`, `Lang`.`vi`, `Lang`.`en`, `Lang`.`pos` FROM `cathcom_db`.`langs` AS `Lang` WHERE 1 = 1 | | 31 | 31 | 0 |
| 2 | SELECT Setting.name, Setting.value FROM `cathcom_db`.`settings` AS `Setting` WHERE 1 = 1 | | 28 | 28 | 0 |
| 3 | SELECT `Category`.`id`, `Category`.`title` FROM `cathcom_db`.`categories` AS `Category` WHERE 1 = 1 | | 18 | 18 | 0 |
| 4 | SELECT `Node`.*, `Category`.* FROM `cathcom_db`.`categories` AS `Category` INNER JOIN `cathcom_db`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`menu` = 1 ORDER BY `Node`.`pos` ASC, `Node`.`id` DESC | | 15 | 15 | 0 |
| 5 | SELECT `Node`.*, `Category`.* FROM `cathcom_db`.`categories` AS `Category` INNER JOIN `cathcom_db`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer` = 1 AND `Category`.`parent_id` IS NULL ORDER BY `Node`.`pos` ASC, `Node`.`id` DESC | | 0 | 0 | 0 |
| 6 | SELECT `Node`.*, `News`.* FROM `cathcom_db`.`nodes` AS `Node` INNER JOIN `cathcom_db`.`news` AS `News` ON (`News`.`node_id` = `Node`.`id`) WHERE `Node`.`status` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc LIMIT 5 | | 5 | 5 | 0 |
| 7 | SELECT `Node`.*, `News`.* FROM `cathcom_db`.`nodes` AS `Node` INNER JOIN `cathcom_db`.`news` AS `News` ON (`News`.`node_id` = `Node`.`id`) WHERE `Node`.`status` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc LIMIT 5 | | 5 | 5 | 0 |
| 8 | SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`description`, `Banner`.`image`, `Banner`.`image_en`, `Banner`.`link`, `Banner`.`type`, `Banner`.`category_id`, `Banner`.`pos`, `Banner`.`status` FROM `cathcom_db`.`banners` AS `Banner` WHERE `Banner`.`status` = 1 ORDER BY `Banner`.`pos` DESC, `Banner`.`id` DESC | | 5 | 5 | 0 |
| 9 | SELECT `Node`.`id`, `Node`.`title`, `Node`.`title_en`, `Node`.`slug`, `Node`.`category_id`, `Node`.`type`, `Node`.`pos`, `Node`.`robots`, `Node`.`read`, `Node`.`created`, `Node`.`modified`, `Node`.`status` FROM `cathcom_db`.`nodes` AS `Node` WHERE `Node`.`type` = 'tag' ORDER BY rand() ASC LIMIT 15 | | 0 | 0 | 0 |
| 10 | SELECT `Node`.`id`, `Node`.`title`, `Node`.`title_en`, `Node`.`slug`, `Node`.`category_id`, `Node`.`type`, `Node`.`pos`, `Node`.`robots`, `Node`.`read`, `Node`.`created`, `Node`.`modified`, `Node`.`status` FROM `cathcom_db`.`nodes` AS `Node` WHERE `Node`.`slug` = 'venus' LIMIT 1 | | 1 | 1 | 0 |