TM Completed sentences

Original	Translated

Other sentences

Original	Similar TM records
How can I optimize MySQL queries for translated pages? - WPML

viewport
width=device-width, initial-scale=1.0
Content-Type
text/html; charset=UTF-8
apple-touch-icon
180x180
https://cdn.wpml.org/wp-content/themes/sitepress/images/apple-touch-icon.png
robots
index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1
alternate
en
https://wpml.org/faq/how-to-optimize-mysql-queries/
alternate
es
https://wpml.org/es/faq/how-to-optimize-mysql-queries/
alternate
de
https://wpml.org/de/faq/how-to-optimize-mysql-queries/
alternate
fr
https://wpml.org/fr/faq/how-to-optimize-mysql-queries/
alternate
pt
https://wpml.org/pt-br/faq/how-to-optimize-mysql-queries/
alternate
ja
https://wpml.org/ja/faq/how-to-optimize-mysql-queries/
alternate
ru
https://wpml.org/ru/faq/how-to-optimize-mysql-queries/
alternate
zh
https://wpml.org/zh-hans/faq/how-to-optimize-mysql-queries/
alternate
it
https://wpml.org/it/faq/how-to-optimize-mysql-queries/
alternate
he
https://wpml.org/he/faq/how-to-optimize-mysql-queries/
alternate
ar
https://wpml.org/ar/faq/how-to-optimize-mysql-queries/
alternate
ko-kr
https://wpml.org/ko/faq/how-to-optimize-mysql-queries/
alternate
th
https://wpml.org/th/faq/how-to-optimize-mysql-queries/
alternate
vi
https://wpml.org/vi/faq/how-to-optimize-mysql-queries/
alternate
x-default
https://wpml.org/faq/how-to-optimize-mysql-queries/
How can I optimize MySQL queries for translated pages? - WPML

preload
image
https://cdn.wpml.org/wp-content/themes/sitepress/images/svg/logo-wpml-otgs.svg
high
description
When you see an unexpectedly large number of queries you can improve performance of translated pages by turning off the String Translation Tracking and Auto ID Adjust features.
canonical
https://wpml.org/faq/how-to-optimize-mysql-queries/
og:locale
en_US
og:type
article
og:title
How can I optimize MySQL queries for translated pages? - WPML
og:description
When you see an unexpectedly large number of queries you can improve performance of translated pages by turning off the String Translation Tracking and Auto ID Adjust features.
og:url
https://wpml.org/faq/how-to-optimize-mysql-queries/
og:site_name
WPML
article:modified_time
2023-09-06T08:35:34+00:00
twitter:card
summary_large_image
twitter:label1
Est. reading time
twitter:data1
1 minute
dns-prefetch
//cdn.wpml.org
https://cdn.wpml.org
preconnect
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-includes/css/dashicons.min.css?ver=1727674433
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
preload
https://cdn.wpml.org/wp-includes/css/admin-bar.min.css?ver=6.6.2
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/sitepress-multilingual-cms/dist/css/blocks/styles.css?ver=1727674429
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
stylesheet
iclMppAnchorHeader
https://cdn.wpml.org/wp-content/plugins/icl-mpp/res/css/anchor-header.css?ver=5.6.4
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/icons/css/otgs-icons.css?ver=1727674429
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
preload
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/templates/language-switchers/legacy-dropdown/style.min.css?ver=1
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
preload
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/templates/language-switchers/menu-item/style.min.css?ver=1
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/sitepress-multilingual-cms/res/css/admin-bar-style.css?ver=1727674462
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
preload
https://cdn.wpml.org/wp-content/plugins/complianz-gdpr-premium/assets/css/cookieblocker.min.css?ver=1727068597
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
preload
https://cdn.wpml.org/wp-content/themes/sitepress/css/font-awesome/font-awesome.css?ver=5.4.3
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/themes/sitepress/style.css?ver=1727674429
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/themes/sitepress/css/wpml-icons.css?ver=1727674429
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/themes/sitepress/css/single-page-simple.css?ver=1727674431
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/wordpress-seo/css/dist/adminbar-2340.css?ver=1727674462
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
1
preload
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/icl-mpp/assets/css/frontend.css?ver=1727674429
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
https://api.w.org/
https://wpml.org/wp-json/
alternate
JSON
application/json
https://wpml.org/wp-json/wp/v2/faq/7623
EditURI
application/rsd+xml
RSD
https://wpml.org/xmlrpc.php?rsd
generator
WordPress 6.6.2
generator
WooCommerce 9.3.1
alternate
oEmbed (JSON)
application/json+oembed
https://wpml.org/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwpml.org%2Ffaq%2Fhow-to-optimize-mysql-queries%2F
alternate
oEmbed (XML)
text/xml+oembed
https://wpml.org/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwpml.org%2Ffaq%2Fhow-to-optimize-mysql-queries%2F&format=xml
generator
WPML ver:4.6.13 stt:5,58,1,4,3,20,27,28,29,62,44,2,51,56;
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/wp-views/vendor/toolset/blocks/public/css/style.css?ver=1727674429
icon
https://cdn.wpml.org/wp-content/uploads/2016/05/cropped-favicon-32x32.png
32x32
icon
https://cdn.wpml.org/wp-content/uploads/2016/05/cropped-favicon-192x192.png
192x192
apple-touch-icon
https://cdn.wpml.org/wp-content/uploads/2016/05/cropped-favicon-180x180.png
msapplication-TileImage
https://cdn.wpml.org/wp-content/uploads/2016/05/cropped-favicon-270x270.png
#content
Skip Navigation
get
https://wpml.org//
search
text
s
Search
presentation
submit
Search
Vertical
navigation
https://wpml.org/faq/how-to-optimize-mysql-queries/
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/en.svg
English
18
12
https://wpml.org/es/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Spanish
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/es.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/es.svg
Spanish
18
12
https://wpml.org/de/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
German
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/de.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/de.svg
German
18
12
https://wpml.org/fr/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
French
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/fr.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/fr.svg
French
18
12
https://wpml.org/pt-br/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Portuguese (Brazil)
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/pt-br.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/pt-br.svg
Portuguese (Brazil)
18
12
https://wpml.org/ja/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Japanese
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ja.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ja.svg
Japanese
18
12
https://wpml.org/ru/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Russian
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ru.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ru.svg
Russian
18
12
https://wpml.org/zh-hans/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Chinese (Simplified)
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/zh-hans.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/zh-hans.svg
Chinese (Simplified)
18
12
https://wpml.org/it/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Italian
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/it.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/it.svg
Italian
18
12
https://wpml.org/he/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Hebrew
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/he.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/he.svg
Hebrew
18
12
https://wpml.org/ar/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Arabic
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ar.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ar.svg
Arabic
18
12
https://wpml.org/ko/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Korean
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ko.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ko.svg
Korean
18
12
https://wpml.org/th/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Thai
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/th.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/th.svg
Thai
18
12
https://wpml.org/vi/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E
Vietnamese
18
12
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/vi.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/vi.svg
Vietnamese
18
12
visibility: hidden
https://wpml.org/account/
Log In
0
https://wpml.org/
high
https://cdn.wpml.org/wp-content/themes/sitepress/images/svg/logo-wpml-otgs.svg
240
90
WPML -
Horizontal
navigation
https://wpml.org/
Home
https://wpml.org/home/about-us/
About WPML
https://wpml.org/home/minimum-requirements/
WPML’s Minimum Requirements
https://wpml.org/home/comparing-wpml-free-paid-alternatives/
Comparing WPML to Free and Paid Alternatives
https://wpml.org/showcase/
WPML Showcase
https://wpml.org/home/how-to-build-a-multilingual-wordpress-website/
How to Translate Your WordPress Website in 2024
https://wpml.org/home/blogger-resources/
Resources for Bloggers and Affiliates
https://wpml.org/testimonial/
Testimonials
https://wpml.org/home/contact-us/
Contact Us
https://wpml.org/features/
Features
https://wpml.org/purchase/
Purchase
https://wpml.org/purchase/
WPML Pricing
https://wpml.org/purchase/support-policy/
WPML Support Policy
https://wpml.org/purchase/refunds/
Refunds
https://wpml.org/purchase/purchase-process/
Purchase Process
https://wpml.org/purchase/pre-sales-questions/
Pre-sales Questions
https://wpml.org/documentation/
Documentation
https://wpml.org/documentation/getting-started-guide/
Getting Started Guide
https://wpml.org/documentation/wpml-core-and-add-on-plugins/
WPML Core and Add-on Plugins
WooCommerce Multilingual – Run E-Commerce Sites in Several Languages
https://wpml.org/documentation/related-projects/woocommerce-multilingual/
WooCommerce Multilingual
https://wpml.org/theme/
Recommended Themes for Multilingual Sites
https://wpml.org/plugin/
Recommended Plugins for Multilingual Sites
https://wpml.org/documentation/automatic-translation/
Automatic Translation for WordPress Sites with WPML
https://wpml.org/documentation/automatic-translation/wpml-ai-wordpress-translation/
WPML AI – Native Looking Translation
https://wpml.org/translation-service/
Translation Services for WordPress Websites
/faq/
FAQs
https://wpml.org/documentation/support/
Developers Information
privacy-policy
https://wpml.org/documentation/privacy-policy-and-gdpr-compliance/
Privacy Policy and GDPR Compliance
/forums/forum/english-support/
Support
/forums/forum/english-support/
Ask a support question
https://wpml.org/contractors/
Hire developers for multilingual sites
https://wpml.org/translation-reviewer/
Certified Reviewers for Automatic Translation
https://wpml.org/forums/supporters/
Meet our supporters
https://wpml.org/blog/
Blog
https://wpml.org/category/announcements/
Announcements
https://wpml.org/category/changelog/
WPML versions
https://wpml.org/category/compatibility/
Compatibility
https://wpml.org/category/tutorials/
Tutorials
https://wpml.org/mention/
Others writing about WPML
Home » FAQs » How can I optimize MySQL queries for translated pages?
https://wpml.org/
https://wpml.org/faq/
How can I optimize MySQL queries for translated pages?
You can optimize MySQL queries by first checking where problems are coming from. When you see an unexpectedly large number of queries, check your String Translation Tracking and Auto ID Adjust as potential sources.

To learn more about identifying performance issues using the Debug Objects plugin, visit our FAQ on debugging performance problems.
https://wpml.org/faq/how-to-debug-performance-problems/
How to optimize String Translation Tracking?
#how-to-optimize-string-translation-tracking
String Translation Tracking triggers SQL queries when you’re logged in as Admin. To enhance performance, navigate to WPML → String Translation and make sure that Track where strings appear on the site is not checked.

How to optimize Auto ID Adjust?
#how-to-optimize-auto-id-adjust
If Adjust IDs for multilingual functionality is selected, WPML will perform SQL queries whenever the theme tries to load items with specific IDs.
You can disable this option in in WPML → Languages → Make themes work multilingual and use icl_object_id and other functions from WPML’s API instead, to turn your theme multilingual.
https://wpml.org/documentation/support/wpml-coding-api/
WPML Coding API
- Edit
https://wpml.org/wp-admin/post.php?post=7623&action=edit&lang=en
display:none;
© 2024 OnTheGoSystems Limited (opens in a new window)
https://www.onthegosystems.com
_blank
noopener
#
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/en.svg
12
en
18
English
#
https://wpml.org/faq/how-to-optimize-mysql-queries/
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/en.svg
12
en
18
English
https://wpml.org/es/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
es
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/es.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/es.svg
12
es
18
Español
https://wpml.org/de/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
de
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/de.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/de.svg
12
de
18
Deutsch
https://wpml.org/fr/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
fr
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/fr.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/fr.svg
12
fr
18
Français
https://wpml.org/pt-br/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
pt-br
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/pt-br.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/pt-br.svg
12
pt-br
18
Português
https://wpml.org/ru/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
ru
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ru.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ru.svg
12
ru
18
Русский
https://wpml.org/it/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
it
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/it.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/it.svg
12
it
18
Italiano
https://wpml.org/ja/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
ja
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ja.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ja.svg
12
ja
18
日本語
https://wpml.org/zh-hans/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
zh-hans
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/zh-hans.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/zh-hans.svg
12
zh-hans
18
简体中文
https://wpml.org/ko/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
ko
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ko.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ko.svg
12
ko
18
한국어
https://wpml.org/th/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
th
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/th.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/th.svg
12
th
18
ไทย
https://wpml.org/vi/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
vi
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/vi.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/vi.svg
12
vi
18
Vietnamese
https://wpml.org/he/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
he
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/he.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/he.svg
12
he
18
עברית
https://wpml.org/ar/faq/how-to-optimize-mysql-queries/
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2018%2012'%3E%3C/svg%3E
12
ar
18
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ar.svg
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/res/flags/ar.svg
12
ar
18
العربية
https://www.onthegosystems.com
_blank
noopener
(opens in a new window)
https://wpml.org/home/about-us/
About WPML
https://www.onthegosystems.com/jobs/
_blank
noopener
WordPress Developer and Support Jobs (opens in a new window)
nofollow noopener
_blank
(opens in a new window) (opens in a new window) (opens in a new window)
http://twitter.com/wpml
https://www.facebook.com/WPMLcms/
https://www.youtube.com/channel/UC0-st_ubApkPzzgxuBh2T0A
nofollow noopener
_blank
nofollow noopener
_blank
skins/default/
https://cdn.wpml.org/wp-content/plugins/wonderplugin-lightbox/engine/
false
false
5000
true
bottom
2
#dc572e
1
inside
outside
true
false
8
true
true
false
true
true
false
false
false
false
false
true
true
bottom
75
true
false
true
true
#000
0.8
1
#FFF
0
96
72
12
12
48
true
%NUM / %TOTAL
{color:#333; font-size:14px; font-family:Armata,sans-serif,Arial; overflow:hidden; text-align:left;}
false
{color:#333; font-size:12px; font-family:Arial,Helvetica,sans-serif; overflow:hidden; text-align:left; margin:4px 0px 0px; padding: 0px;}
color:#fff; font-size:16px; font-family:Arial,Helvetica,sans-serif; overflow:hidden; text-align:left;
color:#fff; font-size:12px; font-family:Arial,Helvetica,sans-serif; overflow:hidden; text-align:left; margin:4px 0px 0px; padding: 0px;
color:#fff; font-size:18px; font-family:Arial,Helvetica,sans-serif; overflow:hidden; text-align:center; margin: 8px;
color:#fff; font-size:14px; font-family:Arial,Helvetica,sans-serif; overflow:hidden; text-align:center; margin:8px; padding: 0px;
#000
false
415
48
false
false
position:absolute;top:100%;right:0;
position:absolute;top:100%;right:0;left:0;
horizontal
32
18
true
true
true
true
48
true
rgba(0,0,0,0.2)
true
false
false
false
a9efd58b83
/wp-admin/admin.php?page=wonderplugin_lightbox_show_options
display:none;
true
true
dialog
polite
cmplz-header-1-optin
cmplz-message-1-optin
Manage Cookie Consent
0
button
Close dialog
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.


Functional Functional Always active
checkbox
cmplz_functional
40
1
cmplz-functional-optin
0
Required for our website to operate and communicate correctly.
Preferences Preferences
checkbox
cmplz_preferences
40
1
cmplz-preferences-optin
0
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics Statistics
checkbox
cmplz_statistics
40
1
cmplz-statistics-optin
0
We use these to analyze the statistics of our site. Collected information is completely anonymous.

The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.

Marketing Marketing
checkbox
cmplz_marketing
40
1
cmplz-marketing-optin
0
These cookies track your browsing to provide ads relevant to you.
#cmplz-manage-consent-container
Manage options Manage services Manage vendors Read more about these purposes
#
#
#
https://cookiedatabase.org/tcf/purposes/
#cmplz-cookies-overview
#cmplz-tcf-wrapper
_blank
noopener noreferrer nofollow
Accept Deny View preferences Save preferences View preferences
#
#cmplz-manage-consent-container
#
#
#
true
Manage Cookie Consent
stylesheet
syntaxHighlighter
https://cdn.wpml.org/wp-content/plugins/syntaxhighlighter/syntaxhighlighter3/styles/shCoreDefault.css?ver=6.6.2
text/css
all
preload
https://cdn.wpml.org/wp-content/themes/sitepress/css/sidebar.css?ver=5.4.3
style
style
this.onload=null;this.rel='stylesheet'
this.removeAttribute('data-rocket-async')
text/css
all
#wp-toolbar
1
Skip to toolbar
navigation
Toolbar
menu
group
menuitem
false
https://wpml.org/wp-admin/about.php
true
About WordPress
menu
About WordPress
group
menuitem
https://wpml.org/wp-admin/about.php
About WordPress
group
menuitem
https://wpml.org/wp-admin/contribute.php
Get Involved
menu
About WordPress
group
menuitem
https://wordpress.org/
WordPress.org
group
menuitem
https://wordpress.org/documentation/
Documentation
group
menuitem
https://learn.wordpress.org/
Learn WordPress
group
menuitem
https://wordpress.org/support/forums/
Support
group
menuitem
https://wordpress.org/support/forum/requests-and-feedback
Feedback
group
menuitem
false
https://wpml.org/wp-admin/
WPML
menu
WPML
group
menuitem
https://wpml.org/wp-admin/
Dashboard
group
menuitem
https://wpml.org/wp-admin/admin.php?page=wc-settings&tab=site-visibility
Live
group
menuitem
https://wpml.org/wp-admin/edit-comments.php
true
true
22 Comments in moderation
group
menuitem
false
https://wpml.org/wp-admin/post-new.php
true
New
menu
New
group
menuitem
https://wpml.org/wp-admin/post-new.php
Posts
group
menuitem
https://wpml.org/wp-admin/media-new.php
Media
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=page
Pages
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=topic
Topic
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=reply
Reply
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=tutorials
Tutorial
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=faq
FAQ
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=theme
Certified theme
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=plugin
Certified plugin
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=developer
Developer
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=website
Website
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=download
Download
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=version
Version
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=tutorial-part
Tutorial part
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=tutorial-faq-part
Tutorial FAQ part
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=products-package
Products Package
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=errata
Errata
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=extensions
Certified WooCommerce Extension
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=wpml-hook
WPML Hook
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=translation-service
Translation Service
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=testimonial
Testimonial
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=wcml-hook
WCML Hook
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=snip
snip
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=showcase
Showcase
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=contractors
Contractor
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=mpp-version
Certified version
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=hosting-partner
Hosting Partner
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=feature-request
Feature Request
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=message
Message
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=offer
Offer
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=version-update
Version update
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=upcoming-feature
Upcoming Feature
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=tran-service-review
Translation Service Review
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=job-board
Contractor Job
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=job-message
Contractor Job Message
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=mention
Mention
group
menuitem
https://wpml.org/wp-admin/post-new.php?post_type=translation-reviewer
Translation reviewer
group
menuitem
https://wpml.org/wp-admin/admin.php?page=gf_new_form
Form
group
menuitem
https://wpml.org/wp-admin/post.php?post=7623&action=edit&lang=en
Edit FAQ
group
0
menuitem
false
SEO
true
Focus keyphrase not set
Focus keyphrase not set
menu
group
0
menuitem
Focus keyphrase: not set
group
0
menuitem
SEO score:
true
Focus keyphrase not set
Focus keyphrase not set
group
0
menuitem
Readability:
true
OK
OK
group
0
menuitem
https://yoa.st/admin-bar-frontend-inspector?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Front-end SEO inspectorPremium
group
0
menuitem
false
true
Analyze this page
menu
group
menuitem
https://search.google.com/search-console/links/drilldown?resource_id=https%3A%2F%2Fwpml.org&type=EXTERNAL&target=https%3A%2F%2Fwpml.org%2Ffaq%2Fhow-to-optimize-mysql-queries%2F&domain=
_blank
noopener
Check links to this URL
group
menuitem
https://search.google.com/test/rich-results?url=https%3A%2F%2Fwpml.org%2Ffaq%2Fhow-to-optimize-mysql-queries%2F
_blank
noopener
Google Rich Results Test
group
menuitem
//developers.facebook.com/tools/debug/?q=https%3A%2F%2Fwpml.org%2Ffaq%2Fhow-to-optimize-mysql-queries%2F
_blank
noopener
Facebook Debugger
group
menuitem
//developers.google.com/speed/pagespeed/insights/?url=https%3A%2F%2Fwpml.org%2Ffaq%2Fhow-to-optimize-mysql-queries%2F
_blank
noopener
Google Page Speed Test
group
0
menuitem
false
true
SEO Tools
menu
group
menuitem
https://yoa.st/admin-bar-semrush?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Semrush
group
menuitem
https://yoa.st/admin-bar-wincher?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Wincher
group
menuitem
https://yoa.st/admin-bar-gtrends?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Google trends
group
0
menuitem
false
true
How to
menu
group
menuitem
https://yoa.st/admin-bar-learn-more-seo?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Learn more SEO
group
menuitem
https://yoa.st/admin-bar-improve-blog-post?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Improve your blog post
group
menuitem
https://yoa.st/admin-bar-write-better?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Write better content
group
0
menuitem
false
true
Help
menu
group
menuitem
https://yoa.st/admin-bar-yoast-help?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Yoast.com help section
group
menuitem
https://yoa.st/admin-bar-premium-support?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Yoast Premium support
group
menuitem
https://yoa.st/admin-bar-wp-support-forums?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
WordPress.org support forums
group
menuitem
https://yoa.st/admin-bar-learn-more-seo-help?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
noopener
Learn more SEO
group
0
menuitem
https://yoa.st/admin-bar-get-premium?php_version=8.0&platform=wordpress&platform_version=6.6.2&software=free&software_version=23.4&days_active=952&user_language=en_US
_blank
load-nfd-ctb
f6a84663-465f-4cb5-8ba5-f7a6d72224b2
padding:0;
noopener
Get Yoast SEO Premium »
group
menuitem
false
#
0 / 45
menu
group
menuitem
https://wpml.org/wp-admin/admin.php?page=wpml-support-queues
Support queue
group
menuitem
https://wpml.org/wp-admin/admin.php?page=wpml-support-queues&user=204609&post_status=assigned
My assigned tickets
menu
group
menuitem
false
https://wpml.org/wp-admin/profile.php
Howdy, eduard.martini
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2026%2026'%3E%3C/svg%3E
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=52&d=mm&r=g 2x
26
26
async
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=26&d=mm&r=g
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=26&d=mm&r=g
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=52&d=mm&r=g 2x
26
26
async
menu
Howdy, eduard.martini
group
menuitem
https://wpml.org/wp-admin/profile.php
data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2064%2064'%3E%3C/svg%3E
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=128&d=mm&r=g 2x
64
64
async
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=64&d=mm&r=g
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=64&d=mm&r=g
https://secure.gravatar.com/avatar/da407d29d74849ef7a30be8e84be498c?s=128&d=mm&r=g 2x
64
64
async
eduard.martiniEdit Profile
group
menuitem
https://wpml.org/wp-login.php?action=logout&_wpnonce=04cc5efadd&redirect_to=https%3A%2F%2Fwpml.org%2Ffaq%2Fhow-to-optimize-mysql-queries%2F%3Floggedout%3Dtrue
Log Out
group
-1
menuitem
https://wpml.org/
get
s
text
150
adminbar-search
Search
submit
Search
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-includes/css/dashicons.min.css?ver=1727674433
text/css
all
stylesheet
https://cdn.wpml.org/wp-includes/css/admin-bar.min.css?ver=6.6.2
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/sitepress-multilingual-cms/dist/css/blocks/styles.css?ver=1727674429
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/icons/css/otgs-icons.css?ver=1727674429
text/css
all
stylesheet
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/templates/language-switchers/legacy-dropdown/style.min.css?ver=1
text/css
all
stylesheet
https://cdn.wpml.org/wp-content/plugins/sitepress-multilingual-cms/templates/language-switchers/menu-item/style.min.css?ver=1
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/sitepress-multilingual-cms/res/css/admin-bar-style.css?ver=1727674462
text/css
all
stylesheet
https://cdn.wpml.org/wp-content/plugins/complianz-gdpr-premium/assets/css/cookieblocker.min.css?ver=1727068597
text/css
all
stylesheet
https://cdn.wpml.org/wp-content/themes/sitepress/css/font-awesome/font-awesome.css?ver=5.4.3
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/themes/sitepress/style.css?ver=1727674429
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/themes/sitepress/css/wpml-icons.css?ver=1727674429
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/themes/sitepress/css/single-page-simple.css?ver=1727674431
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/wordpress-seo/css/dist/adminbar-2340.css?ver=1727674462
text/css
all
1
stylesheet
https://cdn.wpml.org/wp-content/cache/min/1/wp-content/plugins/icl-mpp/assets/css/frontend.css?ver=1727674429
text/css
all
stylesheet
https://cdn.wpml.org/wp-content/themes/sitepress/css/sidebar.css?ver=5.4.3
text/css
all