Slow Queries - визначити причину і виправити
хостинг 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 |
Також на графіку видно піки навантаження. Потрібно зрозуміти, що є причиною
-
1 day223 USD
105 1 day223 USD
Hi, I can manage the work I have a great experience.
-
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 2 days 5 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 23 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 3 days 16 hours back ∙ 90 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 3 days 19 hours back ∙ 18 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 5 days 17 hours back ∙ 6 proposals |
Lvov