| 0.0007 |
SELECT * FROM `ttp_report_warehouse` WHERE `Published` = 1
|
| 0.0009 |
SELECT `sl`.*, `d`.`title` as `name`, `c`.`Title` as `cityName` FROM `ttp_report_store_location` `sl` JOIN `ttp_report_warehouse` as `w` ON `w`.`Shortcut` = `sl`.`store` LEFT JOIN `ttp_report_district` as `d` ON `d`.`ID` = `sl`.`district_id` LEFT JOIN `ttp_report_city` as `c` ON `c`.`ID` = `sl`.`city_id` WHERE `sl`.`published` = 1 GROUP BY `sl`.`id`
|
| 0.0008 |
SELECT * FROM `ttp_report_categories` WHERE `Special` = 1 AND `ParentID` = 0 ORDER BY `STT` ASC
|
| 0.0003 |
SELECT DISTINCT * FROM `auc_cart` WHERE `store` = 'a5' AND `session_id` IS NULL
|
| 0.0006 |
SELECT * FROM `ttp_report_warehouse` WHERE `Published` = 1
|
| 0.0009 |
SELECT `sl`.*, `d`.`title` as `name`, `c`.`Title` as `cityName` FROM `ttp_report_store_location` `sl` JOIN `ttp_report_warehouse` as `w` ON `w`.`Shortcut` = `sl`.`store` LEFT JOIN `ttp_report_district` as `d` ON `d`.`ID` = `sl`.`district_id` LEFT JOIN `ttp_report_city` as `c` ON `c`.`ID` = `sl`.`city_id` WHERE `sl`.`published` = 1 GROUP BY `sl`.`id`
|
| 0.0012 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice` FROM `ttp_report_products` `p` LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID` LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP` WHERE `c`.`CategoriesID` = 585 AND `p`.`Published` = 1 AND `p`.`Status` = 1 ORDER BY `p`.`ID` DESC LIMIT 8
|
| 0.0002 |
SELECT DISTINCT * FROM `auc_cart` WHERE `store` = 'a5' AND `session_id` IS NULL
|
| 0.0004 |
SELECT `p`.`ID`, `p`.`MaSP`, `p`.`TypeProducts`, `p`.`CategoriesID`, `p`.`Barcode`, `p`.`VariantType`, `p`.`Title`, `p`.`Alias`, `p`.`SpecialPrice`, `p`.`Donvi`, `p`.`Content`, `p`.`Description`, `p`.`properties_id`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`CategoriesID`, `p`.`weight_actual`, `p`.`bulky_level`, `p`.`no_voucher`, `p`.`PutcartNegative`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_opening_qty` as `opening_qty`, `pr`.`sat_promo_price` as `SocialPrice`, `p`.`tag_image` FROM `ttp_report_products` `p` LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP` WHERE `p`.`ID` = 2074 AND `p`.`Status` = 1
|
| 0.0003 |
SELECT `c`.`ID` as `category_id`, `c`.`Title` as `category_title`, `c`.`Alias` as `category_alias`, `c`.`ParentID` as `category_parent_id`, `c`.`tag_image` FROM `ttp_report_products_categories` `pc` LEFT JOIN `ttp_report_categories` `c` ON `c`.`ID` = `pc`.`CategoriesID` WHERE `pc`.`ProductsID` = '2074' LIMIT 1
|
| 0.0003 |
SELECT * FROM `auc_report_parttime_products_images` WHERE DATE(start_date) <= '2025-12-06' AND DATE(end_date) >= '2025-12-06' AND `sku` = 'AFFMIXD503'
|
| 0.0419 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice` FROM `ttp_report_products` `p` LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID` LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP` WHERE `c`.`CategoriesID` = '235' AND `p`.`Published` = 1 AND `p`.`Status` = 1 ORDER BY `p`.`ID` DESC LIMIT 20
|
| 0.0004 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0003 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0003 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0002 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0002 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0003 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0002 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0002 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0002 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0002 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0002 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0026 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0003 |
SELECT * FROM `ttp_report_properties` WHERE `ParentID` = 38 AND `Published` = 1
|
| 0.0014 |
SELECT * FROM `ttp_report_products_comments` WHERE `product_id` = '2074' AND `status` = 1 ORDER BY `comment_id` DESC
|
| 0.0013 |
SELECT * FROM `ttp_report_products_comments` WHERE `product_id` = '2074' AND `rating` = 1
|
| 0.0012 |
SELECT * FROM `ttp_report_products_comments` WHERE `product_id` = '2074' AND `rating` = 2
|
| 0.0011 |
SELECT * FROM `ttp_report_products_comments` WHERE `product_id` = '2074' AND `rating` = 3
|
| 0.0012 |
SELECT * FROM `ttp_report_products_comments` WHERE `product_id` = '2074' AND `rating` = 4
|
| 0.0011 |
SELECT * FROM `ttp_report_products_comments` WHERE `product_id` = '2074' AND `rating` = 5
|
| 0.0003 |
SELECT * FROM `ttp_report_categories` WHERE `ID` IN('235') ORDER BY `STT` DESC
|
| 0.0008 |
SELECT * FROM `ttp_report_categories` WHERE `Special` = 1 AND `ParentID` = 0 ORDER BY `STT` ASC
|
| 0.0004 |
SELECT * FROM `ttp_define` WHERE `group` = 'products' AND `type` = 'general_notice'
|
| 0.0004 |
SELECT * FROM `ttp_define` WHERE `group` = 'system' AND `type` = 'cookie_version_require'
|
Hỏi đáp & cảm nhận người dùng