|
0.3190 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_videos';
|
|
0.1781 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_manager';
|
|
0.2141 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'BVSERVICESOPTIONNAME' LIMIT 1;
|
|
0.1140 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
0.1891 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
|
0.1938 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_pro_db_version' LIMIT 1;
|
|
0.6120 [ms]
|
SELECT code, locale FROM cms_icl_locale_map;
|
|
0.2251 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_w' LIMIT 1;
|
|
0.1490 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_h' LIMIT 1;
|
|
0.2310 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
|
0.1769 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
|
0.2000 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
|
0.2551 [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.3281 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_wpml_st_upgrade_in_progress', '1752045281', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.1931 [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.6249 [ms]
|
SHOW TABLES LIKE 'cms_icl_string_packages';
|
|
0.1531 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_wpml_st_upgrade_in_progress';
|
|
0.6471 [ms]
|
SHOW FULL COLUMNS FROM `cms_options`;
|
|
0.2129 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_wpml_st_upgrade_in_progress';
|
|
0.1101 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_timeout_wpml_st_upgrade_in_progress';
|
|
0.1941 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_timeout_wpml_st_upgrade_in_progress';
|
|
0.1271 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_tax_slug_translation_settings' LIMIT 1;
|
|
0.2081 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_d5a83b86abba9804f40adb3ec71d3250' LIMIT 1;
|
|
0.1590 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_db_version' LIMIT 1;
|
|
0.2210 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
43.6099 [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='cs_category/([^/]+)/?$')
;
|
|
0.2110 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_lite_connect' LIMIT 1;
|
|
0.2460 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'fresh_site' LIMIT 1;
|
|
0.1810 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_square_connections' LIMIT 1;
|
|
0.4599 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name LIKE 'widget\_%';
|
|
0.9921 [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.1740 [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);
|
|
1.1382 [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);
|
|
1.5960 [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.1469 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'sticky_posts_de' LIMIT 1;
|
|
0.3459 [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
;
|
|
0.8321 [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.2210 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (5,23,337,22,9);
|
|
0.5169 [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.2661 [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.6099 [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.4189 [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.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 = 337 LIMIT 1);
|
|
0.4661 [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.4668 [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.4718 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_addons_l24637171ef0fe70a62abfdd21aab5180' LIMIT 1;
|
|
0.1869 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frmformapi_request_lock','_transient_timeout_frmformapi_request_lock');
|
|
1.7571 [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.2689 [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.1841 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_site_transient_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218';
|
|
0.2730 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_site_transient_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218';
|
|
0.1140 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_site_transient_timeout_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218';
|
|
0.1929 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_site_transient_timeout_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218';
|
|
0.2840 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES
('_site_transient_timeout_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218', '1752047021', 'off') ON DUPLICATE KEY UPDATE `option_name` =
VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.2248 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES
('_site_transient_wp_theme_files_patterns-8bfef3d3c04ec041f9450cd6ee3e6218', 'a:2:{s:7:\"version\";s:3:\"1.0\";s:8:\"patterns\";a:0:{}}', 'off') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.6480 [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.3171 [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.2630 [ms]
|
SELECT meta_value FROM cms_postmeta WHERE meta_key='frm_param' ;
|
|
0.2239 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN ('_transient_doing_cron','_transient_timeout_doing_cron');
|
|
1.2159 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1752045222.0467519760131835937500', 'on') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.3030 [ms]
|
SELECT t.term_id FROM cms_terms t
JOIN cms_term_taxonomy tt ON t.term_id = tt.term_id
WHERE tt.taxonomy = 'cs_category' AND t.slug = 'klassische-partien' LIMIT 1;
|
|
0.2279 [ms]
|
SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy
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_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id;
|
|
0.2549 [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 = 16 LIMIT 1);
|
|
0.1941 [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 ('cs_category') AND t.slug IN ('klassische-partien')
;
|
|
0.1509 [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 (16);
|
|
0.1400 [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 ('cs_category') AND t.term_id IN ( 16 )
;
|
|
0.1681 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (9,12,10,11);
|
|
0.3610 [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 = 9 LIMIT 1);
|
|
0.4139 [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 = 10 LIMIT 1);
|
|
0.4039 [ms]
|
SELECT t.term_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN cms_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 ( 9,10 ) AND ( ( icl_t.element_type IN ('tax_category') AND ( icl_t.language_code = 'de' OR 0
) )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL )
;
|
|
0.1891 [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 (9,10);
|
|
0.8850 [ms]
|
SELECT SQL_CALC_FOUND_ROWS cms_posts.ID
FROM cms_posts LEFT JOIN cms_term_relationships ON (cms_posts.ID = cms_term_relationships.object_id) LEFT 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_term_relationships.term_taxonomy_id IN (16)
AND
cms_posts.ID NOT IN (
SELECT object_id
FROM cms_term_relationships
WHERE term_taxonomy_id IN (9,10)
)
) AND ((cms_posts.post_type = 'cs_chessgame' 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' ) )
GROUP BY cms_posts.ID
ORDER BY cms_posts.post_date DESC
LIMIT 0, 20;
|
|
0.0570 [ms]
|
SELECT FOUND_ROWS();
|
|
0.1721 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (1304,1296);
|
|
0.4220 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1304,1296) ORDER BY meta_id ASC;
|
|
0.3262 [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 ('cs_category') AND tr.object_id IN (1304, 1296)
ORDER BY tr.term_order ASC
;
|
|
0.2511 [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 ('cs_tag') AND tr.object_id IN (1304, 1296)
ORDER BY tr.term_order ASC
;
|
|
0.2420 [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 ('cs_category') AND t.slug IN ('klassische-partien')
LIMIT 1;
|
|
0.1252 [ms]
|
SELECT trid, language_code, source_language_code
FROM cms_icl_translations
WHERE element_id=16 AND element_type='tax_cs_category'
;
|
|
0.4709 [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 = 1304 LIMIT 1);
|
|
0.3090 [ms]
|
SELECT id FROM cms_icl_strings WHERE BINARY value='Schachschule Regez' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
|
0.1380 [ms]
|
SELECT value, language FROM cms_icl_strings WHERE id=1;
|
|
0.1671 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN ('_transient_timeout_wp_styles_for_blocks');
|
|
0.1042 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_wp_styles_for_blocks' LIMIT 1;
|
|
0.2651 [ms]
|
UPDATE `cms_options` SET `option_value` =
'a:2:{s:4:\"hash\";s:32:\"1d32b9046902021ed88221c6d5ec7e4d\";s:6:\"blocks\";a:5:{s:11:\"core/button\";s:0:\"\";s:14:\"core/site-logo\";s:0:\"\";s:18:\"core/post-template\";s:120:\":where(.wp-block-post-template.is-layout-flex){gap:
1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;}\";s:12:\"core/columns\";s:102:\":where(.wp-block-columns.is-layout-flex){gap:
2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;}\";s:14:\"core/pullquote\";s:69:\":root :where(.wp-block-pullquote){font-size:
1.5em;line-height: 1.6;}\";}}' WHERE `option_name` = '_transient_wp_styles_for_blocks';
|
|
0.9100 [ms]
|
SELECT * FROM cms_users WHERE ID = '2' LIMIT 1;
|
|
0.6840 [ms]
|
SELECT user_id, meta_key, meta_value FROM cms_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
|
0.1681 [ms]
|
SELECT value, language FROM cms_icl_strings WHERE id=1;
|
|
0.2911 [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))
;
|
|
1.1249 [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.5610 [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.2470 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (641) ORDER BY meta_id ASC;
|
|
0.3901 [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.2229 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (619) ORDER BY meta_id ASC;
|
|
0.4261 [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.1550 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (741) ORDER BY meta_id ASC;
|
|
0.3572 [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.1581 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (687) ORDER BY meta_id ASC;
|
|
0.3271 [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.1640 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (987) ORDER BY meta_id ASC;
|
|
0.3681 [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.1681 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (695) ORDER BY meta_id ASC;
|
|
0.3560 [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.1700 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1065) ORDER BY meta_id ASC;
|
|
0.3600 [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.4129 [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.2041 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (350) ORDER BY meta_id ASC;
|
|
0.2820 [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.1550 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (613) ORDER BY meta_id ASC;
|
|
0.4070 [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.5691 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1127) ORDER BY meta_id ASC;
|
|
0.3991 [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.2830 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1180) ORDER BY meta_id ASC;
|
|
0.3099 [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.1881 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1199) ORDER BY meta_id ASC;
|
|
0.3181 [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.2000 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (24) ORDER BY meta_id ASC;
|
|
0.4239 [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.1879 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1393) ORDER BY meta_id ASC;
|
|
0.3080 [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.1500 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (341) ORDER BY meta_id ASC;
|
|
0.3750 [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.2480 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (344) ORDER BY meta_id ASC;
|
|
0.3481 [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.1462 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (728) ORDER BY meta_id ASC;
|
|
0.4251 [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);
|
|
1.0638 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '1' ) AND comment_post_ID = 1304 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3190 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '0' ) AND comment_post_ID = 1304 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3040 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = 'spam' ) AND comment_post_ID = 1304 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2770 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = 'trash' ) AND comment_post_ID = 1304 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3200 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = 'post-trashed' ) AND comment_post_ID = 1304 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.5529 [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 = 1296 LIMIT 1);
|
|
0.4392 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '1' ) AND comment_post_ID = 1296 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2689 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '0' ) AND comment_post_ID = 1296 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2949 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = 'spam' ) AND comment_post_ID = 1296 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2689 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = 'trash' ) AND comment_post_ID = 1296 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2971 [ms]
|
SELECT COUNT(*)
FROM cms_comments JOIN cms_icl_translations icltr2
ON icltr2.element_id = cms_comments.comment_post_ID
JOIN cms_posts ON cms_posts.ID = icltr2.element_id
AND CONCAT('post_', cms_posts.post_type) = icltr2.element_type
LEFT JOIN cms_icl_translations icltr_comment
ON icltr_comment.element_id = cms_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = 'post-trashed' ) AND comment_post_ID = 1296 AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.1521 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (5,9,11,10,12);
|
|
0.3040 [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 = 5 LIMIT 1);
|
|
0.1271 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (5);
|
|
0.1171 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (9);
|
|
0.1080 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (10);
|
|
0.5291 [ms]
|
SELECT t.term_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN cms_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 NOT IN (5,9,10) AND ( ( icl_t.element_type IN ('tax_category') AND ( icl_t.language_code = 'de'
OR 0 ) )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL )
ORDER BY t.name ASC
;
|
|
0.2248 [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 (6,1,15,14,13);
|
|
0.3231 [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 = 6 LIMIT 1);
|
|
0.3510 [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 = 1 LIMIT 1);
|
|
0.3998 [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 = 15 LIMIT 1);
|
|
0.3800 [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 = 14 LIMIT 1);
|
|
0.4091 [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 = 13 LIMIT 1);
|
|
0.3440 [ms]
|
SELECT 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 = 'cs_chessgame' 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_date DESC
LIMIT 0, 1;
|
|
0.3951 [ms]
|
SELECT 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 = 'cs_chessgame' 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_date DESC
LIMIT 0, 5;
|