Bộ lọc
Xóa bộ lọc
Thể loại trang điểm - Từ khóa chính của trang
Xịt Make Up – MAC Prep
316.800đ 376.200đ -15%
Kem che khuyết điểm Nar
564.300đ 594.000đ -5%
Phấn má hồng MAYBELLINE
108.900đ 118.800đ -8%
316.800đ 376.200đ -15%
564.300đ 594.000đ -5%
108.900đ 118.800đ -8%
tiếng việt
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
select `code`, `is_default` from `wb_language` where `is_published` = '1'
660μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_language` (SIMPLE)
41Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_language |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 4 |
Extra | Using where |
select `id`, `taxonomy_type`, `taxonomy_id`, `slug` from `wb_seo` where `taxonomy_type` in ('page', 'group') and `lang_code` = 'vi'
260μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 66 |
Extra | Using where |
select * from `wb_addon`
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_addon` (SIMPLE)
31Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_addon |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 3 |
Extra | null |
select `key`, `value` from `wb_config`
230μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
611Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 61 |
Extra | null |
select * from `wb_config` where `key` = 'address' limit 1
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | const |
possible_keys | key |
key | key |
key_len | 575 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_config_description` where `wb_config_description`.`config_id` in ('14') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config_description |
type | const |
possible_keys | config_id |
key | config_id |
key_len | 21 |
ref | const,const |
rows | 1 |
Extra | null |
select `wb_page`.`id`, `wb_page_description`.`title` from `wb_page` inner join `wb_page_description` on `wb_page`.`id` = `wb_page_description`.`page_id` where `wb_page`.`type` = 'contact' and `wb_page_description`.`lang_code` = 'vi' limit 1
180μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_page` (SIMPLE)
71Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_page |
type | ALL |
possible_keys | PRIMARY |
key | null |
key_len | null |
ref | null |
rows | 7 |
Extra | Using where |
- EXPLAIN #1: `wb_page_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_page_description |
type | eq_ref |
possible_keys | lang_code |
key | lang_code |
key_len | 51 |
ref | const,wb_web_ky_thuat_202310071_s1_loveitop_com.wb_page.id |
rows | 1 |
Extra | Using index condition |
select `taxonomy_id`, `taxonomy_id`, `slug` from `wb_seo` where `wb_seo`.`taxonomy_id` in ('54') and `wb_seo`.`taxonomy_type` = 'page' and `lang_code` = 'vi' order by `id` desc
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | index |
possible_keys | null |
key | PRIMARY |
key_len | 4 |
ref | null |
rows | 66 |
Extra | Using where |
select `code` from `wb_language` where `is_default` = '1' limit 1
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_language` (SIMPLE)
41Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_language |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 4 |
Extra | Using where |
select `id`, `folder_name` from `wb_theme` where `is_published` = '1' limit 1
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_theme` (SIMPLE)
121Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_theme |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 12 |
Extra | Using where |
select `type`, `key`, `value` from `wb_template_custom` where `theme_id` = '19' and `is_active` = '1'
150μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_template_custom` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_template_custom |
type | ref |
possible_keys | IDX_FE |
key | IDX_FE |
key_len | 5 |
ref | const |
rows | 2 |
Extra | Using index condition |
select `wb_category`.`id`, `wb_category`.`taxonomy`, `wb_category`.`parent_id`, `wb_category`.`created_at`, `wb_category_description`.`title`, `wb_category`.`thumbnail` from `wb_category` inner join `wb_category_description` on `wb_category`.`id` = `wb_category_description`.`cat_id` where `wb_category_description`.`lang_code` = 'vi'
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_category` (SIMPLE)
71Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_category |
type | ALL |
possible_keys | PRIMARY |
key | null |
key_len | null |
ref | null |
rows | 7 |
Extra | null |
- EXPLAIN #1: `wb_category_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_category_description |
type | eq_ref |
possible_keys | cat_id |
key | cat_id |
key_len | 51 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_category.id,const |
rows | 1 |
Extra | Using index condition |
select `taxonomy_id`, `slug` from `wb_seo` where `wb_seo`.`taxonomy_id` in ('11', '12', '13', '14', '15', '16', '17', '18', '19') and `wb_seo`.`taxonomy_type` = 'category' and `lang_code` = 'vi' order by `id` desc
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | index |
possible_keys | null |
key | PRIMARY |
key_len | 4 |
ref | null |
rows | 66 |
Extra | Using where |
select `name`, `position`, `content`, `config` from `wb_tag_html`
110μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_tag_html` (SIMPLE)
81Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_tag_html |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 8 |
Extra | null |
select `value` from `wb_config` where `key` = 'website_expired_date' limit 1
150μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | const |
possible_keys | key |
key | key |
key_len | 575 |
ref | const |
rows | 1 |
Extra | null |
select `key`, `value` from `wb_config` where `key` = 'is_locked' limit 1
130μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `` (SIMPLE)
null1Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | null |
type | null |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | null |
Extra | Impossible WHERE noticed after reading const tables |
select `key`, `value` from `wb_config` where `key` in ('redirects', 'redirects_1', 'redirects_2', 'redirects_3')
140μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
41Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | range |
possible_keys | key |
key | key |
key_len | 575 |
ref | null |
rows | 4 |
Extra | Using index condition |
select * from `wb_seo` where `slug` = 'trang-diem' and `lang_code` = 'vi' and `taxonomy_type` = 'category'
230μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 66 |
Extra | Using where |
select * from `wb_category` where `wb_category`.`id` = '15' limit 1
200μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_category` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_category |
type | const |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_category_description` where `wb_category_description`.`cat_id` in ('15') and `lang_code` = 'vi'
290μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_category_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_category_description |
type | const |
possible_keys | cat_id |
key | cat_id |
key_len | 51 |
ref | const,const |
rows | 1 |
Extra | null |
select count(*) as aggregate from `wb_product` left join `wb_product_limit_order` on `wb_product`.`id` = `wb_product_limit_order`.`product_id` inner join `wb_product_description` on `wb_product`.`id` = `wb_product_description`.`product_id` inner join `wb_seo` on `wb_product`.`id` = `wb_seo`.`taxonomy_id` where (`deleted_by` is null or `deleted_by` = '') and `is_published` = '1' and `published_at` <= '2025-04-04 05:59:59' and `wb_product_description`.`lang_code` = 'vi' and `wb_seo`.`lang_code` = 'vi' and `wb_seo`.`taxonomy_type` = 'product' and (`wb_product`.`deleted_by` is null or `wb_product`.`deleted_by` = '') and (`wb_product`.`cat_id` in ('15') or (`wb_product`.`other_cat_ids` LIKE '%\"15\"%'))
310μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 66 |
Extra | Using where |
- EXPLAIN #1: `wb_product` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_seo.taxonomy_id |
rows | 1 |
Extra | Using where |
- EXPLAIN #1: `wb_product_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_description |
type | eq_ref |
possible_keys | product_id |
key | product_id |
key_len | 21 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_product.id,const |
rows | 1 |
Extra | Using where; Using index |
- EXPLAIN #1: `wb_product_limit_order` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_limit_order |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 1 |
Extra | Using where; Using join buffer (Block Nested Loop) |
select distinct `wb_product`.`id`, `wb_product`.`code`, `wb_product`.`quantity`, `wb_product`.`cat_id`, `wb_product`.`other_cat_ids`, `wb_product`.`price`, `wb_product`.`sale_price`, `wb_product`.`thumbnail`, `wb_product`.`gallery`, `wb_product`.`manufacturer_id`, `wb_product`.`in_stock`, `wb_product`.`view_count`, `wb_product`.`sort_order`, `wb_product`.`type`, `wb_product`.`is_published`, `wb_product`.`published_at`, `wb_product`.`created_at`, `wb_product`.`updated_at`, `wb_product`.`rating`, `wb_product`.`purchased`, `wb_product_description`.`lang_code`, `wb_product_description`.`title`, `wb_product_description`.`description`, `wb_product_description`.`config`, `wb_product_limit_order`.`minimum`, `wb_seo`.`meta_title` from `wb_product` left join `wb_product_limit_order` on `wb_product`.`id` = `wb_product_limit_order`.`product_id` inner join `wb_product_description` on `wb_product`.`id` = `wb_product_description`.`product_id` inner join `wb_seo` on `wb_product`.`id` = `wb_seo`.`taxonomy_id` where (`deleted_by` is null or `deleted_by` = '') and `is_published` = '1' and `published_at` <= '2025-04-04 05:59:59' and `wb_product_description`.`lang_code` = 'vi' and `wb_seo`.`lang_code` = 'vi' and `wb_seo`.`taxonomy_type` = 'product' and (`wb_product`.`deleted_by` is null or `wb_product`.`deleted_by` = '') and (`wb_product`.`cat_id` in ('15') or (`wb_product`.`other_cat_ids` LIKE '%\"15\"%')) order by `sort_order` desc, `id` desc, `sort_order` desc, `id` desc limit 10 offset 0
700μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 66 |
Extra | Using where; Using temporary; Using filesort |
- EXPLAIN #1: `wb_product` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_seo.taxonomy_id |
rows | 1 |
Extra | Using where |
- EXPLAIN #1: `wb_product_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_description |
type | eq_ref |
possible_keys | product_id |
key | product_id |
key_len | 21 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_product.id,const |
rows | 1 |
Extra | Using index condition |
- EXPLAIN #1: `wb_product_limit_order` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_limit_order |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 1 |
Extra | Using where; Using join buffer (Block Nested Loop) |
select `taxonomy_id`, `taxonomy_id`, `slug`, `other_link`, `is_newtab_other_link` from `wb_seo` where `wb_seo`.`taxonomy_id` in ('19', '20', '21') and `wb_seo`.`taxonomy_type` = 'product' and `lang_code` = 'vi' order by `id` desc
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | index |
possible_keys | null |
key | PRIMARY |
key_len | 4 |
ref | null |
rows | 66 |
Extra | Using where |
select * from `wb_product_option` where `wb_product_option`.`product_id` in ('19', '20', '21')
130μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_product_option` (SIMPLE)
251Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_option |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 25 |
Extra | Using where |
select * from `wb_category` where `parent_id` = '15' order by `sort_order` desc
220μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_category` (SIMPLE)
71Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_category |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 7 |
Extra | Using where; Using filesort |
select * from `wb_widget_page` where `widget_taxonomy` = 'search_house' and `is_published` = '1' and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
210μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select `key`, `value` from `wb_addon` where `wb_addon`.`key` = 'product_filter' limit 1
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_addon` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_addon |
type | const |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_config` where `key` = 'products_filter' limit 1
90μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | const |
possible_keys | key |
key | key |
key_len | 575 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_config_description` where `wb_config_description`.`config_id` in ('33') and `lang_code` = 'vi'
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config_description |
type | const |
possible_keys | config_id |
key | config_id |
key_len | 21 |
ref | const,const |
rows | 1 |
Extra | null |
select * from `wb_option` where `parent_id` in ('1', '4') order by `sort_order` asc
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_option` (SIMPLE)
91Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_option |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 9 |
Extra | Using where; Using filesort |
select * from `wb_option_description` where `wb_option_description`.`option_id` in ('2', '3', '5', '6', '7', '8', '9') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_option_description` (SIMPLE)
71Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_option_description |
type | ref |
possible_keys | lang_code |
key | lang_code |
key_len | 17 |
ref | const |
rows | 7 |
Extra | Using index condition |
select * from `wb_widget_page` where `position` in ('sidebar') and `type` in ('0', '2') and `block` in ('1', '2') and `is_published` in ('1', '2', '3', '4', '5', '6') and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
220μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select * from `wb_widget_page_description` where `wb_widget_page_description`.`widget_page_id` in ('14', '16', '17', '28', '29') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page_description` (SIMPLE)
141Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page_description |
type | ref |
possible_keys | lang_code |
key | lang_code |
key_len | 47 |
ref | const |
rows | 14 |
Extra | Using index condition |
select * from `wb_config` where `key` = 'products_filter' limit 1
130μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | const |
possible_keys | key |
key | key |
key_len | 575 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_config_description` where `wb_config_description`.`config_id` in ('33') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config_description |
type | const |
possible_keys | config_id |
key | config_id |
key_len | 21 |
ref | const,const |
rows | 1 |
Extra | null |
select max(`price`) as aggregate from `wb_product` where `is_published` = '1' and `published_at` <= '2025-04-04 05:59:59' and (`deleted_by` is null or `deleted_by` = '')
180μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_product` (SIMPLE)
221Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 22 |
Extra | Using where |
select `name`, `id` from `wb_manufacturer`
150μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_manufacturer` (SIMPLE)
41Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_manufacturer |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 4 |
Extra | null |
select * from `wb_option` where `parent_id` in ('1', '4') order by `sort_order` asc
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_option` (SIMPLE)
91Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_option |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 9 |
Extra | Using where; Using filesort |
select * from `wb_option_description` where `wb_option_description`.`option_id` in ('2', '3', '5', '6', '7', '8', '9') and `lang_code` = 'vi'
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_option_description` (SIMPLE)
71Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_option_description |
type | ref |
possible_keys | lang_code |
key | lang_code |
key_len | 17 |
ref | const |
rows | 7 |
Extra | Using index condition |
select * from `wb_group_feature` where `wb_group_feature`.`id` = '3' limit 1
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_group_feature` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_group_feature |
type | const |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_seo` where `wb_seo`.`taxonomy_id` in ('3') and `wb_seo`.`taxonomy_type` = 'group' and `lang_code` = 'vi' order by `id` desc
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | index |
possible_keys | null |
key | PRIMARY |
key_len | 4 |
ref | null |
rows | 66 |
Extra | Using where |
select distinct `wb_product`.`id`, `wb_product`.`code`, `wb_product`.`quantity`, `wb_product`.`cat_id`, `wb_product`.`other_cat_ids`, `wb_product`.`price`, `wb_product`.`sale_price`, `wb_product`.`thumbnail`, `wb_product`.`gallery`, `wb_product`.`manufacturer_id`, `wb_product`.`in_stock`, `wb_product`.`view_count`, `wb_product`.`sort_order`, `wb_product`.`type`, `wb_product`.`is_published`, `wb_product`.`published_at`, `wb_product`.`created_at`, `wb_product`.`updated_at`, `wb_product`.`rating`, `wb_product`.`purchased`, `wb_product_description`.`lang_code`, `wb_product_description`.`title`, `wb_product_description`.`description`, `wb_product_description`.`config`, `wb_product_limit_order`.`minimum`, `wb_seo`.`meta_title` from `wb_product` left join `wb_product_limit_order` on `wb_product`.`id` = `wb_product_limit_order`.`product_id` inner join `wb_product_description` on `wb_product`.`id` = `wb_product_description`.`product_id` inner join `wb_seo` on `wb_product`.`id` = `wb_seo`.`taxonomy_id` where (`deleted_by` is null or `deleted_by` = '') and `is_published` = '1' and `published_at` <= '2025-04-04 05:59:59' and `wb_product_description`.`lang_code` = 'vi' and `wb_seo`.`lang_code` = 'vi' and `wb_seo`.`taxonomy_type` = 'product' order by `wb_product`.`published_at` asc limit 6 offset 0
800μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 66 |
Extra | Using where; Using temporary; Using filesort |
- EXPLAIN #1: `wb_product` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_seo.taxonomy_id |
rows | 1 |
Extra | Using where |
- EXPLAIN #1: `wb_product_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_description |
type | eq_ref |
possible_keys | product_id |
key | product_id |
key_len | 21 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_product.id,const |
rows | 1 |
Extra | Using index condition |
- EXPLAIN #1: `wb_product_limit_order` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_limit_order |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 1 |
Extra | Using where; Using join buffer (Block Nested Loop) |
select `taxonomy_id`, `taxonomy_id`, `slug`, `other_link`, `is_newtab_other_link` from `wb_seo` where `wb_seo`.`taxonomy_id` in ('4', '6', '13', '18', '20', '21') and `wb_seo`.`taxonomy_type` = 'product' and `lang_code` = 'vi' order by `id` desc
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | index |
possible_keys | null |
key | PRIMARY |
key_len | 4 |
ref | null |
rows | 66 |
Extra | Using where |
select * from `wb_product_option` where `wb_product_option`.`product_id` in ('4', '6', '13', '18', '20', '21')
150μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_product_option` (SIMPLE)
251Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_product_option |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 25 |
Extra | Using where |
select * from `wb_group_feature` where `wb_group_feature`.`id` = '1' limit 1
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_group_feature` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_group_feature |
type | const |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_seo` where `wb_seo`.`taxonomy_id` in ('1') and `wb_seo`.`taxonomy_type` = 'group' and `lang_code` = 'vi' order by `id` desc
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | index |
possible_keys | null |
key | PRIMARY |
key_len | 4 |
ref | null |
rows | 66 |
Extra | Using where |
select distinct `wb_post`.`id`, `wb_post`.`cat_id`, `wb_post`.`other_cat_ids`, `wb_post`.`created_at`, `wb_post`.`published_at`, `wb_post`.`thumbnail`, `wb_post`.`view_count`, `wb_post_description`.`description`, `wb_post_description`.`title` from `wb_post` inner join `wb_post_description` on `wb_post`.`id` = `wb_post_description`.`post_id` where `is_published` = '1' and `published_at` <= '2025-04-04 05:59:59' and (`deleted_by` is null or `deleted_by` = '') and `wb_post_description`.`lang_code` = 'vi' order by `published_at` desc, `id` desc limit 6 offset 0
490μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_post` (SIMPLE)
91Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_post |
type | ALL |
possible_keys | PRIMARY |
key | null |
key_len | null |
ref | null |
rows | 9 |
Extra | Using where; Using temporary; Using filesort |
- EXPLAIN #1: `wb_post_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_post_description |
type | eq_ref |
possible_keys | post_id |
key | post_id |
key_len | 21 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_post.id,const |
rows | 1 |
Extra | Using index condition |
select `taxonomy_id`, `taxonomy_id`, `slug`, `other_link`, `is_newtab_other_link` from `wb_seo` where `wb_seo`.`taxonomy_id` in ('106', '107', '108', '109', '110', '111') and `wb_seo`.`taxonomy_type` = 'post' and `lang_code` = 'vi' order by `id` desc
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | index |
possible_keys | null |
key | PRIMARY |
key_len | 4 |
ref | null |
rows | 66 |
Extra | Using where |
select * from `wb_widget_page` where `position` in ('header') and `type` in ('0', '2') and `block` in ('1', '2') and `is_published` in ('1', '2', '3', '4', '5', '6') and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
240μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select * from `wb_widget_page_description` where `wb_widget_page_description`.`widget_page_id` in ('65', '85') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page_description` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page_description |
type | range |
possible_keys | lang_code |
key | lang_code |
key_len | 51 |
ref | null |
rows | 2 |
Extra | Using index condition |
select * from `wb_seo` where `taxonomy_type` = 'category' and `taxonomy_id` = '15' and `lang_code` = 'en'
240μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 66 |
Extra | Using where |
select `wb_menu_item`.`id`, `wb_menu_item`.`parent_id`, `wb_menu_item`.`taxonomy`, `wb_menu_item`.`taxonomy_id`, `wb_menu_item`.`link`, `wb_menu_item`.`icon`, `wb_menu_item`.`menu_name_order`, `wb_menu_item`.`is_new_tab`, `wb_menu_item_description`.`lang_code`, `wb_menu_item_description`.`name` from `wb_menu_item` inner join `wb_menu_item_description` on `wb_menu_item`.`id` = `wb_menu_item_description`.`menu_item_id` where `wb_menu_item`.`menu_id` = '0' and `wb_menu_item`.`is_published` = '1' and `wb_menu_item_description`.`lang_code` = 'vi' order by `wb_menu_item`.`sort_order` asc
130μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_menu_item_description` (SIMPLE)
261Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_menu_item_description |
type | ALL |
possible_keys | menu_id |
key | null |
key_len | null |
ref | null |
rows | 26 |
Extra | Using where; Using temporary; Using filesort |
- EXPLAIN #1: `wb_menu_item` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_menu_item |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_menu_item_description.menu_item_id |
rows | 1 |
Extra | Using where |
select * from `wb_seo` where `taxonomy_type` = 'category' and `taxonomy_id` = '15' and `lang_code` = 'en'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_seo` (SIMPLE)
661Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_seo |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 66 |
Extra | Using where |
select `wb_menu_item`.`id`, `wb_menu_item`.`parent_id`, `wb_menu_item`.`taxonomy`, `wb_menu_item`.`taxonomy_id`, `wb_menu_item`.`link`, `wb_menu_item`.`icon`, `wb_menu_item`.`menu_name_order`, `wb_menu_item`.`is_new_tab`, `wb_menu_item_description`.`lang_code`, `wb_menu_item_description`.`name` from `wb_menu_item` inner join `wb_menu_item_description` on `wb_menu_item`.`id` = `wb_menu_item_description`.`menu_item_id` where `wb_menu_item`.`menu_id` = '0' and `wb_menu_item`.`is_published` = '1' and `wb_menu_item_description`.`lang_code` = 'vi' order by `wb_menu_item`.`sort_order` asc
210μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_menu_item_description` (SIMPLE)
261Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_menu_item_description |
type | ALL |
possible_keys | menu_id |
key | null |
key_len | null |
ref | null |
rows | 26 |
Extra | Using where; Using temporary; Using filesort |
- EXPLAIN #1: `wb_menu_item` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_menu_item |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_menu_item_description.menu_item_id |
rows | 1 |
Extra | Using where |
select * from `wb_widget_page` where `position` in ('footer_top') and `type` in ('0', '2') and `block` in ('1', '2') and `is_published` in ('1', '2', '3', '4', '5', '6') and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
220μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select * from `wb_widget_page_description` where `wb_widget_page_description`.`widget_page_id` in ('25') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page_description |
type | const |
possible_keys | lang_code |
key | lang_code |
key_len | 51 |
ref | const,const |
rows | 1 |
Extra | null |
select * from `wb_widget_page` where `position` in ('footer') and `type` in ('0', '2') and `block` in ('1') and `is_published` in ('1', '2', '3', '4', '5', '6') and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
220μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select * from `wb_widget_page_description` where `wb_widget_page_description`.`widget_page_id` in ('10', '20') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page_description` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page_description |
type | range |
possible_keys | lang_code |
key | lang_code |
key_len | 51 |
ref | null |
rows | 2 |
Extra | Using index condition |
select * from `wb_widget_page` where `position` in ('footer') and `type` in ('0', '2') and `block` in ('2') and `is_published` in ('1', '2', '3', '4', '5', '6') and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
220μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select * from `wb_widget_page_description` where `wb_widget_page_description`.`widget_page_id` in ('11') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page_description |
type | const |
possible_keys | lang_code |
key | lang_code |
key_len | 51 |
ref | const,const |
rows | 1 |
Extra | null |
select `wb_menu_item`.`id`, `wb_menu_item`.`parent_id`, `wb_menu_item`.`taxonomy`, `wb_menu_item`.`taxonomy_id`, `wb_menu_item`.`link`, `wb_menu_item`.`icon`, `wb_menu_item`.`menu_name_order`, `wb_menu_item`.`is_new_tab`, `wb_menu_item_description`.`lang_code`, `wb_menu_item_description`.`name` from `wb_menu_item` inner join `wb_menu_item_description` on `wb_menu_item`.`id` = `wb_menu_item_description`.`menu_item_id` where `wb_menu_item`.`menu_id` = '1' and `wb_menu_item`.`is_published` = '1' and `wb_menu_item_description`.`lang_code` = 'vi' order by `wb_menu_item`.`sort_order` asc
190μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `wb_menu_item_description` (SIMPLE)
261Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_menu_item_description |
type | ALL |
possible_keys | menu_id |
key | null |
key_len | null |
ref | null |
rows | 26 |
Extra | Using where; Using temporary; Using filesort |
- EXPLAIN #1: `wb_menu_item` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_menu_item |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | wb_web_ky_thuat_202310071_s1_loveitop_com.wb_menu_item_description.menu_item_id |
rows | 1 |
Extra | Using where |
select * from `wb_widget_page` where `position` in ('footer') and `type` in ('0', '2') and `block` in ('3') and `is_published` in ('1', '2', '3', '4', '5', '6') and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
210μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select * from `wb_widget_page` where `position` in ('footer_bottom') and `type` in ('0', '2') and `block` in ('1', '2') and `is_published` in ('1', '2', '3', '4', '5', '6') and `widget_taxonomy` in ('product_filter', 'topbar', 'header', 'slider', 'maps', 'service_price_table', 'testimonial', 'post_category', 'product_category', 'post_category_init', 'product_sub_category', 'newsletter', 'countdown', 'partner', 'fanpage_fb', 'footer', 'form', 'form_contact', 'gallery_image', 'accordion', 'call_to_action', 'banner', 'service', 'text_editor', 'social_links', 'menu', 'post', 'product', 'payment_method', 'popup', 'growth_data', 'statistic', 'youtube') and `page_id` = '0' order by `sort_order` asc
220μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page` (SIMPLE)
281Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 28 |
Extra | Using where; Using filesort |
select * from `wb_widget_page_description` where `wb_widget_page_description`.`widget_page_id` in ('13', '78') and `lang_code` = 'vi'
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_page_description` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_page_description |
type | range |
possible_keys | lang_code |
key | lang_code |
key_len | 51 |
ref | null |
rows | 2 |
Extra | Using index condition |
select `key`, `value` from `wb_config` where `key` = 'payment_method_icon' limit 1
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | const |
possible_keys | key |
key | key |
key_len | 575 |
ref | const |
rows | 1 |
Extra | null |
select `key`, `value` from `wb_config` where `key` = 'other_payment_method' limit 1
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `` (SIMPLE)
null1Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | null |
type | null |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | null |
Extra | Impossible WHERE noticed after reading const tables |
select * from `wb_widget_form_item` where (`widget_page_id` = '78' and `lang_code` = 'vi') order by `sort_order` asc
170μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_widget_form_item` (SIMPLE)
421Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_widget_form_item |
type | ALL |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | 42 |
Extra | Using where; Using filesort |
select * from `wb_config` where `key` = 'popup' limit 1
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config |
type | const |
possible_keys | key |
key | key |
key_len | 575 |
ref | const |
rows | 1 |
Extra | null |
select * from `wb_config_description` where `wb_config_description`.`config_id` in ('64') and `lang_code` = 'vi'
160μs/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:70wb_web_ky_thuat_202310071_s1_loveitop_comMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `wb_config_description` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | wb_config_description |
type | const |
possible_keys | config_id |
key | config_id |
key_len | 21 |
ref | const,const |
rows | 1 |
Extra | null |