CDR ID 5072
Hash b02adebb913880b46775f7b4006c6847fb0d01f9
Date Updated 2012-07-06 22:17:00
Date Processed 2012-07-06 22:20:00
Apps Added None
Apps Modified
212180 Combat Arms
Subs Added None
Subs Modified None
(default) 10 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `cdr`771
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `sub_state_capture`25251
4SELECT `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` = 5072 LIMIT 1110
5SELECT `AppStateCapture`.`app_id`, `AppStateCapture`.`created`, `AppStateCapture`.`name` FROM `app_state_capture` AS `AppStateCapture` WHERE `cdr_id` = 5072 AND `created` = 1 ORDER BY `app_id` ASC 000
6SELECT `AppStateCapture`.`app_id`, `AppStateCapture`.`created`, `AppStateCapture`.`name` FROM `app_state_capture` AS `AppStateCapture` WHERE `cdr_id` = 5072 AND `created` = 0 ORDER BY `app_id` ASC 110
7SELECT `Application`.`app_id`, `Application`.`name` FROM `app` AS `Application` WHERE app_id = (212180) 110
8SELECT `SubStateCapture`.`sub_id`, `SubStateCapture`.`created`, `SubStateCapture`.`name` FROM `sub_state_capture` AS `SubStateCapture` WHERE `cdr_id` = 5072 AND `created` = 1 ORDER BY `sub_id` ASC 000
9SELECT `SubStateCapture`.`sub_id`, `SubStateCapture`.`created`, `SubStateCapture`.`name` FROM `sub_state_capture` AS `SubStateCapture` WHERE `cdr_id` = 5072 AND `created` = 0 ORDER BY `sub_id` ASC 000
10SELECT `Subscription`.`sub_id`, `Subscription`.`name` FROM `sub` AS `Subscription` WHERE `sub_id` IS NULL 000