0.3090 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wpml_inactive' LIMIT 1;
|
0.3331 [ms]
|
SELECT option_value
FROM wp_options
WHERE option_name = 'home'
LIMIT 1;
|
0.2360 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'active_sitewide_plugins' LIMIT 1;
|
0.4771 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
0.2351 [ms]
|
SELECT code, locale FROM wp_icl_locale_map;
|
0.2961 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheCDN' LIMIT 1;
|
0.1619 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheExclude' LIMIT 1;
|
0.2930 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
0.3200 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'redirection_database_stage' LIMIT 1;
|
0.3481 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider_change_database' LIMIT 1;
|
1.0250 [ms]
|
SHOW FULL COLUMNS FROM `wp_options`;
|
0.2689 [ms]
|
UPDATE `wp_options` SET `option_value` = '1' WHERE `option_name` = 'rs_tables_created';
|
0.2658 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_settings' LIMIT 1;
|
0.5229 [ms]
|
SELECT option_name, option_value FROM wp_options WHERE option_name LIKE 'widget\_%';
|
0.8299 [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.1249 [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.0660 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (3,5) ORDER BY meta_id ASC;
|
0.0770 [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.0741 [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.8421 [ms]
|
SHOW COLUMNS FROM wp_revslider_sliders LIKE 'type';
|
0.0770 [ms]
|
SELECT * FROM wp_revslider_sliders WHERE type != 'template' ORDER BY title ASC;
|
0.0448 [ms]
|
SELECT * FROM wp_layerslider WHERE flag_hidden = '0' AND flag_deleted = '0' ORDER BY name ASC;
|
0.3910 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revSliderAsTheme' LIMIT 1;
|
0.3731 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wpml_language_switcher_template_objects' LIMIT 1;
|
0.6630 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wpml_language_switcher_template_objects' LIMIT 1;
|
0.2248 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
0.2751 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
0.2389 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_debug' LIMIT 1;
|
0.2122 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_less_version' LIMIT 1;
|
0.1030 [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.0401 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (6,2) ORDER BY meta_id ASC;
|
0.0641 [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.3061 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'vc_automapped_shortcodes' LIMIT 1;
|
0.0842 [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.0310 [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.0379 [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=3410;
|
0.1020 [ms]
|
SELECT * FROM wp_redirection_items WHERE match_url='/en/product/hotels-accessories' OR match_url='regex';
|
0.0880 [ms]
|
SELECT * FROM wp_users WHERE ID = '1' LIMIT 1;
|
0.1431 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('product','hotels-accessories')
AND post_type IN ('page','attachment')
;
|
0.0520 [ms]
|
SELECT * FROM wp_posts WHERE ID = 577 LIMIT 1;
|
0.1030 [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.1419 [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 = 'product/hotels-accessories' 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.0479 [ms]
|
SELECT p.ID, p.post_name, p.post_parent, par.post_name as parent_name
FROM wp_posts p
JOIN wp_icl_translations t
ON p.ID = t.element_id
AND t.element_type = CONCAT('post_', p.post_type )
LEFT JOIN wp_posts par
ON par.ID = p.post_parent
WHERE p.post_type = 'page' AND p.post_name IN ('product','hotels-accessories')
ORDER BY par.post_name IN ('product') DESC;
|
0.1552 [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 = 577 LIMIT 1);
|
0.0532 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (577) ORDER BY meta_id ASC;
|
0.1118 [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 = '577') 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.0930 [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.3121 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_use_custom' LIMIT 1;
|
0.3321 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_conditional_script_loading' LIMIT 1;
|
0.4430 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_include_at_footer' LIMIT 1;
|
0.1578 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_use_custom_jquery' LIMIT 1;
|
0.2451 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'layerslider_custom_capability' LIMIT 1;
|
0.1590 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_gsap_sandboxing' LIMIT 1;
|
0.2060 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-fonts' LIMIT 1;
|
0.2310 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-font-scripts' LIMIT 1;
|
0.2770 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider-static-css' LIMIT 1;
|
0.1040 [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=165
;
|
0.1509 [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.0498 [ms]
|
SELECT * FROM wp_posts WHERE ID = 399 LIMIT 1;
|
0.1490 [ms]
|
SELECT * FROM wp_posts WHERE ID = 549 LIMIT 1;
|
0.0730 [ms]
|
SELECT * FROM wp_posts WHERE ID = 54 LIMIT 1;
|
0.1049 [ms]
|
SELECT * FROM wp_users WHERE ID = '6' LIMIT 1;
|
0.0641 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (6) ORDER BY umeta_id ASC;
|
0.1111 [ms]
|
SELECT code, tag FROM wp_icl_languages;
|
0.1101 [ms]
|
SELECT * FROM wp_posts WHERE ID = 854 LIMIT 1;
|
0.0510 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (854) ORDER BY meta_id ASC;
|
0.0892 [ms]
|
SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') AND post_parent = 577 ORDER BY wp_posts.post_title ASC LIMIT 0,1;
|
0.8121 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_not_responsive_css' LIMIT 1;
|
0.2239 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_otgs_twig_cache_disabled' LIMIT 1;
|
0.1080 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
0.0541 [ms]
|
SELECT * FROM wp_posts WHERE ID = 476 LIMIT 1;
|
0.0370 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (476) ORDER BY meta_id ASC;
|
0.0529 [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);
|
1.0068 [ms]
|
SHOW FULL COLUMNS FROM `wp_posts`;
|
0.0911 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-02-แก้ไข-01.svg';;
|
0.0491 [ms]
|
SELECT * FROM wp_posts WHERE ID = 478 LIMIT 1;
|
0.0360 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (478) ORDER BY meta_id ASC;
|
0.0482 [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.0691 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
0.1009 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
0.0770 [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.1051 [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.0460 [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.0610 [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 ;
|
0.1142 [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.0670 [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,561,429,961,152);
|
0.0820 [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 ;
|
0.2341 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1115,961,561,429,399,217,152,148,142) ORDER BY meta_id ASC;
|
0.1030 [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.0980 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1035) ORDER BY meta_id ASC;
|
0.0980 [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 = 1035 LIMIT 1);
|
0.0842 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 1035 AND wp_posts.post_type = 'ris_gallery' ORDER BY wp_posts.post_date DESC ;
|
0.0439 [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 (1035);
|
0.0930 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1038 LIMIT 1;
|
0.0432 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1038) ORDER BY meta_id ASC;
|
0.1211 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1040 LIMIT 1;
|
0.0408 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1040) ORDER BY meta_id ASC;
|
0.0460 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1039 LIMIT 1;
|
0.0391 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1039) ORDER BY meta_id ASC;
|
0.0501 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1037 LIMIT 1;
|
0.0350 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1037) ORDER BY meta_id ASC;
|
0.0460 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1036 LIMIT 1;
|
0.0420 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1036) ORDER BY meta_id ASC;
|
0.0799 [ms]
|
SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'Widgets';
|
0.1080 [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.0849 [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.0610 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE ID IN (205,190);
|
0.0792 [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.0632 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (190,205) ORDER BY meta_id ASC;
|
0.0679 [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.1118 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/เช็คอิน..png';;
|
0.0501 [ms]
|
SELECT * FROM wp_posts WHERE ID = 463 LIMIT 1;
|
0.0360 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (463) ORDER BY meta_id ASC;
|
0.1042 [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);
|