cant convert keys on _postmeta & _posts

My Id (w22LqgnR)
the first issue was fixed, but nothing website still slow and WP_Query->get_posts() load too slow some times load at 26 sec

WP_Query->get_posts( Main Query ) at 26 sec

SELECT?SQL_CALC_FOUND_ROWS mVkV6_posts.ID
FROM?mVkV6_posts
LEFT?JOIN?mVkV6_term_relationships
ON?(mVkV6_posts.ID = mVkV6_term_relationships.object_id)
INNER?JOIN?mVkV6_postmeta
ON?( mVkV6_posts.ID = mVkV6_postmeta.post_id )
INNER?JOIN?mVkV6_postmeta?AS?mt1
ON?( mVkV6_posts.ID = mt1.post_id )
LEFT?JOIN?mVkV6_wc_product_meta_lookup wc_product_meta_lookup
ON?mVkV6_posts.ID = wc_product_meta_lookup.product_id
WHERE?1=1
AND?( mVkV6_posts.ID?NOT?IN?(
SELECT?object_id
FROM?mVkV6_term_relationships
WHERE?term_taxonomy_id?IN?(7,9) )
AND?mVkV6_term_relationships.term_taxonomy_id?IN?(131,353,354,355,356,357,358,359,360,361,362,403) )
AND?( ( mVkV6_postmeta.meta_key = '_price'
AND?CAST(mVkV6_postmeta.meta_value?AS?SIGNED) != '' )
OR?( mt1.meta_key = '_price'
AND?CAST(mt1.meta_value?AS?SIGNED) != '0' ) )
AND?((mVkV6_posts.post_type = 'product'
AND?(mVkV6_posts.post_status = 'publish'
OR?mVkV6_posts.post_status = 'private')))
GROUP?BY?mVkV6_posts.ID
ORDER?BY?wc_product_meta_lookup.total_sales?DESC, wc_product_meta_lookup.product_id?DESC
LIMIT?0, 12

• This reply was modified 3 months, 1 week ago by belalzekry.

I’m happy to hear you sorted out your first problem. And, for me to help you with your second problem it will be very useful if you upload your database metadata. Please reply to this topic to let me know your upload id. Please read this. https://www.ads-software.com/support/topic/please-when-you-report-a-problem-or-ask-for-help/

And do consider adding a persistent object cache to your site. It caches results of archive-page queries like the one you showed me.

eaANAJRA

Sorry to say, I don’t see any upload with that ID. Try again?