| 76.4840 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_edit_links_calypso_redirect'
LIMIT 1
|
| 0.5522 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = 'ljmm-content-default'
|
| 0.3960 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
|
| 0.2940 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors'
LIMIT 1
|
| 69.2890 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_tos_agreed'
LIMIT 1
|
| 0.4299 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_sync_error_idc'
LIMIT 1
|
| 0.6890 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_excluded_extensions'
LIMIT 1
|
| 28.8949 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_sync_non_blocking'
LIMIT 1
|
| 0.3569 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_client_type'
LIMIT 1
|
| 0.3731 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_allowed_retries'
LIMIT 1
|
| 0.5529 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_lockout_duration'
LIMIT 1
|
| 0.3228 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_valid_duration'
LIMIT 1
|
| 0.6869 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_cookies'
LIMIT 1
|
| 0.6609 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_lockout_notify'
LIMIT 1
|
| 0.5250 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_allowed_lockouts'
LIMIT 1
|
| 68.7120 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_long_duration'
LIMIT 1
|
| 0.4060 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_notify_email_after'
LIMIT 1
|
| 45.2099 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_tax_display_cart'
LIMIT 1
|
| 0.4821 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
|
| 0.4210 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'has_jetpack_search_product'
LIMIT 1
|
| 0.4070 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wpcom_social_media_icons_widget::is_active'
LIMIT 1
|
| 0.4420 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wpcom_social_media_icons_widget::is_active'
LIMIT 1
|
| 0.4210 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_lock_down_admin'
LIMIT 1
|
| 3.6449 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4
LIMIT 1
|
| 0.3352 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_coupons'
LIMIT 1
|
| 0.3109 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_doing_cron'
LIMIT 1
|
| 0.2968 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_doing_cron'
LIMIT 1
|
| 1.0052 |
INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1604129540.5543539524078369140625', 'yes')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
| 0.4039 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'featured-content'
LIMIT 1
|
| 3.7830 |
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
|
| 2.7940 |
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
|
| 8.7349 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 43
LIMIT 1
|
| 6.3140 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (43)
ORDER BY meta_id ASC
|
| 0.6750 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_jetpack_akismet_key_is_valid'
LIMIT 1
|
| 0.6869 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_jetpack_akismet_key_is_valid'
LIMIT 1
|
| 0.4840 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 5
LIMIT 1
|
| 0.4561 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_required'
LIMIT 1
|
| 7.5190 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2980
LIMIT 1
|
| 1.7591 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2980)
ORDER BY meta_id ASC
|
| 0.7241 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2751
LIMIT 1
|
| 79.8769 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2751)
ORDER BY meta_id ASC
|
| 1.4238 |
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
|
| 2.7971 |
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
|
| 3.3181 |
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
|
| 1.0171 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (421)
ORDER BY meta_id ASC
|
| 0.5860 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 328
LIMIT 1
|
| 0.5739 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (423)
ORDER BY meta_id ASC
|
| 0.8962 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 20
LIMIT 1
|
| 1.7641 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (3008)
ORDER BY meta_id ASC
|
| 0.9141 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2403
LIMIT 1
|
| 0.4239 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (418)
ORDER BY meta_id ASC
|
| 0.9770 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 359
LIMIT 1
|
| 1.9681 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (425)
ORDER BY meta_id ASC
|
| 0.5519 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 365
LIMIT 1
|
| 0.5219 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (424)
ORDER BY meta_id ASC
|
| 1.6000 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 412
LIMIT 1
|
| 0.4759 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (417)
ORDER BY meta_id ASC
|
| 0.3371 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 368
LIMIT 1
|
| 0.5882 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (429)
ORDER BY meta_id ASC
|
| 0.8690 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1499)
ORDER BY meta_id ASC
|
| 0.5281 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1325
LIMIT 1
|
| 0.9501 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1086)
ORDER BY meta_id ASC
|
| 0.8612 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (428)
ORDER BY meta_id ASC
|
| 0.8500 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (426)
ORDER BY meta_id ASC
|
| 0.5159 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 7
LIMIT 1
|
| 0.3910 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (419)
ORDER BY meta_id ASC
|
| 0.7648 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 353
LIMIT 1
|
| 1.1680 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (920)
ORDER BY meta_id ASC
|
| 0.7951 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 853
LIMIT 1
|
| 1.1821 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (420)
ORDER BY meta_id ASC
|
| 0.6788 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 104
LIMIT 1
|
| 1.0400 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (614)
ORDER BY meta_id ASC
|
| 0.3300 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 486
LIMIT 1
|
| 1.2641 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (616)
ORDER BY meta_id ASC
|
| 0.3710 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 557
LIMIT 1
|
| 3.6390 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (617)
ORDER BY meta_id ASC
|
| 1.2980 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 575
LIMIT 1
|
| 1.1868 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1998)
ORDER BY meta_id ASC
|
| 0.5610 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1993
LIMIT 1
|
| 1.0779 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1901)
ORDER BY meta_id ASC
|
| 0.3569 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1185
LIMIT 1
|
| 0.9580 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1902)
ORDER BY meta_id ASC
|
| 0.6790 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1624
LIMIT 1
|
| 0.3440 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1686
LIMIT 1
|
| 0.5510 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1903)
ORDER BY meta_id ASC
|
| 0.8309 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1677
LIMIT 1
|
| 0.8650 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1904)
ORDER BY meta_id ASC
|
| 1.0772 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1608
LIMIT 1
|
| 0.7389 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1905)
ORDER BY meta_id ASC
|
| 1.3938 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1542
LIMIT 1
|
| 0.6900 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (1999)
ORDER BY meta_id ASC
|
| 0.6380 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1322
LIMIT 1
|
| 0.6719 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2001)
ORDER BY meta_id ASC
|
| 0.5012 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1939
LIMIT 1
|
| 0.5472 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2002)
ORDER BY meta_id ASC
|
| 0.4301 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1921
LIMIT 1
|
| 1.0171 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2000)
ORDER BY meta_id ASC
|
| 0.4120 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 1943
LIMIT 1
|
| 1.3421 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (3035)
ORDER BY meta_id ASC
|
| 0.3459 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 3032
LIMIT 1
|
| 0.4761 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (416)
ORDER BY meta_id ASC
|
| 0.3128 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 400
LIMIT 1
|
| 0.3841 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (422)
ORDER BY meta_id ASC
|
| 0.4151 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 330
LIMIT 1
|
| 2.9359 |
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.3572 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (21,18)
ORDER BY meta_id ASC
|
| 0.5989 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_term_counts'
LIMIT 1
|
| 0.5150 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_term_counts'
LIMIT 1
|
| 1.0550 |
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 DESC
|
| 1.1959 |
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.3941 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (2)
ORDER BY meta_id ASC
|
| 1.1570 |
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
|
| 1.5399 |
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
|
| 1.2560 |
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.5121 |
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
|
| 0.6261 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (98)
ORDER BY meta_id ASC
|
| 0.3119 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_columns'
LIMIT 1
|
| 73.4560 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
|
| 0.9730 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 43
ORDER BY meta_id
|
| 4.2520 |
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.8991 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
|
| 0.4861 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_cat')
AND t.term_id IN ( 21,18 )
|
| 1.5590 |
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.7361 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_43'
LIMIT 1
|
| 0.4232 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_wc_related_43'
|
| 0.6049 |
SHOW FULL COLUMNS
FROM `aoit_wp_options`
|
| 0.6208 |
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_wc_related_43'
|
| 0.3259 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_43'
|
| 0.6621 |
DELETE
FROM `aoit_wp_options`
WHERE `option_name` = '_transient_timeout_wc_related_43'
|
| 3.0012 |
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.5388 |
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
|
| 3.3860 |
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.4151 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_related_43'
LIMIT 1
|
| 0.3631 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_related_43'
LIMIT 1
|
| 0.5529 |
INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_wc_related_43', '1604215946', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
| 0.6440 |
INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_wc_related_43', 'a:1:{s:50:\"limit=4&exclude_ids%5B0%5D=0&exclude_ids%5B1%5D=43\";a:7:{i:0;s:2:\"41\";i:1;s:2:\"40\";i:2;s:2:\"89\";i:3;s:3:\"984\";i:4;s:2:\"78\";i:5;s:4:\"2586\";i:6;s:4:\"2587\";}}', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
| 0.7610 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 41
LIMIT 1
|
| 1.5500 |
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
|
| 7.7550 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (41)
ORDER BY meta_id ASC
|
| 1.0459 |
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.3902 |
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.3381 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (23)
ORDER BY meta_id ASC
|
| 1.6792 |
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.9600 |
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.3419 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 89
LIMIT 1
|
| 1.0061 |
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.0769 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (89)
ORDER BY meta_id ASC
|
| 1.3549 |
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.0440 |
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
|
| 0.6962 |
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.3421 |
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.2851 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 40
LIMIT 1
|
| 0.8690 |
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
|
| 1.6291 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (40)
ORDER BY meta_id ASC
|
| 0.9120 |
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.9611 |
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.3142 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (22)
ORDER BY meta_id ASC
|
| 102.8130 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_tag')
AND tr.object_id IN (40)
ORDER BY t.name ASC
|
| 1.5140 |
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.5901 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2586
LIMIT 1
|
| 1.2281 |
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.2558 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (4)
ORDER BY meta_id ASC
|
| 2.0921 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2586)
ORDER BY meta_id ASC
|
| 1.5211 |
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.7460 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (25,26,27,28)
ORDER BY meta_id ASC
|
| 1.1711 |
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.9991 |
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.3679 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (20,24)
ORDER BY meta_id ASC
|
| 1.3950 |
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.8061 |
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.5181 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_2586'
LIMIT 1
|
| 0.2680 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_2586'
LIMIT 1
|
| 1.0600 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2873,2874,2875,2876)
|
| 1.5171 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2975
LIMIT 1
|
| 0.7901 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2975)
ORDER BY meta_id ASC
|
| 0.7241 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 40
ORDER BY meta_id
|
| 1.4651 |
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.5648 |
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.2300 |
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
|
| 1.5440 |
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.0951 |
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
|
| 1.4300 |
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.3602 |
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
|
| 1.1389 |
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
|
| 4.4720 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
|
| 0.4058 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_2586'
LIMIT 1
|
| 0.3691 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_2586'
LIMIT 1
|
| 1.1051 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2920
LIMIT 1
|
| 1.4741 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2920)
ORDER BY meta_id ASC
|
| 2.2709 |
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
| 1.6780 |
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.2972 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2586
ORDER BY meta_id
|
| 16.5050 |
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.8850 |
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.8589 |
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.8330 |
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.0039 |
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.5050 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2978
LIMIT 1
|
| 0.9179 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2978)
ORDER BY meta_id ASC
|
| 0.9570 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 89
ORDER BY meta_id
|
| 1.7650 |
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.2529 |
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
|
| 1.4529 |
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.1160 |
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
|
| 1.6329 |
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.2199 |
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
|
| 95.1440 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2976
LIMIT 1
|
| 1.3380 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2976)
ORDER BY meta_id ASC
|
| 1.1060 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 41
ORDER BY meta_id
|
| 2.7080 |
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.7551 |
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.1961 |
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
|
| 4.6980 |
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.3131 |
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.5530 |
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.0919 |
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.8299 |
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
|
| 1.4889 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE ID IN (3697,3610,3460)
|
| 1.8702 |
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
|
| 2.6081 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (3460,3610,3697)
ORDER BY meta_id ASC
|
| 0.6061 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2741
LIMIT 1
|
| 0.3769 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2741)
ORDER BY meta_id ASC
|
| 0.3090 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wpcom_subscribers_total'
LIMIT 1
|
| 0.3788 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wpcom_subscribers_total'
LIMIT 1
|
