0.3412 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = 'ljmm-content-default'
|
0.3951 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
|
0.2871 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_tax_display_cart'
LIMIT 1
|
0.3030 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
|
0.3710 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wpcom_social_media_icons_widget::is_active'
LIMIT 1
|
0.3340 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4
LIMIT 1
|
0.3250 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_coupons'
LIMIT 1
|
0.6940 |
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 ('post_tag')
AND t.name IN ('featured')
LIMIT 1
|
7.5979 |
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.3011 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2586
LIMIT 1
|
0.6161 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2586)
ORDER BY meta_id ASC
|
0.3009 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_jetpack_akismet_key_is_valid'
LIMIT 1
|
0.3018 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 5
LIMIT 1
|
0.2561 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_required'
LIMIT 1
|
0.2968 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2920
LIMIT 1
|
0.4900 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2920)
ORDER BY meta_id ASC
|
0.2520 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2751
LIMIT 1
|
0.4070 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2751)
ORDER BY meta_id ASC
|
0.5040 |
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 t.term_id = 47
|
0.3569 |
SELECT tr.object_id
FROM aoit_wp_term_relationships AS tr
INNER JOIN aoit_wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('nav_menu')
AND tt.term_id IN ('47')
ORDER BY tr.object_id ASC
|
0.9739 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.ID IN (416,417,418,419,420,421,422,423,424,425,426,428,429,614,616,617,920,1086,1499,1901,1902,1903,1904,1905,1998,1999,2000,2001,2002,3008,3035)
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.4020 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (421)
ORDER BY meta_id ASC
|
0.3519 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 328
LIMIT 1
|
0.4568 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (423)
ORDER BY meta_id ASC
|
0.2580 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 20
LIMIT 1
|
0.6161 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (3008)
ORDER BY meta_id ASC
|
0.3080 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2403
LIMIT 1
|
0.3750 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (418)
ORDER BY meta_id ASC
|
0.2720 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 359
LIMIT 1
|
0.3481 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (425)
ORDER BY meta_id ASC
|
0.2730 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 365
LIMIT 1
|
0.3450 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (424)
ORDER BY meta_id ASC
|
0.2739 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 412
LIMIT 1
|
0.3440 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (417)
ORDER BY meta_id ASC
|
0.2830 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 368
LIMIT 1
|
0.3588 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (429)
ORDER BY meta_id ASC
|
0.3572 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1499)
ORDER BY meta_id ASC
|
0.2859 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1325
LIMIT 1
|
0.3719 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1086)
ORDER BY meta_id ASC
|
0.3569 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (428)
ORDER BY meta_id ASC
|
0.3550 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (426)
ORDER BY meta_id ASC
|
0.2680 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 7
LIMIT 1
|
0.3572 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (419)
ORDER BY meta_id ASC
|
0.2961 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 353
LIMIT 1
|
0.3512 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (920)
ORDER BY meta_id ASC
|
0.2789 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 853
LIMIT 1
|
0.3531 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (420)
ORDER BY meta_id ASC
|
0.2799 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 104
LIMIT 1
|
0.3979 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (614)
ORDER BY meta_id ASC
|
0.2689 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 486
LIMIT 1
|
0.3650 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (616)
ORDER BY meta_id ASC
|
0.3221 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 557
LIMIT 1
|
0.4139 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (617)
ORDER BY meta_id ASC
|
0.2909 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 575
LIMIT 1
|
0.4132 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1998)
ORDER BY meta_id ASC
|
0.3371 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1993
LIMIT 1
|
0.4570 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1901)
ORDER BY meta_id ASC
|
0.3049 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1185
LIMIT 1
|
0.4158 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1902)
ORDER BY meta_id ASC
|
0.3259 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1624
LIMIT 1
|
0.3662 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1686
LIMIT 1
|
0.4809 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1903)
ORDER BY meta_id ASC
|
0.2830 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1677
LIMIT 1
|
0.4070 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1904)
ORDER BY meta_id ASC
|
0.2992 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1608
LIMIT 1
|
0.3541 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1905)
ORDER BY meta_id ASC
|
0.2809 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1542
LIMIT 1
|
0.3600 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1999)
ORDER BY meta_id ASC
|
0.2739 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1322
LIMIT 1
|
0.4339 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2001)
ORDER BY meta_id ASC
|
0.3200 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1939
LIMIT 1
|
0.3450 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2002)
ORDER BY meta_id ASC
|
0.2611 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1921
LIMIT 1
|
0.3409 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2000)
ORDER BY meta_id ASC
|
0.4230 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1943
LIMIT 1
|
0.4129 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (3035)
ORDER BY meta_id ASC
|
0.2680 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 3032
LIMIT 1
|
0.3471 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (416)
ORDER BY meta_id ASC
|
0.2658 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 400
LIMIT 1
|
0.4342 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (422)
ORDER BY meta_id ASC
|
0.3891 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 330
LIMIT 1
|
1.8208 |
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.5980 |
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
|
2.1191 |
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.7250 |
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
|
1.3270 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
|
1.5950 |
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.4809 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (4)
ORDER BY meta_id ASC
|
1.7722 |
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.5012 |
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.8070 |
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
|
0.9298 |
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.6080 |
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.6342 |
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.7350 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2873,2874,2875,2876)
|
0.2911 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_columns'
LIMIT 1
|
0.4210 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
|
2.0540 |
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
1.5092 |
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.3650 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2873
LIMIT 1
|
0.7682 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2873)
ORDER BY meta_id ASC
|
0.9170 |
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.3879 |
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.4249 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2874
LIMIT 1
|
0.8850 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2874)
ORDER BY meta_id ASC
|
0.8140 |
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.4890 |
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.5369 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2875
LIMIT 1
|
0.9649 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2875)
ORDER BY meta_id ASC
|
1.1072 |
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.4139 |
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.3009 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2876
LIMIT 1
|
0.6649 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2876)
ORDER BY meta_id ASC
|
0.7911 |
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.4201 |
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.2031 |
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.6480 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2586
ORDER BY meta_id
|
2.8830 |
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.4029 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
|
0.4771 |
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.1048 |
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.9691 |
SELECT post_id
FROM aoit_wp_postmeta
WHERE meta_key = '_weight'
AND meta_value > 0
AND post_id IN ( 2873,2874,2875,2876 )
|
0.2639 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_child_has_weight_2586'
LIMIT 1
|
0.2091 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_child_has_weight_2586'
LIMIT 1
|
0.5081 |
SHOW FULL COLUMNS
FROM `aoit_wp_options`
|
0.2592 |
UPDATE `aoit_wp_options`
SET `option_value` = '1620735524'
WHERE `option_name` = '_transient_timeout_wc_child_has_weight_2586'
|
0.2110 |
UPDATE `aoit_wp_options`
SET `option_value` = ''
WHERE `option_name` = '_transient_wc_child_has_weight_2586'
|
3.0479 |
SELECT post_id
FROM aoit_wp_postmeta
WHERE meta_key IN ( '_length', '_width', '_height' )
AND meta_value > 0
AND post_id IN ( 2873,2874,2875,2876 )
|
0.3750 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_child_has_dimensions_2586'
LIMIT 1
|
0.3111 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_child_has_dimensions_2586'
LIMIT 1
|
0.3619 |
UPDATE `aoit_wp_options`
SET `option_value` = '1620735524'
WHERE `option_name` = '_transient_timeout_wc_child_has_dimensions_2586'
|
0.2999 |
UPDATE `aoit_wp_options`
SET `option_value` = ''
WHERE `option_name` = '_transient_wc_child_has_dimensions_2586'
|
0.6130 |
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.2549 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_verification_required'
LIMIT 1
|
0.4160 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 78
LIMIT 1
|
0.7691 |
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.8211 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (78)
ORDER BY meta_id ASC
|
0.9229 |
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.7820 |
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.4351 |
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.8080 |
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
|
0.9420 |
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.5171 |
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.6080 |
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.2489 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (96)
ORDER BY meta_id ASC
|
0.4361 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_mens-size'
AND post_id IN (2791,2792,2793,2794)
|
0.2711 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 40
LIMIT 1
|
0.6020 |
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
|
0.3161 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (2)
ORDER BY meta_id ASC
|
0.6189 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (40)
ORDER BY meta_id ASC
|
0.8290 |
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
|
0.9542 |
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
|
0.3109 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (18)
ORDER BY meta_id ASC
|
0.6008 |
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
|
0.5939 |
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
|
0.2511 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (98)
ORDER BY meta_id ASC
|
0.3130 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 41
LIMIT 1
|
0.6878 |
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.6280 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (41)
ORDER BY meta_id ASC
|
0.5879 |
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
|
0.7429 |
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.5150 |
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
|
0.6089 |
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
|
1.2770 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 984
LIMIT 1
|
0.6490 |
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
|
0.9680 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (984)
ORDER BY meta_id ASC
|
0.7031 |
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
|
0.9100 |
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
|
0.5178 |
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
|
0.5641 |
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
|
0.6399 |
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.4191 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2921
LIMIT 1
|
0.6399 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2921)
ORDER BY meta_id ASC
|
0.8590 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 78
ORDER BY meta_id
|
0.6690 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2976
LIMIT 1
|
0.7851 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2976)
ORDER BY meta_id ASC
|
0.6959 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 41
ORDER BY meta_id
|
0.4609 |
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 )
|
1.0831 |
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.3190 |
SELECT *
FROM aoit_wp_users
WHERE ID = '104'
LIMIT 1
|
0.8380 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (104)
ORDER BY umeta_id ASC
|
0.5929 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2977
LIMIT 1
|
0.9201 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2977)
ORDER BY meta_id ASC
|
1.1840 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 984
ORDER BY meta_id
|
0.7410 |
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 )
|
1.8260 |
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.7541 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2975
LIMIT 1
|
1.0979 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2975)
ORDER BY meta_id ASC
|
0.8719 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 40
ORDER BY meta_id
|
0.5591 |
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 )
|
1.1559 |
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.7000 |
SELECT aoit_wp_posts.ID
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.post_type = 'post'
AND ((aoit_wp_posts.post_status = 'publish'))
ORDER BY aoit_wp_posts.post_date DESC
LIMIT 0, 3
|
0.4768 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE ID IN (3697,3610,3460)
|
1.2932 |
SELECT t.*, tt.*, tr.object_id
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 ('category', 'post_tag', 'post_format')
AND tr.object_id IN (3460, 3610, 3697)
ORDER BY t.name ASC
|
0.6649 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (3460,3610,3697)
ORDER BY meta_id ASC
|
0.4990 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2741
LIMIT 1
|
1.0500 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2741)
ORDER BY meta_id ASC
|
0.4389 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wpcom_subscribers_total'
LIMIT 1
|
Reviews
There are no reviews yet.