ANALYZE FORMAT=JSON SELECT straight_join MIN(chn.name) AS voiced_char_name, MIN(n.name) AS voicing_actress_name, MIN(t.title) AS kung_fu_panda FROM info_type AS it, role_type AS rt, keyword AS k, movie_keyword AS mk, title AS t, movie_companies AS mc, company_name AS cn, movie_info AS mi force index (movie_id_movie_info), cast_info AS ci, char_name AS chn, name AS n, aka_name AS an WHERE ci.note in ('(voice)', '(voice: Japanese version)', '(voice) (uncredited)', '(voice: English version)') AND cn.country_code ='[us]' AND cn.name = 'DreamWorks Animation' AND it.info = 'release dates' AND k.keyword in ('hero', 'martial-arts', 'hand-to-hand-combat', 'computer-animated-movie') AND mi.info is not null and (mi.info like 'Japan:%201%' or mi.info like 'USA:%201%') AND n.gender ='f' and n.name like '%An%' AND rt.role ='actress' AND t.production_year > 2010 AND t.title like 'Kung Fu Panda%' AND t.id = mi.movie_id AND t.id = mc.movie_id AND t.id = ci.movie_id AND t.id = mk.movie_id AND mc.movie_id = ci.movie_id AND mc.movie_id = mi.movie_id AND mc.movie_id = mk.movie_id AND mi.movie_id = ci.movie_id AND mi.movie_id = mk.movie_id AND ci.movie_id = mk.movie_id AND cn.id = mc.company_id AND it.id = mi.info_type_id AND n.id = ci.person_id AND rt.id = ci.role_id AND n.id = an.person_id AND ci.person_id = an.person_id AND chn.id = ci.person_role_id AND k.id = mk.keyword_id; { "query_block": { "select_id": 1, "r_loops": 1, "r_total_time_ms": 50.62004123, "nested_loop": [ { "table": { "table_name": "it", "access_type": "ALL", "possible_keys": ["PRIMARY"], "r_loops": 1, "rows": 113, "r_rows": 113, "r_table_time_ms": 0.020983871, "r_other_time_ms": 0.005998812, "filtered": 0.884955764, "r_filtered": 0.884955752, "attached_condition": "it.info = 'release dates'" } }, { "block-nl-join": { "table": { "table_name": "rt", "access_type": "ALL", "possible_keys": ["PRIMARY"], "r_loops": 1, "rows": 12, "r_rows": 12, "r_table_time_ms": 0.002752494, "r_other_time_ms": 0.001656841, "filtered": 8.333333015, "r_filtered": 8.333333333, "attached_condition": "rt.`role` = 'actress'" }, "buffer_type": "flat", "buffer_size": "1Kb", "join_type": "BNL", "r_filtered": 100, "r_unpack_time_ms": 5.623016e-4 } }, { "block-nl-join": { "table": { "table_name": "k", "access_type": "ALL", "possible_keys": ["PRIMARY"], "r_loops": 1, "rows": 134170, "r_rows": 134170, "r_table_time_ms": 14.62180105, "r_other_time_ms": 5.385101293, "filtered": 0.002981292, "r_filtered": 0.002235969, "attached_condition": "k.keyword in ('hero','martial-arts','hand-to-hand-combat','computer-animated-movie')" }, "buffer_type": "incremental", "buffer_size": "1Kb", "join_type": "BNL", "r_filtered": 100, "r_unpack_time_ms": 6.814427e-4 } }, { "table": { "table_name": "mk", "access_type": "ref", "possible_keys": ["keyword_id_movie_keyword", "movie_id_movie_keyword"], "key": "keyword_id_movie_keyword", "key_length": "4", "used_key_parts": ["keyword_id"], "ref": ["imdbload.k.id"], "r_loops": 3, "rows": 33, "r_rows": 3232, "r_table_time_ms": 12.66867646, "r_other_time_ms": 0.802853128, "filtered": 100, "r_filtered": 100 } }, { "table": { "table_name": "t", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id"], "ref": ["imdbload.mk.movie_id"], "r_loops": 9696, "rows": 1, "r_rows": 1, "r_table_time_ms": 13.24503562, "r_other_time_ms": 0.403370123, "filtered": 6.127187e-6, "r_filtered": 0.072194719, "attached_condition": "t.production_year > 2010 and t.title like 'Kung Fu Panda%'" } }, { "table": { "table_name": "mc", "access_type": "ref", "possible_keys": [ "company_id_movie_companies", "movie_id_movie_companies" ], "key": "movie_id_movie_companies", "key_length": "4", "used_key_parts": ["movie_id"], "ref": ["imdbload.mk.movie_id"], "r_loops": 7, "rows": 2, "r_rows": 8.857142857, "r_table_time_ms": 0.079134766, "r_other_time_ms": 0.006624581, "filtered": 100, "r_filtered": 100 } }, { "table": { "table_name": "cn", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id"], "ref": ["imdbload.mc.company_id"], "r_loops": 62, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.081661783, "r_other_time_ms": 0.005588499, "filtered": 1.598509e-4, "r_filtered": 9.677419355, "attached_condition": "cn.country_code = '[us]' and cn.`name` = 'DreamWorks Animation'" } }, { "table": { "table_name": "mi", "access_type": "ref", "possible_keys": ["movie_id_movie_info"], "key": "movie_id_movie_info", "key_length": "4", "used_key_parts": ["movie_id"], "ref": ["imdbload.mk.movie_id"], "r_loops": 6, "rows": 6, "r_rows": 90.66666667, "r_table_time_ms": 1.481702048, "r_other_time_ms": 0.043876228, "filtered": 100, "r_filtered": 1.654411765, "attached_condition": "mi.info_type_id = it.`id` and mi.info is not null and (mi.info like 'Japan:%201%' or mi.info like 'USA:%201%')" } }, { "table": { "table_name": "ci", "access_type": "ref", "possible_keys": [ "movie_id_cast_info", "person_id_cast_info", "person_role_id_cast_info", "role_id_cast_info" ], "key": "movie_id_cast_info", "key_length": "4", "used_key_parts": ["movie_id"], "ref": ["imdbload.mk.movie_id"], "r_loops": 9, "rows": 15, "r_rows": 118.3333333, "r_table_time_ms": 1.480570764, "r_other_time_ms": 0.048109078, "filtered": 2.226900816, "r_filtered": 5.727699531, "attached_condition": "ci.role_id = rt.`id` and ci.note in ('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') and ci.person_role_id is not null" } }, { "table": { "table_name": "chn", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id"], "ref": ["imdbload.ci.person_role_id"], "r_loops": 61, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.091051106, "r_other_time_ms": 0.008626597, "filtered": 100, "r_filtered": 100 } }, { "table": { "table_name": "n", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id"], "ref": ["imdbload.ci.person_id"], "r_loops": 61, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.075209789, "r_other_time_ms": 0.011481531, "filtered": 23.07119179, "r_filtered": 27.86885246, "attached_condition": "n.gender = 'f' and n.`name` like '%An%'" } }, { "table": { "table_name": "an", "access_type": "ref", "possible_keys": ["person_id_aka_name"], "key": "person_id_aka_name", "key_length": "4", "used_key_parts": ["person_id"], "ref": ["imdbload.ci.person_id"], "r_loops": 17, "rows": 1, "r_rows": 3.352941176, "r_table_time_ms": 0.028229768, "r_other_time_ms": 0.012277104, "filtered": 100, "r_filtered": 100, "using_index": true } } ] } }