0.9229 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'at_options'
LIMIT 1
|
0.6511 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_edit_links_calypso_redirect'
LIMIT 1
|
0.6108 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = 'ljmm-content-default'
|
0.6380 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'tridebugging'
LIMIT 1
|
0.7331 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
|
0.8469 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_tos_agreed'
LIMIT 1
|
0.6080 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'as_has_wp_comment_logs'
LIMIT 1
|
0.1931 |
SELECT *
FROM aoit_wp_users
WHERE ID = '1'
LIMIT 1
|
0.2990 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (1)
ORDER BY umeta_id ASC
|
0.6061 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors'
LIMIT 1
|
0.6511 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_sync_error_idc'
LIMIT 1
|
0.4551 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_excluded_extensions'
LIMIT 1
|
0.9141 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'wpforms_settings'
LIMIT 1
|
0.4921 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'jetpack_sync_non_blocking'
LIMIT 1
|
0.8068 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_client_type'
LIMIT 1
|
0.5660 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_allowed_retries'
LIMIT 1
|
0.4711 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_lockout_duration'
LIMIT 1
|
0.4702 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_valid_duration'
LIMIT 1
|
0.3901 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_cookies'
LIMIT 1
|
0.6461 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_lockout_notify'
LIMIT 1
|
0.5131 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_allowed_lockouts'
LIMIT 1
|
0.6280 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_long_duration'
LIMIT 1
|
0.5131 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'limit_login_notify_email_after'
LIMIT 1
|
0.6170 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'onepress_custom_css'
LIMIT 1
|
0.8051 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_tax_display_cart'
LIMIT 1
|
0.7138 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
|
0.6580 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'has_jetpack_search_product'
LIMIT 1
|
0.6690 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wpcom_social_media_icons_widget::is_active'
LIMIT 1
|
0.7000 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wpcom_social_media_icons_widget::is_active'
LIMIT 1
|
0.6859 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_lock_down_admin'
LIMIT 1
|
0.3419 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4
LIMIT 1
|
0.6151 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_coupons'
LIMIT 1
|
0.7222 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'Gallerylanguage_external'
LIMIT 1
|
0.3731 |
SELECT a.action_id
FROM aoit_wp_actionscheduler_actions a
WHERE a.hook='wpforms_process_entry_emails_meta_cleanup'
AND a.status='in-progress'
ORDER BY scheduled_date_gmt DESC
LIMIT 1
|
0.2780 |
SELECT a.action_id
FROM aoit_wp_actionscheduler_actions a
WHERE a.hook='wpforms_process_entry_emails_meta_cleanup'
AND a.status='pending'
ORDER BY scheduled_date_gmt ASC
LIMIT 1
|
0.2599 |
SELECT a.*, g.slug AS `group`
FROM aoit_wp_actionscheduler_actions a LEFT JOIN aoit_wp_actionscheduler_groups g ON a.group_id=g.group_id
WHERE a.action_id=6148
|
0.2570 |
SELECT a.action_id
FROM aoit_wp_actionscheduler_actions a
WHERE a.hook='wpforms_email_summaries_fetch_info_blocks'
AND a.status='in-progress'
ORDER BY scheduled_date_gmt DESC
LIMIT 1
|
0.2382 |
SELECT a.action_id
FROM aoit_wp_actionscheduler_actions a
WHERE a.hook='wpforms_email_summaries_fetch_info_blocks'
AND a.status='pending'
ORDER BY scheduled_date_gmt ASC
LIMIT 1
|
0.2451 |
SELECT a.*, g.slug AS `group`
FROM aoit_wp_actionscheduler_actions a LEFT JOIN aoit_wp_actionscheduler_groups g ON a.group_id=g.group_id
WHERE a.action_id=6146
|
1.0431 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_doing_cron'
LIMIT 1
|
0.6781 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_doing_cron'
LIMIT 1
|
1.5831 |
INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1696472183.4706919193267822265625', 'yes')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
2.1451 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.post_name = 'aoit-senior-banquet'
AND aoit_wp_posts.post_type = 'product'
ORDER BY aoit_wp_posts.post_date DESC
|
0.6151 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 89
LIMIT 1
|
2.2910 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (89)
ORDER BY meta_id ASC
|
2.5609 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_jetpack_akismet_key_is_valid'
LIMIT 1
|
3.4342 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_jetpack_akismet_key_is_valid'
LIMIT 1
|
2.3189 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'Gallerytheme_folder'
LIMIT 1
|
1.2331 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 5
LIMIT 1
|
6.4380 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_review_rating_required'
LIMIT 1
|
1.7521 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2978)
ORDER BY meta_id ASC
|
1.3471 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2978
LIMIT 1
|
7.3800 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'medium_crop'
LIMIT 1
|
1.3430 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'large_crop'
LIMIT 1
|
0.7050 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'siteorigin_custom_css[onepress]'
LIMIT 1
|
0.4089 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4567
LIMIT 1
|
0.8018 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'https_migration_required'
LIMIT 1
|
11.7989 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4512)
ORDER BY meta_id ASC
|
0.2210 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4512
LIMIT 1
|
0.2820 |
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 = 139
|
0.2811 |
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 ('139')
ORDER BY tr.object_id ASC
|
0.2780 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE 1=1
AND aoit_wp_posts.ID IN (4416,4417,4421,4422,4431,4432,4433,4434,4435,4436,4439,4443,4447,4458,4466,4467,4478,4479,4480,4483,4571,4609,4716,4717,4718)
AND aoit_wp_posts.post_type = 'nav_menu_item'
AND ((aoit_wp_posts.post_status = 'publish'))
ORDER BY aoit_wp_posts.menu_order ASC
|
0.2079 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4466)
ORDER BY meta_id ASC
|
0.1891 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 3967
LIMIT 1
|
0.1941 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4467)
ORDER BY meta_id ASC
|
0.1781 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4458)
ORDER BY meta_id ASC
|
0.2241 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4330
LIMIT 1
|
0.2019 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4447)
ORDER BY meta_id ASC
|
0.2201 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4182
LIMIT 1
|
0.1860 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4609)
ORDER BY meta_id ASC
|
0.2589 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4294
LIMIT 1
|
0.1950 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4571)
ORDER BY meta_id ASC
|
0.1550 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2403
LIMIT 1
|
0.2260 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 20
LIMIT 1
|
0.1910 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4422)
ORDER BY meta_id ASC
|
0.1791 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4434)
ORDER BY meta_id ASC
|
0.2129 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4137
LIMIT 1
|
0.3150 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4433)
ORDER BY meta_id ASC
|
0.1979 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4146
LIMIT 1
|
0.1891 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4432)
ORDER BY meta_id ASC
|
0.2022 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4154
LIMIT 1
|
0.1860 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4431)
ORDER BY meta_id ASC
|
0.2019 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4160
LIMIT 1
|
0.1860 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4416)
ORDER BY meta_id ASC
|
0.1781 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4417)
ORDER BY meta_id ASC
|
0.2630 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4225
LIMIT 1
|
0.2079 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4421)
ORDER BY meta_id ASC
|
0.1879 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4256
LIMIT 1
|
0.1860 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4435)
ORDER BY meta_id ASC
|
0.1891 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 400
LIMIT 1
|
0.1881 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4716)
ORDER BY meta_id ASC
|
0.1869 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4436)
ORDER BY meta_id ASC
|
0.2000 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4717)
ORDER BY meta_id ASC
|
0.1900 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4718)
ORDER BY meta_id ASC
|
0.1881 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 6
LIMIT 1
|
0.1838 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4439)
ORDER BY meta_id ASC
|
0.2079 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4478)
ORDER BY meta_id ASC
|
0.2089 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 365
LIMIT 1
|
0.2241 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4479)
ORDER BY meta_id ASC
|
0.1981 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4340
LIMIT 1
|
0.2201 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4443)
ORDER BY meta_id ASC
|
0.1891 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 3978
LIMIT 1
|
0.2098 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4480)
ORDER BY meta_id ASC
|
0.2160 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4371
LIMIT 1
|
0.2100 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4483)
ORDER BY meta_id ASC
|
0.2129 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4283
LIMIT 1
|
3.0279 |
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 (89)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
0.8020 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (21,18)
ORDER BY meta_id ASC
|
0.2198 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4)
ORDER BY meta_id ASC
|
0.2160 |
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
|
0.2260 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
|
2.3060 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type')
AND tr.object_id IN (89)
ORDER BY t.name ASC
|
0.6330 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (2)
ORDER BY meta_id ASC
|
1.5261 |
SELECT t.*, tt.*
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_visibility')
AND tr.object_id IN (89)
ORDER BY t.name ASC
|
2.5380 |
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
|
2.1911 |
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
|
2.5430 |
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.4082 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (98)
ORDER BY meta_id ASC
|
0.6990 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_columns'
LIMIT 1
|
0.7920 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
|
0.2868 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 89
ORDER BY meta_id
|
0.2780 |
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.2561 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
|
0.2482 |
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 )
|
0.2580 |
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.9892 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 984
LIMIT 1
|
2.1510 |
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.8349 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (4)
ORDER BY meta_id ASC
|
1.8110 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (984)
ORDER BY meta_id ASC
|
1.7118 |
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
|
2.0850 |
SELECT t.*, tt.*, tm.meta_value
FROM aoit_wp_terms AS t
INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN aoit_wp_termmeta AS tm ON (t.term_id = tm.term_id
AND tm.meta_key = 'order')
WHERE tt.taxonomy IN ('product_cat')
AND tr.object_id IN (984)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
0.7961 |
SELECT term_id, meta_key, meta_value
FROM aoit_wp_termmeta
WHERE term_id IN (20,22,24,23)
ORDER BY meta_id ASC
|
1.3571 |
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
|
2.3942 |
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.5779 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_984'
LIMIT 1
|
0.4950 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_984'
LIMIT 1
|
0.1800 |
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.5128 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 40
LIMIT 1
|
1.3659 |
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
|
2.0089 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (40)
ORDER BY meta_id ASC
|
1.8430 |
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
|
1.8859 |
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
|
1.1292 |
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.6980 |
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.6392 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 3881
LIMIT 1
|
1.6739 |
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 (3881)
ORDER BY t.name ASC
|
1.8051 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (3881)
ORDER BY meta_id ASC
|
2.0599 |
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 (3881)
ORDER BY t.name ASC
|
2.7030 |
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 (3881)
GROUP BY t.term_id
ORDER BY tm.meta_value+0 ASC, t.name ASC
|
2.6400 |
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 (3881)
ORDER BY t.name ASC
|
2.9631 |
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 (3881)
ORDER BY t.name ASC
|
1.0490 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 43
LIMIT 1
|
3.7041 |
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
|
2.3789 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (43)
ORDER BY meta_id ASC
|
2.3859 |
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
|
2.9230 |
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.4751 |
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.4808 |
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.4599 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2980
LIMIT 1
|
0.6521 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2980)
ORDER BY meta_id ASC
|
0.2830 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 43
ORDER BY meta_id
|
0.2432 |
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.2532 |
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.1762 |
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.1941 |
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.2019 |
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.2019 |
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.1649 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4962
LIMIT 1
|
1.0262 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4962)
ORDER BY meta_id ASC
|
0.3760 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 40
ORDER BY meta_id
|
0.2179 |
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.1891 |
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 )
|
0.1941 |
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.2351 |
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.3340 |
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.2890 |
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.2551 |
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.5920 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 4928
LIMIT 1
|
0.4711 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4928)
ORDER BY meta_id ASC
|
0.1819 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 3881
ORDER BY meta_id
|
0.1659 |
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.1631 |
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.1550 |
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.1569 |
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.2971 |
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.1700 |
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.2229 |
SELECT *
FROM aoit_wp_users
WHERE ID = '104'
LIMIT 1
|
0.2730 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (104)
ORDER BY umeta_id ASC
|
0.5989 |
SELECT *
FROM aoit_wp_posts
WHERE ID = 2977
LIMIT 1
|
0.5779 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2977)
ORDER BY meta_id ASC
|
0.1898 |
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
0.1690 |
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.2570 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 984
ORDER BY meta_id
|
0.1581 |
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.1612 |
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 )
|
0.1678 |
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.1640 |
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.2160 |
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.2389 |
SELECT *
FROM aoit_wp_ays_pb
|