|
0.2630 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'greenmarimba_client_settings' LIMIT 1;
|
|
0.4351 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_options`;
|
|
9.3391 [ms]
|
UPDATE `tmgi_options` SET `option_value` = 'active' WHERE `option_name` = 'revslider-code';
|
|
8.0831 [ms]
|
UPDATE `tmgi_options` SET `option_value` = '7h33ky51-7446-4574-4663-91b999e6dad5' WHERE `option_name` = 'revslider-code';
|
|
4.7979 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
1.5290 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'sue_settings_settings' LIMIT 1;
|
|
0.6230 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.9789 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_options' AND site_id = 1;
|
|
0.7710 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wpme_options' AND site_id = 1;
|
|
1.0402 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'sll_db_ver' AND site_id = 1;
|
|
0.3901 [ms]
|
SELECT * FROM tmgi_simple_login_log LIMIT 1;
|
|
11.0371 [ms]
|
ALTER TABLE tmgi_simple_login_log MODIFY user_role varchar(255) NOT NULL;;
|
|
0.3428 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'needsGeoIPSync';
|
|
0.2270 [ms]
|
SELECT name, val, autoload FROM tmgi_wfconfig WHERE name = 'detectProxyRecommendation';
|
|
0.2711 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'WPLANG' AND site_id = 1;
|
|
0.3459 [ms]
|
SELECT MAX(attackLogTime) FROM tmgi_wfhits;
|
|
0.2611 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wordfence_lastSyncAttackData' AND site_id = 1;
|
|
0.3860 [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.3679 [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.3211 [ms]
|
SELECT * FROM `tmgi_wfblocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = X'00000000000000000000ffff03913b59' AND (`expiration` = 0 OR `expiration`
> UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1;
|
|
0.8001 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-replace' AND site_id = 1;
|
|
0.3150 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'classic-editor-allow-sites' AND site_id = 1;
|
|
0.2410 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_quantity' LIMIT 1;
|
|
0.2191 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_quantity' LIMIT 1;
|
|
0.1919 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_minimum_order_value' LIMIT 1;
|
|
0.6220 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_maximum_order_value' LIMIT 1;
|
|
0.2661 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
|
0.2191 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
|
0.9930 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 247 LIMIT 1;
|
|
0.2930 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 248 LIMIT 1;
|
|
0.2410 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;
|
|
0.4160 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_shipping_cost_requires_address' LIMIT 1;
|
|
1.1389 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1;
|
|
0.2759 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = '_transient_sswcmc_lists';
|
|
0.5000 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'rsssl_ssl_activation_active' AND site_id = 1;
|
|
0.5600 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wp_mail_smtp' LIMIT 1;
|
|
0.2120 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_integrations' LIMIT 1;
|
|
5.5799 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('isPaid', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
4.5311 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('success', '1', 'yes') ON DUPLICATE KEY UPDATE val = '1', autoload = 'yes';
|
|
4.5972 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('keyType', 'paid-current', 'yes') ON DUPLICATE KEY UPDATE val = 'paid-current', autoload =
'yes';
|
|
6.0380 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('licenseType', 'response', 'yes') ON DUPLICATE KEY UPDATE val = 'response', autoload = 'yes';
|
|
9.2220 [ms]
|
INSERT INTO tmgi_wfconfig (name, val, autoload) values ('premiumNextRenew', '1763708902', 'yes') ON DUPLICATE KEY UPDATE val = '1763708902', autoload
= 'yes';
|
|
19.4800 [ms]
|
SHOW TABLES LIKE 'tmgi\\_gf\\_rest\\_api\\_keys';
|
|
0.7262 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM tmgi_posts
WHERE post_name IN ('inventory')
AND post_type IN ('page','attachment')
;
|
|
0.5829 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 284 LIMIT 1;
|
|
0.3891 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts
WHERE 1=1 AND (tmgi_posts.ID = '284') AND tmgi_posts.post_type = 'page'
ORDER BY tmgi_posts.post_date DESC
;
|
|
1.4181 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (284) ORDER BY meta_id ASC;
|
|
0.3860 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;
|
|
0.3338 [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.7839 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = 'wfls_last_role_change' AND site_id = 1;
|
|
0.7560 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 246 LIMIT 1;
|
|
0.2768 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_enable_coupons' LIMIT 1;
|
|
0.8581 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;
|
|
0.2360 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;
|
|
0.9019 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'preload_cache_counter' LIMIT 1;
|
|
0.7830 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_db_version' LIMIT 1;
|
|
0.7739 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_shipping' LIMIT 1;
|
|
0.5171 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'wc_fields_additional' LIMIT 1;
|
|
1.1380 [ms]
|
SELECT post_status, COUNT( * ) AS num_posts FROM tmgi_posts WHERE post_type = 'product' GROUP BY post_status;
|
|
1.1280 [ms]
|
DESCRIBE tmgi_stock_log;;
|
|
0.2730 [ms]
|
SHOW INDEX FROM tmgi_stock_log;;
|
|
0.4740 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gravityformsaddon_gf_theme_layers_version' LIMIT 1;
|
|
0.6709 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_timeout_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
0.2949 [ms]
|
SELECT meta_value FROM tmgi_sitemeta WHERE meta_key = '_site_transient_GFCache_3afb61c14cd8f9c46f9e7a9fc59fc25f' AND site_id = 1;
|
|
0.2499 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gf_env_hide_update_message' LIMIT 1;
|
|
0.6850 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'affwp_flush_rewrites' LIMIT 1;
|
|
10.2868 [ms]
|
SHOW FULL COLUMNS FROM `tmgi_wflivetraffichuman`;
|
|
0.7620 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff03913b59' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
0.6540 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'woocommerce_file_download_method' LIMIT 1;
|
|
0.3572 [ms]
|
SELECT autoload FROM tmgi_options WHERE option_name = 'woocommerce_admin_notice_redirect_download_method';
|
|
0.9179 [ms]
|
SELECT `id`, `name`, `path` FROM tmgi_pmxi_imports WHERE `path` IS NULL;
|
|
0.6130 [ms]
|
SELECT tmgi_posts.*
FROM tmgi_posts
WHERE 1=1 AND (tmgi_posts.ID = '284') AND tmgi_posts.post_type = 'page'
ORDER BY tmgi_posts.post_date DESC
;
|
|
0.8559 [ms]
|
SELECT COUNT(*) FROM tmgi_wflivetraffichuman WHERE IP = X'00000000000000000000ffff03913b59' AND identifier = 'üÏ7`Væ?ûéðÎ Yϲ«–÷žRÜ~Óù\Z[ ' AND
expiration >= UNIX_TIMESTAMP();
|
|
3.1619 [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\":\"inventory\"%';
|
|
0.4120 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'mc4wp_form_stylesheets' LIMIT 1;
|
|
0.7219 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'gform_enable_toolbar_menu' LIMIT 1;
|
|
0.7839 [ms]
|
SELECT tmgi_posts.ID
FROM tmgi_posts
WHERE 1=1 AND tmgi_posts.post_parent = 284 AND tmgi_posts.post_type = 'page' AND ((tmgi_posts.post_status = 'publish'))
ORDER BY tmgi_posts.post_title ASC
LIMIT 0, 1;
|
|
0.6199 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = 'site_logo' LIMIT 1;
|
|
0.4640 [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;
|
|
0.6690 [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.4430 [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.5102 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (246,247,248) ORDER BY meta_id ASC;
|
|
1.9529 [ms]
|
SELECT * FROM tmgi_posts WHERE ID = 249 LIMIT 1;
|
|
0.3841 [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.3381 [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,48);
|
|
0.2449 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_timeout_wc_term_counts' LIMIT 1;
|
|
0.2232 [ms]
|
SELECT option_value FROM tmgi_options WHERE option_name = '_transient_wc_term_counts' LIMIT 1;
|
|
1.2951 [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 ('5050')
;
|
|
0.2382 [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 ( 24 )
;
|
|
0.7439 [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 (24)
) 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
;
|
|
0.5531 [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 (44)
ORDER BY t.name ASC
;
|
|
0.2699 [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);
|
|
1.3700 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (44) ORDER BY meta_id ASC;
|
|
2.0809 [ms]
|
SELECT user_id, meta_key, meta_value FROM tmgi_usermeta WHERE user_id IN (8) ORDER BY umeta_id ASC;
|
|
0.4411 [ms]
|
SELECT * FROM tmgi_users WHERE ID IN (8);
|
|
0.3049 [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 ('concentrates')
;
|
|
0.9131 [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 ( 26 )
;
|
|
0.6831 [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 (26)
) 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
;
|
|
0.6871 [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 (72)
ORDER BY t.name ASC
;
|
|
0.4251 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (72) ORDER BY meta_id ASC;
|
|
0.9239 [ms]
|
SELECT user_id, meta_key, meta_value FROM tmgi_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
|
0.5150 [ms]
|
SELECT * FROM tmgi_users WHERE ID IN (2);
|
|
0.5600 [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 ('edibles')
;
|
|
0.2398 [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 ( 25 )
;
|
|
0.6759 [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 (25)
) 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
;
|
|
0.4001 [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 (70)
ORDER BY t.name ASC
;
|
|
0.3228 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (70) ORDER BY meta_id ASC;
|
|
0.3030 [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 ('indica-dominant')
;
|
|
0.2239 [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 ( 6 )
;
|
|
0.6931 [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 (6)
) 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
;
|
|
0.6440 [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 (207, 8)
ORDER BY t.name ASC
;
|
|
0.2902 [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 (7,41,15,42);
|
|
0.8712 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (207,8) ORDER BY meta_id ASC;
|
|
0.3040 [ms]
|
SELECT * FROM tmgi_wc_tax_rate_classes ORDER BY name;
;
|
|
0.2871 [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')
;
|
|
0.6158 [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.0979 [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 (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
;
|
|
0.4239 [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
;
|
|
0.2651 [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);
|
|
0.5219 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (82,10) ORDER BY meta_id ASC;
|
|
0.3331 [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 ('uncategorized')
;
|
|
0.3331 [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 ( 48 )
;
|
|
0.6580 [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 (48)
) 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
;
|
|
0.4411 [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)
ORDER BY t.name ASC
;
|
|
0.4818 [ms]
|
SELECT post_id, meta_key, meta_value FROM tmgi_postmeta WHERE post_id IN (478,218,217) ORDER BY meta_id ASC;
|
|
0.3109 [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;
|