| 1 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'contact_%' | | 16 | 16 | 0 |
| 2 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'site_%' | | 22 | 22 | 0 |
| 3 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'slideshow_%' | | 13 | 13 | 0 |
| 4 | SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`unit`, `Currency`.`location`, `Currency`.`value`, `Currency`.`status` FROM `vnsport24h_admin`.`currencies` AS `Currency` WHERE `status` = '1' ORDER BY `name` asc | | 2 | 2 | 0 |
| 5 | SELECT `ProductCategory`.`slug`, `ProductCategory`.`meta_title`, `ProductCategory`.`name`, `ProductCategory`.`pos_home`, `ProductCategory`.`lang`, `ProductCategory`.`id`, `ProductCategory`.`path`, `ProductCategory`.`rel`, `ProductCategory`.`parent_id`, `ProductCategory`.`target`, `ProductCategory`.`link`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`lang` = 'vi' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' ORDER BY `lft` asc | | 56 | 56 | 0 |
| 6 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `parent_id` IS NULL | | 11 | 11 | 0 |
| 7 | SELECT `PostCategory`.`slug`, `PostCategory`.`meta_title`, `PostCategory`.`name`, `PostCategory`.`lang`, `PostCategory`.`id`, `PostCategory`.`path`, `PostCategory`.`rel`, `PostCategory`.`parent_id`, `PostCategory`.`target`, `PostCategory`.`link`, `PostCategory`.`position` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE `PostCategory`.`lang` = 'vi' AND `PostCategory`.`status` = '1' AND `PostCategory`.`trash` = '0' ORDER BY `lft` asc | | 2 | 2 | 0 |
| 8 | SELECT `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`lft`, `PostCategory`.`rght` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND 1 = 1 ORDER BY `PostCategory`.`lft` asc | | 2 | 2 | 0 |
| 9 | SELECT `PostCategory`.`slug`, `PostCategory`.`meta_title`, `PostCategory`.`name`, `PostCategory`.`lang`, `PostCategory`.`id`, `PostCategory`.`path`, `PostCategory`.`rel`, `PostCategory`.`parent_id`, `PostCategory`.`target`, `PostCategory`.`link`, `PostCategory`.`position` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` LEFT JOIN `vnsport24h_admin`.`post_categories` AS `ParentPostCategory` ON (`PostCategory`.`parent_id` = `ParentPostCategory`.`id`) WHERE `PostCategory`.`lang` = 'vi' AND `PostCategory`.`status` = '1' AND `PostCategory`.`trash` = '0' ORDER BY `PostCategory`.`lft` asc | | 2 | 2 | 0 |
| 10 | SELECT `ChildPostCategory`.`id`, `ChildPostCategory`.`lang`, `ChildPostCategory`.`name`, `ChildPostCategory`.`position`, `ChildPostCategory`.`image`, `ChildPostCategory`.`banner`, `ChildPostCategory`.`banner_link`, `ChildPostCategory`.`slug`, `ChildPostCategory`.`path`, `ChildPostCategory`.`column`, `ChildPostCategory`.`link`, `ChildPostCategory`.`description`, `ChildPostCategory`.`meta_title`, `ChildPostCategory`.`meta_keyword`, `ChildPostCategory`.`meta_description`, `ChildPostCategory`.`meta_robots`, `ChildPostCategory`.`rel`, `ChildPostCategory`.`target`, `ChildPostCategory`.`counter`, `ChildPostCategory`.`parent_id`, `ChildPostCategory`.`lft`, `ChildPostCategory`.`rght`, `ChildPostCategory`.`status`, `ChildPostCategory`.`trash` FROM `vnsport24h_admin`.`post_categories` AS `ChildPostCategory` WHERE `ChildPostCategory`.`parent_id` IN (47, 60) | | 0 | 0 | 0 |
| 11 | SELECT `Post`.`id`, `Post`.`lang`, `Post`.`post_category_id`, `Post`.`user_id`, `Post`.`category_other`, `Post`.`name`, `Post`.`image`, `Post`.`summary`, `Post`.`description`, `Post`.`slug`, `Post`.`tag`, `Post`.`meta_title`, `Post`.`meta_keyword`, `Post`.`meta_description`, `Post`.`meta_robots`, `Post`.`rel`, `Post`.`target`, `Post`.`view`, `Post`.`pos_1`, `Post`.`pos_2`, `Post`.`pos_3`, `Post`.`pos_4`, `Post`.`pos_5`, `Post`.`pos_6`, `Post`.`sort`, `Post`.`public`, `Post`.`star_rate_count`, `Post`.`star_rate`, `Post`.`created`, `Post`.`modifired`, `Post`.`status`, `Post`.`trash` FROM `vnsport24h_admin`.`posts` AS `Post` WHERE `Post`.`post_category_id` = (47) LIMIT 10 | | 10 | 10 | 0 |
| 12 | SELECT `Post`.`id`, `Post`.`lang`, `Post`.`post_category_id`, `Post`.`user_id`, `Post`.`category_other`, `Post`.`name`, `Post`.`image`, `Post`.`summary`, `Post`.`description`, `Post`.`slug`, `Post`.`tag`, `Post`.`meta_title`, `Post`.`meta_keyword`, `Post`.`meta_description`, `Post`.`meta_robots`, `Post`.`rel`, `Post`.`target`, `Post`.`view`, `Post`.`pos_1`, `Post`.`pos_2`, `Post`.`pos_3`, `Post`.`pos_4`, `Post`.`pos_5`, `Post`.`pos_6`, `Post`.`sort`, `Post`.`public`, `Post`.`star_rate_count`, `Post`.`star_rate`, `Post`.`created`, `Post`.`modifired`, `Post`.`status`, `Post`.`trash` FROM `vnsport24h_admin`.`posts` AS `Post` WHERE `Post`.`post_category_id` = (60) LIMIT 10 | | 6 | 6 | 0 |
| 13 | SELECT `Support`.`id`, `Support`.`name`, `Support`.`phone`, `Support`.`yahoo`, `Support`.`skype`, `Support`.`sort`, `Support`.`status` FROM `vnsport24h_admin`.`supports` AS `Support` WHERE `status` = '1' ORDER BY `sort` asc | | 1 | 1 | 0 |
| 14 | SELECT `Information`.`id`, `Information`.`name`, `Information`.`lang`, `Information`.`slug`, `Information`.`parent_id`, `Information`.`link`, `Information`.`rel`, `Information`.`target`, `Information`.`position`, `Information`.`meta_title` FROM `vnsport24h_admin`.`information` AS `Information` WHERE `Information`.`status` = '1' AND `Information`.`trash` = '0' AND `Information`.`parent_id` IS NULL AND `Information`.`lang` = 'vi' ORDER BY `sort` asc | | 12 | 12 | 0 |
| 15 | SELECT `ChildInformation`.`id`, `ChildInformation`.`name`, `ChildInformation`.`lang`, `ChildInformation`.`slug`, `ChildInformation`.`parent_id`, `ChildInformation`.`link`, `ChildInformation`.`rel`, `ChildInformation`.`target`, `ChildInformation`.`position`, `ChildInformation`.`meta_title` FROM `vnsport24h_admin`.`information` AS `ChildInformation` WHERE `status` = '1' AND `trash` = '0' AND `ChildInformation`.`parent_id` IN (1026, 1034, 1037, 1038, 1042, 1029, 1039, 1031, 1040, 1032, 1033, 1035) ORDER BY `sort` asc | | 0 | 0 | 0 |
| 16 | SELECT `VideoCategory`.`id`, `VideoCategory`.`name`, `VideoCategory`.`slug`, `VideoCategory`.`meta_title`, `VideoCategory`.`rel`, `VideoCategory`.`target` FROM `vnsport24h_admin`.`video_categories` AS `VideoCategory` WHERE `lang` = 'vi' AND `status` = 1 AND `trash` = '0' ORDER BY `sort` asc, `name` asc | | 1 | 1 | 0 |
| 17 | SELECT `Video`.`id`, `Video`.`name`, `Video`.`youtube`, `Video`.`slug`, `Video`.`meta_title`, `Video`.`rel`, `Video`.`target` FROM `vnsport24h_admin`.`videos` AS `Video` LEFT JOIN `vnsport24h_admin`.`video_categories` AS `VideoCategory` ON (`Video`.`video_category_id` = `VideoCategory`.`id`) WHERE `Video`.`status` = '1' AND `Video`.`trash` = '0' AND `VideoCategory`.`status` = 1 AND `VideoCategory`.`trash` = '0' AND `Video`.`lang` = 'vi' AND `pos_1` != 0 ORDER BY `pos_1` asc, `name` asc LIMIT 10 | | 1 | 1 | 0 |
| 18 | SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_2` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-4-%')) ORDER BY `sort` asc, `pos_2` asc, `name` asc LIMIT 30 | | 2 | 2 | 0 |
| 19 | SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_3` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-4-%')) ORDER BY `sort` asc, `pos_3` asc, `name` asc LIMIT 30 | | 0 | 0 | 0 |
| 20 | SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_4` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-4-%')) ORDER BY `sort` asc, `pos_4` asc, `name` asc LIMIT 30 | | 1 | 1 | 0 |
| 21 | SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_9` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-4-%')) ORDER BY `sort` asc, `pos_9` asc, `name` asc LIMIT 30 | | 0 | 0 | 0 |
| 22 | SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_10` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-4-%')) ORDER BY `sort` asc, `pos_10` asc, `name` asc LIMIT 30 | | 0 | 0 | 0 |
| 23 | SELECT `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`lang`, `PostCategory`.`banner`, `PostCategory`.`banner_link`, `PostCategory`.`slug`, `PostCategory`.`path`, `PostCategory`.`description`, `PostCategory`.`position`, `PostCategory`.`meta_title`, `PostCategory`.`meta_keyword`, `PostCategory`.`meta_description`, `PostCategory`.`meta_robots` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE `status` = '1' AND `trash` = '0' AND `lang` = 'vi' AND `slug` = 'tu-van-phong-gym' AND ((`link` IS NULL) OR (`link` = '')) LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`slug`, `PostCategory`.`lang`, `PostCategory`.`path`, `PostCategory`.`meta_title`, `PostCategory`.`rel`, `PostCategory`.`target`, `PostCategory`.`link`, `PostCategory`.`image`, `PostCategory`.`status`, `PostCategory`.`position` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE `status` = '1' AND `trash` = '0' AND `lang` = 'vi' AND `parent_id` = 60 ORDER BY `lft` asc, `name` asc | | 0 | 0 | 0 |
| 25 | SELECT `Post`.`id`, `Post`.`name`, `Post`.`lang`, `Post`.`slug`, `Post`.`meta_title`, `Post`.`rel`, `Post`.`target`, `Post`.`public`, `Post`.`image`, `Post`.`summary`, `Post`.`created`, `PostCategory`.`slug`, `PostCategory`.`path`, `PostCategory`.`status`, `PostCategory`.`position`, `PostCategory`.`id` FROM `vnsport24h_admin`.`posts` AS `Post` LEFT JOIN `vnsport24h_admin`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`lang` = 'vi' AND `Post`.`status` = '1' AND `Post`.`trash` = '0' AND ((post_category_id = (60)) OR (`category_other` like '%-60-%')) AND `Post`.`public` <= 1786566492 ORDER BY `Post`.`sort` asc, `Post`.`created` desc, `Post`.`name` asc LIMIT 27 | | 6 | 6 | 1 |
| 26 | SELECT `PostCategory`.`lft`, `PostCategory`.`rght` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE `PostCategory`.`id` = 60 LIMIT 1 | | 1 | 1 | 1 |
| 27 | SELECT `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`slug`, `PostCategory`.`meta_title`, `PostCategory`.`path`, `PostCategory`.`parent_id`, `PostCategory`.`link`, `PostCategory`.`status`, `PostCategory`.`position` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE 1 = 1 AND `PostCategory`.`lft` <= 3 AND `PostCategory`.`rght` >= 4 ORDER BY `PostCategory`.`lft` asc | | 1 | 1 | 0 |
