| 0.0009 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0012 |
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.0009 |
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.0007 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0010 |
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.0015 |
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.0003 |
SELECT DISTINCT *
FROM `auc_cart`
WHERE `store` = 'a5'
AND `session_id` IS NULL
|
| 0.0005 |
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` = 1633
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` = '1633'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `auc_report_parttime_products_images`
WHERE DATE(start_date) <= '2025-12-06'
AND DATE(end_date) >= '2025-12-06'
AND `sku` = 'ADF06AB355'
|
| 0.0423 |
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.0005 |
SELECT *
FROM `ttp_report_properties`
WHERE `ParentID` = 38
AND `Published` = 1
|
| 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.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.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.0002 |
SELECT *
FROM `ttp_report_properties`
WHERE `ParentID` = 38
AND `Published` = 1
|
| 0.0014 |
SELECT *
FROM `ttp_report_products_comments`
WHERE `product_id` = '1633'
AND `status` = 1
ORDER BY `comment_id` DESC
|
| 0.0012 |
SELECT *
FROM `ttp_report_products_comments`
WHERE `product_id` = '1633'
AND `rating` = 1
|
| 0.0011 |
SELECT *
FROM `ttp_report_products_comments`
WHERE `product_id` = '1633'
AND `rating` = 2
|
| 0.0011 |
SELECT *
FROM `ttp_report_products_comments`
WHERE `product_id` = '1633'
AND `rating` = 3
|
| 0.0011 |
SELECT *
FROM `ttp_report_products_comments`
WHERE `product_id` = '1633'
AND `rating` = 4
|
| 0.0011 |
SELECT *
FROM `ttp_report_products_comments`
WHERE `product_id` = '1633'
AND `rating` = 5
|
| 0.0003 |
SELECT *
FROM `ttp_report_categories`
WHERE `ID` IN('235')
ORDER BY `STT` DESC
|
| 0.0007 |
SELECT *
FROM `ttp_report_categories`
WHERE `Special` = 1
AND `ParentID` = 0
ORDER BY `STT` ASC
|
| 0.0005 |
SELECT *
FROM `ttp_define`
WHERE `group` = 'products'
AND `type` = 'general_notice'
|
| 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
Giao hàng nhanh 2 giờ trong 5km
Miễn phí thiệp chúc mừng
Đảm bảo hoa tươi trong 3 ngày
Email Đặt Hàng:
webshop@dalathasfarm.com
Hotline:
1800 1143
Hỏi đáp & cảm nhận người dùng