0.3731 |
SELECT option_value
FROM tr_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
|
0.3901 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_force_ssl_checkout'
LIMIT 1
|
0.2501 |
SELECT option_value
FROM tr_options
WHERE option_name = 'as_has_wp_comment_logs'
LIMIT 1
|
0.4399 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_navigation_enabled'
LIMIT 1
|
0.4258 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_settings_enabled'
LIMIT 1
|
0.5059 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_show_marketplace_suggestions'
LIMIT 1
|
0.6030 |
SELECT option_value
FROM tr_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
|
0.5119 |
SELECT *
FROM tr_posts
WHERE ID = 8
LIMIT 1
|
0.7141 |
SELECT option_value
FROM tr_options
WHERE option_name = '_site_transient_timeout_theme_roots'
LIMIT 1
|
0.2959 |
SELECT option_value
FROM tr_options
WHERE option_name = '_site_transient_theme_roots'
LIMIT 1
|
0.5090 |
CREATE TABLE IF NOT EXISTS tr_toret_tgls_log ( `ID` bigint(255) NOT NULL AUTO_INCREMENT, `order_id` bigint(255) NOT NULL, `date` varchar(100) COLLATE utf8_czech_ci NOT NULL, `datetime` varchar(100) COLLATE utf8_czech_ci NOT NULL, `log` longtext COLLATE utf8_czech_ci NOT NULL, `note` longtext COLLATE utf8_czech_ci NOT NULL, `status` varchar(100) COLLATE utf8_czech_ci NOT NULL, `context` varchar(2000) COLLATE utf8_czech_ci NOT NULL, PRIMARY KEY (`ID`) ) DEFAULT CHARACTER
SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
0.4771 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_myaccount_page_id'
LIMIT 1
|
0.2549 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_checkout_page_id'
LIMIT 1
|
0.2718 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_thumbnail_cropping'
LIMIT 1
|
0.3469 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_default_catalog_orderby'
LIMIT 1
|
1.3888 |
SELECT t.*, tt.*
FROM tr_terms AS t
INNER JOIN tr_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('product_visibility')
ORDER BY t.name ASC
|
0.4070 |
SELECT term_id, meta_key, meta_value
FROM tr_termmeta
WHERE term_id IN (7,6,8,9,10,11,12,13,14)
ORDER BY meta_id ASC
|
0.3722 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_catalog_columns'
LIMIT 1
|
0.1819 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_catalog_rows'
LIMIT 1
|
1.0970 |
SELECT SQL_CALC_FOUND_ROWS tr_posts.ID
FROM tr_posts
WHERE 1=1
AND ( tr_posts.ID NOT IN ( SELECT object_id
FROM tr_term_relationships
WHERE term_taxonomy_id IN (7) ) )
AND ((tr_posts.post_type = 'product'
AND (tr_posts.post_status = 'publish')))
GROUP BY tr_posts.ID
ORDER BY tr_posts.menu_order ASC, tr_posts.post_title ASC
LIMIT 0, 16
|
0.1371 |
SELECT FOUND_ROWS()
|
0.3650 |
SELECT tr_posts.*
FROM tr_posts
WHERE ID IN (318,319,12,20,21,23,29,30,27,28)
|
1.2169 |
SELECT t.*, tt.*, tr.object_id
FROM tr_terms AS t
INNER JOIN tr_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN tr_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type', 'product_visibility', 'product_cat', 'product_tag', 'product_shipping_class')
AND tr.object_id IN (12, 20, 21, 23, 27, 28, 29, 30, 318, 319)
ORDER BY t.name ASC
|
2.4130 |
SELECT post_id, meta_key, meta_value
FROM tr_postmeta
WHERE post_id IN (12,20,21,23,27,28,29,30,318,319)
ORDER BY meta_id ASC
|
0.3500 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_cart_page_id'
LIMIT 1
|
0.2611 |
SELECT option_value
FROM tr_options
WHERE option_name = 'medium_crop'
LIMIT 1
|
0.1950 |
SELECT option_value
FROM tr_options
WHERE option_name = 'medium_large_crop'
LIMIT 1
|
0.1731 |
SELECT option_value
FROM tr_options
WHERE option_name = 'large_crop'
LIMIT 1
|
0.4060 |
SELECT t.*, tt.*
FROM tr_terms AS t
INNER JOIN tr_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('wp_theme')
AND t.name IN ('twentytwenty')
|
0.2232 |
SELECT tr_posts.ID
FROM tr_posts
WHERE 1=1
AND ( 0 = 1 )
AND tr_posts.post_type = 'wp_global_styles'
AND ((tr_posts.post_status = 'publish'))
GROUP BY tr_posts.ID
ORDER BY tr_posts.post_date DESC
LIMIT 0, 1
|
0.5481 |
SELECT *
FROM tr_posts
WHERE ID = 9
LIMIT 1
|
0.3481 |
SELECT option_value
FROM tr_options
WHERE option_name = 'https_migration_required'
LIMIT 1
|
0.2630 |
SELECT option_value
FROM tr_options
WHERE option_name = 'site_logo'
LIMIT 1
|
0.3321 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_demo_store'
LIMIT 1
|
0.5729 |
SELECT t.*, tt.*
FROM tr_terms AS t
INNER JOIN tr_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 16
|
0.4439 |
SELECT tr.object_id
FROM tr_term_relationships AS tr
INNER JOIN tr_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('nav_menu')
AND tt.term_id IN ('16')
ORDER BY tr.object_id ASC
|
0.5450 |
SELECT tr_posts.*
FROM tr_posts
WHERE 1=1
AND tr_posts.ID IN (13,14,15,16)
AND tr_posts.post_type = 'nav_menu_item'
AND ((tr_posts.post_status = 'publish'))
ORDER BY tr_posts.menu_order ASC
|
0.7360 |
SELECT post_id, meta_key, meta_value
FROM tr_postmeta
WHERE post_id IN (16,13,14,15)
ORDER BY meta_id ASC
|
0.6001 |
SELECT tr_posts.*
FROM tr_posts
WHERE 1=1
AND tr_posts.ID IN (8,11,10,9)
AND tr_posts.post_type = 'page'
AND ((tr_posts.post_status = 'publish'))
ORDER BY tr_posts.post_date DESC
|
0.3960 |
SELECT post_id, meta_key, meta_value
FROM tr_postmeta
WHERE post_id IN (8,9,10,11)
ORDER BY meta_id ASC
|
0.5782 |
SELECT tr_posts.*
FROM tr_posts
WHERE 1=1
AND tr_posts.ID IN (13,14,15,16)
AND tr_posts.post_type = 'nav_menu_item'
AND ((tr_posts.post_status = 'publish'))
ORDER BY tr_posts.menu_order ASC
|
0.3428 |
SELECT option_value
FROM tr_options
WHERE option_name = 'woocommerce_shop_page_display'
LIMIT 1
|
0.6430 |
SELECT *
FROM tr_users
WHERE ID = '6'
LIMIT 1
|
0.9270 |
SELECT user_id, meta_key, meta_value
FROM tr_usermeta
WHERE user_id IN (6)
ORDER BY umeta_id ASC
|
0.5760 |
SELECT *
FROM tr_wc_tax_rate_classes
ORDER BY name;
|
0.5522 |
SELECT *
FROM tr_posts
WHERE ID = 7
LIMIT 1
|
0.3729 |
SELECT post_id, meta_key, meta_value
FROM tr_postmeta
WHERE post_id IN (7)
ORDER BY meta_id ASC
|
0.6039 |
SELECT tax_rate_id, location_code
FROM tr_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
1.9531 |
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM tr_woocommerce_tax_rates as tax_rates LEFT OUTER JOIN tr_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id LEFT OUTER JOIN tr_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1
AND tax_rate_country IN ( 'CZ', '' )
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 ('1200','1200*','120*','12*','1*','*')
AND ( ( locations2.location_type = 'city'
AND locations2.location_code = 'TESTROV' ) OR NOT EXISTS ( SELECT sub.tax_rate_id
FROM tr_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 = 'TESTROV'
AND NOT EXISTS ( SELECT sub.tax_rate_id
FROM tr_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.4120 |
SELECT *
FROM tr_users
WHERE ID = '1'
LIMIT 1
|
0.8469 |
SELECT user_id, meta_key, meta_value
FROM tr_usermeta
WHERE user_id IN (1)
ORDER BY umeta_id ASC
|
0.5238 |
SELECT option_value
FROM tr_options
WHERE option_name = '_transient_timeout_wc_var_prices_23'
LIMIT 1
|
0.2789 |
SELECT option_value
FROM tr_options
WHERE option_name = '_transient_wc_var_prices_23'
LIMIT 1
|
0.4470 |
SELECT tax_rate_id, location_code
FROM tr_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
1.0431 |
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM tr_woocommerce_tax_rates as tax_rates LEFT OUTER JOIN tr_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id LEFT OUTER JOIN tr_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1
AND tax_rate_country IN ( 'CZ', '' )
AND tax_rate_state IN ( '', '' )
AND tax_rate_class = 'snizena'
AND ( ( locations.location_type IS NULL ) OR ( locations.location_type = 'postcode'
AND locations.location_code IN ('1200','1200*','120*','12*','1*','*')
AND ( ( locations2.location_type = 'city'
AND locations2.location_code = 'TESTROV' ) OR NOT EXISTS ( SELECT sub.tax_rate_id
FROM tr_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 = 'TESTROV'
AND NOT EXISTS ( SELECT sub.tax_rate_id
FROM tr_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.4358 |
SELECT tax_rate_id, location_code
FROM tr_woocommerce_tax_rate_locations
WHERE location_type = 'postcode'
AND location_code LIKE '%...%';
|
0.8011 |
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM tr_woocommerce_tax_rates as tax_rates LEFT OUTER JOIN tr_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id LEFT OUTER JOIN tr_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1
AND tax_rate_country IN ( 'CZ', '' )
AND tax_rate_state IN ( '', '' )
AND tax_rate_class = 'nulova'
AND ( ( locations.location_type IS NULL ) OR ( locations.location_type = 'postcode'
AND locations.location_code IN ('1200','1200*','120*','12*','1*','*')
AND ( ( locations2.location_type = 'city'
AND locations2.location_code = 'TESTROV' ) OR NOT EXISTS ( SELECT sub.tax_rate_id
FROM tr_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 = 'TESTROV'
AND NOT EXISTS ( SELECT sub.tax_rate_id
FROM tr_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
|