jedxie

( 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;