|
0.4270 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_videos';
|
|
0.1981 [ms]
|
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wpdb_schachreg24' AND TABLE_NAME = 'cms_ts_galleryv_manager';
|
|
0.1650 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'BVSERVICESOPTIONNAME' LIMIT 1;
|
|
0.1068 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
0.1359 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
|
0.1380 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_pro_db_version' LIMIT 1;
|
|
0.1562 [ms]
|
SELECT code, locale FROM cms_icl_locale_map;
|
|
0.1590 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_w' LIMIT 1;
|
|
0.0820 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'embed_size_h' LIMIT 1;
|
|
0.1881 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
|
0.1581 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
|
0.1860 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
|
0.2899 [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.3309 [ms]
|
INSERT INTO `cms_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_wpml_st_upgrade_in_progress', '1750688079', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.1950 [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.4930 [ms]
|
SHOW TABLES LIKE 'cms_icl_string_packages';
|
|
0.1369 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_wpml_st_upgrade_in_progress';
|
|
0.5720 [ms]
|
SHOW FULL COLUMNS FROM `cms_options`;
|
|
0.2589 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_wpml_st_upgrade_in_progress';
|
|
0.1259 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_timeout_wpml_st_upgrade_in_progress';
|
|
0.2069 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = '_transient_timeout_wpml_st_upgrade_in_progress';
|
|
0.2151 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml_tax_slug_translation_settings' LIMIT 1;
|
|
0.1390 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_d5a83b86abba9804f40adb3ec71d3250' LIMIT 1;
|
|
0.1948 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'vimeography_db_version' LIMIT 1;
|
|
0.2019 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.2820 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM cms_posts
WHERE post_name IN ('schoolyardwhispering')
AND post_type IN ('page','attachment')
;
|
|
0.1791 [ms]
|
SELECT * FROM cms_posts WHERE ID = 80 LIMIT 1;
|
|
55.8021 [ms]
|
SELECT DISTINCT
s.id,
s.name,
s.context,
st.status,
s.gettext_context,
st.value AS tra,
st.mo_string AS mo_string,
s.value AS orig
FROM cms_icl_string_pages sp
INNER JOIN cms_icl_string_urls su
ON su.id = sp.url_id
INNER JOIN cms_icl_strings s
ON s.id = sp.string_id
LEFT JOIN cms_icl_string_translations st
ON s.id=st.string_id
AND st.language=su.language
AND s.language!=su.language
WHERE (su.language='en' and su.url='(.?.+?)(?:/([0-9]+))?/?$')
;
|
|
0.2210 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_lite_connect' LIMIT 1;
|
|
0.2050 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'fresh_site' LIMIT 1;
|
|
0.1841 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpforms_square_connections' LIMIT 1;
|
|
0.3760 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name LIKE 'widget\_%';
|
|
0.3090 [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.1640 [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.4382 [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.1211 [ms]
|
SELECT t.term_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.term_taxonomy_id IN (4)
LIMIT 1;
|
|
0.1459 [ms]
|
SELECT t.*, tt.* FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (4);
|
|
0.9129 [ms]
|
SELECT cms_posts.*
FROM cms_posts LEFT JOIN cms_term_relationships ON (cms_posts.ID = cms_term_relationships.object_id)
WHERE 1=1 AND (
cms_term_relationships.term_taxonomy_id IN (4)
) AND cms_posts.post_type = 'nav_menu_item' AND ((cms_posts.post_status = 'publish'))
GROUP BY cms_posts.ID
ORDER BY cms_posts.menu_order ASC
;
|
|
0.1020 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'sticky_posts_en' LIMIT 1;
|
|
0.3879 [ms]
|
SELECT DISTINCT t.term_id, tr.object_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN cms_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
WHERE tt.taxonomy IN ('nav_menu') AND tr.object_id IN (8, 70, 79, 81, 67)
ORDER BY t.name ASC
;
|
|
0.4909 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (8,70,79,81,67) ORDER BY meta_id ASC;
|
|
0.1779 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (7,69,78,66);
|
|
0.3362 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (7,69,78,80,66) ORDER BY meta_id ASC;
|
|
0.2129 [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.4511 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 7 LIMIT 1);
|
|
0.3691 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 69 LIMIT 1);
|
|
0.4680 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 78 LIMIT 1);
|
|
0.3531 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 80 LIMIT 1);
|
|
0.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 = 66 LIMIT 1);
|
|
0.4079 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.language_code, wpml_translations.element_id, wpml_translations.source_language_code,
wpml_translations.element_type, NULLIF(wpml_translations.source_language_code, '') IS NULL AS original
, tm.name, tm.term_id, COUNT(tr.object_id) AS instances
FROM cms_icl_translations wpml_translations
LEFT JOIN cms_term_taxonomy tt ON wpml_translations.element_id=tt.term_taxonomy_id
LEFT JOIN cms_terms tm ON tt.term_id = tm.term_id
LEFT JOIN cms_term_relationships tr ON tr.term_taxonomy_id=tt.term_taxonomy_id
WHERE 1 AND wpml_translations.trid=5
GROUP BY tm.term_id
;
|
|
0.4711 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'frm_addons_l24637171ef0fe70a62abfdd21aab5180' LIMIT 1;
|
|
0.1462 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN
('_transient_frmformapi_request_lock','_transient_timeout_frmformapi_request_lock');
|
|
0.5500 [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.2379 [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.4301 [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.2279 [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.1740 [ms]
|
SELECT meta_value FROM cms_postmeta WHERE meta_key='frm_param' ;
|
|
0.2801 [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.5150 [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 = 'schoolyardwhispering' AND post_type IN ('post', 'page', 'attachment', 'frm_display', 'cs_chessgame', 'custom-courses',
'custom-press')
AND ( post_status = 'publish'
OR ( post_type = 'attachment'
AND post_status = 'inherit' ) )
ORDER BY CASE wpml_translations.language_code WHEN 'en' THEN 3 WHEN 'de' THEN 1 ELSE 0 END DESC , CASE p.post_type WHEN 'page' THEN
2 WHEN 'post' THEN 1 ELSE 0 END DESC
LIMIT 1;
|
|
1.3289 [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 = 'schoolyardwhispering'
ORDER BY p.post_parent = 0 DESC
;
|
|
0.1850 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (9,12,10,11);
|
|
0.2348 [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.3741 [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.4041 [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.2961 [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 ( 12,11 ) AND ( ( icl_t.element_type IN ('tax_category') AND ( icl_t.language_code = 'en' OR 0
) )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL )
;
|
|
0.2520 [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 (11,12);
|
|
1.4131 [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.ID NOT IN (
SELECT object_id
FROM cms_term_relationships
WHERE term_taxonomy_id IN (11,12)
)
) AND ((cms_posts.post_type = 'post' AND (cms_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND
cms_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) )
OR cms_posts.post_type NOT IN
('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) )
GROUP BY cms_posts.ID
ORDER BY cms_posts.post_date DESC
LIMIT 0, 20;
|
|
0.1051 [ms]
|
SELECT FOUND_ROWS();
|
|
0.2558 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (1220,1175,512,459,432,411,287,255,83,82);
|
|
0.4320 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1220,1175,512,459,432,411,287,255,83,82) ORDER BY meta_id ASC;
|
|
0.3221 [ms]
|
SELECT DISTINCT t.term_id, tr.object_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN cms_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1220, 1175, 512, 459, 432, 411, 287, 255, 83, 82)
ORDER BY t.name ASC
;
|
|
0.2420 [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,3);
|
|
0.2968 [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.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 = 3 LIMIT 1);
|
|
0.4430 [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 = 1220 LIMIT 1);
|
|
0.2172 [ms]
|
SELECT id FROM cms_icl_strings WHERE BINARY value='Schachschule Regez' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
|
0.1099 [ms]
|
SELECT value, language FROM cms_icl_strings WHERE id=1;
|
|
0.1471 [ms]
|
SELECT language, value, status FROM cms_icl_string_translations WHERE string_id=1;
|
|
0.1919 [ms]
|
SELECT option_name, option_value FROM cms_options WHERE option_name IN ('_transient_timeout_wp_styles_for_blocks');
|
|
0.1209 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = '_transient_wp_styles_for_blocks' LIMIT 1;
|
|
0.3531 [ms]
|
UPDATE `cms_options` SET `option_value` =
'a:2:{s:4:\"hash\";s:32:\"8c7d46a72d7d4591fc1dd9485bedb304\";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.4060 [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=16
;
|
|
0.2241 [ms]
|
SELECT * FROM cms_posts WHERE ID = 22 LIMIT 1;
|
|
0.1440 [ms]
|
SELECT * FROM cms_users WHERE ID = '2' LIMIT 1;
|
|
0.4449 [ms]
|
SELECT user_id, meta_key, meta_value FROM cms_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
|
1.0450 [ms]
|
SELECT cms_posts.*
FROM cms_posts JOIN cms_icl_translations wpml_translations
ON cms_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', cms_posts.post_type)
WHERE 1=1 AND cms_posts.post_type = 'page' AND ((cms_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 )
AND cms_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' )
) OR cms_posts.post_type NOT IN
('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) )
ORDER BY cms_posts.menu_order ASC
;
|
|
0.5050 [ms]
|
SELECT p.ID FROM cms_posts p
JOIN cms_icl_translations wpml_translations ON p.ID = wpml_translations.element_id
WHERE wpml_translations.element_type='post_page' AND p.post_type='page' AND wpml_translations.language_code <> 'en'
;
|
|
0.4520 [ms]
|
SELECT p.ID FROM cms_posts p
JOIN cms_icl_translations wpml_translations ON p.ID = wpml_translations.element_id
WHERE wpml_translations.element_type='post_page' AND p.post_type='page' AND wpml_translations.language_code <> 'en'
;
|
|
0.1991 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1164) 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 = 1164 LIMIT 1);
|
|
0.1721 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (1177) 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 = 1177 LIMIT 1);
|
|
0.2172 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (986) ORDER BY meta_id ASC;
|
|
0.4191 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 986 LIMIT 1);
|
|
0.3028 [ms]
|
SELECT user_id, meta_key, meta_value FROM cms_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
|
0.1359 [ms]
|
SELECT * FROM cms_users WHERE ID IN (1);
|
|
0.3369 [ms]
|
INSERT IGNORE INTO cms_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1750688019', 'no') /* LOCK */;
|
|
0.1559 [ms]
|
SELECT option_value FROM cms_options WHERE option_name = 'wpml.WPML_ST_DB_Cache.lock' LIMIT 1;
|
|
0.1581 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = 'wpml.WPML_ST_DB_Cache.lock' LIMIT 1;
|
|
0.1328 [ms]
|
UPDATE `cms_options` SET `option_value` = '1750688019' WHERE `option_name` = 'wpml.WPML_ST_DB_Cache.lock';
|
|
2.2740 [ms]
|
SELECT COUNT(id) FROM cms_icl_strings WHERE context = 'default';
|
|
3.5031 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
st.mo_string AS mo_string,
s.value AS original,
s.gettext_context
FROM cms_icl_strings s
LEFT JOIN cms_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 0;
|
|
5.8699 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
st.mo_string AS mo_string,
s.value AS original,
s.gettext_context
FROM cms_icl_strings s
LEFT JOIN cms_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 1000;
|
|
9.2590 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
st.mo_string AS mo_string,
s.value AS original,
s.gettext_context
FROM cms_icl_strings s
LEFT JOIN cms_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 2000;
|
|
10.4189 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
st.mo_string AS mo_string,
s.value AS original,
s.gettext_context
FROM cms_icl_strings s
LEFT JOIN cms_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 3000;
|
|
12.1400 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
st.mo_string AS mo_string,
s.value AS original,
s.gettext_context
FROM cms_icl_strings s
LEFT JOIN cms_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 4000;
|
|
11.9300 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
st.mo_string AS mo_string,
s.value AS original,
s.gettext_context
FROM cms_icl_strings s
LEFT JOIN cms_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 5000;
|
|
0.2229 [ms]
|
SELECT autoload FROM cms_options WHERE option_name = 'wpml.WPML_ST_DB_Cache.lock';
|
|
0.3779 [ms]
|
DELETE FROM `cms_options` WHERE `option_name` = 'wpml.WPML_ST_DB_Cache.lock';
|
|
0.5021 [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 = 1220 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3631 [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 = 1220 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2651 [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 = 1220 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3581 [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 = 1220 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2818 [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 = 1220 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2129 [ms]
|
SELECT * FROM cms_posts WHERE ID = 1221 LIMIT 1;
|
|
0.2849 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (946) ORDER BY meta_id ASC;
|
|
0.6371 [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 = 1175 LIMIT 1);
|
|
0.3691 [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 = 1175 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3629 [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 = 1175 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3340 [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 = 1175 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2899 [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 = 1175 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3140 [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 = 1175 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.5138 [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.element_id IN (936,934,933,920,915,946);
|
|
0.4659 [ms]
|
SELECT cms_posts.ID
FROM cms_posts LEFT JOIN cms_postmeta ON ( cms_posts.ID = cms_postmeta.post_id AND cms_postmeta.meta_key =
'wpforms_richtext_attachment_temporary' )
WHERE 1=1 AND cms_posts.ID IN (936,934,933,920,915,946) AND (cms_posts.post_mime_type LIKE 'image/%') AND (
cms_postmeta.post_id IS NULL
) AND cms_posts.post_type = 'attachment' AND ((cms_posts.post_status = 'inherit'))
GROUP BY cms_posts.ID
ORDER BY FIELD(cms_posts.ID,936,934,933,920,915,946)
LIMIT 0, 6;
|
|
0.2141 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (936,934,933,920,915,946);
|
|
0.2489 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (936,934,933,920,915) ORDER BY meta_id ASC;
|
|
0.3159 [ms]
|
SELECT DISTINCT t.term_id, tr.object_id
FROM cms_terms AS t INNER JOIN cms_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN cms_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
WHERE tt.taxonomy IN ('category') AND tr.object_id IN (936, 934, 933, 920, 915, 946)
ORDER BY t.name ASC
;
|
|
0.2611 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (907) ORDER BY meta_id ASC;
|
|
0.5162 [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 = 512 LIMIT 1);
|
|
0.4170 [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 = 512 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.4311 [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 = 512 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3569 [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 = 512 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3979 [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 = 512 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3340 [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 = 512 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2041 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (325,403);
|
|
0.1910 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (325,403) 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 = 459 LIMIT 1);
|
|
0.3660 [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 = 459 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2999 [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 = 459 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3319 [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 = 459 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2820 [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 = 459 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3302 [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 = 459 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2060 [ms]
|
SELECT cms_posts.* FROM cms_posts WHERE ID IN (361,315);
|
|
0.2029 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (361,315) ORDER BY meta_id ASC;
|
|
0.3941 [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 = 432 LIMIT 1);
|
|
0.3362 [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 = 432 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3109 [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 = 432 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2780 [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 = 432 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2961 [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 = 432 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2539 [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 = 432 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.1512 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (396) ORDER BY meta_id ASC;
|
|
0.4761 [ms]
|
SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code,
wpml_translations.trid, wpml_translations.element_type
FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN cms_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE tridt.trid = (SELECT trid FROM cms_icl_translations wpml_translations
JOIN cms_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 411 LIMIT 1);
|
|
0.3388 [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 = 411 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3309 [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 = 411 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2980 [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 = 411 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2830 [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 = 411 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2701 [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 = 411 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.1810 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (395) ORDER BY meta_id ASC;
|
|
0.4280 [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 = 287 LIMIT 1);
|
|
0.2780 [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 = 287 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2692 [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 = 287 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2799 [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 = 287 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2589 [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 = 287 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2592 [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 = 287 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.1559 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (285) ORDER BY meta_id ASC;
|
|
0.4508 [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 = 255 LIMIT 1);
|
|
0.2909 [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 = 255 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2570 [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 = 255 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2789 [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 = 255 AND icltr2.language_code = 'en'
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 = 255 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2491 [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 = 255 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.1791 [ms]
|
SELECT post_id, meta_key, meta_value FROM cms_postmeta WHERE post_id IN (253) ORDER BY meta_id ASC;
|
|
0.3898 [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 = 83 LIMIT 1);
|
|
0.3800 [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 = 83 AND icltr2.language_code = 'en'
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 = 83 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2861 [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 = 83 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2651 [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 = 83 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2780 [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 = 83 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.4590 [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 = 82 LIMIT 1);
|
|
0.3581 [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 = 82 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3550 [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 = 82 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3459 [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 = 82 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.3331 [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 = 82 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.2871 [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 = 82 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
;
|
|
0.1879 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (5,9,11,10,12);
|
|
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_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.1190 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (12);
|
|
0.1280 [ms]
|
SELECT taxonomy, term_id FROM cms_term_taxonomy
WHERE term_id IN (11);
|
|
0.4430 [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 (12,11) AND ( ( icl_t.element_type IN ('tax_category') AND ( icl_t.language_code = 'en' OR
0 ) )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL )
ORDER BY t.name ASC
;
|
|
0.2079 [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 (8,7);
|
|
0.3970 [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 = 8 LIMIT 1);
|
|
0.3150 [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 = 7 LIMIT 1);
|
|
0.4411 [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 = 'en'
OR 0 ) AND cms_posts.post_type IN
('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) ) OR cms_posts.post_type
NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) )
ORDER BY cms_posts.post_date DESC
LIMIT 0, 1;
|
|
0.3879 [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 = 'en'
OR 0 ) AND cms_posts.post_type IN
('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) ) OR cms_posts.post_type
NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','cs_chessgame','custom-courses' ) )
ORDER BY cms_posts.post_date DESC
LIMIT 0, 5;
|
The chess-school Markus Regez in Küsnacht is organising chesscourses for children and teenager in both weeks of the spring holidays. We worked out a covid19-security-concept for our school. And we will go more outside if the weather is good as usual during our holidaychesscamps.
The chessschool Markus Regez organises once more chesscamps in the sportsvacation for kids from 5 and older. In the weeks from 13.-17. February and from 20. – 24. February we offer a full-day chesscourse from 9 am to 4 pm with lunch. Adress: Schachschule Markus Regez, Seestrasse 149, 8700 Küsnacht. (Please use the parkingplaces in the near accomodation).
