0.3960 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_videos';
|
0.2010 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_manager';
|
0.1180 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'BVSERVICESOPTIONNAME' LIMIT 1;
|
0.0961 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
0.1650 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
0.1621 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_pro_db_version' LIMIT 1;
|
0.1380 [ms]
|
SELECT code, locale FROM cms_icl_locale_map;
|
0.2120 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_w' LIMIT 1;
|
0.1059 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_h' LIMIT 1;
|
0.1662 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
0.1059 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
0.1481 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
0.2141 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_wpml_st_upgrade_in_progress','_transient_timeout_wpml_st_upgrade_in_progress');
|
0.3290 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_wpml_st_upgrade_in_progress', '1750715386', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
0.1590 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_wpml_st_upgrade_in_progress', '1', 'off') ON DUPLICATE KEY
UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
0.4470 [ms]
|
SHOW TABLES LIKE 'cms_icl_string_packages';
|
0.1142 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_wpml_st_upgrade_in_progress';
|
0.5040 [ms]
|
SHOW FULL COLUMNS FROM `cms_options`;
|
0.2570 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_wpml_st_upgrade_in_progress';
|
0.1280 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_timeout_wpml_st_upgrade_in_progress';
|
0.1969 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_timeout_wpml_st_upgrade_in_progress';
|
0.1469 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_tax_slug_translation_settings' LIMIT 1;
|
0.1640 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_d5a83b86abba9804f40adb3ec71d3250' LIMIT 1;
|
0.1562 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_db_version' LIMIT 1;
|
0.1590 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
0.2639 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM cms_posts
WHERE post_name IN ('chess-made-easy','img_1574-2')
AND post_type IN ('page','attachment')
;
|
0.1769 [ms]
|
SELECT * FROM cms_posts WHERE ID = 876 LIMIT 1;
|
47.7500 [ms]
|
SELECT DISTINCT
s.id,
s.name,
s.context,
st.status,
s.gettext_context,
st.value AS tra,
st.mo_string AS mo_string,
s.value AS orig
FROM cms_icl_string_pages sp
INNER JOIN cms_icl_string_urls su
ON su.id = sp.url_id
INNER JOIN cms_icl_strings s
ON s.id = sp.string_id
LEFT JOIN cms_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]+))?/?$')
;
|
0.2100 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_lite_connect' LIMIT 1;
|
0.2129 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'fresh_site' LIMIT 1;
|
0.1361 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_square_connections' LIMIT 1;
|
0.3281 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name LIKE 'widget\_%';
|
0.2711 [ms]
|
SELECT t.term_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('nav_menu') AND t.slug IN ('hauptnavigation')
LIMIT 1;
|
0.1791 [ms]
|
SELECT t.*, tt.* FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (2);
|
0.4420 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 2 LIMIT 1);
|
0.1299 [ms]
|
SELECT t.term_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.term_taxonomy_id IN (4)
LIMIT 1;
|
0.1500 [ms]
|
SELECT t.*, tt.* FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (4);
|
0.7989 [ms]
|
SELECT cms_posts.*
FROM cms_posts LEFT JOIN cms_term_relationships ON (cms_posts.ID = cms_term_relationships.object_id)
WHERE 1=1 AND (
cms_term_relationships.term_taxonomy_id IN (4)
) AND cms_posts.post_type = 'nav_menu_item' AND ((cms_posts.post_status = 'publish'))
GROUP BY cms_posts.ID
ORDER BY cms_posts.menu_order ASC
;
|
0.1080 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'sticky_posts_en' LIMIT 1;
|
0.3781 [ms]
|
SELECT DISTINCT t.term_id, tr.object_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN cms_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
WHERE tt.taxonomy IN ('nav_menu') AND tr.object_id IN (8, 70, 79, 81, 67)
ORDER BY t.name ASC
;
|
0.4849 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (8,70,79,81,67) ORDER BY meta_id ASC;
|
0.2000 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (7,69,78,80,66);
|
0.3071 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (7,69,78,80,66) ORDER BY meta_id ASC;
|
0.2232 [ms]
|
SELECT element_id, language_code
FROM cms_icl_translations
WHERE trid =
(SELECT trid
FROM cms_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM cms_options
WHERE option_name='page_on_front'
LIMIT 1))
;
|
0.3591 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 7 LIMIT 1);
|
0.3340 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 69 LIMIT 1);
|
0.3378 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 78 LIMIT 1);
|
0.3631 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 80 LIMIT 1);
|
0.3211 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 66 LIMIT 1);
|
0.5460 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.language_code, wpml_translations.element_id, wpml_translations.source_language_code,
wpml_translations.element_type, NULLIF(wpml_translations.source_language_code, '') IS NULL AS original
, tm.name, tm.term_id, COUNT(tr.object_id) AS instances
FROM cms_icl_translations wpml_translations
LEFT JOIN cms_term_taxonomy tt ON wpml_translations.element_id=tt.term_taxonomy_id
LEFT JOIN cms_terms tm ON tt.term_id = tm.term_id
LEFT JOIN cms_term_relationships tr ON tr.term_taxonomy_id=tt.term_taxonomy_id
WHERE 1 AND wpml_translations.trid=5
GROUP BY tm.term_id
;
|
0.6461 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_addons_l24637171ef0fe70a62abfdd21aab5180' LIMIT 1;
|
0.2160 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frmformapi_request_lock','_transient_timeout_frmformapi_request_lock');
|
0.6471 [ms]
|
SELECT a.hook FROM cms_actionscheduler_actions a
JOIN cms_actionscheduler_groups g ON g.group_id = a.group_id
WHERE g.slug = 'wp_mail_smtp' AND a.status IN ('in-progress', 'pending');
|
0.4170 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_site_transient_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218','_site_transient_timeout_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218');
|
0.7122 [ms]
|
SELECT a.hook FROM cms_actionscheduler_actions a
JOIN cms_actionscheduler_groups g ON g.group_id = a.group_id
WHERE g.slug = 'wpforms' AND a.status IN ( 'in-progress', 'pending' );
|
0.2918 [ms]
|
SELECT a.action_id FROM cms_actionscheduler_actions a WHERE 1=1 AND a.hook='wpforms_process_entry_emails_meta_cleanup' AND a.status IN ('in-progress',
'pending') LIMIT 0, 1;
|
0.2170 [ms]
|
SELECT meta_value FROM cms_postmeta WHERE meta_key='frm_param' ;
|
0.3269 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM cms_posts
WHERE post_name IN ('chess-made-easy','img_1574-2')
AND post_type IN ('post','attachment')
;
|
0.2680 [ms]
|
SELECT element_id, language_code
FROM cms_icl_translations
WHERE trid =
(SELECT trid
FROM cms_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM cms_options
WHERE option_name='page_for_posts'
LIMIT 1))
;
|
0.5338 [ms]
|
SELECT post_type, post_name
FROM cms_posts p
LEFT JOIN cms_icl_translations wpml_translations
ON wpml_translations.element_id = p.ID
AND CONCAT('post_', p.post_type) = wpml_translations.element_type
AND p.post_type IN
('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' )
WHERE post_name = 'chess-made-easy/img_1574-2' AND post_type IN ('post', 'page', 'attachment', 'frm_display', 'cs_chessgame',
'custom-courses', 'custom-press')
AND ( post_status = 'publish'
OR ( post_type = 'attachment'
AND post_status = 'inherit' ) )
ORDER BY CASE wpml_translations.language_code WHEN 'en' THEN 3 WHEN 'de' 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.4320 [ms]
|
SELECT p.ID, p.post_name, p.post_parent, par.post_name as parent_name
FROM cms_posts p
JOIN cms_icl_translations wpml_translations
ON p.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', p.post_type )
LEFT JOIN cms_posts par
ON par.ID = p.post_parent
WHERE p.post_type = 'page' AND p.post_name IN ('chess-made-easy','img_1574-2')
ORDER BY par.post_name IN ('chess-made-easy') DESC;
|
0.4761 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 876 LIMIT 1);
|
0.3479 [ms]
|
SELECT cms_posts.*
FROM cms_posts JOIN cms_icl_translations wpml_translations
ON cms_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', cms_posts.post_type)
WHERE 1=1 AND (cms_posts.ID = '876') AND cms_posts.ID = 876 AND cms_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code =
'en' OR 0 ) AND cms_posts.post_type IN
('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) ) OR cms_posts.post_type
NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) )
ORDER BY cms_posts.post_date DESC
;
|
0.3431 [ms]
|
SELECT DISTINCT t.term_id, tr.object_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN cms_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
WHERE tt.taxonomy IN ('category') AND tr.object_id IN (876)
ORDER BY t.name ASC
;
|
0.1588 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (876) ORDER BY meta_id ASC;
|
0.4668 [ms]
|
SELECT id FROM cms_icl_strings WHERE BINARY value='Schachschule Regez' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
0.1199 [ms]
|
SELECT value, language FROM cms_icl_strings WHERE id=1;
|
0.1631 [ms]
|
SELECT language, value, status FROM cms_icl_string_translations WHERE string_id=1;
|
0.4661 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (309) ORDER BY meta_id ASC;
|
0.4380 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.language_code, wpml_translations.element_id, wpml_translations.source_language_code,
wpml_translations.element_type, NULLIF(wpml_translations.source_language_code, '') IS NULL AS original
, p.post_title, p.post_status
FROM cms_icl_translations wpml_translations
LEFT JOIN cms_posts p ON wpml_translations.element_id=p.ID
WHERE 1 AND wpml_translations.trid=543
;
|
0.1860 [ms]
|
SELECT * FROM cms_posts WHERE ID = 309 LIMIT 1;
|
0.2098 [ms]
|
SELECT * FROM cms_posts WHERE ID = 5 LIMIT 1;
|
0.4301 [ms]
|
SELECT * FROM cms_users WHERE ID = '2' LIMIT 1;
|
0.6928 [ms]
|
SELECT user_id, meta_key, meta_value FROM cms_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
0.1421 [ms]
|
SELECT value, language FROM cms_icl_strings WHERE id=1;
|
0.1688 [ms]
|
SELECT language, value, status FROM cms_icl_string_translations WHERE string_id=1;
|
1.5030 [ms]
|
SELECT cms_posts.*
FROM cms_posts JOIN cms_icl_translations wpml_translations
ON cms_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', cms_posts.post_type)
WHERE 1=1 AND cms_posts.post_type = 'page' AND ((cms_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 )
AND cms_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' )
) OR cms_posts.post_type NOT IN
('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) )
ORDER BY cms_posts.menu_order ASC
;
|
0.4659 [ms]
|
SELECT p.ID FROM cms_posts p
JOIN cms_icl_translations wpml_translations ON p.ID = wpml_translations.element_id
WHERE wpml_translations.element_type='post_page' AND p.post_type='page' AND wpml_translations.language_code <> 'en'
;
|
0.4058 [ms]
|
SELECT p.ID FROM cms_posts p
JOIN cms_icl_translations wpml_translations ON p.ID = wpml_translations.element_id
WHERE wpml_translations.element_type='post_page' AND p.post_type='page' AND wpml_translations.language_code <> 'en'
;
|
0.2131 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1164) ORDER BY meta_id ASC;
|
0.4451 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 1164 LIMIT 1);
|
0.1609 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1177) ORDER BY meta_id ASC;
|
0.4411 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 1177 LIMIT 1);
|
0.1838 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (986) ORDER BY meta_id ASC;
|
0.4299 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 986 LIMIT 1);
|