|
1.8110 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'greenmarimba_client_settings' LIMIT 1;
|
|
1.5190 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_options`;
|
|
11.2441 [ms]
|
UPDATE `tmgi_options` SET `option_value` = 'active' WHERE `option_name` = 'revslider-code';
|
|
9.5282 [ms]
|
UPDATE `tmgi_options` SET `option_value` = '7h33ky51-7446-4574-4663-91b999e6dad5' WHERE `option_name` = 'revslider-code';
|
|
1.3101 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
1.5459 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'sue_settings_settings' LIMIT 1;
|
|
1.1358 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
1.5309 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_options' AND site_id = 1;
|
|
1.1959 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wpme_options' AND site_id = 1;
|
|
1.1928 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'sll_db_ver' AND site_id = 1;
|
|
1.1699 [ms]
|
SELECT * FROM tmgi_simple_login_log LIMIT 1;
|
|
8.6989 [ms]
|
ALTER TABLE tmgi_simple_login_log MODIFY user_role varchar(255) NOT NULL;;
|
|
1.8880 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'needsGeoIPSync';
|
|
1.3201 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'detectProxyRecommendation';
|
|
1.0681 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'WPLANG' AND site_id = 1;
|
|
1.1182 [ms]
|
SELECT MAX(attackLogTime) FROM tmgi_wfhits;
|
|
1.0550 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wordfence_lastSyncAttackData' AND site_id = 1;
|
|
1.6341 [ms]
|
SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `tmgi_wfblocks7` WHERE `type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC;
|
|
2.2221 [ms]
|
SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `tmgi_wfblocks7` WHERE `type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC;
|
|
1.2541 [ms]
|
SELECT * FROM `tmgi_wfblocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = X'00000000000000000000ffff1275e6c6' AND (`expiration` = 0 OR `expiration`
> UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1;
|
|
2.4979 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-replace' AND site_id = 1;
|
|
1.2739 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-allow-sites' AND site_id = 1;
|
|
0.9649 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_quantity' LIMIT 1;
|
|
2.0349 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_quantity' LIMIT 1;
|
|
1.2479 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_value' LIMIT 1;
|
|
5.0399 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_value' LIMIT 1;
|
|
1.3440 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
|
1.1749 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
|
1.1592 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 247 LIMIT 1;
|
|
1.0409 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 248 LIMIT 1;
|
|
0.9789 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;
|
|
1.2460 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_shipping_cost_requires_address' LIMIT 1;
|
|
1.4811 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1;
|
|
1.3390 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = '_transient_sswcmc_lists';
|
|
1.1539 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_ssl_activation_active' AND site_id = 1;
|
|
1.0421 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
1.5252 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
4.1280 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('isPaid', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
3.8819 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('success', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
3.7889 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('keyType', 'paid-current', 'yes') ON DUPLICATE KEY UPDATE val = 'paid-current', autoload =
'yes';
|
|
6.1488 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('licenseType', 'response', 'yes') ON DUPLICATE KEY UPDATE val = 'response', autoload = 'yes';
|
|
5.7051 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('premiumNextRenew', '1769639226', 'yes') ON DUPLICATE KEY UPDATE val = '1769639226', autoload
= 'yes';
|
|
40.9520 [ms]
|
SHOW TABLES LIKE 'tmgi\\_gf\\_rest\\_api\\_keys';
|
|
1.3978 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;
|
|
1.0691 [ms]
|
SELECT session_value FROM tmgi_woocommerce_sessions WHERE session_key = 't_c895e2cd878c62fedaccc1b5cf57f7';
|
|
1.1060 [ms]
|
SELECT webhook_id, status, name, user_id, delivery_url, secret, topic, date_created, date_modified, api_version, failure_count, pending_delivery FROM
tmgi_wc_webhooks WHERE webhook_id = 1 LIMIT 1;;
|
|
1.1749 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wfls_last_role_change' AND site_id = 1;
|
|
1.3700 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 246 LIMIT 1;
|
|
1.9369 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_coupons' LIMIT 1;
|
|
1.5209 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;
|
|
1.2579 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;
|
|
1.9798 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
1.5211 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_db_version' LIMIT 1;
|
|
1.2610 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_shipping' LIMIT 1;
|
|
1.1559 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_additional' LIMIT 1;
|
|
1.1270 [ms]
|
SELECT post_status, COUNT( * ) AS num_posts FROM tmgi_posts WHERE post_type = 'product' GROUP BY post_status;
|
|
1.4882 [ms]
|
DESCRIBE tmgi_stock_log;;
|
|
1.0781 [ms]
|
SHOW INDEX FROM tmgi_stock_log;;
|
|
1.0960 [ms]
|
SELECT t.term_id
FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat') AND t.slug IN ('sativa-dominant')
;
|
|
1.0731 [ms]
|
SELECT t.*, tt.* FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (20);
|
|
1.7090 [ms]
|
SELECT t.term_id
FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat') AND t.term_id IN ( 20 )
;
|
|
1.9400 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tmgi_posts.ID
FROM tmgi_posts LEFT JOIN tmgi_term_relationships ON (tmgi_posts.ID = tmgi_term_relationships.object_id)
WHERE 1=1 AND (
tmgi_term_relationships.term_taxonomy_id IN (20)
) AND ((tmgi_posts.post_type = 'product' AND (tmgi_posts.post_status = 'publish' OR tmgi_posts.post_status = 'future' OR tmgi_posts.post_status =
'wcrm-not-started' OR tmgi_posts.post_status = 'wcrm-deferred' OR tmgi_posts.post_status = 'wcrm-in-progress' OR tmgi_posts.post_status =
'wcrm-completed' OR tmgi_posts.post_status = 'wcrm-waiting' OR tmgi_posts.post_status = 'wcrm-current')))
GROUP BY tmgi_posts.ID
ORDER BY tmgi_posts.post_date DESC
LIMIT 0, 10;
|
|
1.0030 [ms]
|
SELECT FOUND_ROWS();
|
|
1.0779 [ms]
|
SELECT tmgi_posts.* FROM tmgi_posts WHERE ID IN (82,10);
|
|
1.5419 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (82,10) ORDER BY meta_id ASC;
|
|
1.8551 [ms]
|
SELECT DISTINCT t.term_id, tr.object_id
FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN tmgi_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type', 'product_visibility', 'product_cat', 'product_tag', 'product_shipping_class', 'pa_breeder', 'pa_genetics',
'pa_label') AND tr.object_id IN (82, 10)
ORDER BY t.name ASC
;
|
|
1.1899 [ms]
|
SELECT t.*, tt.* FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (21,8,16,2);
|
|
1.1570 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gravityformsaddon_gf_theme_layers_version' LIMIT 1;
|
|
1.3130 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_timeout_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
1.0612 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
1.2879 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_env_hide_update_message' LIMIT 1;
|
|
1.4451 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'affwp_flush_rewrites' LIMIT 1;
|
|
1.8029 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_wflivetraffichuman`;
|
|
1.0250 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff1275e6c6' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
1.0891 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_file_download_method' LIMIT 1;
|
|
0.9899 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = 'woocommerce_admin_notice_redirect_download_method';
|
|
1.0681 [ms]
|
SELECT `id`, `name`, `path` FROM tmgi_pmxi_imports WHERE `path` IS NULL;
|
|
1.3080 [ms]
|
SELECT t.term_id
FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat') AND t.slug IN ('sativa-dominant')
LIMIT 1;
|
|
1.2228 [ms]
|
SELECT t.term_id
FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_visibility')
ORDER BY t.name ASC
;
|
|
2.3241 [ms]
|
SELECT t.*, tt.* FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (40,39,41,42,43,44,45,46,47);
|
|
1.1680 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_catalog_columns' LIMIT 1;
|
|
0.9661 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_catalog_rows' LIMIT 1;
|
|
1.9629 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tmgi_posts.ID
FROM tmgi_posts LEFT JOIN tmgi_term_relationships ON (tmgi_posts.ID = tmgi_term_relationships.object_id)
WHERE 1=1 AND (
tmgi_posts.ID NOT IN (
SELECT object_id
FROM tmgi_term_relationships
WHERE term_taxonomy_id IN (40)
)
AND
tmgi_term_relationships.term_taxonomy_id IN (20)
) AND ((tmgi_posts.post_type = 'product' AND (tmgi_posts.post_status = 'publish' OR tmgi_posts.post_status = 'future' OR tmgi_posts.post_status =
'wcrm-not-started' OR tmgi_posts.post_status = 'wcrm-deferred' OR tmgi_posts.post_status = 'wcrm-in-progress' OR tmgi_posts.post_status =
'wcrm-completed' OR tmgi_posts.post_status = 'wcrm-waiting' OR tmgi_posts.post_status = 'wcrm-current')))
GROUP BY tmgi_posts.ID
ORDER BY tmgi_posts.menu_order ASC, tmgi_posts.post_title ASC
LIMIT 0, 16;
|
|
0.9680 [ms]
|
SELECT FOUND_ROWS();
|
|
1.1132 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff1275e6c6' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
1.4920 [ms]
|
SELECT form_id FROM tmgi_gf_form_meta AS meta LEFT JOIN tmgi_gf_form AS form ON form.id = meta.form_id WHERE is_trash = 0 AND is_active = 1 AND
display_meta LIKE '%\"form_full_screen_slug\":\"product-category/sativa-dominant\"%';
|
|
1.2012 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
1.4119 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gform_enable_toolbar_menu' LIMIT 1;
|
|
1.0660 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'site_logo' LIMIT 1;
|
|
1.7171 [ms]
|
SELECT t.*, tt.* FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 22;
|
|
1.5280 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts LEFT JOIN tmgi_term_relationships ON (tmgi_posts.ID = tmgi_term_relationships.object_id)
WHERE 1=1 AND (
tmgi_term_relationships.term_taxonomy_id IN (22)
) AND tmgi_posts.post_type = 'nav_menu_item' AND ((tmgi_posts.post_status = 'publish'))
GROUP BY tmgi_posts.ID
ORDER BY tmgi_posts.menu_order ASC
;
|
|
1.2600 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (253,252,251,286) ORDER BY meta_id ASC;
|
|
1.4009 [ms]
|
SELECT tmgi_posts.* FROM tmgi_posts WHERE ID IN (284);
|
|
1.0500 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (246,247,248,284) ORDER BY meta_id ASC;
|
|
1.0550 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 249 LIMIT 1;
|
|
1.7200 [ms]
|
SELECT t.term_id
FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat')
ORDER BY t.name ASC
;
|
|
1.3199 [ms]
|
SELECT t.*, tt.* FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (24,26,25,6,48);
|
|
1.2040 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_timeout_wc_term_counts' LIMIT 1;
|
|
1.1961 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_wc_term_counts' LIMIT 1;
|
|
1.7359 [ms]
|
SELECT term_id, meta_key, meta_value FROM tmgi_termmeta WHERE term_id IN (2,20,8,21,16,40,39,41,42,43,44,45,46,47,24,26,25,6,48) ORDER BY meta_id ASC;
|
|
1.3962 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_review_rating' LIMIT 1;
|
|
4.0090 [ms]
|
SELECT user_id, meta_key, meta_value FROM tmgi_usermeta WHERE user_id IN (8) ORDER BY umeta_id ASC;
|
|
1.3931 [ms]
|
SELECT * FROM tmgi_users WHERE ID IN (8);
|
|
1.4029 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 477 LIMIT 1;
|
|
6.8390 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (477) ORDER BY meta_id ASC;
|
|
1.8229 [ms]
|
SELECT DISTINCT t.term_id
FROM tmgi_terms AS t LEFT JOIN tmgi_termmeta ON ( t.term_id = tmgi_termmeta.term_id AND tmgi_termmeta.meta_key='order') INNER JOIN
tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN tmgi_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('pa_breeder') AND tr.object_id IN (10) AND (
( tmgi_termmeta.meta_key = 'order' OR tmgi_termmeta.meta_key IS NULL )
)
ORDER BY tmgi_termmeta.meta_value+0 ASC, t.name ASC
;
|
|
1.2560 [ms]
|
SELECT DISTINCT t.term_id
FROM tmgi_terms AS t LEFT JOIN tmgi_termmeta ON ( t.term_id = tmgi_termmeta.term_id AND tmgi_termmeta.meta_key='order') INNER JOIN
tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN tmgi_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('pa_label') AND tr.object_id IN (10) AND (
( tmgi_termmeta.meta_key = 'order' OR tmgi_termmeta.meta_key IS NULL )
)
ORDER BY tmgi_termmeta.meta_value+0 ASC, t.name ASC
;
|
|
1.3220 [ms]
|
SELECT DISTINCT t.term_id
FROM tmgi_terms AS t LEFT JOIN tmgi_termmeta ON ( t.term_id = tmgi_termmeta.term_id AND tmgi_termmeta.meta_key='order') INNER JOIN
tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN tmgi_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('pa_genetics') AND tr.object_id IN (10) AND (
( tmgi_termmeta.meta_key = 'order' OR tmgi_termmeta.meta_key IS NULL )
)
ORDER BY tmgi_termmeta.meta_value+0 ASC, t.name ASC
;
|
|
1.4360 [ms]
|
SELECT t.*, tt.* FROM tmgi_terms AS t INNER JOIN tmgi_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 23;
|
