| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | 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` = 2489 LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `AppStateCapture`.`app_id`, `AppStateCapture`.`created`, `AppStateCapture`.`name` FROM `app_state_capture` AS `AppStateCapture` WHERE `cdr_id` = 2489 AND `created` = 1 ORDER BY `app_id` ASC | 0 | 0 | 1 | |
| 3 | SELECT `AppStateCapture`.`app_id`, `AppStateCapture`.`created`, `AppStateCapture`.`name` FROM `app_state_capture` AS `AppStateCapture` WHERE `cdr_id` = 2489 AND `created` = 0 ORDER BY `app_id` ASC | 143 | 143 | 1 | |
| 4 | SELECT `Application`.`app_id`, `Application`.`name` FROM `app` AS `Application` WHERE app_id IN (6850, 6851, 6860, 6861, 6862, 6863, 6880, 6881, 6882, 6883, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6900, 6901, 6910, 6911, 6920, 6921, 6980, 6981, 6982, 7000, 7001, 7002, 7003, 7004, 7005, 8000, 8001, 8002, 8003, 8080, 8081, 8082, 8083, 8084, 8085, 8140, 8141, 8190, 8191, 28000, 28001, 28002, 28003, 28004, 28005, 28006, 28007, 28008, 28009, 28010, 28011, 28012, 28017, 28050, 28051, 28052, 28053, 28054, 28055, 28056, 28057, 28058, 28059, 28060, 28061, 28110, 28111, 28112, 28113, 28114, 28115, 28116, 28117, 35080, 35083, 35086, 35087, 35089, 35090, 35091, 35094, 35101, 35102, 35130, 35131, 35132, 35134, 35135, 35136, 35137, 35138, 39160, 39161, 39162, 39163, 39164, 39165, 39166, 39167, 39168, 39169, 39190, 39191, 39192, 39193, 39194, 39195, 39196, 39200, 39201, 39202, 39203, 39204, 39205, 39206, 39270, 39271, 39272, 39273, 39274, 39275, 39276, 39277, 39278, 107202, 201280, 201281, 201282, 201283, 201284, 201285, 201286, 201287, 201288, 201289) | 143 | 143 | 1 | |
| 5 | SELECT `SubStateCapture`.`sub_id`, `SubStateCapture`.`created`, `SubStateCapture`.`name` FROM `sub_state_capture` AS `SubStateCapture` WHERE `cdr_id` = 2489 AND `created` = 1 ORDER BY `sub_id` ASC | 4 | 4 | 0 | |
| 6 | SELECT `SubStateCapture`.`sub_id`, `SubStateCapture`.`created`, `SubStateCapture`.`name` FROM `sub_state_capture` AS `SubStateCapture` WHERE `cdr_id` = 2489 AND `created` = 0 ORDER BY `sub_id` ASC | 0 | 0 | 0 | |
| 7 | SHOW FULL COLUMNS FROM `sub` | 24 | 24 | 1 | |
| 8 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 1 | |
| 9 | SELECT `Subscription`.`sub_id`, `Subscription`.`name` FROM `sub` AS `Subscription` WHERE sub_id IN (13870, 13871, 13872, 13873) | 4 | 4 | 0 |