| 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 | 2 |
| 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 | 1 |
| 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 | 2 |
| 5 | 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 | 0 |
| 6 | 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 |
| 7 | 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 | 5 |
| 8 | 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 |
| 9 | 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 | 0 |
| 10 | 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` = 'tham-san-cau-long-4-7ly-enlio' AND `Product`.`lang` = 'vi' AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' LIMIT 1 | | 1 | 1 | 8 |
| 11 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`name`, `ProductImage`.`image`, `ProductImage`.`sort` FROM `vnsport24h_admin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (866) | | 0 | 0 | 1 |
| 12 | SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'product_%' | | 5 | 5 | 2 |
| 13 | SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`id` = 182 LIMIT 1 | | 1 | 1 | 0 |
| 14 | 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 |
| 15 | 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` != 'tham-san-cau-long-4-7ly-enlio' AND `Product`.`public` <= 1786567739 AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' ORDER BY rand() ASC LIMIT 10 | | 10 | 10 | 2 |
| 16 | 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` <= 1786567739 ORDER BY rand() ASC | | 0 | 0 | 2 |
| 17 | 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` = 866 LIMIT 1 | | 1 | 1 | 1 |
| 18 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`name`, `ProductImage`.`image`, `ProductImage`.`sort` FROM `vnsport24h_admin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (866) | | 0 | 0 | 0 |
| 19 | SELECT `ProductOption`.`id`, `ProductOption`.`product_id`, `ProductOption`.`name`, `ProductOption`.`price`, `ProductOption`.`image` FROM `vnsport24h_admin`.`product_options` AS `ProductOption` WHERE `ProductOption`.`product_id` = (866) | | 0 | 0 | 0 |
| 20 | SELECT `ProductProperty`.`id`, `ProductProperty`.`product_id`, `ProductProperty`.`field`, `ProductProperty`.`value` FROM `vnsport24h_admin`.`product_properties` AS `ProductProperty` WHERE `ProductProperty`.`product_id` = (866) | | 0 | 0 | 0 |
| 21 | 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` = (866) | | 0 | 0 | 0 |
| 22 | SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 866 | | 1 | 1 | 0 |
| 23 | SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 866 | | 1 | 1 | 0 |
| 24 | SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 866 | | 1 | 1 | 0 |
| 25 | UPDATE `vnsport24h_admin`.`products` SET `view` = 3240, `id` = 866 WHERE `vnsport24h_admin`.`products`.`id` = '866' | | 1 | 1 | 9 |
| 26 | SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 182 LIMIT 1 | | 1 | 1 | 0 |
| 27 | 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 | 0 |
| 28 | 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 |
| 29 | 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 | 0 |
| 30 | 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 | 0 |
