| 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 | 1 |
| 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 | 2 |
| 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 '%-3-%')) 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 '%-3-%')) 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 '%-3-%')) 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 '%-3-%')) 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 '%-3-%')) ORDER BY `sort` asc, `pos_10` asc, `name` asc LIMIT 30 | | 0 | 0 | 0 |
| 23 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`lang`, `ProductCategory`.`banner`, `ProductCategory`.`banner_link`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`description`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keyword`, `ProductCategory`.`meta_description`, `ProductCategory`.`meta_robots` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `status` = '1' AND `trash` = '0' AND `lang` = 'vi' AND `slug` = 'bao-cat-gia-treo-gang-dam-boc' AND ((`link` IS NULL) OR (`link` = '')) LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`lang`, `ProductCategory`.`path`, `ProductCategory`.`meta_title`, `ProductCategory`.`rel`, `ProductCategory`.`target`, `ProductCategory`.`link`, `ProductCategory`.`image`, `ProductCategory`.`status`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `status` = '1' AND `trash` = '0' AND `lang` = 'vi' AND `parent_id` = 154 ORDER BY `lft` asc, `name` asc | | 0 | 0 | 0 |
| 25 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`lang`, `Product`.`price_new`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`rel`, `Product`.`target`, `Product`.`image`, `Product`.`price`, `Product`.`quantity`, `Product`.`discount`, `Product`.`discount_unit`, `Product`.`promotion`, `Product`.`public`, `Product`.`summary`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`status`, `ProductCategory`.`id`, `ProductMaker`.`id` FROM `vnsport24h_admin`.`products` AS `Product` LEFT JOIN `vnsport24h_admin`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `vnsport24h_admin`.`product_makers` AS `ProductMaker` ON (`Product`.`product_maker_id` = `ProductMaker`.`id`) WHERE `Product`.`lang` = 'vi' AND `Product`.`status` = '1' AND `Product`.`trash` = '0' AND `Product`.`product_category_id` = 154 ORDER BY `Product`.`sort` asc LIMIT 56 | | 26 | 26 | 2 |
| 26 | SELECT `Product`.`product_maker_id` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`lang` = 'vi' AND `Product`.`status` = '1' AND `Product`.`trash` = '0' AND ((product_category_id = (154)) OR (`category_other` like '%-154-%')) | | 28 | 28 | 1 |
| 27 | SELECT `ProductMaker`.`id`, `ProductMaker`.`name`, `ProductMaker`.`slug`, `ProductMaker`.`image`, `ProductMaker`.`meta_title`, `ProductMaker`.`link`, `ProductMaker`.`rel`, `ProductMaker`.`target`, `ProductMaker`.`counter` FROM `vnsport24h_admin`.`product_makers` AS `ProductMaker` WHERE `id` IN (39, 68, 59, 69, 48, 71, 132, 179, 153) ORDER BY `sort` asc, `name` asc | | 9 | 9 | 0 |
| 28 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`parent_id` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `status` = '1' AND `trash` = '0' AND `lang` = 'vi' AND `slug` = 'bao-cat-gia-treo-gang-dam-boc' LIMIT 1 | | 1 | 1 | 0 |
| 29 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`parent_id` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `status` = '1' AND `trash` = '0' AND `lang` = 'vi' AND `id` = 127 LIMIT 1 | | 1 | 1 | 0 |
| 30 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`lang`, `ProductCategory`.`path`, `ProductCategory`.`meta_title`, `ProductCategory`.`rel`, `ProductCategory`.`target`, `ProductCategory`.`link`, `ProductCategory`.`image`, `ProductCategory`.`status`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `status` = '1' AND `trash` = '0' AND `lang` = 'vi' AND `parent_id` = 127 ORDER BY `lft` asc, `name` asc | | 5 | 5 | 0 |
| 31 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`lang`, `Product`.`price_new`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`rel`, `Product`.`target`, `Product`.`image`, `Product`.`price`, `Product`.`quantity`, `Product`.`discount`, `Product`.`discount_unit`, `Product`.`promotion`, `Product`.`public`, `Product`.`like`, `Product`.`summary`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`status`, `ProductCategory`.`id`, `ProductMaker`.`id` FROM `vnsport24h_admin`.`products` AS `Product` LEFT JOIN `vnsport24h_admin`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `vnsport24h_admin`.`product_makers` AS `ProductMaker` ON (`Product`.`product_maker_id` = `ProductMaker`.`id`) WHERE `Product`.`lang` = 'vi' AND `Product`.`status` = '1' AND `Product`.`trash` = '0' AND ((product_category_id = (154)) OR (`category_other` like '%-154-%')) AND `Product`.`public` <= 1786565863 AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' AND `product_maker_id` = 69 ORDER BY `Product`.`sort` asc, `Product`.`created` desc, `Product`.`name` asc LIMIT 56 | | 1 | 1 | 1 |
| 32 | SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 154 LIMIT 1 | | 1 | 1 | 1 |
| 33 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`meta_title`, `ProductCategory`.`path`, `ProductCategory`.`link`, `ProductCategory`.`parent_id`, `ProductCategory`.`status` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 38 AND `ProductCategory`.`rght` >= 39 ORDER BY `ProductCategory`.`lft` asc | | 2 | 2 | 0 |
| 34 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`meta_title`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`link`, `ProductCategory`.`parent_id`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `parent_id` IS NULL AND `id` != 127 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc | | 10 | 10 | 0 |
| 35 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`meta_title`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`link`, `ProductCategory`.`parent_id`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `parent_id` = 127 AND `id` != 154 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc | | 4 | 4 | 0 |
