хостинг Ukraine. Сайт на WooCommerce.
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_languages' ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_id INNER JOIN wp_postmeta istockstatus ON (wp_posts.ID = istockstatus.post_id)
WHERE 1=1 AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
wp_term_relationships.term_taxonomy_id IN (20,21,29,30,31,32,33,39,42,43,44,46,47,48,98,99)
) AND (
(
wp_postmeta.post_id IS NULL
OR
( mt1.meta_key = '_languages' AND mt1.meta_value LIKE '%s:2:\\"uk\\";%' )
)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'cwg_mailsent' OR wp_posts.post_status = 'cwg_mailnotsent' OR wp_posts.post_status = 'cwg_subscribed' OR wp_posts.post_status = 'cwg_unsubscribed' OR wp_posts.post_status = 'cwg_converted')))
GROUP BY wp_posts.ID
ORDER BY istockstatus.meta_value ASC, wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC
LIMIT 0, 12
| Тип вибірки | Можливі ключі | Ключ | Посилання | Рядки | Додаткова інформація |
| PRIMARY : wp_term_relationships range | PRIMARY,term_taxonomy_id | term_taxonomy_id (8) | 1309 | Using index condition; Using where; Using temporary; Using filesort | |
| PRIMARY : wp_posts eq_ref | PRIMARY,type_status_date | PRIMARY (8) | allface_site.wp_term_relationships.object_id | 1 | Using where |
| PRIMARY : istockstatus ref | post_id,meta_key | post_id (8) | allface_site.wp_term_relationships.object_id | 40 | Using where |
| PRIMARY : wp_postmeta ref | post_id,meta_key | meta_key (767) | const | 22 | Using where |
| PRIMARY : mt1 ref | post_id | post_id (8) | allface_site.wp_term_relationships.object_id | 40 | Using where |
| PRIMARY : wc_product_meta_lookup eq_ref | PRIMARY | PRIMARY (8) | allface_site.wp_term_relationships.object_id | 1 | Using where |
| SUBQUERY : wp_term_relationships ref | PRIMARY,term_taxonomy_id | term_taxonomy_id (8) | const | 1 |
Також на графіку видно піки навантаження. Потрібно зрозуміти, що є причиною
Budget: 10000 UAH Deadline: 1 day
Hi, I can manage the work I have a great experience.
-
