| 1 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'contact_%' | | 16 | 16 | 101 |
| 2 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'site_%' | | 22 | 22 | 30 |
| 3 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'slideshow_%' | | 13 | 13 | 4 |
| 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 | 2 |
| 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 | 1 |
| 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 | 1 |
| 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 | 1 |
| 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 | 1 |
| 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 | 1 |
| 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 | 1 |
| 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 | 1 |
| 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 | 3 |
| 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 '%-14-%')) ORDER BY `sort` asc, `pos_2` asc, `name` asc LIMIT 30 | | 2 | 2 | 4 |
| 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 '%-14-%')) 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 '%-14-%')) 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 '%-14-%')) 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 '%-14-%')) ORDER BY `sort` asc, `pos_10` asc, `name` asc LIMIT 30 | | 0 | 0 | 1 |
| 23 | SELECT `Product`.*, `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`path`, `ProductMaker`.`name`, `Product`.`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`.`status` = '1' AND `Product`.`trash` = '0' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' AND `Product`.`slug` = 'tru-cau-long-da-nang-l30' AND `Product`.`lang` = 'vi' AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' LIMIT 1 | | 1 | 1 | 26 |
| 24 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`name`, `ProductImage`.`image`, `ProductImage`.`sort` FROM `vnsport24h_admin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (808) | | 0 | 0 | 4 |
| 25 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'product_%' | | 5 | 5 | 0 |
| 26 | SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`id` = 182 LIMIT 1 | | 1 | 1 | 2 |
| 27 | SELECT `ProductCategory`.`id`, `ProductCategory`.`status`, `ProductCategory`.`trash` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`rght` < 120 AND `ProductCategory`.`lft` > 119 ORDER BY `ProductCategory`.`lft` asc | | 0 | 0 | 0 |
| 28 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`lang`, `Product`.`price_new`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`rel`, `Product`.`target`, `Product`.`description`, `Product`.`image`, `Product`.`price`, `Product`.`quantity`, `Product`.`discount`, `Product`.`discount_unit`, `Product`.`promotion`, `Product`.`public`, `Product`.`summary`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`status` 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`) LEFT JOIN `vnsport24h_admin`.`product_taxes` AS `ProductTax` ON (`Product`.`product_tax_id` = `ProductTax`.`id`) LEFT JOIN `vnsport24h_admin`.`users` AS `User` ON (`Product`.`user_id` = `User`.`id`) WHERE product_category_id = (182) AND `Product`.`status` = '1' AND `Product`.`trash` = '0' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' AND `Product`.`lang` = 'vi' AND `Product`.`slug` != 'tru-cau-long-da-nang-l30' AND `Product`.`public` <= 1786568187 AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' ORDER BY rand() ASC LIMIT 10 | | 10 | 10 | 5 |
| 29 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`lang`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`rel`, `Product`.`target`, `Product`.`image`, `Product`.`price`, `Product`.`quantity`, `Product`.`discount`, `Product`.`discount_unit`, `Product`.`public`, `Product`.`promotion`, `Product`.`summary`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`status` 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`) LEFT JOIN `vnsport24h_admin`.`product_taxes` AS `ProductTax` ON (`Product`.`product_tax_id` = `ProductTax`.`id`) LEFT JOIN `vnsport24h_admin`.`users` AS `User` ON (`Product`.`user_id` = `User`.`id`) WHERE `Product`.`code` = ('') AND `Product`.`status` = '1' AND `Product`.`trash` = '0' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' AND `Product`.`lang` = 'vi' AND `Product`.`public` <= 1786568187 ORDER BY rand() ASC | | 0 | 0 | 3 |
| 30 | SELECT `Product`.`view`, `Product`.`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`) LEFT JOIN `vnsport24h_admin`.`product_taxes` AS `ProductTax` ON (`Product`.`product_tax_id` = `ProductTax`.`id`) LEFT JOIN `vnsport24h_admin`.`users` AS `User` ON (`Product`.`user_id` = `User`.`id`) WHERE `Product`.`id` = 808 LIMIT 1 | | 1 | 1 | 4 |
| 31 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`name`, `ProductImage`.`image`, `ProductImage`.`sort` FROM `vnsport24h_admin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (808) | | 0 | 0 | 1 |
| 32 | SELECT `ProductOption`.`id`, `ProductOption`.`product_id`, `ProductOption`.`name`, `ProductOption`.`price`, `ProductOption`.`image` FROM `vnsport24h_admin`.`product_options` AS `ProductOption` WHERE `ProductOption`.`product_id` = (808) | | 0 | 0 | 2 |
| 33 | SELECT `ProductProperty`.`id`, `ProductProperty`.`product_id`, `ProductProperty`.`field`, `ProductProperty`.`value` FROM `vnsport24h_admin`.`product_properties` AS `ProductProperty` WHERE `ProductProperty`.`product_id` = (808) | | 0 | 0 | 2 |
| 34 | SELECT `Comment`.`id`, `Comment`.`member_id`, `Comment`.`item_id`, `Comment`.`model`, `Comment`.`lang`, `Comment`.`name`, `Comment`.`email`, `Comment`.`description`, `Comment`.`like`, `Comment`.`view`, `Comment`.`ip`, `Comment`.`proxy`, `Comment`.`parent_id`, `Comment`.`created`, `Comment`.`status` FROM `vnsport24h_admin`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Product' AND `Comment`.`item_id` = (808) | | 0 | 0 | 2 |
| 35 | SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 808 | | 1 | 1 | 2 |
| 36 | SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 808 | | 1 | 1 | 0 |
| 37 | SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 808 | | 1 | 1 | 1 |
| 38 | UPDATE `vnsport24h_admin`.`products` SET `view` = 5475, `id` = 808 WHERE `vnsport24h_admin`.`products`.`id` = '808' | | 1 | 1 | 5 |
| 39 | SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 182 LIMIT 1 | | 1 | 1 | 1 |
| 40 | 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` <= 119 AND `ProductCategory`.`rght` >= 120 ORDER BY `ProductCategory`.`lft` asc | | 3 | 3 | 1 |
| 41 | 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` != 196 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc | | 10 | 10 | 0 |
| 42 | 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` = 196 AND `id` != 136 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc | | 6 | 6 | 1 |
| 43 | 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` = 136 AND `id` != 182 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc | | 0 | 0 | 1 |
