|
0.2010 [ms]
|
SELECT code, locale FROM cms_icl_locale_map;
|
|
0.4711 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_videos';
|
|
0.2060 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_manager';
|
|
0.1540 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'gutenberg-experiments' LIMIT 1;
|
|
0.1478 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'BVSERVICESOPTIONNAME' LIMIT 1;
|
|
0.0958 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
0.1659 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
|
0.1521 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_pro_db_version' LIMIT 1;
|
|
0.1521 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'WpFastestCache' LIMIT 1;
|
|
0.1512 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'WpFastestCacheCDN' LIMIT 1;
|
|
0.1879 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'WpFastestCacheExclude' LIMIT 1;
|
|
0.1972 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_w' LIMIT 1;
|
|
0.0870 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_h' LIMIT 1;
|
|
0.1490 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
|
0.1800 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
|
0.1349 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
|
0.2329 [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.2971 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_wpml_st_upgrade_in_progress', '1764656643', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.1609 [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.5591 [ms]
|
SHOW TABLES LIKE 'cms_icl_string_packages';
|
|
0.1230 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_wpml_st_upgrade_in_progress';
|
|
0.5879 [ms]
|
SHOW FULL COLUMNS FROM `cms_options`;
|
|
0.2148 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_wpml_st_upgrade_in_progress';
|
|
0.1180 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_timeout_wpml_st_upgrade_in_progress';
|
|
0.1881 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_timeout_wpml_st_upgrade_in_progress';
|
|
0.1600 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_tax_slug_translation_settings' LIMIT 1;
|
|
0.1521 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_d5a83b86abba9804f40adb3ec71d3250' LIMIT 1;
|
|
0.1681 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_db_version' LIMIT 1;
|
|
0.1540 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'seedprod_per' LIMIT 1;
|
|
0.1838 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'health-check-beta-features' LIMIT 1;
|
|
0.2818 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM cms_posts
WHERE post_name IN ('kurse')
AND post_type IN ('page','attachment')
;
|
|
0.1600 [ms]
|
SELECT * FROM cms_posts WHERE ID = 23 LIMIT 1;
|
|
70.6429 [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='de' and su.url='(.?.+?)(?:/([0-9]+))?/?$')
;
|
|
0.2160 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.4230 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_lite_connect' LIMIT 1;
|
|
0.2539 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'fresh_site' LIMIT 1;
|
|
0.1812 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_square_connections' LIMIT 1;
|
|
0.5169 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name LIKE 'widget\_%';
|
|
0.4339 [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.1919 [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.4811 [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.8309 [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 (2)
) 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.1049 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'sticky_posts_de' LIMIT 1;
|
|
0.3800 [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 (6, 27, 338, 28, 10)
ORDER BY t.name ASC
;
|
|
1.0331 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (6,27,338,28,10) ORDER BY meta_id ASC;
|
|
0.2019 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (5,337,22,9);
|
|
0.4950 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (5,23,337,22,9) ORDER BY meta_id ASC;
|
|
0.3061 [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.4439 [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 = 5 LIMIT 1);
|
|
0.5500 [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 = 23 LIMIT 1);
|
|
0.4032 [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 = 337 LIMIT 1);
|
|
0.4039 [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 = 22 LIMIT 1);
|
|
0.3841 [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 = 9 LIMIT 1);
|
|
0.4568 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_addons_l24637171ef0fe70a62abfdd21aab5180' LIMIT 1;
|
|
0.4568 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frmformapi_request_lock','_transient_timeout_frmformapi_request_lock');
|
|
0.7641 [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.2482 [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.7720 [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.2840 [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.2611 [ms]
|
SELECT meta_value FROM cms_postmeta WHERE meta_key='frm_param' ;
|
|
0.1829 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'seedprod_api_key' LIMIT 1;
|
|
0.3679 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'WpFastestCacheToolbarSettings' LIMIT 1;
|
|
0.4249 [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.6900 [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 = 'kurse' 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 'de' THEN 3 WHEN 'en' 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.3588 [ms]
|
SELECT ID
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 ) WHERE p.post_type = 'page' AND p.post_name = 'kurse'
ORDER BY p.post_parent = 0 DESC
;
|
|
0.3481 [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 = '23') AND cms_posts.post_type = 'page' AND ( ( ( wpml_translations.language_code = 'de' 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.2940 [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 ('frm_application') AND tr.object_id IN (23)
ORDER BY t.name ASC
;
|
|
0.2849 [ms]
|
SELECT id FROM cms_icl_strings WHERE BINARY value='Schachschule Regez' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
|
0.1359 [ms]
|
SELECT value, language FROM cms_icl_strings WHERE id=1;
|
|
0.3550 [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 ( p.post_status = 'publish' ) AND wpml_translations.trid=17
;
|
|
0.2151 [ms]
|
SELECT * FROM cms_posts WHERE ID = 69 LIMIT 1;
|
|
0.2580 [ms]
|
SELECT * FROM cms_users WHERE ID = '1' LIMIT 1;
|
|
0.4148 [ms]
|
SELECT user_id, meta_key, meta_value FROM cms_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
|
0.1740 [ms]
|
SELECT value, language FROM cms_icl_strings WHERE id=1;
|
|
1.3161 [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 = 'de' 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.4709 [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 <> 'de'
;
|
|
0.2098 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (641) ORDER BY meta_id ASC;
|
|
0.5660 [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 = 641 LIMIT 1);
|
|
0.1960 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (619) ORDER BY meta_id ASC;
|
|
0.5109 [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 = 619 LIMIT 1);
|
|
0.2511 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (741) ORDER BY meta_id ASC;
|
|
0.5178 [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 = 741 LIMIT 1);
|
|
0.2470 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (687) ORDER BY meta_id ASC;
|
|
0.5939 [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 = 687 LIMIT 1);
|
|
0.1919 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (987) ORDER BY meta_id ASC;
|
|
0.3929 [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 = 987 LIMIT 1);
|
|
0.1659 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (695) ORDER BY meta_id ASC;
|
|
0.3519 [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 = 695 LIMIT 1);
|
|
0.1540 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1065) ORDER BY meta_id ASC;
|
|
0.3309 [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 = 1065 LIMIT 1);
|
|
0.5670 [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 <> 'de'
;
|
|
0.1860 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (350) ORDER BY meta_id ASC;
|
|
0.3550 [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 = 350 LIMIT 1);
|
|
0.1769 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (613) ORDER BY meta_id ASC;
|
|
0.4029 [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 = 613 LIMIT 1);
|
|
0.6549 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1127) ORDER BY meta_id ASC;
|
|
0.4001 [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 = 1127 LIMIT 1);
|
|
0.3288 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1180) ORDER BY meta_id ASC;
|
|
0.3829 [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 = 1180 LIMIT 1);
|
|
0.2401 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1199) ORDER BY meta_id ASC;
|
|
0.3459 [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 = 1199 LIMIT 1);
|
|
0.1869 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (24) ORDER BY meta_id ASC;
|
|
0.4330 [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 = 24 LIMIT 1);
|
|
0.1881 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1393) ORDER BY meta_id ASC;
|
|
0.3669 [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 = 1393 LIMIT 1);
|
|
0.1969 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (341) ORDER BY meta_id ASC;
|
|
0.3450 [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 = 341 LIMIT 1);
|
|
0.1700 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (344) ORDER BY meta_id ASC;
|
|
0.3719 [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 = 344 LIMIT 1);
|
|
0.1881 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (728) ORDER BY meta_id ASC;
|
|
0.3459 [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 = 728 LIMIT 1);
|
|
0.5429 [ms]
|
SELECT SQL_CALC_FOUND_ROWS cms_posts.ID
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 = 'custom-courses' AND ((cms_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de'
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
LIMIT 0, 20;
|
|
0.0570 [ms]
|
SELECT FOUND_ROWS();
|
|
0.2370 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (996,45,54,56,57,58);
|
|
0.4311 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (996,45,54,56,57,58) ORDER BY meta_id ASC;
|
|
0.4480 [ms]
|
SELECT user_id, meta_key, meta_value FROM cms_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
|
0.1481 [ms]
|
SELECT * FROM cms_users WHERE ID IN (2);
|
|
0.9501 [ms]
|
SELECT * FROM cms_frm_forms WHERE id=9 LIMIT 1;
|
|
0.5882 [ms]
|
SELECT cms_posts.ID
FROM cms_posts
WHERE 1=1 AND cms_posts.menu_order = 9 AND cms_posts.post_type = 'frm_form_actions' AND ((cms_posts.post_status = 'publish')) AND post_excerpt
= 'payment'
ORDER BY cms_posts.post_title ASC
LIMIT 0, 99;
|
|
0.3641 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_9excludeexclude','_transient_timeout_frm_form_fields_9excludeexclude');
|
|
1.1258 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=9 AND fi.type='submit' ORDER BY
field_order LIMIT 1;
|
|
0.2069 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'recaptcha' LIMIT 1;
|
|
0.3440 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_9excludeinclude','_transient_timeout_frm_form_fields_9excludeinclude');
|
|
0.4430 [ms]
|
SELECT cms_posts.ID
FROM cms_posts
WHERE 1=1 AND cms_posts.post_type = 'frm_styles' AND ((cms_posts.post_status = 'publish'))
ORDER BY cms_posts.menu_order DESC
LIMIT 0, 1;
|
|
0.2210 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (495);
|
|
0.1700 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (495) ORDER BY meta_id ASC;
|
|
0.2198 [ms]
|
SELECT id FROM cms_frm_fields WHERE 1=1 ORDER BY id desc LIMIT 1;
|
|
0.1910 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_strp_connect_details_submitted_test' LIMIT 1;
|
|
0.3822 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=9 AND type='credit_card' ;
|
|
0.2151 [ms]
|
SELECT * FROM cms_frm_forms WHERE id=10 LIMIT 1;
|
|
0.3729 [ms]
|
SELECT cms_posts.ID
FROM cms_posts
WHERE 1=1 AND cms_posts.menu_order = 10 AND cms_posts.post_type = 'frm_form_actions' AND ((cms_posts.post_status = 'publish')) AND post_excerpt
= 'payment'
ORDER BY cms_posts.post_title ASC
LIMIT 0, 99;
|
|
0.1712 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_10excludeexclude','_transient_timeout_frm_form_fields_10excludeexclude');
|
|
0.2809 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=10 AND fi.type='submit' ORDER BY
field_order LIMIT 1;
|
|
0.2921 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_10excludeinclude','_transient_timeout_frm_form_fields_10excludeinclude');
|
|
0.3841 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=10 AND type='credit_card' ;
|
|
0.2191 [ms]
|
SELECT * FROM cms_frm_forms WHERE id=11 LIMIT 1;
|
|
0.3510 [ms]
|
SELECT cms_posts.ID
FROM cms_posts
WHERE 1=1 AND cms_posts.menu_order = 11 AND cms_posts.post_type = 'frm_form_actions' AND ((cms_posts.post_status = 'publish')) AND post_excerpt
= 'payment'
ORDER BY cms_posts.post_title ASC
LIMIT 0, 99;
|
|
0.1559 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_11excludeexclude','_transient_timeout_frm_form_fields_11excludeexclude');
|
|
0.2341 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=11 AND fi.type='submit' ORDER BY
field_order LIMIT 1;
|
|
0.2320 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_11excludeinclude','_transient_timeout_frm_form_fields_11excludeinclude');
|
|
0.2871 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=11 AND type='credit_card' ;
|
|
0.1991 [ms]
|
SELECT * FROM cms_frm_forms WHERE id=12 LIMIT 1;
|
|
0.3991 [ms]
|
SELECT cms_posts.ID
FROM cms_posts
WHERE 1=1 AND cms_posts.menu_order = 12 AND cms_posts.post_type = 'frm_form_actions' AND ((cms_posts.post_status = 'publish')) AND post_excerpt
= 'payment'
ORDER BY cms_posts.post_title ASC
LIMIT 0, 99;
|
|
0.2508 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_12excludeexclude','_transient_timeout_frm_form_fields_12excludeexclude');
|
|
0.2429 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=12 AND fi.type='submit' ORDER BY
field_order LIMIT 1;
|
|
0.2539 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_12excludeinclude','_transient_timeout_frm_form_fields_12excludeinclude');
|
|
0.3328 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=12 AND type='credit_card' ;
|
|
0.2091 [ms]
|
SELECT * FROM cms_frm_forms WHERE id=14 LIMIT 1;
|
|
0.3150 [ms]
|
SELECT cms_posts.ID
FROM cms_posts
WHERE 1=1 AND cms_posts.menu_order = 14 AND cms_posts.post_type = 'frm_form_actions' AND ((cms_posts.post_status = 'publish')) AND post_excerpt
= 'payment'
ORDER BY cms_posts.post_title ASC
LIMIT 0, 99;
|
|
0.1400 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_14excludeexclude','_transient_timeout_frm_form_fields_14excludeexclude');
|
|
0.2189 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=14 AND fi.type='submit' ORDER BY
field_order LIMIT 1;
|
|
0.2480 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frm_form_fields_14excludeinclude','_transient_timeout_frm_form_fields_14excludeinclude');
|
|
0.2980 [ms]
|
SELECT fi.*, fr.name as form_name FROM cms_frm_fields fi JOIN cms_frm_forms fr ON fi.form_id=fr.id WHERE fi.form_id=14 AND type='credit_card' ;
|
|
1.0111 [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 = 'de' 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_title ASC
;
|
|
0.4799 [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 <> 'de'
;
|
|
0.4251 [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 <> 'de'
;
|
|
0.4649 [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 = 58 LIMIT 1);
|