0.2091 [ms]
|
SELECT NOW() as timestamp;
|
0.7432 [ms]
|
SHOW FULL COLUMNS FROM `wp6c_options`;
|
0.3099 [ms]
|
UPDATE `wp6c_options` SET `option_value` = '1' WHERE `option_name` = 'mepr_activated';
|
0.2749 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_site_transient_mepr_license_info' LIMIT 1;
|
0.3281 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_site_transient_mepr_all_addons' LIMIT 1;
|
0.2720 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_calculate_taxes' LIMIT 1;
|
0.2298 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_tax_avalara_enabled' LIMIT 1;
|
0.2530 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_disable_senddata' LIMIT 1;
|
0.4699 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_vat_enabled' LIMIT 1;
|
0.2310 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_disable_all_popups' LIMIT 1;
|
0.2360 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_disable_reminder_crons' LIMIT 1;
|
0.2539 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_authenticator_site_uuid' LIMIT 1;
|
0.2542 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'wd_bwg_options' LIMIT 1;
|
0.2251 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'tenweb_admin_demo' LIMIT 1;
|
0.7510 [ms]
|
SHOW TABLES LIKE "wp6c_wpml_mails";
|
0.6390 [ms]
|
SHOW TABLES LIKE 'wp6c_snippets';
|
0.4241 [ms]
|
SELECT id, code, scope, active
FROM wp6c_snippets
WHERE scope IN ('global','single-use','front-end') AND active=1
ORDER BY priority, id;
|
0.3030 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'espresso_db_update' LIMIT 1;
|
0.2539 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'ee_espresso_activation' LIMIT 1;
|
0.2608 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'ee_network_config' LIMIT 1;
|
0.3960 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'postman_auth_token' LIMIT 1;
|
0.3211 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'connections_licenses' LIMIT 1;
|
0.3581 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 3047 LIMIT 1;
|
0.4840 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (3047) ORDER BY meta_id ASC;
|
0.3181 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1;
|
0.2382 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1;
|
0.2751 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_core_path' LIMIT 1;
|
0.2489 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_core_path' LIMIT 1;
|
0.2480 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_core_version' LIMIT 1;
|
0.2389 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_core_version' LIMIT 1;
|
0.2370 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_core_needs_old_theme_patch' LIMIT 1;
|
0.2210 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_core_needs_old_theme_patch' LIMIT 1;
|
0.2489 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_core_api_spam_options' LIMIT 1;
|
0.2370 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_core_page_resource_remove_all' LIMIT 1;
|
0.2701 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_pb_role_settings' LIMIT 1;
|
0.3219 [ms]
|
SELECT *
FROM wp6c_masterslider_sliders
WHERE status='published'
ORDER BY ID DESC
;
|
0.3150 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'nonce_key' LIMIT 1;
|
0.2699 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'nonce_salt' LIMIT 1;
|
0.2360 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
0.2151 [ms]
|
SELECT autoload FROM wp6c_options WHERE option_name = '_transient_mepr_migration_error';
|
0.2089 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_mepr_migrating' LIMIT 1;
|
0.2010 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_mepr_migrating' LIMIT 1;
|
0.2079 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'ee_incompatible_addons' LIMIT 1;
|
0.4199 [ms]
|
SELECT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('cn_log_type') AND t.slug IN ('cn-email')
ORDER BY t.term_id ASC
LIMIT 1
;
|
0.3200 [ms]
|
SELECT t.*, tt.* FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (16);
|
0.3519 [ms]
|
SELECT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('cn_log_type') AND t.slug IN ('cn-system-info')
ORDER BY t.term_id ASC
LIMIT 1
;
|
0.3040 [ms]
|
SELECT t.*, tt.* FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (17);
|
0.3741 [ms]
|
SELECT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('cn_log_type') AND t.slug IN ('cn-form')
ORDER BY t.term_id ASC
LIMIT 1
;
|
0.3262 [ms]
|
SELECT t.*, tt.* FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (18);
|
0.2711 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'litespeed.placeholder._summary' LIMIT 1;
|
0.4749 [ms]
|
SELECT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('wp_theme') AND t.name IN ('Divi')
LIMIT 1
;
|
0.3591 [ms]
|
SELECT t.*, tt.* FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (21);
|
0.7591 [ms]
|
SELECT wp6c_posts.*
FROM wp6c_posts LEFT JOIN wp6c_term_relationships ON (wp6c_posts.ID = wp6c_term_relationships.object_id)
WHERE 1=1 AND (
wp6c_term_relationships.term_taxonomy_id IN (21)
) AND wp6c_posts.post_type = 'wp_template_part' AND ((wp6c_posts.post_status = 'publish'))
GROUP BY wp6c_posts.ID
ORDER BY wp6c_posts.post_date DESC
;
|
0.2940 [ms]
|
SELECT * FROM wp6c_itsec_bans WHERE host = '44.200.145.223';
|
0.3161 [ms]
|
SELECT `id`, `host` FROM wp6c_itsec_bans WHERE `type` = 'range';
|
0.3490 [ms]
|
SELECT * FROM `wp6c_itsec_lockouts` WHERE `lockout_active`=1 AND `lockout_expire_gmt` > '2023-06-08 00:56:27' AND `lockout_host` = '44.200.145.223'
ORDER BY `lockout_start` DESC LIMIT 1;;
|
0.2739 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_ee_ssn_317106ca99b6de420a9fb32a601ab6aa' LIMIT 1;
|
0.2301 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_ee_ssn_317106ca99b6de420a9fb32a601ab6aa' LIMIT 1;
|
0.3331 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_support_options' LIMIT 1;
|
0.2799 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 40 LIMIT 1;
|
0.3881 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'https_migration_required' LIMIT 1;
|
0.2489 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'twb_show_cta' LIMIT 1;
|
0.2241 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_tenweb_subscription_id' LIMIT 1;
|
0.2050 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_tenweb_subscription_id' LIMIT 1;
|
0.3140 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'cn_default_category' LIMIT 1;
|
0.2701 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'medium_crop' LIMIT 1;
|
0.2289 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'medium_large_crop' LIMIT 1;
|
0.2251 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'large_crop' LIMIT 1;
|
0.5250 [ms]
|
SELECT wp6c_posts.ID
FROM wp6c_posts LEFT JOIN wp6c_term_relationships ON (wp6c_posts.ID = wp6c_term_relationships.object_id)
WHERE 1=1 AND (
wp6c_term_relationships.term_taxonomy_id IN (21)
) AND wp6c_posts.post_type = 'wp_global_styles' AND ((wp6c_posts.post_status = 'publish'))
GROUP BY wp6c_posts.ID
ORDER BY wp6c_posts.post_date DESC
LIMIT 0, 1
;
|
0.2849 [ms]
|
SELECT wp6c_posts.* FROM wp6c_posts WHERE ID IN (9425);
|
0.4609 [ms]
|
SELECT DISTINCT t.term_id, tr.object_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp6c_term_relationships AS tr ON tr.term_taxonomy_id
= tt.term_taxonomy_id
WHERE tt.taxonomy IN ('wp_theme') AND tr.object_id IN (9425)
ORDER BY t.name ASC
;
|
0.2809 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (9425) ORDER BY meta_id ASC;
|
0.5231 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp6c_posts
WHERE post_name IN ('register')
AND post_type IN ('page','attachment')
;
|
0.3121 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 53 LIMIT 1;
|
0.3569 [ms]
|
SELECT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('category') AND t.slug IN ('register')
ORDER BY t.term_id ASC
LIMIT 1
;
|
0.3600 [ms]
|
SELECT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('category') AND t.name IN ('register')
ORDER BY t.term_id ASC
LIMIT 1
;
|
0.3719 [ms]
|
SELECT post_content from wp6c_posts WHERE post_status NOT IN ('auto-draft', 'inherit', 'trash') AND post_name='register';
|
0.3319 [ms]
|
SELECT wp6c_posts.*
FROM wp6c_posts
WHERE 1=1 AND (wp6c_posts.ID = '53') AND wp6c_posts.post_type = 'page'
ORDER BY wp6c_posts.post_date DESC
;
|
0.8481 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (53) ORDER BY meta_id ASC;
|
0.2530 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_display_conditions_tracking_post_ids' LIMIT 1;
|
0.4961 [ms]
|
SELECT wp6c_posts.ID
FROM wp6c_posts LEFT JOIN wp6c_postmeta ON ( wp6c_posts.ID = wp6c_postmeta.post_id AND wp6c_postmeta.meta_key = '_et_library_theme_builder' )
WHERE 1=1 AND (
wp6c_postmeta.post_id IS NULL
) AND wp6c_posts.post_type = 'et_theme_builder' AND ((wp6c_posts.post_status = 'publish'))
GROUP BY wp6c_posts.ID
ORDER BY wp6c_posts.post_date DESC
LIMIT 0, 1
;
|
0.2379 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_tb_templates_backup_0' LIMIT 1;
|
0.6521 [ms]
|
SELECT DISTINCT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp6c_term_relationships AS tr ON tr.term_taxonomy_id
= tt.term_taxonomy_id
WHERE tt.taxonomy IN ('category') AND tr.object_id IN (53)
ORDER BY t.name ASC
;
|
0.3731 [ms]
|
SELECT DISTINCT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp6c_term_relationships AS tr ON tr.term_taxonomy_id
= tt.term_taxonomy_id
WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (53)
ORDER BY t.name ASC
;
|
0.3688 [ms]
|
SELECT DISTINCT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp6c_term_relationships AS tr ON tr.term_taxonomy_id
= tt.term_taxonomy_id
WHERE tt.taxonomy IN ('project_category') AND tr.object_id IN (53)
ORDER BY t.name ASC
;
|
0.3722 [ms]
|
SELECT DISTINCT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp6c_term_relationships AS tr ON tr.term_taxonomy_id
= tt.term_taxonomy_id
WHERE tt.taxonomy IN ('project_tag') AND tr.object_id IN (53)
ORDER BY t.name ASC
;
|
0.2840 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_check_mod_pagespeed' LIMIT 1;
|
0.2611 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_check_mod_pagespeed' LIMIT 1;
|
0.7150 [ms]
|
SELECT wp6c_posts.ID
FROM wp6c_posts LEFT JOIN wp6c_term_relationships ON (wp6c_posts.ID = wp6c_term_relationships.object_id)
WHERE 1=1 AND wp6c_posts.post_name IN ('default') AND (
wp6c_term_relationships.term_taxonomy_id IN (21)
) AND wp6c_posts.post_type = 'wp_template' AND ((wp6c_posts.post_status = 'publish' OR wp6c_posts.post_status = 'draft' OR wp6c_posts.post_status =
'trash' OR wp6c_posts.post_status = 'auto-draft'))
GROUP BY wp6c_posts.ID
ORDER BY wp6c_posts.post_date DESC
LIMIT 0, 1
;
|
0.2670 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_cn_legacy_templates' LIMIT 1;
|
0.2460 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_cn_legacy_templates' LIMIT 1;
|
0.2799 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 2833 LIMIT 1;
|
0.5291 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (2833) ORDER BY meta_id ASC;
|
0.2921 [ms]
|
SELECT * from wp6c_esp_status LIMIT 1;
|
0.3099 [ms]
|
SELECT STS_ID, STS_code FROM wp6c_esp_status WHERE STS_type = 'registration';
|
0.9999 [ms]
|
SELECT wp6c_posts.*
FROM wp6c_posts LEFT JOIN wp6c_term_relationships ON (wp6c_posts.ID = wp6c_term_relationships.object_id)
WHERE 1=1 AND wp6c_posts.post_name IN ('page-register','page-53','page') AND (
wp6c_term_relationships.term_taxonomy_id IN (21)
) AND wp6c_posts.post_type = 'wp_template' AND ((wp6c_posts.post_status = 'publish'))
GROUP BY wp6c_posts.ID
ORDER BY wp6c_posts.post_date DESC
;
|
0.2840 [ms]
|
SELECT * FROM wp6c_users WHERE ID = '2' LIMIT 1;
|
3.8481 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp6c_usermeta WHERE user_id IN (2) ORDER BY umeta_id ASC;
|
0.3159 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout__et_builder_gf_feature_cache' LIMIT 1;
|
0.2539 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient__et_builder_gf_feature_cache' LIMIT 1;
|
0.2942 [ms]
|
SELECT * FROM wp6c_bwg_theme;
|
0.2670 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_fonts_cache_status' LIMIT 1;
|
0.2470 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_fonts_cache_status' LIMIT 1;
|
0.2511 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_google_fonts_cache' LIMIT 1;
|
0.4439 [ms]
|
SELECT DISTINCT t.term_id
FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp6c_term_relationships AS tr ON tr.term_taxonomy_id
= tt.term_taxonomy_id
WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (53)
ORDER BY t.name ASC
;
|
0.2530 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_uploaded_fonts' LIMIT 1;
|
0.2449 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'wordfenceActivated' LIMIT 1;
|
0.2351 [ms]
|
SELECT * FROM wp6c_masterslider_options WHERE option_name = 'custom_inline_style';
|
0.2370 [ms]
|
SELECT * FROM wp6c_masterslider_options WHERE option_name = 'masterslider_custom_css_ver';
|
0.4630 [ms]
|
SELECT * FROM `wp6c_yoast_indexable` WHERE `object_id` = '53' AND `object_type` = 'post' LIMIT 1;
|
0.2651 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'site_logo' LIMIT 1;
|
0.3650 [ms]
|
SELECT * FROM `wp6c_yoast_indexable` WHERE `object_type` = 'home-page' LIMIT 1;
|
0.2489 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'auth_key' LIMIT 1;
|
0.2339 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'auth_salt' LIMIT 1;
|
0.4110 [ms]
|
SELECT * FROM `wp6c_yoast_indexable` WHERE `object_id` = '242' AND `object_type` = 'post' LIMIT 1;
|
0.2980 [ms]
|
SELECT `ancestor_id` FROM `wp6c_yoast_indexable_hierarchy` WHERE `indexable_id` = '7' ORDER BY `depth` DESC;
|
0.3452 [ms]
|
SELECT id, code, scope, active
FROM wp6c_snippets
WHERE scope IN ('head-content','footer-content') AND active=1
ORDER BY priority, id;
|
0.5200 [ms]
|
SELECT * FROM wp6c_posts WHERE (post_type = 'page' AND post_status = 'publish') AND post_parent = 53 ORDER BY wp6c_posts.post_title ASC LIMIT
0,1;
|
0.3421 [ms]
|
SELECT t.*, tt.* FROM wp6c_terms AS t INNER JOIN wp6c_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 7;
|
1.2519 [ms]
|
SELECT wp6c_posts.*
FROM wp6c_posts LEFT JOIN wp6c_term_relationships ON (wp6c_posts.ID = wp6c_term_relationships.object_id)
WHERE 1=1 AND (
wp6c_term_relationships.term_taxonomy_id IN (7)
) AND wp6c_posts.post_type = 'nav_menu_item' AND ((wp6c_posts.post_status = 'publish'))
GROUP BY wp6c_posts.ID
ORDER BY wp6c_posts.menu_order ASC
;
|
0.5600 [ms]
|
SELECT wp6c_posts.* FROM wp6c_posts WHERE ID IN (244,104,318,103,101,685,8480,99,98,97,326,325,248,96,95,2912,94,2924,2928,2925,102,93);
|
2.7828 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN
(93,94,95,96,97,98,99,101,102,103,104,244,248,318,325,326,685,2912,2924,2925,2928,8480) ORDER BY meta_id ASC;
|
0.9460 [ms]
|
SELECT wp6c_posts.* FROM wp6c_posts WHERE ID IN (242,37,45,673,79,81,83,323,85,87,89,2921,2811,62,91);
|
6.8831 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (37,45,62,79,81,83,85,87,89,91,242,323,673,2811,2921) ORDER BY meta_id ASC;
|
0.3159 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'lolmi_login_page_url' LIMIT 1;
|
0.2248 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'lolmi_logout_redirect_url' LIMIT 1;
|
0.5910 [ms]
|
SELECT Event_CPT.ID AS 'Event_CPT.ID', Event_CPT.post_title AS 'Event_CPT.post_title', Event_CPT.post_content AS 'Event_CPT.post_content',
Event_CPT.post_name AS 'Event_CPT.post_name', Event_CPT.post_date AS 'Event_CPT.post_date', Event_CPT.post_excerpt AS 'Event_CPT.post_excerpt',
Event_CPT.post_modified AS 'Event_CPT.post_modified', Event_CPT.post_author AS 'Event_CPT.post_author', Event_CPT.post_parent AS
'Event_CPT.post_parent', Event_CPT.menu_order AS 'Event_CPT.menu_order', Event_CPT.post_status AS 'Event_CPT.post_status', Event_CPT.post_password AS
'Event_CPT.post_password', Event_CPT.comment_status AS 'Event_CPT.comment_status', Event_CPT.ping_status AS 'Event_CPT.ping_status',
Event_Meta.EVT_display_desc AS 'Event_Meta.EVT_display_desc', Event_Meta.EVT_display_ticket_selector AS 'Event_Meta.EVT_display_ticket_selector',
Event_Meta.EVT_visible_on AS 'Event_Meta.EVT_visible_on', Event_Meta.EVT_additional_limit AS 'Event_Meta.EVT_additional_limit',
Event_Meta.EVT_default_registration_status AS 'Event_Meta.EVT_default_registration_status', Event_Meta.EVT_member_only AS
'Event_Meta.EVT_member_only', Event_Meta.EVT_phone AS 'Event_Meta.EVT_phone', Event_Meta.EVT_allow_overflow AS 'Event_Meta.EVT_allow_overflow',
Event_Meta.EVT_timezone_string AS 'Event_Meta.EVT_timezone_string', Event_Meta.EVT_external_URL AS 'Event_Meta.EVT_external_URL',
Event_Meta.EVT_donations AS 'Event_Meta.EVT_donations', Event_CPT.ID AS 'Event_CPT.ID', Event_Meta.EVTM_ID AS 'Event_Meta.EVTM_ID' FROM wp6c_posts
AS Event_CPT LEFT JOIN wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.post_type = 'espresso_events' AND
Event_CPT.ID = 5118 GROUP BY Event_CPT.ID LIMIT 1;
|
0.7892 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Event_CPT.ID AS 'Event_CPT.ID', Event_CPT.post_title AS 'Event_CPT.post_title', Event_CPT.post_content
AS 'Event_CPT.post_content', Event_CPT.post_name AS 'Event_CPT.post_name', Event_CPT.post_date AS 'Event_CPT.post_date', Event_CPT.post_excerpt AS
'Event_CPT.post_excerpt', Event_CPT.post_modified AS 'Event_CPT.post_modified', Event_CPT.post_author AS 'Event_CPT.post_author',
Event_CPT.post_parent AS 'Event_CPT.post_parent', Event_CPT.menu_order AS 'Event_CPT.menu_order', Event_CPT.post_status AS 'Event_CPT.post_status',
Event_CPT.post_password AS 'Event_CPT.post_password', Event_CPT.comment_status AS 'Event_CPT.comment_status', Event_CPT.ping_status AS
'Event_CPT.ping_status', Event_Meta.EVT_display_desc AS 'Event_Meta.EVT_display_desc', Event_Meta.EVT_display_ticket_selector AS
'Event_Meta.EVT_display_ticket_selector', Event_Meta.EVT_visible_on AS 'Event_Meta.EVT_visible_on', Event_Meta.EVT_additional_limit AS
'Event_Meta.EVT_additional_limit', Event_Meta.EVT_default_registration_status AS 'Event_Meta.EVT_default_registration_status',
Event_Meta.EVT_member_only AS 'Event_Meta.EVT_member_only', Event_Meta.EVT_phone AS 'Event_Meta.EVT_phone', Event_Meta.EVT_allow_overflow AS
'Event_Meta.EVT_allow_overflow', Event_Meta.EVT_timezone_string AS 'Event_Meta.EVT_timezone_string', Event_Meta.EVT_external_URL AS
'Event_Meta.EVT_external_URL', Event_Meta.EVT_donations AS 'Event_Meta.EVT_donations', Event_CPT.ID AS 'Event_CPT.ID', Event_Meta.EVTM_ID AS
'Event_Meta.EVTM_ID' FROM wp6c_esp_datetime AS Datetime LEFT JOIN wp6c_posts AS Event_CPT ON Event_CPT.ID=Datetime.EVT_ID LEFT JOIN
wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.ID = 5118 ORDER BY Datetime.DTT_EVT_start ASC;
|
0.3529 [ms]
|
SELECT COUNT(DISTINCT Datetime.DTT_ID) FROM wp6c_esp_datetime AS Datetime WHERE Datetime.DTT_deleted = 0 AND Datetime.EVT_ID = 5118 AND
Datetime.DTT_EVT_start < '2023-06-08 00:56:28' AND Datetime.DTT_EVT_end > '2023-06-08 00:56:28';
|
0.6571 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 5118 LIMIT 1;
|
1.0450 [ms]
|
SELECT Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID', Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS
'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date', Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS
'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS 'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS
'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved', Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required',
Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row
AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted', Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent',
Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS 'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS
'Datetime_Ticket.TKT_ID', Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name',
Datetime.DTT_description AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS
'Datetime.DTT_EVT_end', Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS
'Datetime.DTT_reserved', Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS
'Datetime.DTT_parent', Datetime.DTT_deleted AS 'Datetime.DTT_deleted' FROM wp6c_esp_ticket AS Ticket LEFT JOIN wp6c_esp_datetime_ticket AS
Datetime_Ticket ON Datetime_Ticket.TKT_ID=Ticket.TKT_ID LEFT JOIN wp6c_esp_datetime AS Datetime ON Datetime.DTT_ID=Datetime_Ticket.DTT_ID WHERE
Ticket.TKT_deleted = 0 AND ( (Datetime.DTT_deleted = 0) OR Datetime.DTT_ID IS NULL) AND Datetime.EVT_ID = 5118 AND Ticket.TKT_end_date > '2023-06-08
00:56:28' ORDER BY Ticket.TKT_order ASC,Ticket.TKT_required DESC,Ticket.TKT_start_date ASC,Ticket.TKT_end_date ASC,Datetime.DTT_EVT_start DESC;
|
0.5741 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Event_CPT.ID AS 'Event_CPT.ID', Event_CPT.post_title AS 'Event_CPT.post_title', Event_CPT.post_content
AS 'Event_CPT.post_content', Event_CPT.post_name AS 'Event_CPT.post_name', Event_CPT.post_date AS 'Event_CPT.post_date', Event_CPT.post_excerpt AS
'Event_CPT.post_excerpt', Event_CPT.post_modified AS 'Event_CPT.post_modified', Event_CPT.post_author AS 'Event_CPT.post_author',
Event_CPT.post_parent AS 'Event_CPT.post_parent', Event_CPT.menu_order AS 'Event_CPT.menu_order', Event_CPT.post_status AS 'Event_CPT.post_status',
Event_CPT.post_password AS 'Event_CPT.post_password', Event_CPT.comment_status AS 'Event_CPT.comment_status', Event_CPT.ping_status AS
'Event_CPT.ping_status', Event_Meta.EVT_display_desc AS 'Event_Meta.EVT_display_desc', Event_Meta.EVT_display_ticket_selector AS
'Event_Meta.EVT_display_ticket_selector', Event_Meta.EVT_visible_on AS 'Event_Meta.EVT_visible_on', Event_Meta.EVT_additional_limit AS
'Event_Meta.EVT_additional_limit', Event_Meta.EVT_default_registration_status AS 'Event_Meta.EVT_default_registration_status',
Event_Meta.EVT_member_only AS 'Event_Meta.EVT_member_only', Event_Meta.EVT_phone AS 'Event_Meta.EVT_phone', Event_Meta.EVT_allow_overflow AS
'Event_Meta.EVT_allow_overflow', Event_Meta.EVT_timezone_string AS 'Event_Meta.EVT_timezone_string', Event_Meta.EVT_external_URL AS
'Event_Meta.EVT_external_URL', Event_Meta.EVT_donations AS 'Event_Meta.EVT_donations', Event_CPT.ID AS 'Event_CPT.ID', Event_Meta.EVTM_ID AS
'Event_Meta.EVTM_ID' FROM wp6c_esp_datetime AS Datetime LEFT JOIN wp6c_posts AS Event_CPT ON Event_CPT.ID=Datetime.EVT_ID LEFT JOIN
wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.ID = 5118 ORDER BY Datetime.DTT_EVT_start ASC;
|
0.8740 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 81 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.7730 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 81 ORDER BY Datetime.DTT_order ASC;
|
0.3090 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted' FROM wp6c_esp_datetime AS Datetime WHERE Datetime.DTT_deleted = 0 AND Datetime.DTT_ID = 6 LIMIT 1;
|
0.7520 [ms]
|
SELECT Price.PRC_ID AS 'Price.PRC_ID', Price.PRT_ID AS 'Price.PRT_ID', Price.PRC_amount AS 'Price.PRC_amount', Price.PRC_name AS 'Price.PRC_name',
Price.PRC_desc AS 'Price.PRC_desc', Price.PRC_is_default AS 'Price.PRC_is_default', Price.PRC_overrides AS 'Price.PRC_overrides', Price.PRC_order AS
'Price.PRC_order', Price.PRC_deleted AS 'Price.PRC_deleted', Price.PRC_parent AS 'Price.PRC_parent', Price.PRC_wp_user AS 'Price.PRC_wp_user',
Ticket_Price.TKP_ID AS 'Ticket_Price.TKP_ID', Ticket_Price.TKT_ID AS 'Ticket_Price.TKT_ID', Ticket_Price.PRC_ID AS 'Ticket_Price.PRC_ID',
Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID', Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS
'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date', Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS
'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS 'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS
'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved', Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required',
Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row
AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted', Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent'
FROM wp6c_esp_price AS Price LEFT JOIN wp6c_esp_ticket_price AS Ticket_Price ON Ticket_Price.PRC_ID=Price.PRC_ID LEFT JOIN wp6c_esp_ticket AS Ticket
ON Ticket.TKT_ID=Ticket_Price.TKT_ID WHERE Ticket.TKT_ID = 81 ORDER BY Price.PRC_order ASC;
|
0.3119 [ms]
|
SELECT WP_User.ID AS 'WP_User.ID', WP_User.user_login AS 'WP_User.user_login', WP_User.user_pass AS 'WP_User.user_pass', WP_User.user_nicename AS
'WP_User.user_nicename', WP_User.user_email AS 'WP_User.user_email', WP_User.user_registered AS 'WP_User.user_registered', WP_User.user_activation_key
AS 'WP_User.user_activation_key', WP_User.user_status AS 'WP_User.user_status', WP_User.display_name AS 'WP_User.display_name' FROM wp6c_users AS
WP_User WHERE WP_User.ID = 1507 GROUP BY WP_User.ID LIMIT 1;
|
0.2871 [ms]
|
SELECT Price_Type.PRT_ID AS 'Price_Type.PRT_ID', Price_Type.PRT_name AS 'Price_Type.PRT_name', Price_Type.PBT_ID AS 'Price_Type.PBT_ID',
Price_Type.PRT_is_percent AS 'Price_Type.PRT_is_percent', Price_Type.PRT_order AS 'Price_Type.PRT_order', Price_Type.PRT_deleted AS
'Price_Type.PRT_deleted', Price_Type.PRT_wp_user AS 'Price_Type.PRT_wp_user' FROM wp6c_esp_price_type AS Price_Type WHERE Price_Type.PRT_ID = 1
GROUP BY Price_Type.PRT_ID LIMIT 1;
|
0.2842 [ms]
|
SELECT WP_User.ID AS 'WP_User.ID', WP_User.user_login AS 'WP_User.user_login', WP_User.user_pass AS 'WP_User.user_pass', WP_User.user_nicename AS
'WP_User.user_nicename', WP_User.user_email AS 'WP_User.user_email', WP_User.user_registered AS 'WP_User.user_registered', WP_User.user_activation_key
AS 'WP_User.user_activation_key', WP_User.user_status AS 'WP_User.user_status', WP_User.display_name AS 'WP_User.display_name' FROM wp6c_users AS
WP_User WHERE WP_User.ID = 1 GROUP BY WP_User.ID LIMIT 1;
|
0.7389 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 81 ORDER BY Datetime.DTT_order ASC;
|
0.3080 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted' FROM wp6c_esp_datetime AS Datetime WHERE Datetime.DTT_deleted = 0 AND Datetime.DTT_ID = 6 LIMIT 1;
|
0.7689 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 81 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.4408 [ms]
|
SELECT Event_CPT.ID AS 'Event_CPT.ID', Event_CPT.post_title AS 'Event_CPT.post_title', Event_CPT.post_content AS 'Event_CPT.post_content',
Event_CPT.post_name AS 'Event_CPT.post_name', Event_CPT.post_date AS 'Event_CPT.post_date', Event_CPT.post_excerpt AS 'Event_CPT.post_excerpt',
Event_CPT.post_modified AS 'Event_CPT.post_modified', Event_CPT.post_author AS 'Event_CPT.post_author', Event_CPT.post_parent AS
'Event_CPT.post_parent', Event_CPT.menu_order AS 'Event_CPT.menu_order', Event_CPT.post_status AS 'Event_CPT.post_status', Event_CPT.post_password AS
'Event_CPT.post_password', Event_CPT.comment_status AS 'Event_CPT.comment_status', Event_CPT.ping_status AS 'Event_CPT.ping_status',
Event_Meta.EVT_display_desc AS 'Event_Meta.EVT_display_desc', Event_Meta.EVT_display_ticket_selector AS 'Event_Meta.EVT_display_ticket_selector',
Event_Meta.EVT_visible_on AS 'Event_Meta.EVT_visible_on', Event_Meta.EVT_additional_limit AS 'Event_Meta.EVT_additional_limit',
Event_Meta.EVT_default_registration_status AS 'Event_Meta.EVT_default_registration_status', Event_Meta.EVT_member_only AS
'Event_Meta.EVT_member_only', Event_Meta.EVT_phone AS 'Event_Meta.EVT_phone', Event_Meta.EVT_allow_overflow AS 'Event_Meta.EVT_allow_overflow',
Event_Meta.EVT_timezone_string AS 'Event_Meta.EVT_timezone_string', Event_Meta.EVT_external_URL AS 'Event_Meta.EVT_external_URL',
Event_Meta.EVT_donations AS 'Event_Meta.EVT_donations', Event_CPT.ID AS 'Event_CPT.ID', Event_Meta.EVTM_ID AS 'Event_Meta.EVTM_ID' FROM wp6c_posts
AS Event_CPT LEFT JOIN wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.ID = 5118 GROUP BY Event_CPT.ID LIMIT 1;
|
0.7770 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 82 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.7370 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 82 ORDER BY Datetime.DTT_order ASC;
|
0.2968 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted' FROM wp6c_esp_datetime AS Datetime WHERE Datetime.DTT_deleted = 0 AND Datetime.DTT_ID = 6 LIMIT 1;
|
0.7081 [ms]
|
SELECT Price.PRC_ID AS 'Price.PRC_ID', Price.PRT_ID AS 'Price.PRT_ID', Price.PRC_amount AS 'Price.PRC_amount', Price.PRC_name AS 'Price.PRC_name',
Price.PRC_desc AS 'Price.PRC_desc', Price.PRC_is_default AS 'Price.PRC_is_default', Price.PRC_overrides AS 'Price.PRC_overrides', Price.PRC_order AS
'Price.PRC_order', Price.PRC_deleted AS 'Price.PRC_deleted', Price.PRC_parent AS 'Price.PRC_parent', Price.PRC_wp_user AS 'Price.PRC_wp_user',
Ticket_Price.TKP_ID AS 'Ticket_Price.TKP_ID', Ticket_Price.TKT_ID AS 'Ticket_Price.TKT_ID', Ticket_Price.PRC_ID AS 'Ticket_Price.PRC_ID',
Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID', Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS
'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date', Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS
'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS 'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS
'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved', Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required',
Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row
AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted', Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent'
FROM wp6c_esp_price AS Price LEFT JOIN wp6c_esp_ticket_price AS Ticket_Price ON Ticket_Price.PRC_ID=Price.PRC_ID LEFT JOIN wp6c_esp_ticket AS Ticket
ON Ticket.TKT_ID=Ticket_Price.TKT_ID WHERE Ticket.TKT_ID = 82 ORDER BY Price.PRC_order ASC;
|
0.2742 [ms]
|
SELECT Price_Type.PRT_ID AS 'Price_Type.PRT_ID', Price_Type.PRT_name AS 'Price_Type.PRT_name', Price_Type.PBT_ID AS 'Price_Type.PBT_ID',
Price_Type.PRT_is_percent AS 'Price_Type.PRT_is_percent', Price_Type.PRT_order AS 'Price_Type.PRT_order', Price_Type.PRT_deleted AS
'Price_Type.PRT_deleted', Price_Type.PRT_wp_user AS 'Price_Type.PRT_wp_user' FROM wp6c_esp_price_type AS Price_Type WHERE Price_Type.PRT_ID = 1
GROUP BY Price_Type.PRT_ID LIMIT 1;
|
0.7250 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 82 ORDER BY Datetime.DTT_order ASC;
|
0.2999 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted' FROM wp6c_esp_datetime AS Datetime WHERE Datetime.DTT_deleted = 0 AND Datetime.DTT_ID = 6 LIMIT 1;
|
0.7422 [ms]
|
SELECT Datetime.DTT_ID AS 'Datetime.DTT_ID', Datetime.EVT_ID AS 'Datetime.EVT_ID', Datetime.DTT_name AS 'Datetime.DTT_name', Datetime.DTT_description
AS 'Datetime.DTT_description', Datetime.DTT_EVT_start AS 'Datetime.DTT_EVT_start', Datetime.DTT_EVT_end AS 'Datetime.DTT_EVT_end',
Datetime.DTT_reg_limit AS 'Datetime.DTT_reg_limit', Datetime.DTT_sold AS 'Datetime.DTT_sold', Datetime.DTT_reserved AS 'Datetime.DTT_reserved',
Datetime.DTT_is_primary AS 'Datetime.DTT_is_primary', Datetime.DTT_order AS 'Datetime.DTT_order', Datetime.DTT_parent AS 'Datetime.DTT_parent',
Datetime.DTT_deleted AS 'Datetime.DTT_deleted', Datetime_Ticket.DTK_ID AS 'Datetime_Ticket.DTK_ID', Datetime_Ticket.DTT_ID AS
'Datetime_Ticket.DTT_ID', Datetime_Ticket.TKT_ID AS 'Datetime_Ticket.TKT_ID', Ticket.TKT_ID AS 'Ticket.TKT_ID', Ticket.TTM_ID AS 'Ticket.TTM_ID',
Ticket.TKT_name AS 'Ticket.TKT_name', Ticket.TKT_description AS 'Ticket.TKT_description', Ticket.TKT_start_date AS 'Ticket.TKT_start_date',
Ticket.TKT_end_date AS 'Ticket.TKT_end_date', Ticket.TKT_min AS 'Ticket.TKT_min', Ticket.TKT_max AS 'Ticket.TKT_max', Ticket.TKT_price AS
'Ticket.TKT_price', Ticket.TKT_sold AS 'Ticket.TKT_sold', Ticket.TKT_qty AS 'Ticket.TKT_qty', Ticket.TKT_reserved AS 'Ticket.TKT_reserved',
Ticket.TKT_uses AS 'Ticket.TKT_uses', Ticket.TKT_required AS 'Ticket.TKT_required', Ticket.TKT_taxable AS 'Ticket.TKT_taxable', Ticket.TKT_is_default
AS 'Ticket.TKT_is_default', Ticket.TKT_order AS 'Ticket.TKT_order', Ticket.TKT_row AS 'Ticket.TKT_row', Ticket.TKT_deleted AS 'Ticket.TKT_deleted',
Ticket.TKT_wp_user AS 'Ticket.TKT_wp_user', Ticket.TKT_parent AS 'Ticket.TKT_parent' FROM wp6c_esp_datetime AS Datetime LEFT JOIN
wp6c_esp_datetime_ticket AS Datetime_Ticket ON Datetime_Ticket.DTT_ID=Datetime.DTT_ID LEFT JOIN wp6c_esp_ticket AS Ticket ON
Ticket.TKT_ID=Datetime_Ticket.TKT_ID WHERE Ticket.TKT_ID = 82 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.4761 [ms]
|
SELECT Event_CPT.ID AS 'Event_CPT.ID', Event_CPT.post_title AS 'Event_CPT.post_title', Event_CPT.post_content AS 'Event_CPT.post_content',
Event_CPT.post_name AS 'Event_CPT.post_name', Event_CPT.post_date AS 'Event_CPT.post_date', Event_CPT.post_excerpt AS 'Event_CPT.post_excerpt',
Event_CPT.post_modified AS 'Event_CPT.post_modified', Event_CPT.post_author AS 'Event_CPT.post_author', Event_CPT.post_parent AS
'Event_CPT.post_parent', Event_CPT.menu_order AS 'Event_CPT.menu_order', Event_CPT.post_status AS 'Event_CPT.post_status', Event_CPT.post_password AS
'Event_CPT.post_password', Event_CPT.comment_status AS 'Event_CPT.comment_status', Event_CPT.ping_status AS 'Event_CPT.ping_status',
Event_Meta.EVT_display_desc AS 'Event_Meta.EVT_display_desc', Event_Meta.EVT_display_ticket_selector AS 'Event_Meta.EVT_display_ticket_selector',
Event_Meta.EVT_visible_on AS 'Event_Meta.EVT_visible_on', Event_Meta.EVT_additional_limit AS 'Event_Meta.EVT_additional_limit',
Event_Meta.EVT_default_registration_status AS 'Event_Meta.EVT_default_registration_status', Event_Meta.EVT_member_only AS
'Event_Meta.EVT_member_only', Event_Meta.EVT_phone AS 'Event_Meta.EVT_phone', Event_Meta.EVT_allow_overflow AS 'Event_Meta.EVT_allow_overflow',
Event_Meta.EVT_timezone_string AS 'Event_Meta.EVT_timezone_string', Event_Meta.EVT_external_URL AS 'Event_Meta.EVT_external_URL',
Event_Meta.EVT_donations AS 'Event_Meta.EVT_donations', Event_CPT.ID AS 'Event_CPT.ID', Event_Meta.EVTM_ID AS 'Event_Meta.EVTM_ID' FROM wp6c_posts
AS Event_CPT LEFT JOIN wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.ID = 5118 GROUP BY Event_CPT.ID LIMIT 1;
|