| 1 | 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 |
| 2 | 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 |
| 3 | 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 |
| 4 | 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 |
| 5 | 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` = 151 ORDER BY `lft` asc, `name` asc | | 0 | 0 | 0 |
| 6 | 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` = 151 ORDER BY `Product`.`sort` asc LIMIT 56 | | 22 | 22 | 0 |
| 7 | 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 = (151)) OR (`category_other` like '%-151-%')) | | 22 | 22 | 0 |
| 8 | 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 (48, 66, 76, 109, 173, 154, 65, 171, 174, 102, 177, 185) ORDER BY `sort` asc, `name` asc | | 12 | 12 | 0 |
| 9 | 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` = 'ghe-tap-ta-gian-ta-da-nang' LIMIT 1 | | 1 | 1 | 0 |
| 10 | 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` = 126 LIMIT 1 | | 1 | 1 | 0 |
| 11 | 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` = 126 ORDER BY `lft` asc, `name` asc | | 5 | 5 | 0 |
| 12 | 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 = (151)) OR (`category_other` like '%-151-%')) AND `Product`.`public` <= 1786568293 AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' ORDER BY `Product`.`sort` asc, `Product`.`created` desc, `Product`.`name` asc LIMIT 56 | | 22 | 22 | 0 |
| 13 | SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 151 LIMIT 1 | | 1 | 1 | 0 |
| 14 | 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` <= 26 AND `ProductCategory`.`rght` >= 27 ORDER BY `ProductCategory`.`lft` asc | | 2 | 2 | 0 |
| 15 | 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` != 126 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc | | 10 | 10 | 0 |
| 16 | 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` = 126 AND `id` != 151 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc | | 4 | 4 | 0 |