| 0.0006 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0008 |
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.0007 |
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.0005 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0007 |
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.0014 |
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.0005 |
SELECT *
FROM `ttp_report_categories`
WHERE `Alias` = 'e-gift-voucher'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `auc_products_category_properties`
WHERE `cate_id` = '585'
|
| 0.0011 |
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`.`OrdersCat` DESC, `p`.`ID` DESC
LIMIT 300
|
| 0.0002 |
SELECT DISTINCT *
FROM `ttp_report_trademark` `tm`
WHERE `ID` IN('1')
AND `Published` = '1'
AND `ID` != 7
|
| 0.0006 |
SELECT *
FROM `ttp_report_categories`
WHERE `Special` = 1
AND `ParentID` = 0
ORDER BY `STT` ASC
|
| 0.0003 |
SELECT *
FROM `ttp_report_categories`
WHERE `ParentID` = '585'
ORDER BY `STT` ASC
|
| 0.0005 |
SELECT *
FROM `ttp_define`
WHERE `group` = 'system'
AND `type` = 'cookie_version_require'
|
About Dalat Hasfarm
Tin nổi bật
Tìm cửa hàng
Thẻ thành viên
Hỗ trợ
Đăng nhập
Email Đặt Hàng:
webshop@dalathasfarm.com
Hotline:
1800 1143
Hỏi đáp & cảm nhận người dùng