Title: SmartCrawl WordPress SEO (slow SQL queries) Last modified: February 25, 2020 --- # SmartCrawl WordPress SEO (slow SQL queries) * Resolved [krut1](https://wordpress.org/support/users/krut1/) * (@krut1) * [6 years, 5 months ago](https://wordpress.org/support/topic/smartcrawl-wordpress-seo/) * Hi people, your plugin (SmartCrawl v2.5.0) has a slow queries, that 48 hours works. This happens if you have 100 products and more than 50 keywords per each produkt. * You has **48 times** `INNER JOIN` in your logic. It ist not a good idea 🙁 * There is an example of your query: * ``` 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 ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) INNER JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) INNER JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id ) INNER JOIN wp_postmeta AS mt6 ON ( wp_posts.ID = mt6.post_id ) INNER JOIN wp_postmeta AS mt7 ON ( wp_posts.ID = mt7.post_id ) INNER JOIN wp_postmeta AS mt8 ON ( wp_posts.ID = mt8.post_id ) INNER JOIN wp_postmeta AS mt9 ON ( wp_posts.ID = mt9.post_id ) INNER JOIN wp_postmeta AS mt10 ON ( wp_posts.ID = mt10.post_id ) INNER JOIN wp_postmeta AS mt11 ON ( wp_posts.ID = mt11.post_id ) INNER JOIN wp_postmeta AS mt12 ON ( wp_posts.ID = mt12.post_id ) INNER JOIN wp_postmeta AS mt13 ON ( wp_posts.ID = mt13.post_id ) INNER JOIN wp_postmeta AS mt14 ON ( wp_posts.ID = mt14.post_id ) INNER JOIN wp_postmeta AS mt15 ON ( wp_posts.ID = mt15.post_id ) INNER JOIN wp_postmeta AS mt16 ON ( wp_posts.ID = mt16.post_id ) INNER JOIN wp_postmeta AS mt17 ON ( wp_posts.ID = mt17.post_id ) INNER JOIN wp_postmeta AS mt18 ON ( wp_posts.ID = mt18.post_id ) INNER JOIN wp_postmeta AS mt19 ON ( wp_posts.ID = mt19.post_id ) INNER JOIN wp_postmeta AS mt20 ON ( wp_posts.ID = mt20.post_id ) INNER JOIN wp_postmeta AS mt21 ON ( wp_posts.ID = mt21.post_id ) INNER JOIN wp_postmeta AS mt22 ON ( wp_posts.ID = mt22.post_id ) INNER JOIN wp_postmeta AS mt23 ON ( wp_posts.ID = mt23.post_id ) INNER JOIN wp_postmeta AS mt24 ON ( wp_posts.ID = mt24.post_id ) INNER JOIN wp_postmeta AS mt25 ON ( wp_posts.ID = mt25.post_id ) INNER JOIN wp_postmeta AS mt26 ON ( wp_posts.ID = mt26.post_id ) INNER JOIN wp_postmeta AS mt27 ON ( wp_posts.ID = mt27.post_id ) INNER JOIN wp_postmeta AS mt28 ON ( wp_posts.ID = mt28.post_id ) INNER JOIN wp_postmeta AS mt29 ON ( wp_posts.ID = mt29.post_id ) INNER JOIN wp_postmeta AS mt30 ON ( wp_posts.ID = mt30.post_id ) INNER JOIN wp_postmeta AS mt31 ON ( wp_posts.ID = mt31.post_id ) INNER JOIN wp_postmeta AS mt32 ON ( wp_posts.ID = mt32.post_id ) INNER JOIN wp_postmeta AS mt33 ON ( wp_posts.ID = mt33.post_id ) INNER JOIN wp_postmeta AS mt34 ON ( wp_posts.ID = mt34.post_id ) INNER JOIN wp_postmeta AS mt35 ON ( wp_posts.ID = mt35.post_id ) INNER JOIN wp_postmeta AS mt36 ON ( wp_posts.ID = mt36.post_id ) INNER JOIN wp_postmeta AS mt37 ON ( wp_posts.ID = mt37.post_id ) INNER JOIN wp_postmeta AS mt38 ON ( wp_posts.ID = mt38.post_id ) INNER JOIN wp_postmeta AS mt39 ON ( wp_posts.ID = mt39.post_id ) INNER JOIN wp_postmeta AS mt40 ON ( wp_posts.ID = mt40.post_id ) INNER JOIN wp_postmeta AS mt41 ON ( wp_posts.ID = mt41.post_id ) INNER JOIN wp_postmeta AS mt42 ON ( wp_posts.ID = mt42.post_id ) INNER JOIN wp_postmeta AS mt43 ON ( wp_posts.ID = mt43.post_id ) INNER JOIN wp_postmeta AS mt44 ON ( wp_posts.ID = mt44.post_id ) INNER JOIN wp_postmeta AS mt45 ON ( wp_posts.ID = mt45.post_id ) INNER JOIN wp_postmeta AS mt46 ON ( wp_posts.ID = mt46.post_id ) INNER JOIN wp_postmeta AS mt47 ON ( wp_posts.ID = mt47.post_id ) WHERE 1=1 AND wp_posts.ID NOT IN (1212) AND ( ( ( wp_postmeta.meta_key = '_wds_focus-keywords' AND wp_postmeta.meta_value LIKE '%natures%' ) AND ( mt1.meta_key = '_wds_focus-keywords' AND mt1.meta_value LIKE '%sunshine%' ) AND ( mt2.meta_key = '_wds_focus-keywords' AND mt2.meta_value LIKE '%belgien%' ) AND ( mt3.meta_key = '_wds_focus-keywords' AND mt3.meta_value LIKE '%bulgarien%' ) AND ( mt4.meta_key = '_wds_focus-keywords' AND mt4.meta_value LIKE '%finnland%' ) AND ( mt5.meta_key = '_wds_focus-keywords' AND mt5.meta_value LIKE '%frankreich%' ) AND ( mt6.meta_key = '_wds_focus-keywords' AND mt6.meta_value LIKE '%griechenland%' ) AND ( mt7.meta_key = '_wds_focus-keywords' AND mt7.meta_value LIKE '%italien%' ) AND ( mt8.meta_key = '_wds_focus-keywords' AND mt8.meta_value LIKE '%netherlands%' ) AND ( mt9.meta_key = '_wds_focus-keywords' AND mt9.meta_value LIKE '%niederlande%' ) AND ( mt10.meta_key = '_wds_focus-keywords' AND mt10.meta_value LIKE '%österreich%' ) AND ( mt11.meta_key = '_wds_focus-keywords' AND mt11.meta_value LIKE '%portugal%' ) AND ( mt12.meta_key = '_wds_focus-keywords' AND mt12.meta_value LIKE '%spanien%' ) AND ( mt13.meta_key = '_wds_focus-keywords' AND mt13.meta_value LIKE '%tschechische%' ) AND ( mt14.meta_key = '_wds_focus-keywords' AND mt14.meta_value LIKE '%republik%' ) AND ( mt15.meta_key = '_wds_focus-keywords' AND mt15.meta_value LIKE '%grecovital%' ) AND ( mt16.meta_key = '_wds_focus-keywords' AND mt16.meta_value LIKE '%synergy%' ) AND ( mt17.meta_key = '_wds_focus-keywords' AND mt17.meta_value LIKE '%wwwnaturessunshineeu%' ) AND ( mt18.meta_key = '_wds_focus-keywords' AND mt18.meta_value LIKE '%nahrungsergĂ€nzung%' ) AND ( mt19.meta_key = '_wds_focus-keywords' AND mt19.meta_value LIKE '%lily%' ) AND ( mt20.meta_key = '_wds_focus-keywords' AND mt20.meta_value LIKE '%loaf%' ) AND ( mt21.meta_key = '_wds_focus-keywords' AND mt21.meta_value LIKE '%Ă€therische%' ) AND ( mt22.meta_key = '_wds_focus-keywords' AND mt22.meta_value LIKE '%öle%' ) AND ( mt23.meta_key = '_wds_focus-keywords' AND mt23.meta_value LIKE '%doterra%' ) AND ( mt24.meta_key = '_wds_focus-keywords' AND mt24.meta_value LIKE '%wwwlilyandloafeu%' ) AND ( mt25.meta_key = '_wds_focus-keywords' AND mt25.meta_value LIKE '%wwwlilyandloafcom%' ) AND ( mt26.meta_key = '_wds_focus-keywords' AND mt26.meta_value LIKE '%wwwlilyandloafde%' ) AND ( mt27.meta_key = '_wds_focus-keywords' AND mt27.meta_value LIKE '%produkte%' ) AND ( mt28.meta_key = '_wds_focus-keywords' AND mt28.meta_value LIKE '%fĂŒr%' ) AND ( mt29.meta_key = '_wds_focus-keywords' AND mt29.meta_value LIKE '%kinder%' ) AND ( mt30.meta_key = '_wds_focus-keywords' AND mt30.meta_value LIKE '%kinderprodukte%' ) AND ( mt31.meta_key = '_wds_focus-keywords' AND mt31.meta_value LIKE '%globaltradingservice%' ) AND ( mt32.meta_key = '_wds_focus-keywords' AND mt32.meta_value LIKE '%hautpflegeprodukte%' ) AND ( mt33.meta_key = '_wds_focus-keywords' AND mt33.meta_value LIKE '%tierprodukte%' ) AND ( mt34.meta_key = '_wds_focus-keywords' AND mt34.meta_value LIKE '%nutripets%' ) AND ( mt35.meta_key = '_wds_focus-keywords' AND mt35.meta_value LIKE '%naturessunshine24%' ) AND ( mt36.meta_key = '_wds_focus-keywords' AND mt36.meta_value LIKE '%nspshop24%' ) AND ( mt37.meta_key = '_wds_focus-keywords' AND mt37.meta_value LIKE '%naturessunshine%' ) AND ( mt38.meta_key = '_wds_focus-keywords' AND mt38.meta_value LIKE '%deutschland%' ) AND ( mt39.meta_key = '_wds_focus-keywords' AND mt39.meta_value LIKE '%angebot%' ) AND ( mt40.meta_key = '_wds_focus-keywords' AND mt40.meta_value LIKE '%global%' ) AND ( mt41.meta_key = '_wds_focus-keywords' AND mt41.meta_value LIKE '%trading%' ) AND ( mt42.meta_key = '_wds_focus-keywords' AND mt42.meta_value LIKE '%center%' ) AND ( mt43.meta_key = '_wds_focus-keywords' AND mt43.meta_value LIKE '%vitalproducts4you%' ) AND ( mt44.meta_key = '_wds_focus-keywords' AND mt44.meta_value LIKE '%define%' ) AND ( mt45.meta_key = '_wds_focus-keywords' AND mt45.meta_value LIKE '%body%' ) AND ( mt46.meta_key = '_wds_focus-keywords' AND mt46.meta_value LIKE '%balm%' ) AND ( mt47.meta_key = '_wds_focus-keywords' AND mt47.meta_value LIKE '%coq10%' ) ) ) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'product') AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wc-authorization' 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_posts.post_date DESC LIMIT 0, 10 ``` * Can you please fix it? - This topic was modified 6 years, 5 months ago by [krut1](https://wordpress.org/support/users/krut1/). - This topic was modified 6 years, 5 months ago by [krut1](https://wordpress.org/support/users/krut1/). * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsmartcrawl-wordpress-seo%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 1 replies (of 1 total) * [Predrag – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support1/) * (@wpmudev-support1) * [6 years, 5 months ago](https://wordpress.org/support/topic/smartcrawl-wordpress-seo/#post-12482792) * Hi [@krut1](https://wordpress.org/support/users/krut1/), * Our QA team is already testing a fix for this issue and we’re hoping to have it pushed live soon. * Cheers, Predrag Viewing 1 replies (of 1 total) The topic ‘SmartCrawl WordPress SEO (slow SQL queries)’ is closed to new replies. * ![](https://ps.w.org/smartcrawl-seo/assets/icon-256x256.gif?rev=3446894) * [SmartCrawl SEO checker, analyzer & optimizer](https://wordpress.org/plugins/smartcrawl-seo/) * [Frequently Asked Questions](https://wordpress.org/plugins/smartcrawl-seo/#faq) * [Support Threads](https://wordpress.org/support/plugin/smartcrawl-seo/) * [Active Topics](https://wordpress.org/support/plugin/smartcrawl-seo/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/smartcrawl-seo/unresolved/) * [Reviews](https://wordpress.org/support/plugin/smartcrawl-seo/reviews/) ## Tags * [query](https://wordpress.org/support/topic-tag/query/) * [sql](https://wordpress.org/support/topic-tag/sql/) * 1 reply * 2 participants * Last reply from: [Predrag – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support1/) * Last activity: [6 years, 5 months ago](https://wordpress.org/support/topic/smartcrawl-wordpress-seo/#post-12482792) * Status: resolved