| 0.7210 |
SELECT autoload
FROM aoit_wp_options
WHERE option_name = 'ljmm-content-default'
|
| 0.5939 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_columns'
LIMIT 1
|
| 0.3109 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_catalog_rows'
LIMIT 1
|
| 1.3919 |
SELECT SQL_CALC_FOUND_ROWS aoit_wp_posts.ID
FROM aoit_wp_posts
WHERE 1=1
AND ( aoit_wp_posts.ID NOT IN ( SELECT object_id
FROM aoit_wp_term_relationships
WHERE term_taxonomy_id IN (100,102) ) )
AND aoit_wp_posts.post_type = 'product'
AND (aoit_wp_posts.post_status = 'publish')
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_posts.menu_order ASC, aoit_wp_posts.post_title ASC
LIMIT 0, 20
|
| 0.2031 |
SELECT FOUND_ROWS()
|
| 0.9201 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (4)
ORDER BY meta_id ASC
|
| 0.3951 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = 'woocommerce_enable_review_rating'
LIMIT 1
|
| 1.4589 |
SELECT *
FROM aoit_wp_users
WHERE ID = '442'
LIMIT 1
|
| 1.6489 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (442)
ORDER BY umeta_id ASC
|
| 0.5169 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_2586'
LIMIT 1
|
| 0.9990 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_2586'
LIMIT 1
|
| 2.2850 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2873,2874,2875,2876)
|
| 0.4189 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_2586'
LIMIT 1
|
| 0.4139 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_2586'
LIMIT 1
|
| 1.5819 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts
WHERE ID IN (2920,2978,2922,3940,2977,2980,4928,2921,4962,2976)
|
| 3.7110 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (2920,2921,2922,2976,2977,2978,2980,3940,4928,4962)
ORDER BY meta_id ASC
|
| 2.1470 |
SELECT tax_rate_id, location_code
FROM aoit_wp_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
| 2.4610 |
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 ( 'VE', '' )
AND tax_rate_state IN ( '', '' )
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.1220 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2586
ORDER BY meta_id
|
| 5.3701 |
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.0691 |
SELECT post_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id IN (88)
ORDER BY meta_id ASC
|
| 1.0169 |
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 )
|
| 3.6092 |
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.6191 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 89
ORDER BY meta_id
|
| 0.9110 |
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.9209 |
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.7751 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_2587'
LIMIT 1
|
| 0.5581 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_2587'
LIMIT 1
|
| 1.2701 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_adult-size'
AND post_id IN (2796,2797,2798,2799)
|
| 0.5710 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_2587'
LIMIT 1
|
| 0.5949 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_2587'
LIMIT 1
|
| 1.3161 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 2587
ORDER BY meta_id
|
| 0.5980 |
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 )
|
| 1.8849 |
SELECT aoit_wp_posts.*
FROM aoit_wp_posts LEFT JOIN aoit_wp_term_relationships ON (aoit_wp_posts.ID = aoit_wp_term_relationships.object_id)
INNER JOIN aoit_wp_postmeta ON ( aoit_wp_posts.ID = aoit_wp_postmeta.post_id )
WHERE 1=1
AND ( aoit_wp_term_relationships.term_taxonomy_id IN (20,21,22,24) )
AND ( aoit_wp_postmeta.meta_key = '_priority' )
AND aoit_wp_posts.post_type = 'global_product_addon'
AND ((aoit_wp_posts.post_status = 'publish'))
GROUP BY aoit_wp_posts.ID
ORDER BY aoit_wp_postmeta.meta_value ASC
|
| 1.2910 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 3939
ORDER BY meta_id
|
| 0.5932 |
SELECT *
FROM aoit_wp_users
WHERE ID = '104'
LIMIT 1
|
| 4.1149 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (104)
ORDER BY umeta_id ASC
|
| 0.5820 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_984'
LIMIT 1
|
| 2.1970 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_984'
LIMIT 1
|
| 0.9720 |
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.5960 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_984'
LIMIT 1
|
| 0.8261 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_984'
LIMIT 1
|
| 1.3461 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 984
ORDER BY meta_id
|
| 0.8841 |
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 )
|
| 2.6410 |
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
|
| 2.3119 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 43
ORDER BY meta_id
|
| 1.0979 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 3881
ORDER BY meta_id
|
| 0.6459 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_product_children_78'
LIMIT 1
|
| 0.4828 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_product_children_78'
LIMIT 1
|
| 1.3950 |
SELECT meta_value
FROM aoit_wp_postmeta
WHERE meta_key = 'attribute_pa_mens-size'
AND post_id IN (2791,2792,2793,2794)
|
| 0.6940 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_timeout_wc_var_prices_78'
LIMIT 1
|
| 0.9880 |
SELECT option_value
FROM aoit_wp_options
WHERE option_name = '_transient_wc_var_prices_78'
LIMIT 1
|
| 1.4620 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 78
ORDER BY meta_id
|
| 2.3530 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 40
ORDER BY meta_id
|
| 1.5810 |
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 )
|
| 4.9109 |
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.5100 |
SELECT *
FROM aoit_wp_users
WHERE ID = '1015'
LIMIT 1
|
| 1.4079 |
SELECT user_id, meta_key, meta_value
FROM aoit_wp_usermeta
WHERE user_id IN (1015)
ORDER BY umeta_id ASC
|
| 0.9711 |
SELECT meta_id as meta_id, meta_key, meta_value
FROM aoit_wp_postmeta
WHERE post_id = 41
ORDER BY meta_id
|
| 1.0581 |
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.3079 |
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
|
