Invite Only: Password Protected
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Site`.`id`, `Site`.`title` FROM `cakedb`.`sites` AS `Site` WHERE 1 = 1 | 12 | 12 | 0 | |
| 2 | SELECT COUNT(*) AS `count` FROM `cakedb`.`events` AS `Event` WHERE `Event`.`id` = 10875 | 1 | 1 | 0 | |
| 3 | SELECT COUNT(*) AS `count` FROM `cakedb`.`registrations` AS `Registration` LEFT JOIN `cakedb`.`events` AS `Event` ON (`Registration`.`event_id` = `Event`.`id`) LEFT JOIN `cakedb`.`users` AS `User` ON (`Registration`.`user_id` = `User`.`id`) LEFT JOIN `cakedb`.`ftcc_pifs` AS `FtccPif` ON (`FtccPif`.`registration_id` = `Registration`.`id`) LEFT JOIN `cakedb`.`pifs` AS `Pif` ON (`Pif`.`registration_id` = `Registration`.`id`) LEFT JOIN `cakedb`.`transactions` AS `Transaction` ON (`Transaction`.`registration_id` = `Registration`.`id`) WHERE `Registration`.`event_id` = 10875 AND `Registration`.`user_id` IS NULL | 1 | 1 | 0 | |
| 4 | SELECT `Event`.`id`, `Event`.`ERDATE`, `Event`.`end_date`, `Event`.`ERNAME`, `Event`.`LOCZIP`, `Event`.`ER9_1_bak`, `Event`.`ER9_2_bak`, `Event`.`ER9_3_bak`, `Event`.`ER9_4a_bak`, `Event`.`ER9_4b_bak`, `Event`.`ER9_5_bak`, `Event`.`AETC`, `Event`.`PROG_ID`, `Event`.`max_registrants`, `Event`.`is_password_protected`, `Event`.`password`, `Event`.`webinar_link`, `Event`.`confirmation_email`, `Event`.`extra_questions`, `Event`.`fee`, `Event`.`active`, `Event`.`status`, `Event`.`address`, `Event`.`description`, `Event`.`meta_data`, `Event`.`acre_redirect`, `Event`.`webex_link`, `Event`.`webex_password`, `Event`.`archived_web_posts`, `Event`.`webex_test_link`, `Event`.`edited`, `Event`.`type`, `Event`.`site_id`, `Event`.`user_id`, `Event`.`featured`, `Event`.`registration_close_date`, `Event`.`archived`, `Event`.`evaluation_btn_flag`, `Event`.`post_reg_redirect_link`, `Event`.`group_id`, `Event`.`location_name`, `Event`.`status_id`, `Event`.`event_type`, `Event`.`ER7_01`, `Event`.`ER7_02`, `Event`.`ER7_03`, `Event`.`ER7_04`, `Event`.`ER7_05`, `Event`.`ER7_06`, `Event`.`ER7_07`, `Event`.`ER8_01`, `Event`.`ER8_02`, `Event`.`ER8_03`, `Event`.`ER8_04`, `Event`.`ER8_05`, `Event`.`ER8_06`, `Event`.`ER8_07`, `Event`.`ER8_08`, `Event`.`ER8_09`, `Event`.`ER8_10`, `Event`.`ER8_11`, `Event`.`ER8_12`, `Event`.`ER8_13`, `Event`.`ER9_01`, `Event`.`ER9_02`, `Event`.`ER9_03`, `Event`.`ER9_04`, `Event`.`ER9_05`, `Event`.`ER9_06`, `Event`.`ER9_07`, `Event`.`ER9_08`, `Event`.`ER9_09`, `Event`.`ER9_10`, `Event`.`ER9_11`, `Event`.`ER9_12`, `Event`.`ER9_13`, `Event`.`ER9_14`, `Event`.`ER9_15`, `Event`.`ER9_16`, `Event`.`ER9_17`, `Event`.`ER9_18`, `Event`.`ER9_19`, `Event`.`ER9_20`, `Event`.`ER9_21`, `Event`.`ER10_01`, `Event`.`ER10_02`, `Event`.`ER10_03`, `Event`.`ER10_04`, `Event`.`ER10_05`, `Event`.`ER11_01`, `Event`.`ER11_02`, `Event`.`ER11_03`, `Event`.`ER11_04`, `Event`.`ER12_01`, `Event`.`ER12_02`, `Event`.`ER12_03`, `Event`.`ER12_04`, `Event`.`ER12_05`, `Event`.`ER12_06`, `Event`.`ER12_07`, `Event`.`ER12_08`, `Event`.`ER12_09`, `Event`.`ER12_10`, `Event`.`ER12_11`, `Event`.`ER12_12`, `Event`.`ER12_13`, `Event`.`ER12_14`, `Event`.`ER12_15`, `Event`.`ER12_16`, `Event`.`ER13_01`, `Event`.`ER13_02`, `Event`.`ER13_03`, `Event`.`ER13_04`, `Event`.`ER13_05`, `Event`.`ER13_06`, `Event`.`ER13_07`, `Event`.`ER13_08`, `Event`.`ER13_09`, `Event`.`ER13_10`, `Event`.`ER13_10_other`, `Event`.`ER13_11`, `Event`.`ER13_12`, `Event`.`ER13_13`, `Event`.`ER13_14`, `Event`.`ER13_15`, `Event`.`ER13_16`, `Event`.`ER13_17`, `Event`.`ER13_18`, `Event`.`ER13_18_other`, `Event`.`ER14_01`, `Event`.`ER14_02`, `Event`.`ER14_03`, `Event`.`ER14_04`, `Event`.`ER14_05`, `Event`.`ER14_06`, `Event`.`ER14_07`, `Event`.`ER14_08`, `Event`.`ER14_09`, `Event`.`ER14_10`, `Event`.`ER14_11`, `Event`.`ER14_12`, `Event`.`ER14_12_other`, `Event`.`ER14_13`, `Event`.`ER14_14`, `Event`.`ER14_15`, `Event`.`ER14_16`, `Event`.`ER14_17`, `Event`.`ER15_01`, `Event`.`ER15_02`, `Event`.`ER15_03`, `Event`.`ER15_04`, `Event`.`ER15_05`, `Event`.`ER15_06`, `Event`.`ER15_07`, `Event`.`ER15_08`, `Event`.`ER16_01`, `Event`.`ER16_02`, `Event`.`ER16_03`, `Event`.`ER16_04`, `Event`.`ER16_05`, `Event`.`ER16_06`, `Event`.`ER16_07`, `Event`.`ER16_08`, `Event`.`ER16_09`, `Event`.`ER16_10`, `Event`.`ER16_11`, `Event`.`ER16_12`, `Event`.`ER16_13`, `Event`.`ER16_13_other`, `Event`.`ER17_01`, `Event`.`ER17_02`, `Event`.`ER17_03`, `Event`.`ER17_04`, `Event`.`ER17_05`, `Event`.`ER17_06`, `Event`.`ER17_07`, `Event`.`ER17_08`, `Event`.`ER17_09`, `Event`.`ER17_10`, `Event`.`ER17_11`, `Event`.`ER17_12`, `Event`.`ER17_13`, `Event`.`ER17_14`, `Event`.`ER18`, `Event`.`ER19_01`, `Event`.`ER19_02`, `Event`.`ER19_03`, `Event`.`ER19_04`, `Event`.`ER19_05`, `Event`.`ER20`, `Event`.`ER21`, `Event`.`ER22`, `Event`.`priority1`, `Event`.`priority2`, `Event`.`priority3` FROM `cakedb`.`events` AS `Event` WHERE `Event`.`id` = 10875 LIMIT 1 | 1 | 1 | 1 | |
| 5 | SELECT `Presentation`.`id`, `Presentation`.`title`, `Presentation`.`description`, `Presentation`.`objectives`, `Presentation`.`speakers`, `Presentation`.`start`, `Presentation`.`end`, `Presentation`.`active`, `Presentation`.`evaluation_redirect`, `Presentation`.`event_id`, `Presentation`.`user_id` FROM `cakedb`.`presentations` AS `Presentation` WHERE `Presentation`.`event_id` = (10875) | 0 | 0 | 0 | |
| 6 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created` FROM `cakedb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Event' AND `Attachment`.`foreign_key` = (10875) | 0 | 0 | 1 | |
| 7 | SELECT `Registration`.`id`, `Registration`.`event_id`, `Registration`.`user_id`, `Registration`.`remind`, `Registration`.`created`, `Registration`.`thank_you` FROM `cakedb`.`registrations` AS `Registration` WHERE `Registration`.`user_id` IS NULL | 0 | 0 | 0 | |
| 8 | SELECT COUNT(1) as Registration__count, event_id FROM registrations AS Registration GROUP BY event_id; | 6036 | 6036 | 9 |
