|
0.6940 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'greenmarimba_client_settings' LIMIT 1;
|
|
0.8702 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_options`;
|
|
15.7340 [ms]
|
UPDATE `tmgi_options` SET `option_value` = 'active' WHERE `option_name` = 'revslider-code';
|
|
11.1780 [ms]
|
UPDATE `tmgi_options` SET `option_value` = '7h33ky51-7446-4574-4663-91b999e6dad5' WHERE `option_name` = 'revslider-code';
|
|
0.9470 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
0.7319 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'sue_settings_settings' LIMIT 1;
|
|
1.0870 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
1.1570 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_options' AND site_id = 1;
|
|
0.7820 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wpme_options' AND site_id = 1;
|
|
0.7482 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'sll_db_ver' AND site_id = 1;
|
|
1.0891 [ms]
|
SELECT * FROM tmgi_simple_login_log LIMIT 1;
|
|
17.5261 [ms]
|
ALTER TABLE tmgi_simple_login_log MODIFY user_role varchar(255) NOT NULL;;
|
|
1.0691 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'needsGeoIPSync';
|
|
0.7000 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'detectProxyRecommendation';
|
|
0.7539 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'WPLANG' AND site_id = 1;
|
|
1.2050 [ms]
|
SELECT MAX(attackLogTime) FROM tmgi_wfhits;
|
|
0.7839 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wordfence_lastSyncAttackData' AND site_id = 1;
|
|
1.4210 [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.8309 [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.8080 [ms]
|
SELECT * FROM `tmgi_wfblocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = X'00000000000000000000ffff0395ea32' AND (`expiration` = 0 OR `expiration`
> UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1;
|
|
1.9679 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-replace' AND site_id = 1;
|
|
0.7212 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-allow-sites' AND site_id = 1;
|
|
0.6711 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_quantity' LIMIT 1;
|
|
0.8352 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_quantity' LIMIT 1;
|
|
0.6611 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_value' LIMIT 1;
|
|
0.6530 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_value' LIMIT 1;
|
|
0.7198 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
|
0.6690 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
|
0.7980 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 247 LIMIT 1;
|
|
0.9100 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 248 LIMIT 1;
|
|
0.6912 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;
|
|
0.7410 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_shipping_cost_requires_address' LIMIT 1;
|
|
1.6990 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1;
|
|
1.5271 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = '_transient_sswcmc_lists';
|
|
1.4439 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_ssl_activation_active' AND site_id = 1;
|
|
0.9129 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.6788 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
10.2460 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('isPaid', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
6.0792 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('success', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
9.5060 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('keyType', 'paid-current', 'yes') ON DUPLICATE KEY UPDATE val = 'paid-current', autoload =
'yes';
|
|
7.6640 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('licenseType', 'response', 'yes') ON DUPLICATE KEY UPDATE val = 'response', autoload = 'yes';
|
|
5.4128 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('premiumNextRenew', '1763724171', 'yes') ON DUPLICATE KEY UPDATE val = '1763724171', autoload
= 'yes';
|
|
19.2149 [ms]
|
SHOW TABLES LIKE 'tmgi\\_gf\\_rest\\_api\\_keys';
|
|
1.9290 [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
;
|
|
1.0772 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (405) ORDER BY meta_id ASC;
|
|
0.9100 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;
|
|
0.8152 [ms]
|
SELECT session_value FROM tmgi_woocommerce_sessions WHERE session_key = 't_0b124377bb9398f1a41d4dbbde0811';
|
|
1.1249 [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.0591 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wfls_last_role_change' AND site_id = 1;
|
|
0.7958 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 246 LIMIT 1;
|
|
0.9949 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_coupons' LIMIT 1;
|
|
0.9511 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;
|
|
1.4479 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;
|
|
0.8290 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
0.7660 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_db_version' LIMIT 1;
|
|
1.1430 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_shipping' LIMIT 1;
|
|
0.8950 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_additional' LIMIT 1;
|
|
0.8380 [ms]
|
SELECT post_status, COUNT( * ) AS num_posts FROM tmgi_posts WHERE post_type = 'product' GROUP BY post_status;
|
|
1.1919 [ms]
|
DESCRIBE tmgi_stock_log;;
|
|
0.9181 [ms]
|
SHOW INDEX FROM tmgi_stock_log;;
|
|
1.2009 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts
WHERE 1=1 AND tmgi_posts.post_name = 'product-name-2' AND tmgi_posts.post_type = 'product'
ORDER BY tmgi_posts.post_date DESC
;
|
|
1.3499 [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 (218)
ORDER BY t.name ASC
;
|
|
1.1730 [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 (2,48);
|
|
0.7219 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (218) ORDER BY meta_id ASC;
|
|
0.9420 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gravityformsaddon_gf_theme_layers_version' LIMIT 1;
|
|
1.0118 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_timeout_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
1.0052 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
0.8190 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_env_hide_update_message' LIMIT 1;
|
|
0.6711 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'affwp_flush_rewrites' LIMIT 1;
|
|
0.9708 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_wflivetraffichuman`;
|
|
0.9289 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff0395ea32' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
0.6940 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_file_download_method' LIMIT 1;
|
|
0.8929 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = 'woocommerce_admin_notice_redirect_download_method';
|
|
1.4899 [ms]
|
SELECT `id`, `name`, `path` FROM tmgi_pmxi_imports WHERE `path` IS NULL;
|
|
1.1239 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts
WHERE 1=1 AND tmgi_posts.post_name = 'product-name-2' AND tmgi_posts.post_type = 'product'
ORDER BY tmgi_posts.post_date DESC
;
|
|
0.9711 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff0395ea32' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
1.1780 [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/product-name-2\"%';
|
|
1.1721 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
0.8080 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_review_rating_required' LIMIT 1;
|
|
1.3349 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gform_enable_toolbar_menu' LIMIT 1;
|
|
1.1692 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'site_logo' LIMIT 1;
|
|
1.0662 [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.3001 [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.8090 [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.7310 [ms]
|
SELECT tmgi_posts.* FROM tmgi_posts WHERE ID IN (284);
|
|
0.9141 [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.2791 [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 (218) 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.9232 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_timeout_wc_term_counts' LIMIT 1;
|
|
1.1110 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_wc_term_counts' LIMIT 1;
|
|
1.0731 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 249 LIMIT 1;
|
|
1.3731 [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 (218)
ORDER BY tt.parent DESC
;
|
|
1.0941 [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.0970 [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,20);
|
|
0.7460 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_catalog_columns' LIMIT 1;
|
|
4.8451 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 477 LIMIT 1;
|
|
0.8061 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (477) ORDER BY meta_id ASC;
|
|
0.6728 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_review_rating' LIMIT 1;
|
|
4.4029 [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 = 218 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.8509 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_review_rating_verification_required' LIMIT 1;
|
|
0.7300 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_timeout_wc_related_218' LIMIT 1;
|
|
0.7329 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_wc_related_218' LIMIT 1;
|
|
0.9401 [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.9000 [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.0920 [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 ( 48 ) ) 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,218 )
LIMIT 25
;
|
|
9.9401 [ms]
|
UPDATE `tmgi_options` SET `option_value` = '1732274571' WHERE `option_name` = '_transient_timeout_wc_related_218';
|
|
0.7529 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 478 LIMIT 1;
|
|
1.3220 [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 (478)
ORDER BY t.name ASC
;
|
|
1.5090 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (478) ORDER BY meta_id ASC;
|
|
0.8390 [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 (478)
ORDER BY t.name ASC
;
|
|
1.3049 [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 (478) 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.1709 [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 (478)
ORDER BY t.name ASC
;
|
|
1.2960 [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 (478)
ORDER BY t.name ASC
;
|
|
0.8290 [ms]
|
SELECT * FROM tmgi_wc_tax_rate_classes ORDER BY name;
;
|
|
0.9720 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 217 LIMIT 1;
|
|
0.7989 [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 (217)
ORDER BY t.name ASC
;
|
|
0.7248 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (217) ORDER BY meta_id ASC;
|
|
0.8140 [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 (217)
ORDER BY t.name ASC
;
|
|
1.1110 [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 (217) 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.9031 [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 (217)
ORDER BY t.name ASC
;
|
|
0.7939 [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 (217)
ORDER BY t.name ASC
;
|
|
1.0259 [ms]
|
SELECT * FROM tmgi_users WHERE ID = '8' LIMIT 1;
|
|
3.2170 [ms]
|
SELECT user_id, meta_key, meta_value FROM tmgi_usermeta WHERE user_id IN (8) ORDER BY umeta_id ASC;
|
|
1.2879 [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;
|
Reviews
There are no reviews yet.