SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.post_name = 'senior-ropes-fee'
AND aoit_wp_posts.post_type = 'product'
ORDER BY aoit_wp_posts.post_date DESC
0.4601
SELECT *
FROM aoit_wp_posts
WHERE ID = 43
LIMIT 1
4.2682
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (43)
ORDER BY meta_id ASC
0.6709
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_required'
LIMIT 1
1.2071
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2980)
ORDER BY meta_id ASC
0.5808
SELECT *
FROM aoit_wp_posts
WHERE ID = 2980
LIMIT 1
1.6081
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
3.2501
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 (43)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
0.9589
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (21,18)
ORDER BY meta_id ASC
1.4181
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4)
ORDER BY meta_id ASC
3.5541
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 (43)
ORDER BY t.name ASC
0.5641
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (2)
ORDER BY meta_id ASC
0.7012
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 (43)
ORDER BY t.name ASC
0.9239
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 (43)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
11.7199
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 (43)
ORDER BY t.name ASC
1.1430
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 (43)
ORDER BY t.name ASC
3.0260
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (98)
ORDER BY meta_id ASC
0.8502
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
0.9758
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 43
ORDER BY meta_id
3.9618
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.9458
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
0.9842
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 )
2.9640
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.6320
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_43'
LIMIT 1
0.5081
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_wc_related_43'
1.3540
SHOW FULL COLUMNS
FROM `aoit_wp_options`
1.5059
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_wc_related_43'
0.2918
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_43'
0.3810
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_timeout_wc_related_43'
2.0990
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,43 )
LIMIT 24
0.4861
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_related_43'
LIMIT 1
0.4158
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_43'
LIMIT 1
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.5128
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (4)
ORDER BY meta_id ASC
2.3360
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (78)
ORDER BY meta_id ASC
1.7812
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
0.4399
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (25,26,27,28)
ORDER BY meta_id ASC
0.9940
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.4890
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (37,38,39,40)
ORDER BY meta_id ASC
0.9060
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.0850
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
0.3948
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (20,22,24,23)
ORDER BY meta_id ASC
0.6371
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
0.6571
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.2491
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (96)
ORDER BY meta_id ASC
0.4539
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_mens-size'
AND post_id IN (2791,2792,2793,2794)
0.2589
SELECT *
FROM aoit_wp_posts
WHERE ID = 89
LIMIT 1
0.6680
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.6869
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (89)
ORDER BY meta_id ASC
0.9758
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.1729
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.3108
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
1.4279
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.6990
SELECT *
FROM aoit_wp_posts
WHERE ID = 41
LIMIT 1
1.6220
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 (41)
ORDER BY t.name ASC
2.2089
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (41)
ORDER BY meta_id ASC
1.6770
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 (41)
ORDER BY t.name ASC
2.2039
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 (41)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
1.4091
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 (41)
ORDER BY t.name ASC
1.4260
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 (41)
ORDER BY t.name ASC
0.5951
SELECT *
FROM aoit_wp_posts
WHERE ID = 2586
LIMIT 1
1.3590
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.4229
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2586)
ORDER BY meta_id ASC
2.8300
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
1.6818
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.2850
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.8461
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.6282
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.2231
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2873,2874,2875,2876)
0.5710
SELECT *
FROM aoit_wp_posts
WHERE ID = 2921
LIMIT 1
1.4269
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2921)
ORDER BY meta_id ASC
0.3850
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
0.7050
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
2.3861
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 78
ORDER BY meta_id
2.0669
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.8209
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 )
1.5080
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.2900
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.1820
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
1.0419
SELECT *
FROM aoit_wp_users
WHERE ID = '1015'
LIMIT 1
1.5678
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (1015)
ORDER BY umeta_id ASC
0.4930
SELECT *
FROM aoit_wp_posts
WHERE ID = 2976
LIMIT 1
1.2901
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2976)
ORDER BY meta_id ASC
1.4441
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 41
ORDER BY meta_id
4.0879
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
1.0331
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 ( 23,18 )
2.3100
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,23) )
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.1639
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
1.1408
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,23) )
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.2678
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.3081
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,23) )
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.6640
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
1.3649
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
0.5040
SELECT *
FROM aoit_wp_posts
WHERE ID = 2920
LIMIT 1
1.1230
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2920)
ORDER BY meta_id ASC
0.7379
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2586
ORDER BY meta_id
3.3438
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.6300
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.5010
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
1.4970
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.3850
SELECT *
FROM aoit_wp_posts
WHERE ID = 2978
LIMIT 1
0.9642
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2978)
ORDER BY meta_id ASC
0.8171
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 89
ORDER BY meta_id
4.1530
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.7142
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
2.3110
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
1.6379
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
2.1091
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
1.6809
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.3350
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_info_cache'
LIMIT 1
0.2751
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_jetpack_woocommerce_analytics_cart_checkout_info_cache'
0.5999
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_jetpack_woocommerce_analytics_cart_checkout_info_cache'
0.2999
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_info_cache'
0.4909
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_info_cache'
0.2761
SELECT COUNT( * )
FROM aoit_wp_posts
WHERE ID=5
AND aoit_wp_posts.post_content LIKE '%
