|
0.3211 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_secret_key' LIMIT 1;
|
|
0.1729 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_admin_access_token' LIMIT 1;
|
|
0.3562 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ossdl_https' LIMIT 1;
|
|
0.1581 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'gzipcompression' LIMIT 1;
|
|
0.4189 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'alp_settings' LIMIT 1;
|
|
0.4809 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
|
0.2460 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
|
0.4971 [ms]
|
SHOW TABLES LIKE 'tnfr_icl_mo_files_domains';
|
|
0.7670 [ms]
|
SELECT * FROM tnfr_icl_mo_files_domains;
|
|
0.7610 [ms]
|
SELECT default_locale, code FROM tnfr_icl_languages;
|
|
0.1960 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml-xml-config-update-log' LIMIT 1;
|
|
0.2310 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
|
0.1981 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
|
0.7021 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM tnfr_posts
WHERE post_name IN ('partners')
AND post_type IN ('page','attachment')
;
|
|
0.2189 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 792 LIMIT 1;
|
|
43.7410 [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='en' and su.url='(.?.+?)(?:/([0-9]+))?/?$') or (su.language='en' and su.url IS NULL)
;
|
|
0.2239 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.3519 [ms]
|
SELECT option_name, option_value FROM tnfr_options WHERE option_name LIKE 'widget\_%';
|
|
0.2611 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
0.2918 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Tony Frey' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
|
0.1841 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2291 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Windsurfing Club' AND context='WP' AND name = 'Tagline' LIMIT 1;
|
|
0.1779 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=2 AND language='en';
|
|
0.3369 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
1.3890 [ms]
|
SELECT post_type, post_name
FROM tnfr_posts p
LEFT JOIN tnfr_icl_translations t
ON t.element_id = p.ID
AND CONCAT('post_', p.post_type) = t.element_type
AND p.post_type IN ('post','page','attachment','event','testimonial','mc4wp-form' )
WHERE post_name = 'partners' AND post_type IN ('post', 'page', 'attachment', 'event', 'testimonial')
AND ( post_status = 'publish'
OR ( post_type = 'attachment'
AND post_status = 'inherit' ) )
ORDER BY CASE t.language_code WHEN 'en' THEN 3 WHEN 'el' THEN 1 ELSE 0 END DESC , CASE p.post_type WHEN 'page' THEN 2 WHEN 'post'
THEN 1 ELSE 0 END DESC
LIMIT 1;
|
|
0.4029 [ms]
|
SELECT 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_type = 'page' AND p.post_name = 'partners'
ORDER BY p.post_parent = 0 DESC
;
|
|
0.6912 [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 = 792 LIMIT 1);
|
|
0.6890 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (792) ORDER BY meta_id ASC;
|
|
0.3190 [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.4170 [ms]
|
SELECT tnfr_posts.* 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.ID = '792') AND tnfr_posts.post_type = 'page' AND ( ( (
t.language_code = 'en' 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 ;
|
|
0.5760 [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.4139 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.4261 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.3130 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
0.2131 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ot_css_file_paths' LIMIT 1;
|
|
0.6900 [ms]
|
SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, t.element_type, NULLIF(t.source_language_code, '') IS NULL AS
original
, p.post_title, p.post_status
FROM tnfr_icl_translations t
LEFT JOIN tnfr_posts p ON t.element_id=p.ID
WHERE 1 AND ( p.post_status = 'publish' ) AND t.trid=262
;
|
|
0.5889 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 790 LIMIT 1;
|
|
0.9429 [ms]
|
SELECT * FROM tnfr_users WHERE ID = '1';
|
|
0.8950 [ms]
|
SELECT user_id, meta_key, meta_value FROM tnfr_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
|
0.2570 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
1.7951 [ms]
|
SELECT t.*, tt.* 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 ('post_tag') AND tr.object_id IN (792) ORDER BY t.name ASC ;
|
|
0.7110 [ms]
|
SELECT t.*, tt.* 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') AND tr.object_id IN (792) ORDER BY t.name ASC ;
|
|
0.3631 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 1038 LIMIT 1;
|
|
0.7749 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (1038) ORDER BY meta_id ASC;
|
|
0.2930 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2069 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
|
1.3189 [ms]
|
SELECT * FROM tnfr_posts WHERE (post_type = 'page' AND post_status = 'publish') AND post_parent = 792 ORDER BY tnfr_posts.post_title ASC LIMIT
0,1;
|
|
0.6709 [ms]
|
SELECT p.ID FROM tnfr_posts p
JOIN tnfr_icl_translations t ON p.ID = t.element_id
WHERE t.element_type='post_page' AND p.post_type='page' AND t.language_code <> 'en'
;
|
|
0.5200 [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.3080 [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.2708 [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.8528 [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.2921 [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.term_taxonomy_id = 3 LIMIT 1;
|
|
0.3569 [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 ('3') ORDER BY tr.object_id ASC;
|
|
0.9220 [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.element_id IN (9,11,22,23,24,25,26,862);
|
|
0.5691 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (9,11,22,23,24,25,26,862) AND tnfr_posts.post_type = 'nav_menu_item' AND
((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.menu_order ASC ;
|
|
0.8469 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (9,11,26,25,24,23,862,22) ORDER BY meta_id ASC;
|
|
1.0040 [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.element_id IN (2,12,14,16,18,20);
|
|
0.5240 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (2,12,14,16,18,792,20) AND tnfr_posts.post_type = 'page' AND
((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.post_date DESC ;
|
|
1.9388 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (2,14,18,20,16,12) ORDER BY meta_id ASC;
|
|
1.0231 [ms]
|
SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, t.element_type, NULLIF(t.source_language_code, '') IS NULL AS
original
, tm.name, tm.term_id, COUNT(tr.object_id) AS instances
FROM tnfr_icl_translations t
LEFT JOIN tnfr_term_taxonomy tt ON t.element_id=tt.term_taxonomy_id
LEFT JOIN tnfr_terms tm ON tt.term_id = tm.term_id
LEFT JOIN tnfr_term_relationships tr ON tr.term_taxonomy_id=tt.term_taxonomy_id
WHERE 1 AND t.trid=11
GROUP BY tm.term_id
;
|
|
1.4441 [ms]
|
SELECT * FROM tnfr_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order ASC;
|
|
0.6411 [ms]
|
SELECT p.ID FROM tnfr_posts p
JOIN tnfr_icl_translations t ON p.ID = t.element_id
WHERE t.element_type='post_page' AND p.post_type='page' AND t.language_code <> 'en'
;
|
|
0.9670 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (1098) ORDER BY meta_id ASC;
|
|
0.3309 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (1874) ORDER BY meta_id ASC;
|
|
1.2820 [ms]
|
SELECT * FROM tnfr_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order ASC;
|
|
0.6230 [ms]
|
SELECT p.ID FROM tnfr_posts p
JOIN tnfr_icl_translations t ON p.ID = t.element_id
WHERE t.element_type='post_page' AND p.post_type='page' AND t.language_code <> 'en'
;
|
|
0.2131 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 1875 LIMIT 1;
|
|
0.2019 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (1875) ORDER BY meta_id ASC;
|
|
0.3240 [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.5171 [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.1900 [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.term_taxonomy_id = 4 LIMIT 1;
|
|
0.2542 [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 ('4') ORDER BY tr.object_id ASC;
|
|
0.7570 [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.element_id IN (62,63,64,65,66,67,68,70,71,72,73,75,77,429,430,431,436,592,593,594,595);
|
|
0.4721 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (62,63,64,65,66,67,68,70,71,72,73,75,77,429,430,431,436,592,593,594,595) AND
tnfr_posts.post_type = 'nav_menu_item' AND ((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.menu_order ASC ;
|
|
0.8810 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (72,73,64,75,77,70,429,71,430,431,68,67,592,593,594,595,62,65,63,436,66)
ORDER BY meta_id ASC;
|
|
0.6070 [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.element_id IN (38,47,34,48,54,47,36,37,38);
|
|
0.4630 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE 1=1 AND tnfr_posts.ID IN (2,38,47,34,12,48,54,47,14,16,18,36,37,38,20) AND tnfr_posts.post_type = 'page'
AND ((tnfr_posts.post_status = 'publish')) ORDER BY tnfr_posts.post_date DESC ;
|
|
1.3161 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (37,48,54,47,38,36,34) ORDER BY meta_id ASC;
|
|
0.2270 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (7,1,5,6);
|
|
0.3068 [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.5510 [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 = 1 LIMIT 1);
|
|
0.4640 [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 = 5 LIMIT 1);
|
|
0.4201 [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 = 6 LIMIT 1);
|
|
0.4220 [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 = 7 LIMIT 1);
|
|
0.4761 [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 ( 1,5,6,7 ) AND
tt.count > 0 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.6750 [ms]
|
SELECT term_id, meta_key, meta_value FROM tnfr_termmeta WHERE term_id IN (1,7,6,5) ORDER BY meta_id ASC;
|
|
0.7050 [ms]
|
SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, t.element_type, NULLIF(t.source_language_code, '') IS NULL AS
original
, tm.name, tm.term_id, COUNT(tr.object_id) AS instances
FROM tnfr_icl_translations t
LEFT JOIN tnfr_term_taxonomy tt ON t.element_id=tt.term_taxonomy_id
LEFT JOIN tnfr_terms tm ON tt.term_id = tm.term_id
LEFT JOIN tnfr_term_relationships tr ON tr.term_taxonomy_id=tt.term_taxonomy_id
WHERE 1 AND t.trid=112
GROUP BY tm.term_id
;
|
|
0.5510 [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.4890 [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);
|
