1.2262 |
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.slug = 'freshmen'
LIMIT 1
|
0.3150 |
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.2320 |
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
|
0.9470 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_rows'
LIMIT 1
|
0.9618 |
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.slug IN ('freshmen')
|
0.6838 |
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 )
|
2.0680 |
SELECT SQL_CALC_FOUND_ROWS aoit_wp_posts.ID
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
WHERE 1=1
AND ( aoit_wp_posts.ID NOT IN ( SELECT object_id
FROM aoit_wp_term_relationships
WHERE term_taxonomy_id IN (100,102) )
AND aoit_wp_term_relationships.term_taxonomy_id IN (22) )
AND aoit_wp_posts.post_type = 'product'
AND (aoit_wp_posts.post_status = 'publish')
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_posts.menu_order ASC, aoit_wp_posts.post_title ASC
LIMIT 0, 20
|
0.3531 |
SELECT FOUND_ROWS()
|
0.7279 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE ID IN (984,40)
|
6.8860 |
SELECT t.*, tt.*, tr.object_id, 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_type', 'product_visibility', 'product_cat', 'product_tag', 'product_shipping_class', 'pa_adult-size', 'pa_donations', 'pa_mens-size', 'pa_mixed-sizes', 'pa_womens-size')
AND tr.object_id IN (40, 984)
GROUP BY t.term_id, tr.object_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
3.1860 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (40,984)
ORDER BY meta_id ASC
|
11.0168 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.ID IN (4416,4417,4421,4422,4431,4432,4433,4434,4435,4436,4439,4443,4447,4458,4466,4467,4478,4479,4480,4483,4571,4609,4716,4717,4718)
AND aoit_wp_posts.post_type = 'nav_menu_item'
AND ((aoit_wp_posts.post_status = 'publish'))
ORDER BY aoit_wp_posts.menu_order ASC
|
0.3140 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4432)
ORDER BY meta_id ASC
|
2.1229 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4154
LIMIT 1
|
9.8641 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4431)
ORDER BY meta_id ASC
|
0.3412 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4160
LIMIT 1
|
8.1410 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4416)
ORDER BY meta_id ASC
|
0.3040 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4417)
ORDER BY meta_id ASC
|
0.3531 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4225
LIMIT 1
|
0.2899 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4421)
ORDER BY meta_id ASC
|
1.9670 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4256
LIMIT 1
|
0.3312 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4435)
ORDER BY meta_id ASC
|
0.2739 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 400
LIMIT 1
|
10.2620 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4716)
ORDER BY meta_id ASC
|
0.2549 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4436)
ORDER BY meta_id ASC
|
6.9931 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4717)
ORDER BY meta_id ASC
|
0.1419 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4718)
ORDER BY meta_id ASC
|
2.0640 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 6
LIMIT 1
|
10.7172 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4439)
ORDER BY meta_id ASC
|
0.2921 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4478)
ORDER BY meta_id ASC
|
0.3040 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 365
LIMIT 1
|
10.0839 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4479)
ORDER BY meta_id ASC
|
0.1979 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4443)
ORDER BY meta_id ASC
|
0.2139 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 3978
LIMIT 1
|
9.6400 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4480)
ORDER BY meta_id ASC
|
0.2711 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4371
LIMIT 1
|
5.8138 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4483)
ORDER BY meta_id ASC
|
0.2530 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4283
LIMIT 1
|
10.4971 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4)
ORDER BY meta_id ASC
|
8.5361 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (4,20,22,24,21,23,18,2,98)
ORDER BY meta_id ASC
|
10.1089 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
|
0.3271 |
SELECT *
FROM aoit_wp_users
WHERE ID = '104'
LIMIT 1
|
7.8909 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (104)
ORDER BY umeta_id ASC
|
1.7090 |
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)
|
10.3340 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE ID IN (2977,4962)
|
1.2810 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2977,4962)
ORDER BY meta_id ASC
|
12.2299 |
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
0.3221 |
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.6949 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 984
ORDER BY meta_id
|
0.2799 |
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
|
6.4380 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
|
0.3021 |
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 )
|
10.0641 |
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
|
6.0298 |
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
|
1.4410 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
|
12.6240 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 40
ORDER BY meta_id
|
7.9269 |
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 )
|
7.0131 |
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
|
10.4380 |
SELECT *
FROM aoit_wp_ays_pb
|