|
0.4909 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_secret_key' LIMIT 1;
|
|
0.1452 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_admin_access_token' LIMIT 1;
|
|
0.3150 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ossdl_https' LIMIT 1;
|
|
0.1290 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'gzipcompression' LIMIT 1;
|
|
0.2320 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'alp_settings' LIMIT 1;
|
|
0.3929 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
|
0.2091 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
|
0.3691 [ms]
|
SHOW TABLES LIKE 'tnfr_icl_mo_files_domains';
|
|
0.6959 [ms]
|
SELECT * FROM tnfr_icl_mo_files_domains;
|
|
0.7031 [ms]
|
SELECT default_locale, code FROM tnfr_icl_languages;
|
|
0.2329 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml-xml-config-update-log' LIMIT 1;
|
|
0.3350 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
|
0.3591 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
|
44.8620 [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.3159 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.6590 [ms]
|
SELECT option_name, option_value FROM tnfr_options WHERE option_name LIKE 'widget\_%';
|
|
0.3650 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
0.3519 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Tony Frey' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
|
0.2470 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2940 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Windsurfing Club' AND context='WP' AND name = 'Tagline' LIMIT 1;
|
|
0.2210 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=2 AND language='en';
|
|
0.4120 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
1.0240 [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.5631 [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.6430 [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.1931 [ms]
|
SELECT slug FROM tnfr_terms
WHERE term_id = 1 LIMIT 1;
|
|
0.4098 [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.4501 [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.2370 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.3631 [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.4179 [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.3590 [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.0951 [ms]
|
SELECT FOUND_ROWS();
|
|
0.3271 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (685,498,494,500);
|
|
0.8771 [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.5131 [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.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 = 5 LIMIT 1);
|
|
0.8090 [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.3760 [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.2239 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2999 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2141 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
0.1931 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ot_css_file_paths' LIMIT 1;
|
|
0.5701 [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.9210 [ms]
|
SELECT * FROM tnfr_users WHERE ID = '1';
|
|
0.6709 [ms]
|
SELECT user_id, meta_key, meta_value FROM tnfr_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
|
0.4220 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.9730 [ms]
|
SELECT post_id FROM tnfr_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2014/05/TF_logo_youtube_3.png';
|
|
0.2620 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 624 LIMIT 1;
|
|
0.2799 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (624) ORDER BY meta_id ASC;
|
|
0.2711 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2189 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
|
0.3741 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 16 LIMIT 1;
|
|
0.5960 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (16) ORDER BY meta_id ASC;
|
|
0.2680 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 336 LIMIT 1;
|
|
0.2491 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (336) ORDER BY meta_id ASC;
|
|
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.slug =
'primary' LIMIT 1;
|
|
0.2429 [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.2570 [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.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_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.1991 [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.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 ('3') ORDER BY tr.object_id ASC;
|
|
0.6192 [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.3948 [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.4752 [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.6280 [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.3779 [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.9519 [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.7701 [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.3650 [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.2880 [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))
;
|
|
1.2341 [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.6099 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (669,605,603,601);
|
|
0.5879 [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.4570 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (688,690,692);
|
|
0.4010 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (688,690,692) ORDER BY meta_id ASC;
|
|
0.9160 [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.8671 [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.8929 [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);
|
|
1.2002 [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.7069 [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.5391 [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.2592 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.3879 [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.3951 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.2980 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.4141 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.6711 [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.3600 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (728,719,709);
|
|
1.1389 [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.5341 [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.4900 [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.4580 [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.4971 [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.4401 [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.4990 [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.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 = 39 LIMIT 1);
|
|
0.4392 [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.5052 [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.4621 [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.4721 [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.4311 [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.4270 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (709,719,728) ORDER BY meta_id ASC;
|
|
0.8609 [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.8781 [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);
|
|
1.1299 [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);
|
|
1.9000 [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.8109 [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.5448 [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.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_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.3700 [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.3412 [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;
|
|
1.3258 [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.6442 [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 ;
|
|
1.1520 [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.7439 [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.5538 [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.4150 [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.3209 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (7,1,5,6);
|
|
0.5610 [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.8731 [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.9711 [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.3061 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 143 LIMIT 1;
|
|
0.6580 [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.2458 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 144 LIMIT 1;
|
