|
0.2170 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_secret_key' LIMIT 1;
|
|
0.1340 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_admin_access_token' LIMIT 1;
|
|
0.2410 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ossdl_https' LIMIT 1;
|
|
0.1569 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'gzipcompression' LIMIT 1;
|
|
0.1872 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'alp_settings' LIMIT 1;
|
|
0.2880 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
|
0.2270 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
|
0.4179 [ms]
|
SHOW TABLES LIKE 'tnfr_icl_mo_files_domains';
|
|
0.2379 [ms]
|
SELECT * FROM tnfr_icl_mo_files_domains;
|
|
0.3669 [ms]
|
SELECT default_locale, code FROM tnfr_icl_languages;
|
|
0.2110 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml-xml-config-update-log' LIMIT 1;
|
|
0.3190 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
|
0.7272 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM tnfr_posts
WHERE post_name IN ('2018')
AND post_type IN ('post','attachment')
;
|
|
37.9238 [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 tnfr_icl_string_pages sp
INNER JOIN tnfr_icl_string_urls su
ON su.id = sp.url_id
INNER JOIN tnfr_icl_strings s
ON s.id = sp.string_id
LEFT JOIN tnfr_icl_string_translations st
ON s.id=st.string_id
AND st.language=su.language
AND s.language!=su.language
WHERE (su.language='el' and su.url='([0-9]{4})/([0-9]{1,2})/?$') or (su.language='el' and su.url IS NULL)
;
|
|
0.3901 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.6931 [ms]
|
SELECT option_name, option_value FROM tnfr_options WHERE option_name LIKE 'widget\_%';
|
|
0.3722 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
0.5760 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Tony Frey' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
|
0.3161 [ms]
|
SELECT language, value, status FROM tnfr_icl_string_translations WHERE string_id=1;
|
|
0.4070 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Windsurfing Club' AND context='WP' AND name = 'Tagline' LIMIT 1;
|
|
0.2949 [ms]
|
SELECT language, value, status FROM tnfr_icl_string_translations WHERE string_id=2;
|
|
0.3300 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
0.7300 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tnfr_posts.ID FROM tnfr_posts JOIN tnfr_icl_translations t
ON tnfr_posts.ID = t.element_id
AND t.element_type = CONCAT('post_', tnfr_posts.post_type) WHERE 1=1 AND (
( YEAR( tnfr_posts.post_date ) = 2018 AND MONTH( tnfr_posts.post_date ) = 5 )
) AND tnfr_posts.post_type = 'post' AND (tnfr_posts.post_status = 'publish') AND ( ( ( t.language_code = 'el' OR 0 ) AND tnfr_posts.post_type IN
('post','page','attachment','event','testimonial','mc4wp-form' ) ) OR tnfr_posts.post_type NOT IN
('post','page','attachment','event','testimonial','mc4wp-form' ) ) ORDER BY tnfr_posts.post_date DESC LIMIT 0, 10;
|
|
0.1180 [ms]
|
SELECT FOUND_ROWS();
|
|
0.2868 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (1890,1883);
|
|
1.2760 [ms]
|
SELECT t.*, tt.*, tr.object_id FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN tnfr_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 (1883, 1890) ORDER
BY t.name ASC ;
|
|
0.8271 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 40 LIMIT 1);
|
|
0.5782 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 41 LIMIT 1);
|
|
0.5569 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 42 LIMIT 1);
|
|
0.6080 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 2 LIMIT 1);
|
|
0.5720 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (1883,1890) ORDER BY meta_id ASC;
|
|
0.3910 [ms]
|
SELECT language, value, status FROM tnfr_icl_string_translations WHERE string_id=1;
|
|
0.3631 [ms]
|
SELECT language, value, status FROM tnfr_icl_string_translations WHERE string_id=1;
|
|
0.2701 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
0.2148 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ot_css_file_paths' LIMIT 1;
|
|
0.6130 [ms]
|
SELECT p.ID FROM tnfr_posts p
JOIN tnfr_icl_translations t
ON p.ID = t.element_id AND t.element_type = CONCAT('post_', p.post_type)
WHERE p.post_status = 'publish' AND year(p.post_date) = 2018 AND month(p.post_date) = 5 AND p.post_type = 'post' AND (t.language_code = 'en'
OR 0)
LIMIT 1;
|
|
0.4630 [ms]
|
SELECT p.ID FROM tnfr_posts p
JOIN tnfr_icl_translations t
ON p.ID = t.element_id AND t.element_type = CONCAT('post_', p.post_type)
WHERE p.post_status = 'publish' AND year(p.post_date) = 2018 AND month(p.post_date) = 5 AND p.post_type = 'post' AND (t.language_code = 'el'
OR 0)
LIMIT 1;
|
|
0.3681 [ms]
|
SELECT * FROM tnfr_users WHERE ID = '2';
|
|
0.6120 [ms]
|
SELECT user_id, meta_key, meta_value FROM tnfr_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
|
0.2971 [ms]
|
SELECT language, value, status FROM tnfr_icl_string_translations WHERE string_id=1;
|
|
1.7869 [ms]
|
SELECT post_id FROM tnfr_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2014/05/TF_logo_youtube_3.png';
|
|
0.3450 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 624 LIMIT 1;
|
|
0.3319 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (624) ORDER BY meta_id ASC;
|
|
0.3030 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
|
0.2501 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
|
0.3150 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 16 LIMIT 1;
|
|
0.6242 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (16) ORDER BY meta_id ASC;
|
|
0.2692 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 336 LIMIT 1;
|
|
0.2959 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (336) ORDER BY meta_id ASC;
|
|
0.4060 [ms]
|
SELECT t.*, tt.* FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('nav_menu') AND t.slug =
'primary' LIMIT 1;
|
|
0.3512 [ms]
|
SELECT t.*, tt.* FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('nav_menu') AND t.name IN
('primary') LIMIT 1;
|
|
0.3221 [ms]
|
SELECT t.*, tt.* FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 8;
|
|
0.6552 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 8 LIMIT 1);
|
|
0.2799 [ms]
|
SELECT tr.object_id FROM tnfr_term_relationships AS tr INNER JOIN tnfr_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE
tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('8') ORDER BY tr.object_id ASC;
|
|
0.4370 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (235,237,238,239,240,241,242,863) AND tnfr_posts.post_type = 'nav_menu_item'
AND ((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.menu_order ASC ;
|
|
0.5178 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (235,239,237,241,238,240,863,242) ORDER BY meta_id ASC;
|
|
0.4699 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (168,167,166,165,164,790,133) AND tnfr_posts.post_type = 'page' AND
((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.post_date DESC ;
|
|
1.2460 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (790,168,166,164,133,165,167) ORDER BY meta_id ASC;
|
|
0.8001 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 168 LIMIT 1);
|
|
0.6521 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 167 LIMIT 1);
|
|
0.7119 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 166 LIMIT 1);
|
|
0.5460 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 165 LIMIT 1);
|
|
0.7360 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 164 LIMIT 1);
|
|
0.6680 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 790 LIMIT 1);
|
|
0.6208 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 133 LIMIT 1);
|
|
0.4668 [ms]
|
SELECT element_id, language_code
FROM tnfr_icl_translations
WHERE trid =
(SELECT trid
FROM tnfr_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM tnfr_options
WHERE option_name='page_for_posts'
LIMIT 1))
;
|
|
0.2980 [ms]
|
SELECT element_id, language_code
FROM tnfr_icl_translations
WHERE trid =
(SELECT trid
FROM tnfr_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM tnfr_options
WHERE option_name='page_on_front'
LIMIT 1))
;
|
|
0.4311 [ms]
|
SELECT t.element_id, tax.term_id, tax.taxonomy
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id;
|
|
0.5491 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 1890 LIMIT 1);
|
|
0.3290 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (1891,1884);
|
|
0.2542 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (1884,1891) ORDER BY meta_id ASC;
|
|
0.7060 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 1893 LIMIT 1;
|
|
0.2499 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (1893) ORDER BY meta_id ASC;
|
|
0.5970 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 1883 LIMIT 1);
|
|
0.5579 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 403 LIMIT 1);
|
|
0.2818 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 403 LIMIT 1;
|
|
0.3009 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (403) ORDER BY meta_id ASC;
|
|
0.2451 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 604 LIMIT 1;
|
|
0.3059 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (604) ORDER BY meta_id ASC;
|
|
1.0190 [ms]
|
SELECT t.*, tt.* FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN tnfr_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 tt.count > 0 AND ( (
icl_t.element_type IN ('tax_category') AND ( icl_t.language_code = 'el' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL ) ORDER BY t.name ASC ;
|
|
0.2840 [ms]
|
SELECT term_id, meta_key, meta_value FROM tnfr_termmeta WHERE term_id IN (2,9) ORDER BY meta_id ASC;
|
|
0.5751 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 9 LIMIT 1);
|
|
0.5341 [ms]
|
SELECT tnfr_posts.ID FROM tnfr_posts JOIN tnfr_icl_translations t
ON tnfr_posts.ID = t.element_id
AND t.element_type = CONCAT('post_', tnfr_posts.post_type) WHERE 1=1 AND tnfr_posts.post_type = 'post' AND ((tnfr_posts.post_status =
'publish')) AND ( ( ( t.language_code = 'el' OR 0 ) AND tnfr_posts.post_type IN ('post','page','attachment','event','testimonial','mc4wp-form' ) )
OR tnfr_posts.post_type NOT IN ('post','page','attachment','event','testimonial','mc4wp-form' ) ) ORDER BY tnfr_posts.post_date DESC LIMIT 0, 5;
|
|
0.4110 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (724,715,705);
|
|
1.5321 [ms]
|
SELECT t.*, tt.*, tr.object_id FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN tnfr_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 (705, 715, 724)
ORDER BY t.name ASC ;
|
|
0.4508 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 17 LIMIT 1);
|
|
0.6299 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 31 LIMIT 1);
|
|
0.6249 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 21 LIMIT 1);
|
|
0.5431 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 15 LIMIT 1);
|
|
0.4370 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 33 LIMIT 1);
|
|
0.4561 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 34 LIMIT 1);
|
|
0.4420 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 19 LIMIT 1);
|
|
0.4380 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 18 LIMIT 1);
|
|
0.4740 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 32 LIMIT 1);
|
|
0.5100 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 38 LIMIT 1);
|
|
0.4210 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 16 LIMIT 1);
|
|
0.4001 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 20 LIMIT 1);
|
|
0.3800 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 22 LIMIT 1);
|
|
0.4122 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (705,715,724) ORDER BY meta_id ASC;
|
|
0.6671 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 724 LIMIT 1);
|
|
0.6981 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 715 LIMIT 1);
|
|
0.6568 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 705 LIMIT 1);
|
|
1.3659 [ms]
|
SELECT tnfr_comments.comment_ID FROM tnfr_comments JOIN tnfr_posts ON tnfr_posts.ID = tnfr_comments.comment_post_ID JOIN tnfr_icl_translations icltr2
ON icltr2.element_id = tnfr_comments.comment_post_ID
AND tnfr_posts.ID = icltr2.element_id
AND CONCAT('post_', tnfr_posts.post_type) = icltr2.element_type
LEFT JOIN tnfr_icl_translations icltr_comment
ON icltr_comment.element_id = tnfr_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '1' ) AND tnfr_posts.post_status IN ('publish') AND icltr2.language_code = 'el'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
) ORDER BY tnfr_comments.comment_date_gmt DESC LIMIT 0,5;
|
|
0.2382 [ms]
|
SELECT tnfr_comments.* FROM tnfr_comments WHERE comment_ID IN (1);
|
|
0.5929 [ms]
|
SELECT comment_id, meta_key, meta_value FROM tnfr_commentmeta WHERE comment_id IN (1) ORDER BY meta_id ASC;
|
|
0.3221 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (398);
|
|
0.6850 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 398 LIMIT 1);
|
|
0.7639 [ms]
|
SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM tnfr_posts JOIN tnfr_icl_translations t ON t.element_id =
tnfr_posts.ID AND t.element_type='post_post' WHERE post_type = 'post' AND post_status = 'publish' AND (language_code = 'el' OR 0 ) GROUP BY
YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC ;
|
|
1.4672 [ms]
|
SELECT t.*, tt.* FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 12;
|
|
0.7389 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 12 LIMIT 1);
|
|
0.3390 [ms]
|
SELECT tr.object_id FROM tnfr_term_relationships AS tr INNER JOIN tnfr_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE
tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('12') ORDER BY tr.object_id ASC;
|
|
0.7999 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (437,438,439,440,441,442,443,444,445,446,447,448,449,450,455,456,457,596,597)
AND tnfr_posts.post_type = 'nav_menu_item' AND ((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.menu_order ASC ;
|
|
1.6000 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (442,437,445,444,443,441,446,447,448,449,438,450,596,597,439,455,456,457,440)
ORDER BY meta_id ASC;
|
|
0.8991 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (168,177,163,180,167,176,175,163,166,165,164,179,178,177,133) AND
tnfr_posts.post_type = 'page' AND ((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.post_date DESC ;
|
|
2.4209 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (178,176,175,163,177,179,180) ORDER BY meta_id ASC;
|
|
0.2720 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (9,2);
|
|
0.6921 [ms]
|
SELECT t.*, tt.* FROM tnfr_terms AS t INNER JOIN tnfr_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN tnfr_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 ( 2,9 ) AND
tt.count > 0 AND ( ( icl_t.element_type IN ('tax_category') AND ( icl_t.language_code = 'el' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL ) ORDER BY t.name ASC ;
|
|
0.7980 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 177 LIMIT 1);
|
|
0.7629 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 163 LIMIT 1);
|
|
0.7660 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 180 LIMIT 1);
|
|
0.7920 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 176 LIMIT 1);
|
|
0.5610 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 175 LIMIT 1);
|
|
0.7188 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 179 LIMIT 1);
|
|
0.6230 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 178 LIMIT 1);
|
|
0.5629 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 143 LIMIT 1);
|
|
0.2930 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 161 LIMIT 1;
|
|
0.5651 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN tnfr_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM tnfr_icl_translations t
JOIN tnfr_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 144 LIMIT 1);
|
|
0.2429 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 160 LIMIT 1;
|
