{\rtf1\ansi\ansicpg1252\cocoartf1187\cocoasubrtf370
{\fonttbl\f0\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;}
\margl1440\margr1440\vieww10800\viewh8400\viewkind0
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural

\f0\fs24 \cf0 mysql> SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\\G\
*************************** 1. row ***************************\
                            QUERY: select audio_media_owner_id \
from audio_media_play \
where station_id = 3555 and audio_media_owner_type = 'STATION_CLIP'\
and audio_media_owner_id in (48901, 48900, 48903, 48902, 48897, 48893, 48892, 48896, 48895, 48899, 48898, 48894) \
and start_server_unix_timestamp  >= 1378227067247 order by start_server_unix_timestamp desc\
                            TRACE: \{\
  "steps": [\
    \{\
      "join_preparation": \{\
        "select#": 1,\
        "steps": [\
          \{\
            "expanded_query": "/* select#1 */ select `audio_media_play`.`audio_media_owner_id` AS `audio_media_owner_id` from `audio_media_play` where ((`audio_media_play`.`station_id` = 3555) and (`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894)) and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247)) order by `audio_media_play`.`start_server_unix_timestamp` desc"\
          \}\
        ]\
      \}\
    \},\
    \{\
      "join_optimization": \{\
        "select#": 1,\
        "steps": [\
          \{\
            "condition_processing": \{\
              "condition": "WHERE",\
              "original_condition": "((`audio_media_play`.`station_id` = 3555) and (`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894)) and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247))",\
              "steps": [\
                \{\
                  "transformation": "equality_propagation",\
                  "resulting_condition": "((`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894)) and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247) and multiple equal(3555, `audio_media_play`.`station_id`))"\
                \},\
                \{\
                  "transformation": "constant_propagation",\
                  "resulting_condition": "((`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894)) and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247) and multiple equal(3555, `audio_media_play`.`station_id`))"\
                \},\
                \{\
                  "transformation": "trivial_condition_removal",\
                  "resulting_condition": "((`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894)) and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247) and multiple equal(3555, `audio_media_play`.`station_id`))"\
                \}\
              ]\
            \}\
          \},\
          \{\
            "table_dependencies": [\
              \{\
                "table": "`audio_media_play`",\
                "row_may_be_null": false,\
                "map_bit": 0,\
                "depends_on_map_bits": [\
                ]\
              \}\
            ]\
          \},\
          \{\
            "ref_optimizer_key_uses": [\
              \{\
                "table": "`audio_media_play`",\
                "field": "station_id",\
                "equals": "3555",\
                "null_rejecting": false\
              \},\
              \{\
                "table": "`audio_media_play`",\
                "field": "station_id",\
                "equals": "3555",\
                "null_rejecting": false\
              \}\
            ]\
          \},\
          \{\
            "rows_estimation": [\
              \{\
                "table": "`audio_media_play`",\
                "range_analysis": \{\
                  "table_scan": \{\
                    "rows": 4094123,\
                    "cost": 860235\
                  \},\
                  "potential_range_indices": [\
                    \{\
                      "index": "PRIMARY",\
                      "usable": false,\
                      "cause": "not_applicable"\
                    \},\
                    \{\
                      "index": "play_hash_idx",\
                      "usable": false,\
                      "cause": "not_applicable"\
                    \},\
                    \{\
                      "index": "audio_media_id_idx",\
                      "usable": false,\
                      "cause": "not_applicable"\
                    \},\
                    \{\
                      "index": "streaming_idx",\
                      "usable": false,\
                      "cause": "not_applicable"\
                    \},\
                    \{\
                      "index": "audio_media_owner_id_idx",\
                      "usable": true,\
                      "key_parts": [\
                        "audio_media_owner_id",\
                        "id"\
                      ]\
                    \},\
                    \{\
                      "index": "station_id_start_server_time",\
                      "usable": true,\
                      "key_parts": [\
                        "station_id",\
                        "start_server_time",\
                        "id"\
                      ]\
                    \},\
                    \{\
                      "index": "station_id_start_server_unix_timestamp",\
                      "usable": true,\
                      "key_parts": [\
                        "station_id",\
                        "start_server_unix_timestamp",\
                        "id"\
                      ]\
                    \},\
                    \{\
                      "index": "last_modified_server_time_idx",\
                      "usable": false,\
                      "cause": "not_applicable"\
                    \},\
                    \{\
                      "index": "last_modified_timestamp_idx",\
                      "usable": false,\
                      "cause": "not_applicable"\
                    \}\
                  ],\
                  "setup_range_conditions": [\
                  ],\
                  "group_index_range": \{\
                    "chosen": false,\
                    "cause": "not_group_by_or_distinct"\
                  \},\
                  "analyzing_range_alternatives": \{\
                    "range_scan_alternatives": [\
                      \{\
                        "index": "audio_media_owner_id_idx",\
                        "ranges": [\
                          "48892 <= audio_media_owner_id <= 48892",\
                          "48893 <= audio_media_owner_id <= 48893",\
                          "48894 <= audio_media_owner_id <= 48894",\
                          "48895 <= audio_media_owner_id <= 48895",\
                          "48896 <= audio_media_owner_id <= 48896",\
                          "48897 <= audio_media_owner_id <= 48897",\
                          "48898 <= audio_media_owner_id <= 48898",\
                          "48899 <= audio_media_owner_id <= 48899",\
                          "48900 <= audio_media_owner_id <= 48900",\
                          "48901 <= audio_media_owner_id <= 48901",\
                          "48902 <= audio_media_owner_id <= 48902",\
                          "48903 <= audio_media_owner_id <= 48903"\
                        ],\
                        "index_dives_for_eq_ranges": false,\
                        "rowid_ordered": false,\
                        "using_mrr": false,\
                        "index_only": false,\
                        "rows": 264,\
                        "cost": 328.81,\
                        "chosen": true\
                      \},\
                      \{\
                        "index": "station_id_start_server_time",\
                        "ranges": [\
                          "3555 <= station_id <= 3555"\
                        ],\
                        "index_dives_for_eq_ranges": true,\
                        "rowid_ordered": false,\
                        "using_mrr": false,\
                        "index_only": false,\
                        "rows": 173604,\
                        "cost": 208326,\
                        "chosen": false,\
                        "cause": "cost"\
                      \},\
                      \{\
                        "index": "station_id_start_server_unix_timestamp",\
                        "ranges": [\
                          "3555 <= station_id <= 3555 AND 1378227067247 <= start_server_unix_timestamp"\
                        ],\
                        "index_dives_for_eq_ranges": true,\
                        "rowid_ordered": false,\
                        "using_mrr": false,\
                        "index_only": false,\
                        "rows": 903,\
                        "cost": 1084.6,\
                        "chosen": false,\
                        "cause": "cost"\
                      \}\
                    ],\
                    "analyzing_roworder_intersect": \{\
                      "usable": false,\
                      "cause": "too_few_roworder_scans"\
                    \}\
                  \},\
                  "chosen_range_access_summary": \{\
                    "range_access_plan": \{\
                      "type": "range_scan",\
                      "index": "audio_media_owner_id_idx",\
                      "rows": 264,\
                      "ranges": [\
                        "48892 <= audio_media_owner_id <= 48892",\
                        "48893 <= audio_media_owner_id <= 48893",\
                        "48894 <= audio_media_owner_id <= 48894",\
                        "48895 <= audio_media_owner_id <= 48895",\
                        "48896 <= audio_media_owner_id <= 48896",\
                        "48897 <= audio_media_owner_id <= 48897",\
                        "48898 <= audio_media_owner_id <= 48898",\
                        "48899 <= audio_media_owner_id <= 48899",\
                        "48900 <= audio_media_owner_id <= 48900",\
                        "48901 <= audio_media_owner_id <= 48901",\
                        "48902 <= audio_media_owner_id <= 48902",\
                        "48903 <= audio_media_owner_id <= 48903"\
                      ]\
                    \},\
                    "rows_for_plan": 264,\
                    "cost_for_plan": 328.81,\
                    "chosen": true\
                  \}\
                \}\
              \}\
            ]\
          \},\
          \{\
            "considered_execution_plans": [\
              \{\
                "plan_prefix": [\
                ],\
                "table": "`audio_media_play`",\
                "best_access_path": \{\
                  "considered_access_paths": [\
                    \{\
                      "access_type": "ref",\
                      "index": "station_id_start_server_time",\
                      "rows": 173604,\
                      "cost": 158945,\
                      "chosen": true\
                    \},\
                    \{\
                      "access_type": "ref",\
                      "index": "station_id_start_server_unix_timestamp",\
                      "rows": 12110,\
                      "cost": 14532,\
                      "chosen": true\
                    \},\
                    \{\
                      "access_type": "range",\
                      "rows": 198,\
                      "cost": 381.61,\
                      "chosen": true,\
                      "use_tmp_table": true\
                    \}\
                  ]\
                \},\
                "cost_for_plan": 381.61,\
                "rows_for_plan": 198,\
                "sort_cost": 198,\
                "new_cost_for_plan": 579.61,\
                "chosen": true\
              \}\
            ]\
          \},\
          \{\
            "attaching_conditions_to_tables": \{\
              "original_condition": "((`audio_media_play`.`station_id` = 3555) and (`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894)) and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247))",\
              "attached_conditions_computation": [\
              ],\
              "attached_conditions_summary": [\
                \{\
                  "table": "`audio_media_play`",\
                  "attached": "((`audio_media_play`.`station_id` = 3555) and (`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894)) and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247))"\
                \}\
              ]\
            \}\
          \},\
          \{\
            "clause_processing": \{\
              "clause": "ORDER BY",\
              "original_clause": "`audio_media_play`.`start_server_unix_timestamp` desc",\
              "items": [\
                \{\
                  "item": "`audio_media_play`.`start_server_unix_timestamp`"\
                \}\
              ],\
              "resulting_clause_is_simple": true,\
              "resulting_clause": "`audio_media_play`.`start_server_unix_timestamp` desc"\
            \}\
          \},\
          \{\
            "refine_plan": [\
              \{\
                "table": "`audio_media_play`",\
                "pushed_index_condition": "(`audio_media_play`.`audio_media_owner_id` in (48901,48900,48903,48902,48897,48893,48892,48896,48895,48899,48898,48894))",\
                "table_condition_attached": "((`audio_media_play`.`station_id` = 3555) and (`audio_media_play`.`audio_media_owner_type` = 'STATION_CLIP') and (`audio_media_play`.`start_server_unix_timestamp` >= 1378227067247))",\
                "access_type": "range"\
              \}\
            ]\
          \},\
          \{\
            "reconsidering_access_paths_for_index_ordering": \{\
              "clause": "ORDER BY",\
              "index_order_summary": \{\
                "table": "`audio_media_play`",\
                "index_provides_order": false,\
                "order_direction": "undefined",\
                "index": "audio_media_owner_id_idx",\
                "plan_changed": false\
              \}\
            \}\
          \}\
        ]\
      \}\
    \},\
    \{\
      "join_execution": \{\
        "select#": 1,\
        "steps": [\
          \{\
            "filesort_information": [\
              \{\
                "direction": "desc",\
                "table": "`audio_media_play`",\
                "field": "start_server_unix_timestamp"\
              \}\
            ],\
            "filesort_priority_queue_optimization": \{\
              "usable": false,\
              "cause": "not applicable (no LIMIT)"\
            \},\
            "filesort_execution": [\
            ],\
            "filesort_summary": \{\
              "rows": 369,\
              "examined_rows": 44148,\
              "number_of_tmp_files": 0,\
              "sort_buffer_size": 1048560,\
              "sort_mode": "<sort_key, additional_fields>"\
            \}\
          \}\
        ]\
      \}\
    \}\
  ]\
\}\
MISSING_BYTES_BEYOND_MAX_MEM_SIZE: 0\
          INSUFFICIENT_PRIVILEGES: 0}