|
0.4511 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wpml_inactive' LIMIT 1;
|
|
0.6590 [ms]
|
SELECT option_value
FROM wp_options
WHERE option_name = 'home'
LIMIT 1;
|
|
0.5040 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'active_sitewide_plugins' LIMIT 1;
|
|
0.7060 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
|
0.0520 [ms]
|
SELECT code, locale FROM wp_icl_locale_map;
|
|
0.2060 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheCDN' LIMIT 1;
|
|
0.1919 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheExclude' LIMIT 1;
|
|
0.3021 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.2570 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'redirection_database_stage' LIMIT 1;
|
|
0.4411 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider_change_database' LIMIT 1;
|
|
0.8922 [ms]
|
SHOW FULL COLUMNS FROM `wp_options`;
|
|
0.2198 [ms]
|
UPDATE `wp_options` SET `option_value` = '1' WHERE `option_name` = 'rs_tables_created';
|
|
0.5999 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_settings' LIMIT 1;
|
|
0.4501 [ms]
|
SELECT option_name, option_value FROM wp_options WHERE option_name LIKE 'widget\_%';
|
|
0.6821 [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.1450 [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.0429 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (3,5) ORDER BY meta_id ASC;
|
|
0.0539 [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.0460 [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.9222 [ms]
|
SHOW COLUMNS FROM wp_revslider_sliders LIKE 'type';
|
|
0.0780 [ms]
|
SELECT * FROM wp_revslider_sliders WHERE type != 'template' ORDER BY title ASC;
|
|
0.0420 [ms]
|
SELECT * FROM wp_layerslider WHERE flag_hidden = '0' AND flag_deleted = '0' ORDER BY name ASC;
|
|
0.2611 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revSliderAsTheme' LIMIT 1;
|
|
0.3040 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wpml_language_switcher_template_objects' LIMIT 1;
|
|
0.2129 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wpml_language_switcher_template_objects' LIMIT 1;
|
|
0.4940 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
|
0.3481 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
|
0.1931 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_debug' LIMIT 1;
|
|
0.2289 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_less_version' LIMIT 1;
|
|
0.1390 [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.0420 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (6,2) ORDER BY meta_id ASC;
|
|
0.0532 [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.5419 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'vc_automapped_shortcodes' LIMIT 1;
|
|
0.1030 [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.0601 [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.0479 [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=3470;
|
|
0.1280 [ms]
|
SELECT * FROM wp_redirection_items WHERE
match_url='/en/205/2017/12/06/08/39/00/tips-on-towels/%e0%b8%82%e0%b9%88%e0%b8%b2%e0%b8%a7%e0%b8%aa%e0%b8%b2%e0%b8%a3%e0%b9%81%e0%b8%a5%e0%b8%b0%e0%b8%84%e0%b8%a7%e0%b8%b2%e0%b8%a1%e0%b8%a3%e0%b8%b9%e0%b9%89-en/maipromthai'
OR match_url='regex';
|
|
0.0610 [ms]
|
SELECT * FROM wp_users WHERE ID = '1' LIMIT 1;
|
|
0.0920 [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 = 'tips-on-towels' AND post_type IN ('post', 'page', 'attachment', 'uig_image', 'slide') AND YEAR(post_date) = 2017 AND
MONTH(post_date) = 6 AND DAY(post_date) = 12
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 'post' THEN 0 ELSE 1 END , CASE
p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC
LIMIT 1;
|
|
0.0460 [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 = 'post' AND p.post_name = 'tips-on-towels'
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 = 205 LIMIT 1);
|
|
0.0579 [ms]
|
SELECT * FROM wp_posts WHERE ID = 205 LIMIT 1;
|
|
0.0551 [ms]
|
SELECT t.*, tt.* 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') AND tr.object_id IN (205) ORDER BY t.name ASC ;
|
|
0.0479 [ms]
|
SELECT * FROM wp_users WHERE ID = '6' LIMIT 1;
|
|
0.0570 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (6) ORDER BY umeta_id ASC;
|
|
0.0532 [ms]
|
SELECT t.term_id FROM wp_terms t
JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id
WHERE tt.taxonomy = 'category' AND t.slug =
'%e0%b8%82%e0%b9%88%e0%b8%b2%e0%b8%a7%e0%b8%aa%e0%b8%b2%e0%b8%a3%e0%b9%81%e0%b8%a5%e0%b8%b0%e0%b8%84%e0%b8%a7%e0%b8%b2%e0%b8%a1%e0%b8%a3%e0%b8%b9%e0%b9%89-en'
LIMIT 1;
|
|
0.0420 [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.0370 [ms]
|
SELECT slug FROM wp_terms
WHERE term_id = 6 LIMIT 1;
|
|
0.0370 [ms]
|
SELECT ID FROM wp_posts WHERE post_name='tips-on-towels' AND post_type='post' LIMIT 1;
|
|
0.0610 [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 (
( YEAR( wp_posts.post_date ) = 2017 AND MONTH( wp_posts.post_date ) = 6 AND DAYOFMONTH( wp_posts.post_date ) = 12 AND DATE_FORMAT(
wp_posts.post_date, '%H.%i%s' ) = 8.390000 )
) AND wp_posts.ID = 205 AND (wp_posts.post_author = 6) AND wp_posts.post_type = 'post' 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.0520 [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 (205) ORDER BY t.name
ASC ;
|
|
0.0458 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (205) ORDER BY meta_id ASC;
|
|
0.0570 [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 t.slug =
'%e0%b8%82%e0%b9%88%e0%b8%b2%e0%b8%a7%e0%b8%aa%e0%b8%b2%e0%b8%a3%e0%b9%81%e0%b8%a5%e0%b8%b0%e0%b8%84%e0%b8%a7%e0%b8%b2%e0%b8%a1%e0%b8%a3%e0%b8%b9%e0%b9%89-en'
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.0539 [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.3171 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_use_custom' LIMIT 1;
|
|
0.1600 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_conditional_script_loading' LIMIT 1;
|
|
0.1321 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_include_at_footer' LIMIT 1;
|
|
0.1271 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_use_custom_jquery' LIMIT 1;
|
|
0.1259 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'layerslider_custom_capability' LIMIT 1;
|
|
0.1271 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_gsap_sandboxing' LIMIT 1;
|
|
0.1230 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-fonts' LIMIT 1;
|
|
0.1192 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-font-scripts' LIMIT 1;
|
|
0.1431 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider-static-css' LIMIT 1;
|
|
0.5100 [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=131
;
|
|
0.2890 [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.5999 [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);
|
|
0.2251 [ms]
|
SELECT * FROM wp_posts WHERE ID = 131 LIMIT 1;
|
|
0.8109 [ms]
|
SELECT t.*, tt.* 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') AND tr.object_id IN (131) ORDER BY t.name ASC ;
|
|
0.3641 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (4) ORDER BY meta_id ASC;
|
|
0.9420 [ms]
|
SELECT code, tag FROM wp_icl_languages;
|
|
0.3850 [ms]
|
SELECT p.ID FROM wp_posts AS p JOIN wp_icl_translations t ON t.element_id = p.ID AND t.element_type = 'post_post' WHERE p.post_date < '2017-06-12
08:39:00' AND p.post_type = 'post' AND p.post_status = 'publish' AND language_code = 'en' ORDER BY p.post_date DESC LIMIT 1;
|
|
0.3490 [ms]
|
SELECT * FROM wp_posts WHERE ID = 190 LIMIT 1;
|
|
0.7279 [ms]
|
SELECT t.*, tt.* 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') AND tr.object_id IN (190) ORDER BY t.name ASC ;
|
|
0.4930 [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 = 190 LIMIT 1);
|
|
0.3071 [ms]
|
SELECT p.ID FROM wp_posts AS p JOIN wp_icl_translations t ON t.element_id = p.ID AND t.element_type = 'post_post' WHERE p.post_date > '2017-06-12
08:39:00' AND p.post_type = 'post' AND p.post_status = 'publish' AND language_code = 'en' ORDER BY p.post_date ASC LIMIT 1;
|
|
0.3362 [ms]
|
SELECT meta_id FROM wp_postmeta WHERE meta_key = 'awepop_views' AND post_id = 205;
|
|
0.5040 [ms]
|
SHOW FULL COLUMNS FROM `wp_postmeta`;
|
|
1.6010 [ms]
|
UPDATE `wp_postmeta` SET `meta_value` =
'011111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111'
WHERE `post_id` = 205 AND `meta_key` = 'awepop_views';
|
|
0.2811 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (205) ORDER BY meta_id ASC;
|
|
0.0720 [ms]
|
SELECT * FROM wp_posts WHERE ID = 854 LIMIT 1;
|
|
0.7660 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (854) ORDER BY meta_id ASC;
|
|
0.3960 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_not_responsive_css' LIMIT 1;
|
|
0.2279 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_otgs_twig_cache_disabled' LIMIT 1;
|
|
1.1580 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
0.3231 [ms]
|
SELECT * FROM wp_posts WHERE ID = 476 LIMIT 1;
|
|
0.2980 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (476) ORDER BY meta_id ASC;
|
|
0.8340 [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.6678 [ms]
|
SHOW FULL COLUMNS FROM `wp_posts`;
|
|
0.6058 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-02-แก้ไข-01.svg';;
|
|
0.1938 [ms]
|
SELECT * FROM wp_posts WHERE ID = 478 LIMIT 1;
|
|
0.2041 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (478) ORDER BY meta_id ASC;
|
|
0.4239 [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.0479 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
0.0448 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
0.3130 [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.5891 [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.4020 [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 ;
|
|
2.0370 [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.5560 [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,217,399,577,561,429,961,152);
|
|
0.4470 [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 ;
|
|
2.1191 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1115,961,577,561,429,399,217,152,148,142) ORDER BY meta_id ASC;
|
|
0.4621 [ms]
|
SELECT t.term_id, tt.parent, tt.count, tt.taxonomy 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') AND tr.object_id IN (205) ORDER BY t.name
ASC ;
|
|
0.5069 [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.2720 [ms]
|
SELECT * FROM wp_posts WHERE ID = 813 LIMIT 1;
|
|
0.5670 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (813) ORDER BY meta_id ASC;
|
|
1.1559 [ms]
|
SELECT t.*, tt.* 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 ('post_format') AND tr.object_id IN (190) ORDER BY t.name ASC ;
|
|
0.3369 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (190) ORDER BY meta_id ASC;
|
|
0.1910 [ms]
|
SELECT * FROM wp_posts WHERE ID = 814 LIMIT 1;
|
|
0.2279 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (814) ORDER BY meta_id ASC;
|
|
0.3061 [ms]
|
SELECT COUNT(*) FROM wp_postmeta WHERE meta_key = 'mfn-post-love' AND post_id = 205;
|
|
0.2561 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE ID IN (132,133,134);
|
|
0.1609 [ms]
|
SELECT * FROM wp_posts WHERE ID = 132 LIMIT 1;
|
|
0.1581 [ms]
|
SELECT * FROM wp_posts WHERE ID = 133 LIMIT 1;
|
|
0.1450 [ms]
|
SELECT * FROM wp_posts WHERE ID = 134 LIMIT 1;
|
|
0.4148 [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 t.term_id IN ( 6 ) 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 ) ;
|
|
0.6659 [ms]
|
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 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 NOT IN (205) AND (
wp_term_relationships.term_taxonomy_id IN (6)
) 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' ) ) GROUP BY wp_posts.ID ORDER BY
wp_posts.post_date DESC LIMIT 0, 1;
|
|
0.6750 [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) ORDER BY t.name
ASC ;
|
|
0.9170 [ms]
|
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments JOIN wp_icl_translations icltr2
ON icltr2.element_id = wp_comments.comment_post_ID
JOIN wp_posts ON wp_posts.ID = icltr2.element_id
AND CONCAT('post_', wp_posts.post_type) = icltr2.element_type
LEFT JOIN wp_icl_translations icltr_comment
ON icltr_comment.element_id = wp_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '1' ) AND comment_post_ID = 205 AND comment_parent = 0 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
) ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;
|
|
6.1021 [ms]
|
SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'Widgets';
|
|
15.1970 [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.8750 [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.0049 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/เช็คอิน..png';;
|
|
0.2530 [ms]
|
SELECT * FROM wp_posts WHERE ID = 463 LIMIT 1;
|
|
0.2720 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (463) ORDER BY meta_id ASC;
|
|
0.6390 [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);
|
