| 11.0331 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = 'ljmm-content-default'
|
| 1.4999 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.post_name = 'aoit-senior-banquet'
AND aoit_wp_posts.post_type = 'product'
ORDER BY aoit_wp_posts.post_date DESC
|
| 0.5701 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 89
LIMIT 1
|
| 1.6210 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (89)
ORDER BY meta_id ASC
|
| 0.3030 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_jetpack_akismet_key_is_valid'
LIMIT 1
|
| 0.4539 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_required'
LIMIT 1
|
| 0.4518 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2978
LIMIT 1
|
| 0.9720 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2978)
ORDER BY meta_id ASC
|
| 27.5931 |
SELECT t.term_id, tt.parent, tt.count, tt.taxonomy, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (89)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.0819 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (21,18)
ORDER BY meta_id ASC
|
| 1.3649 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (89)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name DESC
|
| 0.5322 |
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
|
| 3.3500 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
|
| 2.7311 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type')
AND tr.object_id IN (89)
ORDER BY t.name ASC
|
| 0.9019 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (2)
ORDER BY meta_id ASC
|
| 2.4471 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_visibility')
AND tr.object_id IN (89)
ORDER BY t.name ASC
|
| 2.7680 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (89)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.1902 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_tag')
AND tr.object_id IN (89)
ORDER BY t.name ASC
|
| 2.1241 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_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 (89)
ORDER BY t.name ASC
|
| 0.5009 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (98)
ORDER BY meta_id ASC
|
| 0.4711 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_columns'
LIMIT 1
|
| 0.5012 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
|
| 0.8030 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 89
ORDER BY meta_id
|
| 1.6351 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.3800 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
|
| 0.5300 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat')
AND t.term_id IN ( 21,18 )
|
| 1.2801 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (18,21) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.6309 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_89'
LIMIT 1
|
| 0.4041 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_wc_related_89'
|
| 0.7300 |
SHOW FULL COLUMNS
FROM `aoit_wp_options`
|
| 1.7421 |
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_wc_related_89'
|
| 0.3059 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_89'
|
| 0.5989 |
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_timeout_wc_related_89'
|
| 1.0669 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_visibility')
ORDER BY t.name ASC
|
| 0.4458 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (100,99,101,102,103,104,105,106,107)
ORDER BY meta_id ASC
|
| 1.3559 |
SELECT DISTINCT ID
FROM aoit_wp_posts p LEFT JOIN ( SELECT object_id
FROM aoit_wp_term_relationships
WHERE term_taxonomy_id IN ( 100,102 ) ) AS exclude_join ON exclude_join.object_id = p.ID
INNER JOIN ( SELECT object_id
FROM aoit_wp_term_relationships
INNER JOIN aoit_wp_term_taxonomy using( term_taxonomy_id )
WHERE term_id IN ( 21,18 ) ) 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,89 )
LIMIT 24
|
| 0.2761 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_related_89'
LIMIT 1
|
| 0.2599 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_89'
LIMIT 1
|
| 0.3791 |
INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_wc_related_89', '1594816570', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
| 0.3390 |
INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_wc_related_89', 'a:1:{s:50:\"limit=4&exclude_ids%5B0%5D=0&exclude_ids%5B1%5D=89\";a:7:{i:0;s:2:\"43\";i:1;s:2:\"41\";i:2;s:2:\"40\";i:3;s:3:\"984\";i:4;s:2:\"78\";i:5;s:4:\"2586\";i:6;s:4:\"2587\";}}', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
| 0.3250 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 78
LIMIT 1
|
| 1.5490 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type')
AND tr.object_id IN (78)
ORDER BY t.name ASC
|
| 0.4461 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (4)
ORDER BY meta_id ASC
|
| 2.5198 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (78)
ORDER BY meta_id ASC
|
| 3.2928 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order_pa_adult-size')
WHERE tt.taxonomy IN ('pa_adult-size')
AND tr.object_id IN (78)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.2569 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (25,26,27,28)
ORDER BY meta_id ASC
|
| 2.8028 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order_pa_mens-size')
WHERE tt.taxonomy IN ('pa_mens-size')
AND tr.object_id IN (78)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 0.8299 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (37,38,39,40)
ORDER BY meta_id ASC
|
| 1.9779 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_visibility')
AND tr.object_id IN (78)
ORDER BY t.name ASC
|
| 1.7910 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (78)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.4820 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (20,22,24,23)
ORDER BY meta_id ASC
|
| 2.7690 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_tag')
AND tr.object_id IN (78)
ORDER BY t.name ASC
|
| 1.5812 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_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 (78)
ORDER BY t.name ASC
|
| 0.8259 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (96)
ORDER BY meta_id ASC
|
| 0.9990 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_mens-size'
AND post_id IN (2791,2792,2793,2794)
|
| 0.6351 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2586
LIMIT 1
|
| 1.7290 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type')
AND tr.object_id IN (2586)
ORDER BY t.name ASC
|
| 1.3781 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2586)
ORDER BY meta_id ASC
|
| 2.3229 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order_pa_adult-size')
WHERE tt.taxonomy IN ('pa_adult-size')
AND tr.object_id IN (2586)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 2.0359 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_visibility')
AND tr.object_id IN (2586)
ORDER BY t.name ASC
|
| 2.7268 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (2586)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.3430 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_tag')
AND tr.object_id IN (2586)
ORDER BY t.name ASC
|
| 1.2350 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_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 (2586)
ORDER BY t.name ASC
|
| 1.1861 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2873,2874,2875,2876)
|
| 0.4730 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 984
LIMIT 1
|
| 1.5531 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type')
AND tr.object_id IN (984)
ORDER BY t.name ASC
|
| 2.3808 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (984)
ORDER BY meta_id ASC
|
| 8.3029 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_visibility')
AND tr.object_id IN (984)
ORDER BY t.name ASC
|
| 1.5669 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (984)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.6639 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_tag')
AND tr.object_id IN (984)
ORDER BY t.name ASC
|
| 1.9479 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_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 (984)
ORDER BY t.name ASC
|
| 1.0500 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_donation'
AND post_id IN (3062,1430,1432,1433,1434,1435,1436,1437,1438,1439,1440,1502,1503,1504,1505,1506)
|
| 0.5498 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 40
LIMIT 1
|
| 1.2960 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type')
AND tr.object_id IN (40)
ORDER BY t.name ASC
|
| 2.1341 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (40)
ORDER BY meta_id ASC
|
| 1.1630 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_visibility')
AND tr.object_id IN (40)
ORDER BY t.name ASC
|
| 1.4012 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (40)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.0879 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_tag')
AND tr.object_id IN (40)
ORDER BY t.name ASC
|
| 1.7948 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_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 (40)
ORDER BY t.name ASC
|
| 35.8381 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2977
LIMIT 1
|
| 0.9420 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2977)
ORDER BY meta_id ASC
|
| 0.5298 |
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
| 0.9160 |
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM aoit_wp_woocommerce_tax_rates as tax_rates LEFT OUTER JOIN aoit_wp_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id LEFT OUTER JOIN aoit_wp_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1
AND tax_rate_country IN ( 'US', '' )
AND tax_rate_state IN ( 'NC', '' )
AND tax_rate_class = ''
AND ( ( locations.location_type IS NULL ) OR ( locations.location_type = 'postcode'
AND locations.location_code IN ('','*')
AND ( ( locations2.location_type = 'city'
AND locations2.location_code = '' ) OR NOT EXISTS ( SELECT sub.tax_rate_id
FROM aoit_wp_woocommerce_tax_rate_locations as sub
WHERE sub.location_type = 'city'
AND sub.tax_rate_id = tax_rates.tax_rate_id ) ) ) OR ( locations.location_type = 'city'
AND locations.location_code = ''
AND NOT EXISTS ( SELECT sub.tax_rate_id
FROM aoit_wp_woocommerce_tax_rate_locations as sub
WHERE sub.location_type = 'postcode'
AND sub.tax_rate_id = tax_rates.tax_rate_id ) ) )
GROUP BY tax_rates.tax_rate_id
ORDER BY tax_rates.tax_rate_priority
|
| 1.8728 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 984
ORDER BY meta_id
|
| 31.4770 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.7811 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat')
AND t.term_id IN ( 20,22,24,21,23,18 )
|
| 2.9421 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (18,20,21,22,23,24) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 3.4690 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 3.0172 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (18,20,21,22,23,24) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.8669 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2920
LIMIT 1
|
| 0.7970 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2920)
ORDER BY meta_id ASC
|
| 0.8519 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2586
ORDER BY meta_id
|
| 1.7269 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.7050 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat')
AND t.term_id IN ( 20,22,24,21,23 )
|
| 2.0931 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (20,21,22,23,24) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 3.2320 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 2.1570 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (20,21,22,23,24) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.6249 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2921
LIMIT 1
|
| 1.0259 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2921)
ORDER BY meta_id ASC
|
| 1.0979 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 78
ORDER BY meta_id
|
| 2.4891 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 2.0399 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (20,21,22,23,24) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 2.0018 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 9.1841 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (20,21,22,23,24) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.5410 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2975
LIMIT 1
|
| 0.9050 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2975)
ORDER BY meta_id ASC
|
| 1.0560 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 40
ORDER BY meta_id
|
| 2.6901 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.6330 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat')
AND t.term_id IN ( 22,18 )
|
| 2.1858 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (18,22) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 2.7599 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 2.1520 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (18,22) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 2.5692 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
INNER JOIN aoit_wp_postmeta AS mt1 ON ( aoit_wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( aoit_wp_postmeta.meta_key = '_priority'
AND ( ( mt1.meta_key = '_all_products'
AND mt1.meta_value = '1' ) ) )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 2.1539 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (18,22) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 0.9439 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wpcom_subscribers_total'
LIMIT 1
|
