1.1640 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'greenmarimba_client_settings' LIMIT 1;
|
1.1621 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_options`;
|
13.2151 [ms]
|
UPDATE `tmgi_options` SET `option_value` = 'active' WHERE `option_name` = 'revslider-code';
|
9.4488 [ms]
|
UPDATE `tmgi_options` SET `option_value` = '7h33ky51-7446-4574-4663-91b999e6dad5' WHERE `option_name` = 'revslider-code';
|
0.7560 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
0.6449 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'sue_settings_settings' LIMIT 1;
|
1.2848 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
1.0190 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_options' AND site_id = 1;
|
1.0040 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wpme_options' AND site_id = 1;
|
0.9980 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'sll_db_ver' AND site_id = 1;
|
0.7870 [ms]
|
SELECT * FROM tmgi_simple_login_log LIMIT 1;
|
15.3251 [ms]
|
ALTER TABLE tmgi_simple_login_log MODIFY user_role varchar(255) NOT NULL;;
|
0.7992 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'needsGeoIPSync';
|
0.7081 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'detectProxyRecommendation';
|
0.8790 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'WPLANG' AND site_id = 1;
|
0.6809 [ms]
|
SELECT MAX(attackLogTime) FROM tmgi_wfhits;
|
0.7150 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wordfence_lastSyncAttackData' AND site_id = 1;
|
1.1940 [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.8960 [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.7560 [ms]
|
SELECT * FROM `tmgi_wfblocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = X'00000000000000000000ffff03913247' AND (`expiration` = 0 OR `expiration`
> UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1;
|
1.0309 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-replace' AND site_id = 1;
|
0.7398 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-allow-sites' AND site_id = 1;
|
0.7291 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_quantity' LIMIT 1;
|
0.6800 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_quantity' LIMIT 1;
|
0.6390 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_value' LIMIT 1;
|
0.7350 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_value' LIMIT 1;
|
0.6759 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
0.6590 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
0.8931 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 247 LIMIT 1;
|
0.7651 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 248 LIMIT 1;
|
0.7210 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;
|
0.6449 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_shipping_cost_requires_address' LIMIT 1;
|
0.7238 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1;
|
1.3800 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = '_transient_sswcmc_lists';
|
1.1439 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_ssl_activation_active' AND site_id = 1;
|
1.0400 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
1.0021 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
5.1951 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('isPaid', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
5.5840 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('success', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
6.4929 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('keyType', 'paid-current', 'yes') ON DUPLICATE KEY UPDATE val = 'paid-current', autoload =
'yes';
|
5.4300 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('licenseType', 'response', 'yes') ON DUPLICATE KEY UPDATE val = 'response', autoload = 'yes';
|
5.2159 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('premiumNextRenew', '1763716216', 'yes') ON DUPLICATE KEY UPDATE val = '1763716216', autoload
= 'yes';
|
19.9721 [ms]
|
SHOW TABLES LIKE 'tmgi\\_gf\\_rest\\_api\\_keys';
|
1.3402 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts
WHERE 1=1 AND tmgi_posts.ID = 405 AND tmgi_posts.post_type = 'page'
ORDER BY tmgi_posts.post_date DESC
;
|
0.9410 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (405) ORDER BY meta_id ASC;
|
1.0660 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;
|
0.7679 [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;;
|
0.8509 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wfls_last_role_change' AND site_id = 1;
|
1.2932 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 246 LIMIT 1;
|
0.7551 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_coupons' LIMIT 1;
|
1.3151 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;
|
0.6480 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;
|
1.0440 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
1.3189 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_db_version' LIMIT 1;
|
0.6709 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_shipping' LIMIT 1;
|
0.6301 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_additional' LIMIT 1;
|
0.8070 [ms]
|
SELECT post_status, COUNT( * ) AS num_posts FROM tmgi_posts WHERE post_type = 'product' GROUP BY post_status;
|
1.1699 [ms]
|
DESCRIBE tmgi_stock_log;;
|
0.7191 [ms]
|
SHOW INDEX FROM tmgi_stock_log;;
|
1.1818 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts
WHERE 1=1 AND tmgi_posts.post_name = 'cobra-lips' AND tmgi_posts.post_type = 'product'
ORDER BY tmgi_posts.post_date DESC
;
|
0.9589 [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)
ORDER BY t.name ASC
;
|
1.0591 [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,2);
|
1.2360 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (82) ORDER BY meta_id ASC;
|
7.1979 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gravityformsaddon_gf_theme_layers_version' LIMIT 1;
|
1.1699 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_timeout_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
0.8059 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
0.7479 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_env_hide_update_message' LIMIT 1;
|
0.8278 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'affwp_flush_rewrites' LIMIT 1;
|
1.3640 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_wflivetraffichuman`;
|
0.7460 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff03913247' AND identifier = 'üÏ7`Væ?ûéðÎYϲ«–÷žRÜ~Óù\Z[' AND
expiration >= UNIX_TIMESTAMP();
|
0.8259 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_file_download_method' LIMIT 1;
|
0.6831 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = 'woocommerce_admin_notice_redirect_download_method';
|
1.1759 [ms]
|
SELECT `id`, `name`, `path` FROM tmgi_pmxi_imports WHERE `path` IS NULL;
|
0.9439 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts
WHERE 1=1 AND tmgi_posts.post_name = 'cobra-lips' AND tmgi_posts.post_type = 'product'
ORDER BY tmgi_posts.post_date DESC
;
|
0.7410 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff03913247' AND identifier = 'üÏ7`Væ?ûéðÎYϲ«–÷žRÜ~Óù\Z[' AND
expiration >= UNIX_TIMESTAMP();
|
1.1511 [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/cobra-lips\"%';
|
0.8531 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
1.0190 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_review_rating_required' LIMIT 1;
|
0.8671 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gform_enable_toolbar_menu' LIMIT 1;
|
0.6869 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'site_logo' LIMIT 1;
|
0.8259 [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.7810 [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.2350 [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.0002 [ms]
|
SELECT tmgi_posts.* FROM tmgi_posts WHERE ID IN (284);
|
1.1599 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (246,247,248,284) ORDER BY meta_id ASC;
|
0.9840 [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 ('product_cat') AND tr.object_id IN (82) 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 option_value FROM tmgi_options WHERE option_name = '_transient_timeout_wc_term_counts' LIMIT 1;
|
1.2040 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_wc_term_counts' LIMIT 1;
|
1.3418 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 249 LIMIT 1;
|
1.2379 [ms]
|
SELECT DISTINCT t.term_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_cat') AND tr.object_id IN (82)
ORDER BY tt.parent DESC
;
|
1.0762 [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
;
|
0.8080 [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);
|
2.9240 [ms]
|
SELECT user_id, meta_key, meta_value FROM tmgi_usermeta WHERE user_id IN (8) ORDER BY umeta_id ASC;
|
0.6878 [ms]
|
SELECT * FROM tmgi_users WHERE ID IN (8);
|
0.8359 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_catalog_columns' LIMIT 1;
|
1.1292 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 477 LIMIT 1;
|
1.2319 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (477) ORDER BY meta_id ASC;
|
1.0240 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_review_rating' LIMIT 1;
|
1.4441 [ms]
|
SELECT SQL_CALC_FOUND_ROWS tmgi_comments.comment_ID
FROM tmgi_comments LEFT JOIN tmgi_posts ON comment_post_ID = tmgi_posts.ID
WHERE ( comment_approved = '1' ) AND comment_post_ID = 82 AND comment_parent = 0 AND tmgi_posts.post_type NOT IN ('wc_crm_accounts') AND
comment_type != 'order_note' AND comment_type != 'webhook_delivery'
ORDER BY tmgi_comments.comment_date_gmt ASC, tmgi_comments.comment_ID ASC
;
|
0.7782 [ms]
|
SELECT tmgi_comments.* FROM tmgi_comments WHERE comment_ID IN (97);
|
0.8411 [ms]
|
SELECT tmgi_comments.comment_ID
FROM tmgi_comments LEFT JOIN tmgi_posts ON comment_post_ID = tmgi_posts.ID
WHERE ( comment_approved = '1' ) AND comment_post_ID = 82 AND comment_parent IN ( 97 ) AND tmgi_posts.post_type NOT IN ('wc_crm_accounts') AND
comment_type != 'order_note' AND comment_type != 'webhook_delivery'
ORDER BY tmgi_comments.comment_date_gmt ASC, tmgi_comments.comment_ID ASC
;
|
0.7880 [ms]
|
SELECT * FROM tmgi_users WHERE ID = '2' LIMIT 1;
|
1.5230 [ms]
|
SELECT user_id, meta_key, meta_value FROM tmgi_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
1.0531 [ms]
|
SELECT comment_id, meta_key, meta_value FROM tmgi_commentmeta WHERE comment_id IN (97) ORDER BY meta_id ASC;
|
0.7019 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_review_rating_verification_label' LIMIT 1;
|
0.7701 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_review_rating_verification_required' LIMIT 1;
|
1.3969 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_timeout_wc_related_82' LIMIT 1;
|
0.6728 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_wc_related_82' LIMIT 1;
|
0.8881 [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.8020 [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);
|
0.9170 [ms]
|
SELECT DISTINCT ID FROM tmgi_posts p
LEFT JOIN ( SELECT object_id FROM tmgi_term_relationships WHERE term_taxonomy_id IN ( 40 ) ) AS exclude_join ON exclude_join.object_id = p.ID
INNER JOIN ( SELECT object_id FROM tmgi_term_relationships INNER JOIN tmgi_term_taxonomy using( term_taxonomy_id ) WHERE term_id IN ( 20 ) ) AS
include_join ON include_join.object_id = p.ID
WHERE 1=1
AND p.post_status = 'publish'
AND p.post_type = 'product'
AND exclude_join.object_id IS NULL AND p.ID NOT IN ( 0,82 )
LIMIT 25
;
|
9.7132 [ms]
|
INSERT INTO `tmgi_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_wc_related_82', '1732266616', 'no') ON DUPLICATE
KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
11.5180 [ms]
|
INSERT INTO `tmgi_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_wc_related_82',
'a:1:{s:50:\"limit=5&exclude_ids%5B0%5D=0&exclude_ids%5B1%5D=82\";a:1:{i:0;s:2:\"10\";}}', 'no') ON DUPLICATE KEY UPDATE `option_name` =
VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
1.3831 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 10 LIMIT 1;
|
0.9351 [ms]
|
SELECT DISTINCT t.term_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') AND tr.object_id IN (10)
ORDER BY t.name ASC
;
|
1.6582 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (10) ORDER BY meta_id ASC;
|
0.9530 [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
;
|
0.7870 [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 (8);
|
0.9360 [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.7060 [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 (16);
|
0.8080 [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
;
|
0.9708 [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);
|
0.8399 [ms]
|
SELECT DISTINCT t.term_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_visibility') AND tr.object_id IN (10)
ORDER BY t.name ASC
;
|
0.8411 [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 ('product_cat') 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.9961 [ms]
|
SELECT DISTINCT t.term_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_tag') AND tr.object_id IN (10)
ORDER BY t.name ASC
;
|
0.9720 [ms]
|
SELECT DISTINCT t.term_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_shipping_class') AND tr.object_id IN (10)
ORDER BY t.name ASC
;
|
1.4350 [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;
|
Rodrigo (verified owner) –
Excellent quality and presentation