|
0.3161 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wpml_inactive' LIMIT 1;
|
|
3.9940 [ms]
|
SELECT option_value
FROM wp_options
WHERE option_name = 'home'
LIMIT 1;
|
|
0.4840 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'active_sitewide_plugins' LIMIT 1;
|
|
0.3479 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
|
0.0551 [ms]
|
SELECT code, locale FROM wp_icl_locale_map;
|
|
0.2589 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheCDN' LIMIT 1;
|
|
0.1709 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheExclude' LIMIT 1;
|
|
44.9979 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.4380 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'redirection_database_stage' LIMIT 1;
|
|
0.2539 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider_change_database' LIMIT 1;
|
|
0.8450 [ms]
|
SHOW FULL COLUMNS FROM `wp_options`;
|
|
0.2389 [ms]
|
UPDATE `wp_options` SET `option_value` = '1' WHERE `option_name` = 'rs_tables_created';
|
|
0.2539 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_settings' LIMIT 1;
|
|
0.4470 [ms]
|
SELECT option_name, option_value FROM wp_options WHERE option_name LIKE 'widget\_%';
|
|
73.8649 [ms]
|
SELECT DISTINCT
s.id,
s.name,
s.context,
st.status,
s.gettext_context,
st.value AS tra,
s.value AS orig
FROM wp_icl_string_pages sp
INNER JOIN wp_icl_string_urls su
ON su.id = sp.url_id
INNER JOIN wp_icl_strings s
ON s.id = sp.string_id
LEFT JOIN wp_icl_string_translations st
ON s.id=st.string_id
AND st.language=su.language
AND s.language!=su.language
WHERE (su.language='en' and su.url='(.?.+?)(?:/([0-9]+))?/?$') or (su.language='en' and su.url IS NULL)
;
|
|
0.9449 [ms]
|
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('nav_menu') ORDER BY t.name
ASC ;
|
|
0.6738 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (3,5) ORDER BY meta_id ASC;
|
|
0.1502 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 3 LIMIT 1);
|
|
0.2401 [ms]
|
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.term_taxonomy_id = 5 LIMIT 1;
|
|
0.8550 [ms]
|
SHOW COLUMNS FROM wp_revslider_sliders LIKE 'type';
|
|
0.1080 [ms]
|
SELECT * FROM wp_revslider_sliders WHERE type != 'template' ORDER BY title ASC;
|
|
0.0510 [ms]
|
SELECT * FROM wp_layerslider WHERE flag_hidden = '0' AND flag_deleted = '0' ORDER BY name ASC;
|
|
0.4089 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revSliderAsTheme' LIMIT 1;
|
|
0.3328 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wpml_language_switcher_template_objects' LIMIT 1;
|
|
0.2241 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wpml_language_switcher_template_objects' LIMIT 1;
|
|
0.2980 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
|
0.3021 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
|
0.1800 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_debug' LIMIT 1;
|
|
0.2232 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_less_version' LIMIT 1;
|
|
0.1111 [ms]
|
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_category') WHERE tt.taxonomy IN ('category') AND ( ( icl_t.element_type IN
('tax_category') AND icl_t.language_code = 'en' )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL ) ORDER BY t.name ASC ;
|
|
0.0491 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (6,2) ORDER BY meta_id ASC;
|
|
0.0422 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 6 LIMIT 1);
|
|
0.3190 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'vc_automapped_shortcodes' LIMIT 1;
|
|
0.0970 [ms]
|
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook='wpforms_process_entry_emails_meta_cleanup' AND a.status='in-progress' ORDER BY
scheduled_date_gmt DESC LIMIT 1;
|
|
0.0341 [ms]
|
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook='wpforms_process_entry_emails_meta_cleanup' AND a.status='pending' ORDER BY
scheduled_date_gmt ASC LIMIT 1;
|
|
0.0401 [ms]
|
SELECT a.*, g.slug AS `group` FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON a.group_id=g.group_id WHERE a.action_id=3434;
|
|
0.3259 [ms]
|
SELECT * FROM wp_redirection_items WHERE match_url='/en/news-knowledge' OR match_url='regex';
|
|
0.0441 [ms]
|
SELECT * FROM wp_users WHERE ID = '1' LIMIT 1;
|
|
0.4199 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('news-knowledge')
AND post_type IN ('page','attachment')
;
|
|
0.0470 [ms]
|
SELECT * FROM wp_posts WHERE ID = 217 LIMIT 1;
|
|
0.3800 [ms]
|
SELECT element_id, language_code
FROM wp_icl_translations
WHERE trid =
(SELECT trid
FROM wp_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wp_options
WHERE option_name='page_for_posts'
LIMIT 1))
;
|
|
0.6549 [ms]
|
SELECT post_type, post_name
FROM wp_posts p
LEFT JOIN wp_icl_translations t
ON t.element_id = p.ID
AND CONCAT('post_', p.post_type) = t.element_type
AND p.post_type IN ('post','page','wp_block','slide' )
WHERE post_name = 'news-knowledge' AND post_type IN ('post', 'page', 'attachment', 'uig_image', 'slide')
AND ( post_status = 'publish'
OR ( post_type = 'attachment'
AND post_status = 'inherit' ) )
ORDER BY CASE t.language_code WHEN 'en' THEN 3 WHEN 'th' THEN 1 ELSE 0 END DESC , CASE p.post_type WHEN 'page' THEN 2 WHEN 'post'
THEN 1 ELSE 0 END DESC
LIMIT 1;
|
|
0.4051 [ms]
|
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations t
ON p.ID = t.element_id
AND t.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'page' AND p.post_name = 'news-knowledge'
ORDER BY p.post_parent = 0 DESC
;
|
|
0.0470 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 217 LIMIT 1);
|
|
0.0310 [ms]
|
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations t
ON p.ID = t.element_id
AND t.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'page' AND p.post_name = 'news-knowledge'
ORDER BY p.post_parent = 0 DESC
;
|
|
0.4721 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (217) ORDER BY meta_id ASC;
|
|
0.3951 [ms]
|
SELECT wp_posts.* FROM wp_posts JOIN wp_icl_translations t
ON wp_posts.ID = t.element_id
AND t.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (wp_posts.ID = '217') AND wp_posts.post_type = 'page' AND ( (
t.language_code = 'en' AND wp_posts.post_type IN ('post','page','wp_block','slide' ) ) OR wp_posts.post_type NOT IN
('post','page','wp_block','slide' ) ) ORDER BY wp_posts.post_date DESC ;
|
|
0.0429 [ms]
|
SELECT element_id, language_code
FROM wp_icl_translations
WHERE trid =
(SELECT trid
FROM wp_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wp_options
WHERE option_name='page_on_front'
LIMIT 1))
;
|
|
0.2160 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_use_custom' LIMIT 1;
|
|
0.2272 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_conditional_script_loading' LIMIT 1;
|
|
0.1411 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_include_at_footer' LIMIT 1;
|
|
0.1440 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_use_custom_jquery' LIMIT 1;
|
|
0.1149 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'layerslider_custom_capability' LIMIT 1;
|
|
0.1190 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_gsap_sandboxing' LIMIT 1;
|
|
0.1211 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-fonts' LIMIT 1;
|
|
0.1090 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-font-scripts' LIMIT 1;
|
|
0.2041 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider-static-css' LIMIT 1;
|
|
0.5209 [ms]
|
SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, t.element_type, NULLIF(t.source_language_code, '') IS NULL AS
original
, p.post_title, p.post_status
FROM wp_icl_translations t
LEFT JOIN wp_posts p ON t.element_id=p.ID
WHERE 1 AND ( p.post_status = 'publish' OR p.post_status = 'pending' ) AND t.trid=53
;
|
|
1.2929 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 142 LIMIT 1);
|
|
1.4760 [ms]
|
SELECT * FROM wp_posts WHERE ID = 53 LIMIT 1;
|
|
0.2911 [ms]
|
SELECT * FROM wp_users WHERE ID = '6' LIMIT 1;
|
|
1.4849 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (6) ORDER BY umeta_id ASC;
|
|
0.3128 [ms]
|
SELECT code, tag FROM wp_icl_languages;
|
|
0.0610 [ms]
|
SELECT * FROM wp_posts WHERE ID = 854 LIMIT 1;
|
|
0.0360 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (854) ORDER BY meta_id ASC;
|
|
0.4058 [ms]
|
SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') AND post_parent = 217 ORDER BY wp_posts.post_title ASC LIMIT 0,1;
|
|
0.4630 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_not_responsive_css' LIMIT 1;
|
|
0.3140 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_otgs_twig_cache_disabled' LIMIT 1;
|
|
5.6059 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
2.1150 [ms]
|
SELECT * FROM wp_posts WHERE ID = 476 LIMIT 1;
|
|
0.3629 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (476) ORDER BY meta_id ASC;
|
|
1.7159 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 476 LIMIT 1);
|
|
0.7529 [ms]
|
SHOW FULL COLUMNS FROM `wp_posts`;
|
|
1.1148 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-02-แก้ไข-01.svg';;
|
|
1.4219 [ms]
|
SELECT * FROM wp_posts WHERE ID = 478 LIMIT 1;
|
|
1.3700 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (478) ORDER BY meta_id ASC;
|
|
0.7620 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 478 LIMIT 1);
|
|
0.1230 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
0.1101 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
1.0049 [ms]
|
SELECT t.element_id, tax.term_id, tax.taxonomy
FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN wp_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id;
|
|
0.6449 [ms]
|
SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy
IN ('nav_menu') AND tt.term_id IN ('5') ORDER BY tr.object_id ASC;
|
|
0.8640 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.element_id IN (154,155,156,219,405,834,835,836,965,1121);
|
|
0.6561 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (154,155,156,219,405,834,835,836,965,1121) AND wp_posts.post_type = 'nav_menu_item'
AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC ;
|
|
1.0140 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (154,155,1121,219,405,834,835,836,965,156) ORDER BY meta_id ASC;
|
|
0.8729 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.element_id IN (148,1115,399,577,561,429,961,152);
|
|
0.7269 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (142,148,1115,217,399,577,561,429,961,152) AND wp_posts.post_type = 'page' AND
((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC ;
|
|
1.3270 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1115,961,577,561,429,399,152,148,142) ORDER BY meta_id ASC;
|
|
0.8070 [ms]
|
SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, t.element_type, NULLIF(t.source_language_code, '') IS NULL AS
original
, tm.name, tm.term_id, COUNT(tr.object_id) AS instances
FROM wp_icl_translations t
LEFT JOIN wp_term_taxonomy tt ON t.element_id=tt.term_taxonomy_id
LEFT JOIN wp_terms tm ON tt.term_id = tm.term_id
LEFT JOIN wp_term_relationships tr ON tr.term_taxonomy_id=tt.term_taxonomy_id
WHERE 1 AND t.trid=140
GROUP BY tm.term_id
;
|
|
0.7639 [ms]
|
SELECT wp_posts.ID FROM wp_posts JOIN wp_icl_translations t
ON wp_posts.ID = t.element_id
AND t.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish'))
AND ( ( t.language_code = 'en' AND wp_posts.post_type IN ('post','page','wp_block','slide' ) ) OR wp_posts.post_type NOT IN
('post','page','wp_block','slide' ) ) ORDER BY wp_posts.post_date DESC LIMIT 0, 5;
|
|
0.8099 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE ID IN (205,190);
|
|
1.3990 [ms]
|
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (190, 205) ORDER BY
t.name ASC ;
|
|
0.6330 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (190,205) ORDER BY meta_id ASC;
|
|
0.7219 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.element_id IN (205,190);
|
|
0.3240 [ms]
|
SELECT * FROM wp_posts WHERE ID = 813 LIMIT 1;
|
|
0.9050 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (813) ORDER BY meta_id ASC;
|
|
0.4859 [ms]
|
SELECT COUNT(*) FROM wp_postmeta WHERE meta_key = 'mfn-post-love' AND post_id = 205;
|
|
0.2961 [ms]
|
SELECT * FROM wp_posts WHERE ID = 814 LIMIT 1;
|
|
0.3440 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (814) ORDER BY meta_id ASC;
|
|
0.4680 [ms]
|
SELECT COUNT(*) FROM wp_postmeta WHERE meta_key = 'mfn-post-love' AND post_id = 190;
|
|
9.5091 [ms]
|
SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'Widgets';
|
|
22.4650 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
s.value AS original,
s.gettext_context
FROM wp_icl_strings s
LEFT JOIN wp_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'Widgets'
LIMIT 1000 OFFSET 0;
|
|
0.1109 [ms]
|
SELECT wp_posts.ID FROM wp_posts JOIN wp_icl_translations t
ON wp_posts.ID = t.element_id
AND t.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish'))
AND ( ( t.language_code = 'en' AND wp_posts.post_type IN ('post','page','wp_block','slide' ) ) OR wp_posts.post_type NOT IN
('post','page','wp_block','slide' ) ) ORDER BY wp_posts.post_date DESC LIMIT 0, 5;
|
|
1.1041 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/เช็คอิน..png';;
|
|
0.8981 [ms]
|
SELECT * FROM wp_posts WHERE ID = 463 LIMIT 1;
|
|
0.9720 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (463) ORDER BY meta_id ASC;
|
|
0.7241 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 463 LIMIT 1);
|
