|
1.3928 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'greenmarimba_client_settings' LIMIT 1;
|
|
1.4551 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_options`;
|
|
9.4111 [ms]
|
UPDATE `tmgi_options` SET `option_value` = 'active' WHERE `option_name` = 'revslider-code';
|
|
9.3341 [ms]
|
UPDATE `tmgi_options` SET `option_value` = '7h33ky51-7446-4574-4663-91b999e6dad5' WHERE `option_name` = 'revslider-code';
|
|
0.6988 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
0.7050 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'sue_settings_settings' LIMIT 1;
|
|
4.5352 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.9210 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_options' AND site_id = 1;
|
|
0.9038 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wpme_options' AND site_id = 1;
|
|
0.8140 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'sll_db_ver' AND site_id = 1;
|
|
0.8280 [ms]
|
SELECT * FROM tmgi_simple_login_log LIMIT 1;
|
|
15.3289 [ms]
|
ALTER TABLE tmgi_simple_login_log MODIFY user_role varchar(255) NOT NULL;;
|
|
0.7839 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'needsGeoIPSync';
|
|
0.7219 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'detectProxyRecommendation';
|
|
0.8559 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'WPLANG' AND site_id = 1;
|
|
0.7539 [ms]
|
SELECT MAX(attackLogTime) FROM tmgi_wfhits;
|
|
0.9100 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wordfence_lastSyncAttackData' AND site_id = 1;
|
|
0.9062 [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;
|
|
0.8471 [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;
|
|
0.8290 [ms]
|
SELECT * FROM `tmgi_wfblocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = X'00000000000000000000ffff12bfc8df' AND (`expiration` = 0 OR `expiration`
> UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1;
|
|
3.5422 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-replace' AND site_id = 1;
|
|
0.8020 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-allow-sites' AND site_id = 1;
|
|
1.2028 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_quantity' LIMIT 1;
|
|
0.7739 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_quantity' LIMIT 1;
|
|
0.7281 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_value' LIMIT 1;
|
|
0.7319 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_value' LIMIT 1;
|
|
0.8130 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
|
0.7510 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
|
0.8881 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 247 LIMIT 1;
|
|
0.8430 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 248 LIMIT 1;
|
|
0.8309 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;
|
|
0.7389 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_shipping_cost_requires_address' LIMIT 1;
|
|
0.7160 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1;
|
|
0.7479 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = '_transient_sswcmc_lists';
|
|
0.8590 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_ssl_activation_active' AND site_id = 1;
|
|
0.7651 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.7060 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
5.2161 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('isPaid', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
5.1012 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('success', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
5.2660 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('keyType', 'paid-current', 'yes') ON DUPLICATE KEY UPDATE val = 'paid-current', autoload =
'yes';
|
|
5.3301 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('licenseType', 'response', 'yes') ON DUPLICATE KEY UPDATE val = 'response', autoload = 'yes';
|
|
4.7479 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('premiumNextRenew', '1763707266', 'yes') ON DUPLICATE KEY UPDATE val = '1763707266', autoload
= 'yes';
|
|
19.1829 [ms]
|
SHOW TABLES LIKE 'tmgi\\_gf\\_rest\\_api\\_keys';
|
|
1.0409 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tmgi_posts.ID
FROM tmgi_posts
WHERE 1=1 AND ((tmgi_posts.post_type = 'product' AND (tmgi_posts.post_status = 'publish')))
ORDER BY tmgi_posts.post_date DESC
LIMIT 0, 10;
|
|
0.8779 [ms]
|
SELECT FOUND_ROWS();
|
|
1.6968 [ms]
|
SELECT tmgi_posts.* FROM tmgi_posts WHERE ID IN (478,218,217,207,82,72,70,44,10,8);
|
|
1.4319 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (478,218,217,207,82,72,70,44,10,8) ORDER BY meta_id ASC;
|
|
1.1680 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;
|
|
0.9711 [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.1201 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wfls_last_role_change' AND site_id = 1;
|
|
1.4200 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 246 LIMIT 1;
|
|
0.7801 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_coupons' LIMIT 1;
|
|
0.7610 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;
|
|
0.7598 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;
|
|
0.7398 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
0.7122 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_db_version' LIMIT 1;
|
|
0.7710 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_shipping' LIMIT 1;
|
|
0.8659 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_additional' LIMIT 1;
|
|
0.8900 [ms]
|
SELECT post_status, COUNT( * ) AS num_posts FROM tmgi_posts WHERE post_type = 'product' GROUP BY post_status;
|
|
0.9921 [ms]
|
DESCRIBE tmgi_stock_log;;
|
|
1.5500 [ms]
|
SHOW INDEX FROM tmgi_stock_log;;
|
|
1.6580 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tmgi_posts.ID
FROM tmgi_posts
WHERE 1=1 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')))
ORDER BY tmgi_posts.post_date DESC
LIMIT 0, 10;
|
|
1.2600 [ms]
|
SELECT FOUND_ROWS();
|
|
1.4160 [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 (478, 218, 217, 207, 82, 72, 70, 44, 10, 8)
ORDER BY t.name ASC
;
|
|
0.9699 [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,21,7,8,26,25,41,15,16,6,42,20,2,48);
|
|
1.0738 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gravityformsaddon_gf_theme_layers_version' LIMIT 1;
|
|
1.5292 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_timeout_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
0.9048 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
1.3540 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_env_hide_update_message' LIMIT 1;
|
|
0.7601 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'affwp_flush_rewrites' LIMIT 1;
|
|
1.2000 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_wflivetraffichuman`;
|
|
1.2379 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff12bfc8df' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
0.9880 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_file_download_method' LIMIT 1;
|
|
1.0669 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = 'woocommerce_admin_notice_redirect_download_method';
|
|
0.8841 [ms]
|
SELECT `id`, `name`, `path` FROM tmgi_pmxi_imports WHERE `path` IS NULL;
|
|
2.5630 [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
;
|
|
0.8588 [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,43,44,45,46,47);
|
|
0.9542 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_catalog_columns' LIMIT 1;
|
|
0.7830 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_catalog_rows' LIMIT 1;
|
|
1.0779 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tmgi_posts.ID
FROM tmgi_posts
WHERE 1=1 AND (
tmgi_posts.ID NOT IN (
SELECT object_id
FROM tmgi_term_relationships
WHERE term_taxonomy_id IN (40)
)
) 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.7319 [ms]
|
SELECT FOUND_ROWS();
|
|
1.2491 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff12bfc8df' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
1.3769 [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\":\"shop\"%';
|
|
0.8070 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
0.8390 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gform_enable_toolbar_menu' LIMIT 1;
|
|
0.7069 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'site_logo' LIMIT 1;
|
|
0.8609 [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.8382 [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
;
|
|
0.9332 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (253,252,251,286) ORDER BY meta_id ASC;
|
|
0.8261 [ms]
|
SELECT tmgi_posts.* FROM tmgi_posts WHERE ID IN (284);
|
|
1.0538 [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.0099 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 249 LIMIT 1;
|
|
1.2422 [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.5271 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_timeout_wc_term_counts' LIMIT 1;
|
|
1.8370 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_wc_term_counts' LIMIT 1;
|
|
1.2460 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_review_rating' LIMIT 1;
|
|
3.0310 [ms]
|
SELECT user_id, meta_key, meta_value FROM tmgi_usermeta WHERE user_id IN (8,2) ORDER BY umeta_id ASC;
|
|
1.3530 [ms]
|
SELECT * FROM tmgi_users WHERE ID IN (8,2);
|
|
1.3752 [ms]
|
SELECT * FROM tmgi_wc_tax_rate_classes ORDER BY name;
;
|
|
0.8771 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 282 LIMIT 1;
|
|
1.7931 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (282) ORDER BY meta_id ASC;
|
|
1.2519 [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 (8) AND (
( tmgi_termmeta.meta_key = 'order' OR tmgi_termmeta.meta_key IS NULL )
)
ORDER BY tmgi_termmeta.meta_value+0 ASC, t.name ASC
;
|
|
0.9961 [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 (8) 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.0900 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 477 LIMIT 1;
|
|
0.8411 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (477) ORDER BY meta_id ASC;
|
|
1.2050 [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.1091 [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
;
|
|
0.8671 [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.1549 [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;
|
