0.1760 [ms]
|
SELECT NOW() as timestamp;
|
0.5729 [ms]
|
SHOW FULL COLUMNS FROM `wp6c_options`;
|
0.2291 [ms]
|
UPDATE `wp6c_options` SET `option_value` = '1' WHERE `option_name` = 'mepr_activated';
|
0.2320 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_site_transient_mepr_license_info' LIMIT 1;
|
0.2260 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_site_transient_mepr_all_addons' LIMIT 1;
|
0.2391 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_calculate_taxes' LIMIT 1;
|
0.1960 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_tax_avalara_enabled' LIMIT 1;
|
0.1941 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_disable_senddata' LIMIT 1;
|
0.2189 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_vat_enabled' LIMIT 1;
|
0.1879 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_disable_all_popups' LIMIT 1;
|
0.1941 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_disable_reminder_crons' LIMIT 1;
|
0.1872 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'mepr_authenticator_site_uuid' LIMIT 1;
|
0.2489 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'wd_bwg_options' LIMIT 1;
|
0.2022 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'tenweb_admin_demo' LIMIT 1;
|
0.2599 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'wp-mail-logging_allow_tracking' LIMIT 1;
|
0.1900 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'wp-mail-logging_tracking_notice' LIMIT 1;
|
0.1872 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'redux-framework-tracking' LIMIT 1;
|
0.6340 [ms]
|
SHOW TABLES LIKE "wp6c_wpml_mails";
|
0.6859 [ms]
|
SHOW TABLES LIKE 'wp6c_snippets';
|
0.3550 [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.2339 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'espresso_db_update' LIMIT 1;
|
0.2189 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'ee_espresso_activation' LIMIT 1;
|
0.2110 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'ee_network_config' LIMIT 1;
|
0.2670 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'postman_auth_token' LIMIT 1;
|
0.2420 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'connections_licenses' LIMIT 1;
|
0.2689 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 3047 LIMIT 1;
|
0.3581 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (3047) ORDER BY meta_id ASC;
|
0.2129 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'redux_pro_license_key' LIMIT 1;
|
0.3610 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1;
|
0.2449 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1;
|
0.3359 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_core_path' LIMIT 1;
|
0.2148 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_core_path' LIMIT 1;
|
0.2198 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_core_version' LIMIT 1;
|
0.1960 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_core_version' LIMIT 1;
|
0.3011 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_core_needs_old_theme_patch' LIMIT 1;
|
0.3049 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_core_needs_old_theme_patch' LIMIT 1;
|
0.2382 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_core_api_spam_options' LIMIT 1;
|
0.2010 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_core_page_resource_remove_all' LIMIT 1;
|
0.3040 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_pb_role_settings' LIMIT 1;
|
0.4048 [ms]
|
SELECT *
FROM wp6c_masterslider_sliders
WHERE status='published'
ORDER BY ID DESC
;
|
0.2429 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'nonce_key' LIMIT 1;
|
0.2000 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'nonce_salt' LIMIT 1;
|
0.2079 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
0.2022 [ms]
|
SELECT autoload FROM wp6c_options WHERE option_name = '_transient_mepr_migration_error';
|
0.2079 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_mepr_migrating' LIMIT 1;
|
0.1781 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_mepr_migrating' LIMIT 1;
|
0.1721 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'ee_incompatible_addons' LIMIT 1;
|
0.3760 [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.2680 [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.3011 [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.2520 [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.3090 [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.2542 [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.2220 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'litespeed.placeholder._summary' LIMIT 1;
|
0.3550 [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.2751 [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.6962 [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.3049 [ms]
|
SELECT id, code, scope, active
FROM wp6c_snippets
WHERE scope IN ('head-content','footer-content') AND active=1
ORDER BY priority, id;
|
0.2611 [ms]
|
SELECT * FROM wp6c_itsec_bans WHERE host = '34.225.194.102';
|
0.2151 [ms]
|
SELECT `id`, `host` FROM wp6c_itsec_bans WHERE `type` = 'range';
|
0.3171 [ms]
|
SELECT * FROM `wp6c_itsec_lockouts` WHERE `lockout_active`=1 AND `lockout_expire_gmt` > '2023-02-02 11:35:26' AND `lockout_host` = '34.225.194.102'
ORDER BY `lockout_start` DESC LIMIT 1;;
|
0.2441 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_ee_ssn_030fd6dcf0e977b4b1b7ee7024eabe24' LIMIT 1;
|
0.1850 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_ee_ssn_030fd6dcf0e977b4b1b7ee7024eabe24' LIMIT 1;
|
0.2141 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_support_options' LIMIT 1;
|
0.2580 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 40 LIMIT 1;
|
0.1969 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'https_migration_required' LIMIT 1;
|
0.2041 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'twb_show_cta' LIMIT 1;
|
0.1950 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_tenweb_subscription_id' LIMIT 1;
|
0.1860 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_tenweb_subscription_id' LIMIT 1;
|
0.2010 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'cn_default_category' LIMIT 1;
|
0.2429 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'medium_crop' LIMIT 1;
|
0.1991 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'medium_large_crop' LIMIT 1;
|
0.1900 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'large_crop' LIMIT 1;
|
0.4909 [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.2470 [ms]
|
SELECT wp6c_posts.* FROM wp6c_posts WHERE ID IN (9425);
|
0.3850 [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.2480 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (9425) ORDER BY meta_id ASC;
|
0.2029 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
|
0.1838 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
|
0.3269 [ms]
|
INSERT INTO `wp6c_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1675337727.5259668827056884765625', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
0.3331 [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 ('board-review')
ORDER BY t.term_id ASC
LIMIT 1
;
|
0.2830 [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 ('board-review')
ORDER BY t.term_id ASC
LIMIT 1
;
|
0.3231 [ms]
|
SELECT post_content from wp6c_posts WHERE post_status NOT IN ('auto-draft', 'inherit', 'trash') AND post_name='board-review';
|
0.2341 [ms]
|
SELECT * from wp6c_esp_status LIMIT 1;
|
0.2611 [ms]
|
SELECT STS_ID, STS_code FROM wp6c_esp_status WHERE STS_type = 'registration';
|
0.4389 [ms]
|
SELECT wp6c_posts.*
FROM wp6c_posts
WHERE 1=1 AND wp6c_posts.post_name = 'board-review' AND wp6c_posts.post_type = 'espresso_events'
ORDER BY wp6c_posts.post_date DESC
;
|
0.6239 [ms]
|
SELECT * FROM wp6c_esp_event_meta WHERE EVT_ID = 5118;
|
0.2601 [ms]
|
SELECT wp6c_posts.* FROM wp6c_posts WHERE ID IN (5118);
|
0.4182 [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 ('post_tag', 'espresso_event_categories', 'espresso_event_type') AND tr.object_id IN (5118)
ORDER BY t.name ASC
;
|
0.2580 [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 (2);
|
0.3519 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (5118) ORDER BY meta_id ASC;
|
0.2151 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_display_conditions_tracking_post_ids' LIMIT 1;
|
0.4768 [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.1950 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_tb_templates_backup_0' LIMIT 1;
|
0.4561 [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 (5118)
ORDER BY t.name ASC
;
|
0.3421 [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 (5118)
ORDER BY t.name ASC
;
|
0.3409 [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 (5118)
ORDER BY t.name ASC
;
|
0.3209 [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 (5118)
ORDER BY t.name ASC
;
|
0.2410 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_et_check_mod_pagespeed' LIMIT 1;
|
0.2010 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_et_check_mod_pagespeed' LIMIT 1;
|
0.6230 [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.2360 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_cn_legacy_templates' LIMIT 1;
|
0.1991 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_cn_legacy_templates' LIMIT 1;
|
0.2501 [ms]
|
SELECT * FROM wp6c_posts WHERE ID = 2833 LIMIT 1;
|
0.3991 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (2833) ORDER BY meta_id ASC;
|
0.8991 [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 ('single-espresso_events-board-review','single-espresso_events','single') 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.2530 [ms]
|
SELECT * FROM wp6c_users WHERE ID = '1507' LIMIT 1;
|
1.2722 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp6c_usermeta WHERE user_id IN (1507) ORDER BY umeta_id ASC;
|
0.2611 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout__et_builder_gf_feature_cache' LIMIT 1;
|
0.2301 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient__et_builder_gf_feature_cache' LIMIT 1;
|
0.2630 [ms]
|
SELECT * FROM wp6c_bwg_theme;
|
0.2170 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_timeout_fonts_cache_status' LIMIT 1;
|
0.1771 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = '_transient_fonts_cache_status' LIMIT 1;
|
0.2022 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_google_fonts_cache' LIMIT 1;
|
0.4370 [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 (5118)
ORDER BY t.name ASC
;
|
0.2069 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'et_uploaded_fonts' LIMIT 1;
|
0.1931 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'wordfenceActivated' LIMIT 1;
|
0.2019 [ms]
|
SELECT * FROM wp6c_masterslider_options WHERE option_name = 'custom_inline_style';
|
0.1969 [ms]
|
SELECT * FROM wp6c_masterslider_options WHERE option_name = 'masterslider_custom_css_ver';
|
0.5200 [ms]
|
SELECT * FROM `wp6c_yoast_indexable` WHERE `object_id` = '5118' AND `object_type` = 'post' LIMIT 1;
|
0.2260 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'site_logo' LIMIT 1;
|
0.3550 [ms]
|
SELECT * FROM `wp6c_yoast_indexable` WHERE `object_type` = 'home-page' LIMIT 1;
|
0.2270 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'auth_key' LIMIT 1;
|
0.1922 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'auth_salt' LIMIT 1;
|
0.4191 [ms]
|
SELECT * FROM `wp6c_yoast_indexable` WHERE `object_id` = '242' AND `object_type` = 'post' LIMIT 1;
|
0.4759 [ms]
|
SELECT * FROM `wp6c_yoast_indexable` WHERE `object_type` = 'post-type-archive' AND `object_sub_type` = 'espresso_events' LIMIT 1;
|
0.2799 [ms]
|
SELECT `ancestor_id` FROM `wp6c_yoast_indexable_hierarchy` WHERE `indexable_id` = '31' ORDER BY `depth` DESC;
|
1.2422 [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 Datetime.DTT_deleted = 0 AND Event_CPT.ID = 5118 AND Datetime.DTT_EVT_end
>= '2023-02-02 11:35:27' GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_EVT_start asc LIMIT 1;
|
0.5190 [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_order ASC;
|
0.9220 [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.DTT_ID IN (6);
|
1.0490 [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 = 77 ORDER BY Datetime.DTT_order ASC;
|
0.3822 [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.9542 [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 = 78 ORDER BY Datetime.DTT_order ASC;
|
0.3660 [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.9439 [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 = 79 ORDER BY Datetime.DTT_order ASC;
|
0.3729 [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.7908 [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 = 80 ORDER BY Datetime.DTT_order ASC;
|
0.2849 [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;
|
2.1911 [ms]
|
SELECT Venue_CPT.ID AS 'Venue_CPT.ID', Venue_CPT.post_title AS 'Venue_CPT.post_title', Venue_CPT.post_content AS 'Venue_CPT.post_content',
Venue_CPT.post_name AS 'Venue_CPT.post_name', Venue_CPT.post_date AS 'Venue_CPT.post_date', Venue_CPT.post_excerpt AS 'Venue_CPT.post_excerpt',
Venue_CPT.post_modified AS 'Venue_CPT.post_modified', Venue_CPT.post_author AS 'Venue_CPT.post_author', Venue_CPT.post_parent AS
'Venue_CPT.post_parent', Venue_CPT.menu_order AS 'Venue_CPT.menu_order', Venue_CPT.post_password AS 'Venue_CPT.post_password', Venue_CPT.post_status
AS 'Venue_CPT.post_status', Venue_CPT.comment_status AS 'Venue_CPT.comment_status', Venue_CPT.ping_status AS 'Venue_CPT.ping_status',
Venue_Meta.VNU_address AS 'Venue_Meta.VNU_address', Venue_Meta.VNU_address2 AS 'Venue_Meta.VNU_address2', Venue_Meta.VNU_city AS
'Venue_Meta.VNU_city', Venue_Meta.STA_ID AS 'Venue_Meta.STA_ID', Venue_Meta.CNT_ISO AS 'Venue_Meta.CNT_ISO', Venue_Meta.VNU_zip AS
'Venue_Meta.VNU_zip', Venue_Meta.VNU_phone AS 'Venue_Meta.VNU_phone', Venue_Meta.VNU_capacity AS 'Venue_Meta.VNU_capacity', Venue_Meta.VNU_url AS
'Venue_Meta.VNU_url', Venue_Meta.VNU_virtual_phone AS 'Venue_Meta.VNU_virtual_phone', Venue_Meta.VNU_virtual_url AS 'Venue_Meta.VNU_virtual_url',
Venue_Meta.VNU_google_map_link AS 'Venue_Meta.VNU_google_map_link', Venue_Meta.VNU_enable_for_gmap AS 'Venue_Meta.VNU_enable_for_gmap', Venue_CPT.ID
AS 'Venue_CPT.ID', Venue_Meta.VNUM_ID AS 'Venue_Meta.VNUM_ID', Event_Venue.EVV_ID AS 'Event_Venue.EVV_ID', Event_Venue.EVT_ID AS 'Event_Venue.EVT_ID',
Event_Venue.VNU_ID AS 'Event_Venue.VNU_ID', Event_Venue.EVV_primary AS 'Event_Venue.EVV_primary', 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 Venue_CPT LEFT JOIN wp6c_esp_venue_meta AS Venue_Meta ON Venue_CPT.ID = Venue_Meta.VNU_ID LEFT JOIN
wp6c_esp_event_venue AS Event_Venue ON Event_Venue.VNU_ID=Venue_CPT.ID LEFT JOIN wp6c_posts AS Event_CPT ON Event_CPT.ID=Event_Venue.EVT_ID LEFT JOIN
wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.ID = 5118;
|
0.4640 [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.6670 [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.6020 [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.2659 [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.8779 [ms]
|
SELECT wp6c_posts.* FROM wp6c_posts WHERE ID IN (242,37,45,53,673,79,81,83,323,85,87,89,2921,2811,62,91);
|
4.6270 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (37,45,53,62,79,81,83,85,87,89,91,242,323,673,2811,2921) ORDER BY meta_id ASC;
|
0.2320 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'lolmi_login_page_url' LIMIT 1;
|
0.1910 [ms]
|
SELECT option_value FROM wp6c_options WHERE option_name = 'lolmi_logout_redirect_url' LIMIT 1;
|
0.3829 [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 ('espresso_event_categories') AND tr.object_id IN (5118)
ORDER BY t.name ASC
;
|
0.3531 [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 ('espresso_event_type') AND tr.object_id IN (5118)
ORDER BY t.name ASC
;
|
0.1850 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp6c_termmeta WHERE term_id IN (2) ORDER BY meta_id ASC;
|
0.6621 [ms]
|
SELECT wp6c_comments.comment_ID
FROM wp6c_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 5118
ORDER BY wp6c_comments.comment_date_gmt DESC
;
|
0.5610 [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.4981 [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 AND Datetime.DTT_EVT_end >= '2023-02-02 11:35:27'
ORDER BY Datetime.DTT_order ASC;
|
0.5460 [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
Datetime.DTT_ID = 6;
|
0.7379 [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 = 60 ORDER BY Datetime.DTT_order ASC;
|
0.2720 [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.6590 [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 = 63 ORDER BY Datetime.DTT_order ASC;
|
0.2670 [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.6671 [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 = 64 ORDER BY Datetime.DTT_order ASC;
|
0.2749 [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.6540 [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 = 65 ORDER BY Datetime.DTT_order ASC;
|
0.2661 [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.6440 [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 = 69 ORDER BY Datetime.DTT_order ASC;
|
0.2639 [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.6499 [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 = 71 ORDER BY Datetime.DTT_order ASC;
|
0.3030 [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.6542 [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 = 73 ORDER BY Datetime.DTT_order ASC;
|
0.2639 [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.6409 [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 = 74 ORDER BY Datetime.DTT_order ASC;
|
0.2720 [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.6599 [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 = 76 ORDER BY Datetime.DTT_order ASC;
|
0.2708 [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.6599 [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 = 77 ORDER BY Datetime.DTT_order ASC;
|
0.2649 [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.6428 [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 = 78 ORDER BY Datetime.DTT_order ASC;
|
0.2630 [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.6471 [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 = 79 ORDER BY Datetime.DTT_order ASC;
|
0.2689 [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.6490 [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 = 80 ORDER BY Datetime.DTT_order ASC;
|
0.2682 [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.5131 [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.3340 [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-02-02 11:35:27' AND Datetime.DTT_EVT_end > '2023-02-02 11:35:27';
|
0.8640 [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-02-02
11:35:27' 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.4940 [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.7050 [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 = 77 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.6599 [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 = 77 ORDER BY Datetime.DTT_order ASC;
|
0.2670 [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;
|
1.3590 [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 = 77 ORDER BY Price.PRC_order ASC;
|
0.2649 [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.6330 [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.2520 [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.6640 [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 = 77 ORDER BY Datetime.DTT_order ASC;
|
0.2689 [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.6709 [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 = 77 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.4010 [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.6802 [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 = 78 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.6678 [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 = 78 ORDER BY Datetime.DTT_order ASC;
|
0.2649 [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.6421 [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 = 78 ORDER BY Price.PRC_order ASC;
|
0.2429 [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.6499 [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 = 78 ORDER BY Datetime.DTT_order ASC;
|
0.2730 [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.6700 [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 = 78 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.4048 [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.6750 [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 = 79 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.6549 [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 = 79 ORDER BY Datetime.DTT_order ASC;
|
0.2689 [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.6478 [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 = 79 ORDER BY Price.PRC_order ASC;
|
0.2499 [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.6511 [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 = 79 ORDER BY Datetime.DTT_order ASC;
|
0.2670 [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.6659 [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 = 79 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.4251 [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.6890 [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 = 80 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.6490 [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 = 80 ORDER BY Datetime.DTT_order ASC;
|
0.2649 [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.6490 [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 = 80 ORDER BY Price.PRC_order ASC;
|
0.2451 [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.6449 [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 = 80 ORDER BY Datetime.DTT_order ASC;
|
0.2639 [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.6709 [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 = 80 GROUP BY Datetime.DTT_ID ORDER BY Datetime.DTT_order ASC LIMIT 1;
|
0.3998 [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.5891 [ms]
|
SELECT Venue_CPT.ID AS 'Venue_CPT.ID', Venue_CPT.post_title AS 'Venue_CPT.post_title', Venue_CPT.post_content AS 'Venue_CPT.post_content',
Venue_CPT.post_name AS 'Venue_CPT.post_name', Venue_CPT.post_date AS 'Venue_CPT.post_date', Venue_CPT.post_excerpt AS 'Venue_CPT.post_excerpt',
Venue_CPT.post_modified AS 'Venue_CPT.post_modified', Venue_CPT.post_author AS 'Venue_CPT.post_author', Venue_CPT.post_parent AS
'Venue_CPT.post_parent', Venue_CPT.menu_order AS 'Venue_CPT.menu_order', Venue_CPT.post_password AS 'Venue_CPT.post_password', Venue_CPT.post_status
AS 'Venue_CPT.post_status', Venue_CPT.comment_status AS 'Venue_CPT.comment_status', Venue_CPT.ping_status AS 'Venue_CPT.ping_status',
Venue_Meta.VNU_address AS 'Venue_Meta.VNU_address', Venue_Meta.VNU_address2 AS 'Venue_Meta.VNU_address2', Venue_Meta.VNU_city AS
'Venue_Meta.VNU_city', Venue_Meta.STA_ID AS 'Venue_Meta.STA_ID', Venue_Meta.CNT_ISO AS 'Venue_Meta.CNT_ISO', Venue_Meta.VNU_zip AS
'Venue_Meta.VNU_zip', Venue_Meta.VNU_phone AS 'Venue_Meta.VNU_phone', Venue_Meta.VNU_capacity AS 'Venue_Meta.VNU_capacity', Venue_Meta.VNU_url AS
'Venue_Meta.VNU_url', Venue_Meta.VNU_virtual_phone AS 'Venue_Meta.VNU_virtual_phone', Venue_Meta.VNU_virtual_url AS 'Venue_Meta.VNU_virtual_url',
Venue_Meta.VNU_google_map_link AS 'Venue_Meta.VNU_google_map_link', Venue_Meta.VNU_enable_for_gmap AS 'Venue_Meta.VNU_enable_for_gmap', Venue_CPT.ID
AS 'Venue_CPT.ID', Venue_Meta.VNUM_ID AS 'Venue_Meta.VNUM_ID', Event_Venue.EVV_ID AS 'Event_Venue.EVV_ID', Event_Venue.EVT_ID AS 'Event_Venue.EVT_ID',
Event_Venue.VNU_ID AS 'Event_Venue.VNU_ID', Event_Venue.EVV_primary AS 'Event_Venue.EVV_primary', 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 Venue_CPT LEFT JOIN wp6c_esp_venue_meta AS Venue_Meta ON Venue_CPT.ID = Venue_Meta.VNU_ID LEFT JOIN
wp6c_esp_event_venue AS Event_Venue ON Event_Venue.VNU_ID=Venue_CPT.ID LEFT JOIN wp6c_posts AS Event_CPT ON Event_CPT.ID=Event_Venue.EVT_ID LEFT JOIN
wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.ID = 5118;
|
0.5450 [ms]
|
SELECT Venue_CPT.ID AS 'Venue_CPT.ID', Venue_CPT.post_title AS 'Venue_CPT.post_title', Venue_CPT.post_content AS 'Venue_CPT.post_content',
Venue_CPT.post_name AS 'Venue_CPT.post_name', Venue_CPT.post_date AS 'Venue_CPT.post_date', Venue_CPT.post_excerpt AS 'Venue_CPT.post_excerpt',
Venue_CPT.post_modified AS 'Venue_CPT.post_modified', Venue_CPT.post_author AS 'Venue_CPT.post_author', Venue_CPT.post_parent AS
'Venue_CPT.post_parent', Venue_CPT.menu_order AS 'Venue_CPT.menu_order', Venue_CPT.post_password AS 'Venue_CPT.post_password', Venue_CPT.post_status
AS 'Venue_CPT.post_status', Venue_CPT.comment_status AS 'Venue_CPT.comment_status', Venue_CPT.ping_status AS 'Venue_CPT.ping_status',
Venue_Meta.VNU_address AS 'Venue_Meta.VNU_address', Venue_Meta.VNU_address2 AS 'Venue_Meta.VNU_address2', Venue_Meta.VNU_city AS
'Venue_Meta.VNU_city', Venue_Meta.STA_ID AS 'Venue_Meta.STA_ID', Venue_Meta.CNT_ISO AS 'Venue_Meta.CNT_ISO', Venue_Meta.VNU_zip AS
'Venue_Meta.VNU_zip', Venue_Meta.VNU_phone AS 'Venue_Meta.VNU_phone', Venue_Meta.VNU_capacity AS 'Venue_Meta.VNU_capacity', Venue_Meta.VNU_url AS
'Venue_Meta.VNU_url', Venue_Meta.VNU_virtual_phone AS 'Venue_Meta.VNU_virtual_phone', Venue_Meta.VNU_virtual_url AS 'Venue_Meta.VNU_virtual_url',
Venue_Meta.VNU_google_map_link AS 'Venue_Meta.VNU_google_map_link', Venue_Meta.VNU_enable_for_gmap AS 'Venue_Meta.VNU_enable_for_gmap', Venue_CPT.ID
AS 'Venue_CPT.ID', Venue_Meta.VNUM_ID AS 'Venue_Meta.VNUM_ID', Event_Venue.EVV_ID AS 'Event_Venue.EVV_ID', Event_Venue.EVT_ID AS 'Event_Venue.EVT_ID',
Event_Venue.VNU_ID AS 'Event_Venue.VNU_ID', Event_Venue.EVV_primary AS 'Event_Venue.EVV_primary', 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 Venue_CPT LEFT JOIN wp6c_esp_venue_meta AS Venue_Meta ON Venue_CPT.ID = Venue_Meta.VNU_ID LEFT JOIN
wp6c_esp_event_venue AS Event_Venue ON Event_Venue.VNU_ID=Venue_CPT.ID LEFT JOIN wp6c_posts AS Event_CPT ON Event_CPT.ID=Event_Venue.EVT_ID LEFT JOIN
wp6c_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.ID = 5118;
|
0.3281 [ms]
|
SELECT wp6c_posts.ID
FROM wp6c_posts
WHERE 1=1 AND wp6c_posts.post_type = 'post' AND ((wp6c_posts.post_status = 'publish'))
ORDER BY wp6c_posts.post_date DESC
LIMIT 0, 5
;
|
0.2661 [ms]
|
SELECT wp6c_posts.* FROM wp6c_posts WHERE ID IN (537,535);
|
0.4120 [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 ('category', 'post_tag', 'post_format') AND tr.object_id IN (535, 537)
ORDER BY t.name ASC
;
|
0.2539 [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 (1);
|
0.5751 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp6c_postmeta WHERE post_id IN (535,537) ORDER BY meta_id ASC;
|
0.3488 [ms]
|
SELECT wp6c_comments.comment_ID
FROM wp6c_comments JOIN wp6c_posts ON wp6c_posts.ID = wp6c_comments.comment_post_ID
WHERE ( comment_approved = '1' ) AND wp6c_posts.post_status IN ('publish') AND wp6c_posts.post_type != 'espresso_attendees'
ORDER BY wp6c_comments.comment_date_gmt DESC
LIMIT 0,5
;
|
0.3669 [ms]
|
SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp6c_posts WHERE post_type = 'post' AND post_status =
'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC ;
|
0.3052 [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 tt.count > 0
ORDER BY t.name ASC
;
|
0.1850 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp6c_termmeta WHERE term_id IN (1) ORDER BY meta_id ASC;
|
Recent Comments