|
0.2968 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_secret_key' LIMIT 1;
|
|
0.1431 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'disqus_admin_access_token' LIMIT 1;
|
|
0.3560 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ossdl_https' LIMIT 1;
|
|
0.1559 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'gzipcompression' LIMIT 1;
|
|
0.3080 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'alp_settings' LIMIT 1;
|
|
0.3490 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml_notices' LIMIT 1;
|
|
0.1810 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = '_wpml_dismissed_notices' LIMIT 1;
|
|
0.3891 [ms]
|
SHOW TABLES LIKE 'tnfr_icl_mo_files_domains';
|
|
0.7770 [ms]
|
SELECT * FROM tnfr_icl_mo_files_domains;
|
|
0.7930 [ms]
|
SELECT default_locale, code FROM tnfr_icl_languages;
|
|
0.2029 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpml-xml-config-update-log' LIMIT 1;
|
|
0.2289 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'icl_st_settings' LIMIT 1;
|
|
0.1991 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
|
37.3759 [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.2370 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.3750 [ms]
|
SELECT option_name, option_value FROM tnfr_options WHERE option_name LIKE 'widget\_%';
|
|
0.2508 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
0.5190 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Tony Frey' AND context='WP' AND name = 'Blog Title' LIMIT 1;
|
|
0.1900 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2310 [ms]
|
SELECT id FROM tnfr_icl_strings WHERE BINARY value='Windsurfing Club' AND context='WP' AND name = 'Tagline' LIMIT 1;
|
|
0.2048 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=2 AND language='en';
|
|
0.3560 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
|
|
0.1500 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
|
|
0.9398 [ms]
|
INSERT INTO `tnfr_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1573559251.2661299705505371093750', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.3259 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
0.9730 [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.5901 [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.6330 [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.1621 [ms]
|
SELECT slug FROM tnfr_terms
WHERE term_id = 1 LIMIT 1;
|
|
0.3309 [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.4508 [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.2010 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.3431 [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.3350 [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.0569 [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.0989 [ms]
|
SELECT FOUND_ROWS();
|
|
0.3200 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (685,498,494,500);
|
|
0.9232 [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.4711 [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.4332 [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.8030 [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.4411 [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.2079 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.3209 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2139 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
0.1540 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'ot_css_file_paths' LIMIT 1;
|
|
0.5920 [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.8762 [ms]
|
SELECT * FROM tnfr_users WHERE ID = '1';
|
|
0.6540 [ms]
|
SELECT user_id, meta_key, meta_value FROM tnfr_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
|
0.2999 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
1.0169 [ms]
|
SELECT post_id FROM tnfr_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2014/05/TF_logo_youtube_3.png';
|
|
0.2370 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 624 LIMIT 1;
|
|
0.2580 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (624) ORDER BY meta_id ASC;
|
|
0.2382 [ms]
|
SELECT value FROM tnfr_icl_strings WHERE id=1 AND language='en';
|
|
0.2320 [ms]
|
SELECT option_value FROM tnfr_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
|
0.2999 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 16 LIMIT 1;
|
|
0.4141 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (16) ORDER BY meta_id ASC;
|
|
0.2620 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 336 LIMIT 1;
|
|
0.2069 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (336) ORDER BY meta_id ASC;
|
|
0.3350 [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.2840 [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.2830 [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.5670 [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.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.term_taxonomy_id = 3 LIMIT 1;
|
|
0.3848 [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.9520 [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.5920 [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.7620 [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.0550 [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.5581 [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 ;
|
|
2.0289 [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.6330 [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.2990 [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.2480 [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.6909 [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.2880 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (669,605,603,601);
|
|
0.3631 [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.3252 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (688,690,692);
|
|
0.2291 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (688,690,692) ORDER BY meta_id ASC;
|
|
0.5839 [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.7331 [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.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.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.2369 [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.7279 [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.5000 [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.2029 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.3049 [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.2079 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.2098 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.2060 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (1);
|
|
0.5839 [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.4191 [ms]
|
SELECT tnfr_posts.* FROM tnfr_posts WHERE ID IN (728,719,709);
|
|
1.1671 [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.4759 [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.5682 [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.4840 [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.4761 [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.4330 [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.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 = 35 LIMIT 1);
|
|
0.4251 [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.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 = 29 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 = 28 LIMIT 1);
|
|
0.4668 [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.4871 [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.5050 [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.3870 [ms]
|
SELECT post_id, meta_key, meta_value FROM tnfr_postmeta WHERE post_id IN (709,719,728) ORDER BY meta_id ASC;
|
|
0.5829 [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.5109 [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.4930 [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.0831 [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.5560 [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.3729 [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.5209 [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.2291 [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.2780 [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.8049 [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.5460 [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.9401 [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.6599 [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.5889 [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.3990 [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.2232 [ms]
|
SELECT taxonomy, term_id FROM tnfr_term_taxonomy
WHERE term_id IN (7,1,5,6);
|
|
0.5701 [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.6828 [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.6120 [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.3572 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 143 LIMIT 1;
|
|
0.4251 [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.2041 [ms]
|
SELECT * FROM tnfr_posts WHERE ID = 144 LIMIT 1;
|
