0.4299 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_secret_key' LIMIT 1;
|
0.1330 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_admin_access_token' LIMIT 1;
|
0.3760 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ossdl_https' LIMIT 1;
|
0.1240 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'gzipcompression' LIMIT 1;
|
0.2680 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'alp_settings' LIMIT 1;
|
0.4029 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
0.3240 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
0.5651 [ms]
|
SHOW TABLES LIKE 'tnfr_icl_mo_files_domains';
|
0.8759 [ms]
|
SELECT * FROM tnfr_icl_mo_files_domains;
|
1.1709 [ms]
|
SELECT default_locale, code FROM tnfr_icl_languages;
|
0.2301 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml-xml-config-update-log' LIMIT 1;
|
0.2542 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
0.3641 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
40.4651 [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='category/(.+?)/?$') or (su.language='en' and su.url IS NULL)
;
|
0.2389 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
0.3481 [ms]
|
SELECT option_name, option_value FROM tnfr_options WHERE option_name LIKE 'widget\_%';
|
0.2201 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
0.4711 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Tony Frey' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
0.1931 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
0.2329 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Windsurfing Club' AND context='WP' AND name = 'Tagline' LIMIT 1;
|
0.1810 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=2 AND language='en';
|
0.3982 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
1.0042 [ms]
|
SELECT t.term_id FROM tnfr_terms t
JOIN tnfr_term_taxonomy tt ON t.term_id = tt.term_id
WHERE tt.taxonomy = 'category' AND t.slug = 'news' LIMIT 1;
|
0.5369 [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.5860 [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.1481 [ms]
|
SELECT slug FROM tnfr_terms
WHERE term_id = 1 LIMIT 1;
|
0.2961 [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 ('category') AND t.slug =
'news' LIMIT 1;
|
0.3881 [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.slug IN ('news') 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.1800 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
0.3061 [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 ) 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.2711 [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 ('category') AND t.slug IN
('news') LIMIT 1;
|
1.1001 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tnfr_posts.ID FROM tnfr_posts LEFT JOIN tnfr_term_relationships ON (tnfr_posts.ID = tnfr_term_relationships.object_id)
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_term_relationships.term_taxonomy_id IN (1)
) AND tnfr_posts.post_type = 'post' AND (tnfr_posts.post_status = 'publish') 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' ) ) GROUP BY tnfr_posts.ID ORDER BY tnfr_posts.post_date DESC LIMIT 0, 10;
|
0.0911 [ms]
|
SELECT FOUND_ROWS();
|
0.3159 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (685,498,494,500);
|
0.7520 [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 (494, 498, 500,
685) ORDER BY t.name ASC ;
|
0.4258 [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.4098 [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.6270 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (494,498,500,685) ORDER BY meta_id ASC;
|
0.3810 [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 = 2;
|
0.1991 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
0.2389 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
0.1669 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
0.1440 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ot_css_file_paths' LIMIT 1;
|
0.5839 [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=7
GROUP BY tm.term_id
;
|
0.7761 [ms]
|
SELECT * FROM tnfr_users WHERE ID = '1';
|
0.6092 [ms]
|
SELECT user_id, meta_key, meta_value FROM tnfr_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
0.2029 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
1.0321 [ms]
|
SELECT post_id FROM tnfr_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2014/05/TF_logo_youtube_3.png';
|
0.2701 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 624 LIMIT 1;
|
0.2480 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (624) ORDER BY meta_id ASC;
|
0.2730 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
0.2279 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
0.3560 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 16 LIMIT 1;
|
0.4771 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (16) ORDER BY meta_id ASC;
|
0.2019 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 336 LIMIT 1;
|
0.2480 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (336) ORDER BY meta_id ASC;
|
0.3011 [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.2599 [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.2551 [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.5262 [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.2129 [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.3111 [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.6101 [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.3741 [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.4859 [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;
|
0.6368 [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,792,20);
|
0.3788 [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.0171 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (792,2,14,18,20,12) ORDER BY meta_id ASC;
|
0.5929 [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
;
|
0.2949 [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.2511 [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.6990 [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 = 685 LIMIT 1);
|
0.3021 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (669,605,603,601);
|
0.4060 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (601,603,605,669) ORDER BY meta_id ASC;
|
0.4461 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (688,690,692);
|
0.3378 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (688,690,692) ORDER BY meta_id ASC;
|
0.6611 [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 = 498 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_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 = 494 LIMIT 1);
|
0.5281 [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 = 500 LIMIT 1);
|
0.8979 [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 = '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.7679 [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.4649 [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.1731 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
0.3321 [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 ) 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.1700 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
0.1969 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
0.1919 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
0.4761 [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 = '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 LIMIT 0, 5;
|
0.3040 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (728,719,709);
|
0.8881 [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 (709, 719, 728)
ORDER BY t.name ASC ;
|
0.4101 [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 = 27 LIMIT 1);
|
0.4010 [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 = 37 LIMIT 1);
|
0.4091 [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 = 25 LIMIT 1);
|
0.4339 [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 = 36 LIMIT 1);
|
0.4239 [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 = 26 LIMIT 1);
|
0.4120 [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 = 35 LIMIT 1);
|
0.4320 [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 = 39 LIMIT 1);
|
0.4249 [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 = 29 LIMIT 1);
|
0.4139 [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 = 28 LIMIT 1);
|
0.4170 [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 = 30 LIMIT 1);
|
0.4480 [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 = 23 LIMIT 1);
|
0.4439 [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 = 24 LIMIT 1);
|
0.3810 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (709,719,728) ORDER BY meta_id ASC;
|
0.4649 [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 = 728 LIMIT 1);
|
0.4079 [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 = 719 LIMIT 1);
|
0.4430 [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 = 709 LIMIT 1);
|
0.8891 [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 = 'en'
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.4659 [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 = 'en' OR 0 ) GROUP BY
YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC ;
|
0.2899 [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.4430 [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.1941 [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.2620 [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.7341 [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.4740 [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.8519 [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.5581 [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.4141 [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.1160 [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.1831 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (7,1,5,6);
|
0.4389 [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.5550 [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.5410 [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.2680 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 143 LIMIT 1;
|
0.4232 [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.1922 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 144 LIMIT 1;
|