I can’t edit size chart

( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451]%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451]%’ )
) AND ((wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’
OR wp_posts.post_status = ‘private’)))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value DESC
LIMIT 0, 10;
# Time: 2022-07-15T16:36:26.582290Z
# User@Host: topek[topek] @ localhost [] Id: 3163744
# Query_time: 84.606490 Lock_time: 0.000264 Rows_sent: 0 Rows_examined: 38766622
SET timestamp=1657902986;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘prod-chart’ AND wp_postmeta.meta_value = ‘77451’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%77451%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451]%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451]%’ )
) AND ((wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’
OR wp_posts.post_status = ‘private’)))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value DESC
LIMIT 0, 10;
# Time: 2022-07-15T16:38:34.361286Z
# User@Host: topek[topek] @ localhost [] Id: 3164009
# Query_time: 71.923446 Lock_time: 0.000274 Rows_sent: 0 Rows_examined: 38766622
SET timestamp=1657903114;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘prod-chart’ AND wp_postmeta.meta_value = ‘77451’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%77451%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451]%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451]%’ )
) AND ((wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’
OR wp_posts.post_status = ‘private’)))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value DESC
LIMIT 0, 10;
# Time: 2022-07-15T16:48:37.696968Z
# User@Host: topek[topek] @ localhost [] Id: 3164867
# Query_time: 71.627486 Lock_time: 0.000325 Rows_sent: 0 Rows_examined: 38766622
SET timestamp=1657903717;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘prod-chart’ AND wp_postmeta.meta_value = ‘77451’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%77451%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451]%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451]%’ )
) AND ((wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’
OR wp_posts.post_status = ‘private’)))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value DESC
LIMIT 0, 10;
# Time: 2022-07-15T16:49:55.605866Z
# User@Host: topek[topek] @ localhost [] Id: 3164974
# Query_time: 75.171389 Lock_time: 0.000165 Rows_sent: 0 Rows_examined: 38766622
SET timestamp=1657903795;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘prod-chart’ AND wp_postmeta.meta_value = ‘77451’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%77451%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451,%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%,77451]%’ )
OR
( mt1.meta_key = ‘prod-chart’ AND mt1.meta_value LIKE ‘%[77451]%’ )
) AND ((wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’
OR wp_posts.post_status = ‘private’)))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value DESC
LIMIT 0, 10;

Hello Jedxie,

Thanks for reaching out!

This type of issue might come if you have more products in your store like 10k or might create multiple size charts and take time to load.

We will review mentioned query in detail and try to optimize it to increase load speed.

Best Regards,
Hitendra & Dotstore Team

Hello Jedxie,

We haven’t heard back from you in a while, so I’m going to mark this as resolved.

If you have any further questions, you can start a new thread.

Best Regards,
Hitendra & Dotstore Team