1 of 3
1 | 2 | 3
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `app` | 20 | 20 | 1 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | |
| 3 | SELECT `Subscription`.`sub_id`, `Subscription`.`name`, `Subscription`.`billing_type`, `Subscription`.`cost_in_cents`, `Subscription`.`period_in_minutes`, `Subscription`.`on_subscribe_run_app_id`, `Subscription`.`on_subscribe_run_launch_option_index`, `Subscription`.`rate_limits`, `Subscription`.`discounts`, `Subscription`.`is_preorder`, `Subscription`.`requires_shipping_address`, `Subscription`.`domestic_cost_in_cents`, `Subscription`.`international_cost_in_cents`, `Subscription`.`required_key_type`, `Subscription`.`is_cyber_cafe`, `Subscription`.`game_code`, `Subscription`.`game_code_description`, `Subscription`.`is_disabled`, `Subscription`.`requires_cd`, `Subscription`.`territory_code`, `Subscription`.`is_steam3_subscription`, `Subscription`.`extended_info`, `Subscription`.`app_count`, `Subscription`.`date_updated` FROM `sub` AS `Subscription` WHERE `Subscription`.`sub_id` = 158 LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT COUNT(*) AS `count` FROM `app` AS `Application` LEFT JOIN `apps_subs` AS `AppsSubs` ON (`AppsSubs`.`app_id` = `Application`.`app_id` AND cdr_id_last IS NULL) WHERE `AppsSubs`.`sub_id` = 158 | 1 | 1 | 37 | |
| 5 | SELECT `Application`.`app_id`, `Application`.`name`, `Application`.`install_dir`, `Application`.`min_cache_size`, `Application`.`max_cache_size`, `Application`.`launch_options`, `Application`.`on_first_launch`, `Application`.`is_bandwidth_greedy`, `Application`.`current_version_id`, `Application`.`trickle_version_id`, `Application`.`user_defined`, `Application`.`beta_version_password`, `Application`.`beta_version_id`, `Application`.`legacy_install_dir`, `Application`.`skip_mfp_overwrite`, `Application`.`use_filesystem_dvr`, `Application`.`manifest_only`, `Application`.`app_of_manifest_only`, `Application`.`sub_count`, `Application`.`date_updated`, (`AppsSubs`.`cdr_id`) AS `Application__cdr_id`, `AppsSubs`.`app_id`, `AppsSubs`.`sub_id`, `AppsSubs`.`cdr_id`, `AppsSubs`.`cdr_id_last` FROM `app` AS `Application` LEFT JOIN `apps_subs` AS `AppsSubs` ON (`AppsSubs`.`app_id` = `Application`.`app_id` AND cdr_id_last IS NULL) WHERE `AppsSubs`.`sub_id` = 158 ORDER BY `Application`.`app_id` asc LIMIT 100 | 100 | 100 | 14 |