| 0.5150 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = 'ljmm-content-default'
|
| 0.9890 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.post_name = 'aoit-long-sleeve-polo'
AND aoit_wp_posts.post_type = 'product'
ORDER BY aoit_wp_posts.post_date DESC
|
| 0.6239 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2586
LIMIT 1
|
| 2.4228 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2586)
ORDER BY meta_id ASC
|
| 0.4971 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_required'
LIMIT 1
|
| 0.7751 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2920
LIMIT 1
|
| 0.9241 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2920)
ORDER BY meta_id ASC
|
| 2.6941 |
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 (2586)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 0.4869 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (20,22,24,21,23)
ORDER BY meta_id ASC
|
| 0.9069 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_term_counts'
LIMIT 1
|
| 0.5701 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_term_counts'
LIMIT 1
|
| 1.6940 |
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 DESC
|
| 0.5429 |
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
|
| 1.3251 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
|
| 1.9228 |
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
|
| 0.7720 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (4)
ORDER BY meta_id ASC
|
| 1.2050 |
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
|
| 0.4358 |
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.9050 |
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
|
| 1.2860 |
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
|
| 0.9398 |
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
|
| 0.8509 |
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
|
| 0.4630 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_2586'
LIMIT 1
|
| 0.3860 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_2586'
LIMIT 1
|
| 0.7389 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2873,2874,2875,2876)
|
| 0.4470 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_columns'
LIMIT 1
|
| 0.3250 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_2586'
LIMIT 1
|
| 0.3359 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_2586'
LIMIT 1
|
| 165.2808 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
|
| 3.2270 |
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
| 2.8319 |
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
|
| 0.8180 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2873
LIMIT 1
|
| 0.6981 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2873)
ORDER BY meta_id ASC
|
| 0.8600 |
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 (2873)
ORDER BY t.name ASC
|
| 0.6399 |
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 ('pa_adult-size')
AND t.slug = 'adult-xl'
LIMIT 1
|
| 0.5400 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2874
LIMIT 1
|
| 1.2522 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2874)
ORDER BY meta_id ASC
|
| 1.3270 |
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 (2874)
ORDER BY t.name ASC
|
| 0.5481 |
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 ('pa_adult-size')
AND t.slug = 'adult-l'
LIMIT 1
|
| 0.4830 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2875
LIMIT 1
|
| 0.8652 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2875)
ORDER BY meta_id ASC
|
| 1.0860 |
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 (2875)
ORDER BY t.name ASC
|
| 0.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
WHERE tt.taxonomy IN ('pa_adult-size')
AND t.slug = 'adult-m'
LIMIT 1
|
| 0.8061 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2876
LIMIT 1
|
| 0.7510 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2876)
ORDER BY meta_id ASC
|
| 1.0121 |
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 (2876)
ORDER BY t.name ASC
|
| 0.5119 |
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 ('pa_adult-size')
AND t.slug = 'adult-s'
LIMIT 1
|
| 1.2760 |
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 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 t.term_id IN ( 25,26,27,28 )
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 0.8330 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2586
ORDER BY meta_id
|
| 2.6791 |
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.8950 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
|
| 0.6499 |
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.0220 |
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.4740 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_child_has_weight_2586'
LIMIT 1
|
| 0.2551 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_child_has_weight_2586'
LIMIT 1
|
| 0.2959 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_child_has_dimensions_2586'
LIMIT 1
|
| 0.2561 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_child_has_dimensions_2586'
LIMIT 1
|
| 0.8051 |
SELECT SQL_CALC_FOUND_ROWS aoit_wp_comments.comment_ID
FROM aoit_wp_comments
WHERE ( comment_approved = '1' )
AND comment_post_ID = 2586
AND comment_parent = 0
AND comment_type != 'order_note'
AND comment_type != 'webhook_delivery'
ORDER BY aoit_wp_comments.comment_date_gmt ASC, aoit_wp_comments.comment_ID ASC
|
| 0.4010 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_verification_required'
LIMIT 1
|
| 0.3722 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_2586'
LIMIT 1
|
| 0.2761 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_related_2586'
LIMIT 1
|
| 0.6051 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2587
LIMIT 1
|
| 1.3180 |
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 (2587)
ORDER BY t.name ASC
|
| 0.6618 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2587)
ORDER BY meta_id ASC
|
| 1.3950 |
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 (2587)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 0.5648 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (29)
ORDER BY meta_id ASC
|
| 0.9851 |
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 (2587)
ORDER BY t.name ASC
|
| 3.3500 |
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 (2587)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
| 1.1671 |
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 (2587)
ORDER BY t.name ASC
|
| 1.8160 |
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 (2587)
ORDER BY t.name ASC
|
| 0.5820 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_2587'
LIMIT 1
|
| 0.6330 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_2587'
LIMIT 1
|
| 0.9429 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2796,2797,2798,2799)
|
| 0.5629 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 78
LIMIT 1
|
| 2.0819 |
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
|
| 2.5430 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (78)
ORDER BY meta_id ASC
|
| 1.2579 |
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.8399 |
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.5388 |
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.6170 |
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.4460 |
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.5900 |
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.1940 |
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.4010 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (96)
ORDER BY meta_id ASC
|
| 0.4251 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_78'
LIMIT 1
|
| 0.3171 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_78'
LIMIT 1
|
| 0.5338 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_mens-size'
AND post_id IN (2791,2792,2793,2794)
|
| 0.6521 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 41
LIMIT 1
|
| 0.8340 |
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
|
| 0.2871 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (2)
ORDER BY meta_id ASC
|
| 2.6391 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (41)
ORDER BY meta_id ASC
|
| 1.0650 |
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
|
| 1.1961 |
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
|
| 0.4799 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (18)
ORDER BY meta_id ASC
|
| 1.2929 |
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
|
| 2.2459 |
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.4020 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (98)
ORDER BY meta_id ASC
|
| 0.8981 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 89
LIMIT 1
|
| 1.1170 |
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
|
| 2.5969 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (89)
ORDER BY meta_id ASC
|
| 1.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_visibility')
AND tr.object_id IN (89)
ORDER BY t.name ASC
|
| 1.4291 |
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.5459 |
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.2529 |
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.7281 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2978
LIMIT 1
|
| 1.3220 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2978)
ORDER BY meta_id ASC
|
| 1.4670 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 89
ORDER BY meta_id
|
| 0.8612 |
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.1899 |
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.6421 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_2587'
LIMIT 1
|
| 0.3080 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_2587'
LIMIT 1
|
| 0.5491 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2922
LIMIT 1
|
| 0.6828 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2922)
ORDER BY meta_id ASC
|
| 1.2801 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2587
ORDER BY meta_id
|
| 0.9022 |
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 )
|
| 2.5809 |
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,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.4871 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_78'
LIMIT 1
|
| 0.2439 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_78'
LIMIT 1
|
| 0.5641 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2921
LIMIT 1
|
| 0.9189 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2921)
ORDER BY meta_id ASC
|
| 1.3950 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 78
ORDER BY meta_id
|
| 0.7010 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2976
LIMIT 1
|
| 1.2460 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2976)
ORDER BY meta_id ASC
|
| 1.0111 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 41
ORDER BY meta_id
|
| 1.0109 |
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.6970 |
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.5569 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_info_cache'
LIMIT 1
|
| 0.2911 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_jetpack_woocommerce_analytics_cart_checkout_info_cache'
|
| 1.1158 |
SHOW FULL COLUMNS
FROM `aoit_wp_options`
|
| 1.2469 |
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_jetpack_woocommerce_analytics_cart_checkout_info_cache'
|
| 0.3941 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_info_cache'
|
| 0.5879 |
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_info_cache'
|
| 0.3870 |
SELECT COUNT( * )
FROM aoit_wp_posts
WHERE ID=5
AND aoit_wp_posts.post_content LIKE '%
|
Reviews
There are no reviews yet.