| 1 | SHOW FULL COLUMNS FROM `app_state_capture` | | 21 | 21 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
| 3 | SELECT `ContentRecord`.`cdr_id`, `ContentRecord`.`hash`, `ContentRecord`.`version`, `ContentRecord`.`date_updated`, `ContentRecord`.`date_processed`, `ContentRecord`.`app_count`, `ContentRecord`.`sub_count` FROM `cdr` AS `ContentRecord` WHERE `ContentRecord`.`cdr_id` = 3343 LIMIT 1 | | 1 | 1 | 0 |
| 4 | SELECT `AppStateCapture`.`app_id`, `AppStateCapture`.`created`, `AppStateCapture`.`name` FROM `app_state_capture` AS `AppStateCapture` WHERE `cdr_id` = 3343 AND `created` = 1 ORDER BY `app_id` ASC | | 0 | 0 | 0 |
| 5 | SELECT `AppStateCapture`.`app_id`, `AppStateCapture`.`created`, `AppStateCapture`.`name` FROM `app_state_capture` AS `AppStateCapture` WHERE `cdr_id` = 3343 AND `created` = 0 ORDER BY `app_id` ASC | | 13 | 13 | 0 |
| 6 | SELECT `Application`.`app_id`, `Application`.`name` FROM `app` AS `Application` WHERE app_id IN (40950, 40951, 40952, 40953, 40954, 40955, 47400, 47401, 47402, 47407, 47408, 47409, 47430) | | 13 | 13 | 0 |
| 7 | SELECT `SubStateCapture`.`sub_id`, `SubStateCapture`.`created`, `SubStateCapture`.`name` FROM `sub_state_capture` AS `SubStateCapture` WHERE `cdr_id` = 3343 AND `created` = 1 ORDER BY `sub_id` ASC | | 1 | 1 | 0 |
| 8 | SELECT `SubStateCapture`.`sub_id`, `SubStateCapture`.`created`, `SubStateCapture`.`name` FROM `sub_state_capture` AS `SubStateCapture` WHERE `cdr_id` = 3343 AND `created` = 0 ORDER BY `sub_id` ASC | | 0 | 0 | 0 |
| 9 | SELECT `Subscription`.`sub_id`, `Subscription`.`name` FROM `sub` AS `Subscription` WHERE sub_id = (14591) | | 1 | 1 | 0 |
