time="2020-07-21T11:17:04+08:00" level=info msg="complete plan collection" plan space size=2 query="SELECT * FROM (aka_title) JOIN movie_link WHERE ((aka_title.id<=>242091 OR aka_title.id>242091) AND (aka_title.movie_id<=>3865448 OR aka_title.movie_id>3865448) OR (aka_title.title<=>\"Golden jade slave\" OR aka_title.title<\"Golden jade slave\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id>1) OR (aka_title.production_year<=>1962 OR aka_title.production_year>1962) OR (aka_title.phonetic_code<=>\"G4352\" OR aka_title.phonetic_code<\"G4352\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"0422d64139af699bceac3265e154fe04\" OR aka_title.md5sum>\"0422d64139af699bceac3265e154fe04\")) AND ((movie_link.id<=>1996389 OR movie_link.id>1996389) AND (movie_link.movie_id<=>4352804 OR movie_link.movie_id>4352804) AND (movie_link.linked_movie_id<=>4352801 OR movie_link.linked_movie_id<4352801) AND (movie_link.link_type_id<=>1 OR movie_link.link_type_id>1)) LIMIT 100" query id=1.sql time="2020-07-21T11:17:06+08:00" level=info msg="complete origin query" cost="[530 664 646 652]ms" query="SELECT * FROM (aka_title) JOIN movie_link WHERE ((aka_title.id<=>242091 OR aka_title.id>242091) AND (aka_title.movie_id<=>3865448 OR aka_title.movie_id>3865448) OR (aka_title.title<=>\"Golden jade slave\" OR aka_title.title<\"Golden jade slave\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id>1) OR (aka_title.production_year<=>1962 OR aka_title.production_year>1962) OR (aka_title.phonetic_code<=>\"G4352\" OR aka_title.phonetic_code<\"G4352\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"0422d64139af699bceac3265e154fe04\" OR aka_title.md5sum>\"0422d64139af699bceac3265e154fe04\")) AND ((movie_link.id<=>1996389 OR movie_link.id>1996389) AND (movie_link.movie_id<=>4352804 OR movie_link.movie_id>4352804) AND (movie_link.linked_movie_id<=>4352801 OR movie_link.linked_movie_id<4352801) AND (movie_link.link_type_id<=>1 OR movie_link.link_type_id>1)) LIMIT 100" query id=1.sql time="2020-07-21T11:17:08+08:00" level=info msg="complete execution plan1" cost="[461 420 371 355]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM (aka_title) JOIN movie_link WHERE ((aka_title.id<=>242091 OR aka_title.id>242091) AND (aka_title.movie_id<=>3865448 OR aka_title.movie_id>3865448) OR (aka_title.title<=>\"Golden jade slave\" OR aka_title.title<\"Golden jade slave\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id>1) OR (aka_title.production_year<=>1962 OR aka_title.production_year>1962) OR (aka_title.phonetic_code<=>\"G4352\" OR aka_title.phonetic_code<\"G4352\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"0422d64139af699bceac3265e154fe04\" OR aka_title.md5sum>\"0422d64139af699bceac3265e154fe04\")) AND ((movie_link.id<=>1996389 OR movie_link.id>1996389) AND (movie_link.movie_id<=>4352804 OR movie_link.movie_id>4352804) AND (movie_link.linked_movie_id<=>4352801 OR movie_link.linked_movie_id<4352801) AND (movie_link.link_type_id<=>1 OR movie_link.link_type_id>1)) LIMIT 100" query id=1.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete execution plan2" cost="[689 648 640 636]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM (aka_title) JOIN movie_link WHERE ((aka_title.id<=>242091 OR aka_title.id>242091) AND (aka_title.movie_id<=>3865448 OR aka_title.movie_id>3865448) OR (aka_title.title<=>\"Golden jade slave\" OR aka_title.title<\"Golden jade slave\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id>1) OR (aka_title.production_year<=>1962 OR aka_title.production_year>1962) OR (aka_title.phonetic_code<=>\"G4352\" OR aka_title.phonetic_code<\"G4352\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"0422d64139af699bceac3265e154fe04\" OR aka_title.md5sum>\"0422d64139af699bceac3265e154fe04\")) AND ((movie_link.id<=>1996389 OR movie_link.id>1996389) AND (movie_link.movie_id<=>4352804 OR movie_link.movie_id>4352804) AND (movie_link.linked_movie_id<=>4352801 OR movie_link.linked_movie_id<4352801) AND (movie_link.link_type_id<=>1 OR movie_link.link_type_id>1)) LIMIT 100" query id=1.sql time="2020-07-21T11:17:10+08:00" level=info msg="Complete a step" cost="[530 664 646 652]" default hints="use_index(@`sel_1` `imdb`.`aka_title` ), use_index(@`sel_1` `imdb`.`movie_link` ), hash_join(@`sel_1` `imdb`.`aka_title`)" default plan=2 plan size=2 query="SELECT * FROM (aka_title) JOIN movie_link WHERE ((aka_title.id<=>242091 OR aka_title.id>242091) AND (aka_title.movie_id<=>3865448 OR aka_title.movie_id>3865448) OR (aka_title.title<=>\"Golden jade slave\" OR aka_title.title<\"Golden jade slave\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id>1) OR (aka_title.production_year<=>1962 OR aka_title.production_year>1962) OR (aka_title.phonetic_code<=>\"G4352\" OR aka_title.phonetic_code<\"G4352\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"0422d64139af699bceac3265e154fe04\" OR aka_title.md5sum>\"0422d64139af699bceac3265e154fe04\")) AND ((movie_link.id<=>1996389 OR movie_link.id>1996389) AND (movie_link.movie_id<=>4352804 OR movie_link.movie_id>4352804) AND (movie_link.linked_movie_id<=>4352801 OR movie_link.linked_movie_id<4352801) AND (movie_link.link_type_id<=>1 OR movie_link.link_type_id>1)) LIMIT 100" query id=1.sql time="2020-07-21T11:17:10+08:00" level=error msg="may choose a suboptimal plan(401.75ms < 623.00ms)" better hints="use_index(@`sel_1` `imdb`.`aka_title` ), use_index(@`sel_1` `imdb`.`movie_link` ), hash_join(@`sel_1` `imdb`.`aka_title`), nth_plan(1)" better plan=1 query id=1.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete plan collection" plan space size=6 query="SELECT * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete origin query" cost="[2 1 1 1]ms" query="SELECT * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete execution plan1" cost="[1 1 1 1]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete execution plan2" cost="[1 1 1 1]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete execution plan3" cost="[1 1 1 0]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete execution plan4" cost="[0 1 1 0]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete execution plan5" cost="[1 0 1 0]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="complete execution plan6" cost="[1 0 0 1]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:10+08:00" level=info msg="Complete a step" cost="[2 1 1 1]" default hints="use_index(@`sel_1` `imdb`.`comp_cast_type` )" default plan=0 plan size=6 query="SELECT * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>\"crew\" OR comp_cast_type.kind>\"crew\")) LIMIT 100" query id=10.sql time="2020-07-21T11:17:11+08:00" level=info msg="complete plan collection" plan space size=12 query="SELECT * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql time="2020-07-21T11:17:37+08:00" level=info msg="complete origin query" cost="[6972 6464 6949 6243]ms" query="SELECT * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql time="2020-07-21T11:18:07+08:00" level=info msg="complete execution plan1" cost="[8157 6687 6866 8287]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql time="2020-07-21T11:18:38+08:00" level=info msg="complete execution plan2" cost="[7660 7888 7817 7133]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql time="2020-07-21T11:19:09+08:00" level=info msg="complete execution plan3" cost="[8283 8014 7148 7571]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql time="2020-07-21T11:19:35+08:00" level=info msg="complete execution plan4" cost="[6947 5874 6746 6540]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql time="2020-07-21T11:19:59+08:00" level=info msg="complete execution plan5" cost="[6377 5940 5966 6045]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql time="2020-07-21T11:20:25+08:00" level=info msg="complete execution plan6" cost="[7364 6154 6091 6715]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>276175 OR movie_companies.id>276175) OR (movie_companies.movie_id<=>1226901 OR movie_companies.movie_id>1226901) AND (movie_companies.company_id<=>2010 OR movie_companies.company_id>2010) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>4316710 OR movie_keyword.id<4316710) OR (movie_keyword.movie_id<=>3896601 OR movie_keyword.movie_id<3896601) AND (movie_keyword.keyword_id<=>177251 OR movie_keyword.keyword_id<177251)) AND ((name.id<=>2626173 OR name.id<2626173) OR (name.name<=>\"Yamane, Koji\" OR name.name<\"Yamane, Koji\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"m\" OR name.gender>\"m\") OR (name.name_pcode_cf<=>\"Y52\" OR name.name_pcode_cf<\"Y52\") AND (name.name_pcode_nf<=>\"K25\" OR name.name_pcode_nf>\"K25\") OR (name.surname_pcode<=>\"Y5\" OR name.surname_pcode<\"Y5\") AND (name.md5sum<=>\"a22578114d00bef24ec4104d298b8b72\" OR name.md5sum<\"a22578114d00bef24ec4104d298b8b72\")) LIMIT 100" query id=11.sql [mysql] 2020/07/21 11:21:27 packets.go:36: unexpected EOF time="2020-07-21T11:21:27+08:00" level=warning msg="Occurs an error when benching one query" err="invalid connection" time="2020-07-21T11:23:27+08:00" level=info msg="complete plan collection" plan space size=2 query="SELECT * FROM char_name WHERE ((char_name.id<=>3777407 OR char_name.id>3777407) OR (char_name.name<=>\"Burqua Woman One\" OR char_name.name>\"Burqua Woman One\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"B625\" OR char_name.name_pcode_nf>\"B625\") AND (char_name.surname_pcode<=>\"O5\" OR char_name.surname_pcode<\"O5\") AND (char_name.md5sum<=>\"a5d1f0d01bf3d9bec55ed09918652b57\" OR char_name.md5sum<\"a5d1f0d01bf3d9bec55ed09918652b57\")) LIMIT 100" query id=12.sql time="2020-07-21T11:23:28+08:00" level=info msg="complete origin query" cost="[167 79 3 4]ms" query="SELECT * FROM char_name WHERE ((char_name.id<=>3777407 OR char_name.id>3777407) OR (char_name.name<=>\"Burqua Woman One\" OR char_name.name>\"Burqua Woman One\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"B625\" OR char_name.name_pcode_nf>\"B625\") AND (char_name.surname_pcode<=>\"O5\" OR char_name.surname_pcode<\"O5\") AND (char_name.md5sum<=>\"a5d1f0d01bf3d9bec55ed09918652b57\" OR char_name.md5sum<\"a5d1f0d01bf3d9bec55ed09918652b57\")) LIMIT 100" query id=12.sql time="2020-07-21T11:23:28+08:00" level=info msg="complete execution plan1" cost="[2 2 3 2]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM char_name WHERE ((char_name.id<=>3777407 OR char_name.id>3777407) OR (char_name.name<=>\"Burqua Woman One\" OR char_name.name>\"Burqua Woman One\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"B625\" OR char_name.name_pcode_nf>\"B625\") AND (char_name.surname_pcode<=>\"O5\" OR char_name.surname_pcode<\"O5\") AND (char_name.md5sum<=>\"a5d1f0d01bf3d9bec55ed09918652b57\" OR char_name.md5sum<\"a5d1f0d01bf3d9bec55ed09918652b57\")) LIMIT 100" query id=12.sql time="2020-07-21T11:23:31+08:00" level=info msg="complete execution plan2" cost="[810 1548 388 382]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM char_name WHERE ((char_name.id<=>3777407 OR char_name.id>3777407) OR (char_name.name<=>\"Burqua Woman One\" OR char_name.name>\"Burqua Woman One\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"B625\" OR char_name.name_pcode_nf>\"B625\") AND (char_name.surname_pcode<=>\"O5\" OR char_name.surname_pcode<\"O5\") AND (char_name.md5sum<=>\"a5d1f0d01bf3d9bec55ed09918652b57\" OR char_name.md5sum<\"a5d1f0d01bf3d9bec55ed09918652b57\")) LIMIT 100" query id=12.sql time="2020-07-21T11:23:31+08:00" level=info msg="Complete a step" cost="[167 79 3 4]" default hints="use_index(@`sel_1` `imdb`.`char_name` )" default plan=1 plan size=2 query="SELECT * FROM char_name WHERE ((char_name.id<=>3777407 OR char_name.id>3777407) OR (char_name.name<=>\"Burqua Woman One\" OR char_name.name>\"Burqua Woman One\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"B625\" OR char_name.name_pcode_nf>\"B625\") AND (char_name.surname_pcode<=>\"O5\" OR char_name.surname_pcode<\"O5\") AND (char_name.md5sum<=>\"a5d1f0d01bf3d9bec55ed09918652b57\" OR char_name.md5sum<\"a5d1f0d01bf3d9bec55ed09918652b57\")) LIMIT 100" query id=12.sql time="2020-07-21T11:23:31+08:00" level=warning msg="Fails to parse, ignore this query" err="line 1 column 210 near \"Costner'' OR aka_name.name > '''Mama A' Costner'') AND (aka_name.name_pcode_cf <=> 'M5235' OR aka_name.name_pcode_cf < 'M5235') AND (aka_name.name_pcode_nf <=> NULL OR aka_name.name_pcode_nf < NULL) AND (aka_name.surname_pcode <=> NULL OR aka_name.surname_pcode < NULL) OR (aka_name.md5sum <=> 'ee52e5862a2d84c9ecdc457b53591d3a' OR aka_name.md5sum > 'ee52e5862a2d84c9ecdc457b53591d3a')) AND ((complete_cast.id <=> 91256 OR complete_cast.id < 91256) OR (complete_cast.movie_id <=> 3465388 OR complete_cast.movie_id > 3465388) OR (complete_cast.subject_id <=> 2 OR complete_cast.subject_id > 2)) AND ((info_type.id <=> 103 OR info_type.id < 103) AND (info_type.info <=> 'copyright holder' OR info_type.info < 'copyright holder')) LIMIT 100;\n\" " query="{13.sql SELECT * FROM aka_name,complete_cast,info_type WHERE ((aka_name.id <=> 185300 OR aka_name.id > 185300) OR (aka_name.person_id <=> 492461 OR aka_name.person_id < 492461) AND (aka_name.name <=> '''Mama A' Costner'' OR aka_name.name > '''Mama A' Costner'') AND (aka_name.name_pcode_cf <=> 'M5235' OR aka_name.name_pcode_cf < 'M5235') AND (aka_name.name_pcode_nf <=> NULL OR aka_name.name_pcode_nf < NULL) AND (aka_name.surname_pcode <=> NULL OR aka_name.surname_pcode < NULL) OR (aka_name.md5sum <=> 'ee52e5862a2d84c9ecdc457b53591d3a' OR aka_name.md5sum > 'ee52e5862a2d84c9ecdc457b53591d3a')) AND ((complete_cast.id <=> 91256 OR complete_cast.id < 91256) OR (complete_cast.movie_id <=> 3465388 OR complete_cast.movie_id > 3465388) OR (complete_cast.subject_id <=> 2 OR complete_cast.subject_id > 2)) AND ((info_type.id <=> 103 OR info_type.id < 103) AND (info_type.info <=> 'copyright holder' OR info_type.info < 'copyright holder')) LIMIT 100;\n}" time="2020-07-21T11:23:31+08:00" level=info msg="complete plan collection" plan space size=12 query="SELECT * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql time="2020-07-21T11:24:07+08:00" level=info msg="complete origin query" cost="[12175 8801 8067 6919]ms" query="SELECT * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql time="2020-07-21T11:24:42+08:00" level=info msg="complete execution plan1" cost="[11363 8378 6769 8715]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql time="2020-07-21T11:25:15+08:00" level=info msg="complete execution plan2" cost="[7944 8010 8016 8519]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql time="2020-07-21T11:25:48+08:00" level=info msg="complete execution plan3" cost="[8700 8323 7704 8363]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql time="2020-07-21T11:26:17+08:00" level=info msg="complete execution plan4" cost="[7867 6669 7585 7350]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql time="2020-07-21T11:26:46+08:00" level=info msg="complete execution plan5" cost="[6952 7396 6979 7399]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql time="2020-07-21T11:27:17+08:00" level=info msg="complete execution plan6" cost="[8621 6627 8716 7229]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM ((movie_companies) JOIN movie_keyword) JOIN name WHERE ((movie_companies.id<=>4154765 OR movie_companies.id>4154765) OR (movie_companies.movie_id<=>3777802 OR movie_companies.movie_id<3777802) AND (movie_companies.company_id<=>45034 OR movie_companies.company_id<45034) OR (movie_companies.company_type_id<=>2 OR movie_companies.company_type_id>2)) AND ((movie_keyword.id<=>2668067 OR movie_keyword.id>2668067) AND (movie_keyword.movie_id<=>3458814 OR movie_keyword.movie_id>3458814) OR (movie_keyword.keyword_id<=>1090 OR movie_keyword.keyword_id>1090)) AND ((name.id<=>3606071 OR name.id<3606071) AND (name.name<=>\"Morita, Kokoro\" OR name.name<\"Morita, Kokoro\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender>\"f\") AND (name.name_pcode_cf<=>\"M6326\" OR name.name_pcode_cf>\"M6326\") AND (name.name_pcode_nf<=>\"K2656\" OR name.name_pcode_nf<\"K2656\") AND (name.surname_pcode<=>\"M63\" OR name.surname_pcode>\"M63\") OR (name.md5sum<=>\"58871054934d2923a137673d0cc1a8b8\" OR name.md5sum<\"58871054934d2923a137673d0cc1a8b8\")) LIMIT 100" query id=14.sql [mysql] 2020/07/21 11:28:40 packets.go:36: unexpected EOF time="2020-07-21T11:28:40+08:00" level=warning msg="Occurs an error when benching one query" err="invalid connection" time="2020-07-21T11:30:40+08:00" level=info msg="complete plan collection" plan space size=6 query="SELECT * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete origin query" cost="[79 1 0 1]ms" query="SELECT * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete execution plan1" cost="[0 0 1 0]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete execution plan2" cost="[0 0 5 0]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete execution plan3" cost="[3 1 0 1]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete execution plan4" cost="[1 1 10 1]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete execution plan5" cost="[0 1 1 1]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete execution plan6" cost="[1 0 0 0]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="Complete a step" cost="[79 1 0 1]" default hints="use_index(@`sel_1` `imdb`.`company_type` )" default plan=0 plan size=6 query="SELECT * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>\"production companies\" OR company_type.kind<\"production companies\")) LIMIT 100" query id=15.sql time="2020-07-21T11:30:40+08:00" level=info msg="complete plan collection" plan space size=6 query="SELECT * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:41+08:00" level=info msg="complete origin query" cost="[205 129 122 124]ms" query="SELECT * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:42+08:00" level=info msg="complete execution plan1" cost="[131 124 123 126]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:42+08:00" level=info msg="complete execution plan2" cost="[117 131 129 127]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:43+08:00" level=info msg="complete execution plan3" cost="[123 133 142 136]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:43+08:00" level=info msg="complete execution plan4" cost="[123 124 120 130]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:44+08:00" level=info msg="complete execution plan5" cost="[123 125 125 124]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:44+08:00" level=info msg="complete execution plan6" cost="[125 125 124 122]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:44+08:00" level=info msg="Complete a step" cost="[205 129 122 124]" default hints="use_index(@`sel_1` `imdb`.`info_type` ), use_index(@`sel_1` `imdb`.`keyword` ), hash_join(@`sel_1` `imdb`.`info_type`)" default plan=0 plan size=6 query="SELECT * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>\"LD quality program\" OR info_type.info<\"LD quality program\")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>\"italian-pilot\" OR keyword.keyword>\"italian-pilot\") AND (keyword.phonetic_code<=>\"I3451\" OR keyword.phonetic_code>\"I3451\")) LIMIT 100" query id=16.sql time="2020-07-21T11:30:44+08:00" level=info msg="complete plan collection" plan space size=2 query="SELECT * FROM (title) JOIN aka_title WHERE ((title.id<=>3740595 OR title.id<3740595) AND (title.title<=>\"Golpe de gracia\" OR title.title>\"Golpe de gracia\") OR (title.kind_id<=>1 OR title.kind_id>1) AND (title.production_year<=>1944 OR title.production_year>1944) AND (title.imdb_id<=>NULL OR title.imdb_id>NULL) AND (title.phonetic_code<=>\"G4132\" OR title.phonetic_code<\"G4132\") OR (title.episode_of_id<=>NULL OR title.episode_of_idNULL OR title.season_nr>NULL) AND (title.episode_nr<=>NULL OR title.episode_nr\"45c5559eaec0b13dbcd6eff31c40853a\" OR title.md5sum>\"45c5559eaec0b13dbcd6eff31c40853a\")) AND ((aka_title.id<=>29276 OR aka_title.id<29276) AND (aka_title.movie_id<=>1767606 OR aka_title.movie_id<1767606) OR (aka_title.title<=>\"Der Tunnel\" OR aka_title.title<\"Der Tunnel\") AND (aka_title.kind_id<=>7 OR aka_title.kind_id<7) AND (aka_title.production_year<=>NULL OR aka_title.production_year>NULL) AND (aka_title.phonetic_code<=>\"T5436\" OR aka_title.phonetic_code<\"T5436\") AND (aka_title.episode_of_id<=>29275 OR aka_title.episode_of_id>29275) AND (aka_title.md5sum<=>\"f783fc3de44089f5bb0ca3719b35b03f\" OR aka_title.md5sum<\"f783fc3de44089f5bb0ca3719b35b03f\")) LIMIT 100" query id=17.sql time="2020-07-21T11:30:50+08:00" level=info msg="complete origin query" cost="[4254 368 511 552]ms" query="SELECT * FROM (title) JOIN aka_title WHERE ((title.id<=>3740595 OR title.id<3740595) AND (title.title<=>\"Golpe de gracia\" OR title.title>\"Golpe de gracia\") OR (title.kind_id<=>1 OR title.kind_id>1) AND (title.production_year<=>1944 OR title.production_year>1944) AND (title.imdb_id<=>NULL OR title.imdb_id>NULL) AND (title.phonetic_code<=>\"G4132\" OR title.phonetic_code<\"G4132\") OR (title.episode_of_id<=>NULL OR title.episode_of_idNULL OR title.season_nr>NULL) AND (title.episode_nr<=>NULL OR title.episode_nr\"45c5559eaec0b13dbcd6eff31c40853a\" OR title.md5sum>\"45c5559eaec0b13dbcd6eff31c40853a\")) AND ((aka_title.id<=>29276 OR aka_title.id<29276) AND (aka_title.movie_id<=>1767606 OR aka_title.movie_id<1767606) OR (aka_title.title<=>\"Der Tunnel\" OR aka_title.title<\"Der Tunnel\") AND (aka_title.kind_id<=>7 OR aka_title.kind_id<7) AND (aka_title.production_year<=>NULL OR aka_title.production_year>NULL) AND (aka_title.phonetic_code<=>\"T5436\" OR aka_title.phonetic_code<\"T5436\") AND (aka_title.episode_of_id<=>29275 OR aka_title.episode_of_id>29275) AND (aka_title.md5sum<=>\"f783fc3de44089f5bb0ca3719b35b03f\" OR aka_title.md5sum<\"f783fc3de44089f5bb0ca3719b35b03f\")) LIMIT 100" query id=17.sql time="2020-07-21T11:31:05+08:00" level=info msg="complete execution plan1" cost="[4859 3760 3408 3670]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM (title) JOIN aka_title WHERE ((title.id<=>3740595 OR title.id<3740595) AND (title.title<=>\"Golpe de gracia\" OR title.title>\"Golpe de gracia\") OR (title.kind_id<=>1 OR title.kind_id>1) AND (title.production_year<=>1944 OR title.production_year>1944) AND (title.imdb_id<=>NULL OR title.imdb_id>NULL) AND (title.phonetic_code<=>\"G4132\" OR title.phonetic_code<\"G4132\") OR (title.episode_of_id<=>NULL OR title.episode_of_idNULL OR title.season_nr>NULL) AND (title.episode_nr<=>NULL OR title.episode_nr\"45c5559eaec0b13dbcd6eff31c40853a\" OR title.md5sum>\"45c5559eaec0b13dbcd6eff31c40853a\")) AND ((aka_title.id<=>29276 OR aka_title.id<29276) AND (aka_title.movie_id<=>1767606 OR aka_title.movie_id<1767606) OR (aka_title.title<=>\"Der Tunnel\" OR aka_title.title<\"Der Tunnel\") AND (aka_title.kind_id<=>7 OR aka_title.kind_id<7) AND (aka_title.production_year<=>NULL OR aka_title.production_year>NULL) AND (aka_title.phonetic_code<=>\"T5436\" OR aka_title.phonetic_code<\"T5436\") AND (aka_title.episode_of_id<=>29275 OR aka_title.episode_of_id>29275) AND (aka_title.md5sum<=>\"f783fc3de44089f5bb0ca3719b35b03f\" OR aka_title.md5sum<\"f783fc3de44089f5bb0ca3719b35b03f\")) LIMIT 100" query id=17.sql time="2020-07-21T11:31:08+08:00" level=info msg="complete execution plan2" cost="[545 450 624 536]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM (title) JOIN aka_title WHERE ((title.id<=>3740595 OR title.id<3740595) AND (title.title<=>\"Golpe de gracia\" OR title.title>\"Golpe de gracia\") OR (title.kind_id<=>1 OR title.kind_id>1) AND (title.production_year<=>1944 OR title.production_year>1944) AND (title.imdb_id<=>NULL OR title.imdb_id>NULL) AND (title.phonetic_code<=>\"G4132\" OR title.phonetic_code<\"G4132\") OR (title.episode_of_id<=>NULL OR title.episode_of_idNULL OR title.season_nr>NULL) AND (title.episode_nr<=>NULL OR title.episode_nr\"45c5559eaec0b13dbcd6eff31c40853a\" OR title.md5sum>\"45c5559eaec0b13dbcd6eff31c40853a\")) AND ((aka_title.id<=>29276 OR aka_title.id<29276) AND (aka_title.movie_id<=>1767606 OR aka_title.movie_id<1767606) OR (aka_title.title<=>\"Der Tunnel\" OR aka_title.title<\"Der Tunnel\") AND (aka_title.kind_id<=>7 OR aka_title.kind_id<7) AND (aka_title.production_year<=>NULL OR aka_title.production_year>NULL) AND (aka_title.phonetic_code<=>\"T5436\" OR aka_title.phonetic_code<\"T5436\") AND (aka_title.episode_of_id<=>29275 OR aka_title.episode_of_id>29275) AND (aka_title.md5sum<=>\"f783fc3de44089f5bb0ca3719b35b03f\" OR aka_title.md5sum<\"f783fc3de44089f5bb0ca3719b35b03f\")) LIMIT 100" query id=17.sql time="2020-07-21T11:31:08+08:00" level=info msg="Complete a step" cost="[4254 368 511 552]" default hints="use_index(@`sel_1` `imdb`.`aka_title` ), use_index(@`sel_1` `imdb`.`title` ), hash_join(@`sel_1` `imdb`.`aka_title`)" default plan=2 plan size=2 query="SELECT * FROM (title) JOIN aka_title WHERE ((title.id<=>3740595 OR title.id<3740595) AND (title.title<=>\"Golpe de gracia\" OR title.title>\"Golpe de gracia\") OR (title.kind_id<=>1 OR title.kind_id>1) AND (title.production_year<=>1944 OR title.production_year>1944) AND (title.imdb_id<=>NULL OR title.imdb_id>NULL) AND (title.phonetic_code<=>\"G4132\" OR title.phonetic_code<\"G4132\") OR (title.episode_of_id<=>NULL OR title.episode_of_idNULL OR title.season_nr>NULL) AND (title.episode_nr<=>NULL OR title.episode_nr\"45c5559eaec0b13dbcd6eff31c40853a\" OR title.md5sum>\"45c5559eaec0b13dbcd6eff31c40853a\")) AND ((aka_title.id<=>29276 OR aka_title.id<29276) AND (aka_title.movie_id<=>1767606 OR aka_title.movie_id<1767606) OR (aka_title.title<=>\"Der Tunnel\" OR aka_title.title<\"Der Tunnel\") AND (aka_title.kind_id<=>7 OR aka_title.kind_id<7) AND (aka_title.production_year<=>NULL OR aka_title.production_year>NULL) AND (aka_title.phonetic_code<=>\"T5436\" OR aka_title.phonetic_code<\"T5436\") AND (aka_title.episode_of_id<=>29275 OR aka_title.episode_of_id>29275) AND (aka_title.md5sum<=>\"f783fc3de44089f5bb0ca3719b35b03f\" OR aka_title.md5sum<\"f783fc3de44089f5bb0ca3719b35b03f\")) LIMIT 100" query id=17.sql time="2020-07-21T11:31:08+08:00" level=info msg="complete plan collection" plan space size=8 query="SELECT * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:31:16+08:00" level=info msg="complete origin query" cost="[3773 1107 1314 1453]ms" query="SELECT * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:31:47+08:00" level=info msg="complete execution plan1" cost="[15092 5247 5425 5525]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:32:08+08:00" level=info msg="complete execution plan2" cost="[5379 5453 5006 4968]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:32:29+08:00" level=info msg="complete execution plan3" cost="[5595 5251 5203 5547]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:32:50+08:00" level=info msg="complete execution plan4" cost="[5227 5459 5277 5239]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:33:12+08:00" level=info msg="complete execution plan5" cost="[5501 5079 5239 5523]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:33:33+08:00" level=info msg="complete execution plan6" cost="[5354 5292 4990 5665]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:33:40+08:00" level=info msg="complete execution plan7" cost="[1483 1443 2039 1725]ms" query="SELECT /*+ NTH_PLAN(7)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:33:45+08:00" level=info msg="complete execution plan8" cost="[1347 1040 1372 1297]ms" query="SELECT /*+ NTH_PLAN(8)*/ * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:33:45+08:00" level=info msg="Complete a step" cost="[3773 1107 1314 1453]" default hints="use_index(@`sel_1` `imdb`.`comp_cast_type` ), use_index(@`sel_1` `imdb`.`company_name` ), hash_join(@`sel_1` `imdb`.`comp_cast_type`), use_index(@`sel_1` `imdb`.`cast_info` ), hash_join(@`sel_1` `imdb`.`cast_info`)" default plan=8 plan size=8 query="SELECT * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>\"complete+verified\" OR comp_cast_type.kind<\"complete+verified\")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>\"Roma Film\" OR company_name.name>\"Roma Film\") AND (company_name.country_code<=>\"[it]\" OR company_name.country_code<\"[it]\") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id\"R5145\" OR company_name.name_pcode_nf>\"R5145\") OR (company_name.name_pcode_sf<=>\"R5145\" OR company_name.name_pcode_sf<\"R5145\") AND (company_name.md5sum<=>\"660bb9a7a6d668394b1e809159a5fcdf\" OR company_name.md5sum>\"660bb9a7a6d668394b1e809159a5fcdf\")) LIMIT 100" query id=18.sql time="2020-07-21T11:33:45+08:00" level=info msg="complete plan collection" plan space size=2 query="SELECT * FROM company_name WHERE ((company_name.id<=>186308 OR company_name.id>186308) AND (company_name.name<=>\"Sundaram Sound Studios\" OR company_name.name>\"Sundaram Sound Studios\") AND (company_name.country_code<=>NULL OR company_name.country_codeNULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"S5365\" OR company_name.name_pcode_nf<\"S5365\") AND (company_name.name_pcode_sf<=>NULL OR company_name.name_pcode_sf\"4dab96f2a3bf6629cef292fd17bdfef2\" OR company_name.md5sum>\"4dab96f2a3bf6629cef292fd17bdfef2\")) LIMIT 100" query id=19.sql time="2020-07-21T11:33:45+08:00" level=info msg="complete origin query" cost="[5 19 11 11]ms" query="SELECT * FROM company_name WHERE ((company_name.id<=>186308 OR company_name.id>186308) AND (company_name.name<=>\"Sundaram Sound Studios\" OR company_name.name>\"Sundaram Sound Studios\") AND (company_name.country_code<=>NULL OR company_name.country_codeNULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"S5365\" OR company_name.name_pcode_nf<\"S5365\") AND (company_name.name_pcode_sf<=>NULL OR company_name.name_pcode_sf\"4dab96f2a3bf6629cef292fd17bdfef2\" OR company_name.md5sum>\"4dab96f2a3bf6629cef292fd17bdfef2\")) LIMIT 100" query id=19.sql time="2020-07-21T11:33:45+08:00" level=info msg="complete execution plan1" cost="[14 12 14 11]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM company_name WHERE ((company_name.id<=>186308 OR company_name.id>186308) AND (company_name.name<=>\"Sundaram Sound Studios\" OR company_name.name>\"Sundaram Sound Studios\") AND (company_name.country_code<=>NULL OR company_name.country_codeNULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"S5365\" OR company_name.name_pcode_nf<\"S5365\") AND (company_name.name_pcode_sf<=>NULL OR company_name.name_pcode_sf\"4dab96f2a3bf6629cef292fd17bdfef2\" OR company_name.md5sum>\"4dab96f2a3bf6629cef292fd17bdfef2\")) LIMIT 100" query id=19.sql time="2020-07-21T11:33:46+08:00" level=info msg="complete execution plan2" cost="[73 199 158 189]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM company_name WHERE ((company_name.id<=>186308 OR company_name.id>186308) AND (company_name.name<=>\"Sundaram Sound Studios\" OR company_name.name>\"Sundaram Sound Studios\") AND (company_name.country_code<=>NULL OR company_name.country_codeNULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"S5365\" OR company_name.name_pcode_nf<\"S5365\") AND (company_name.name_pcode_sf<=>NULL OR company_name.name_pcode_sf\"4dab96f2a3bf6629cef292fd17bdfef2\" OR company_name.md5sum>\"4dab96f2a3bf6629cef292fd17bdfef2\")) LIMIT 100" query id=19.sql time="2020-07-21T11:33:46+08:00" level=info msg="Complete a step" cost="[5 19 11 11]" default hints="use_index(@`sel_1` `imdb`.`company_name` )" default plan=1 plan size=2 query="SELECT * FROM company_name WHERE ((company_name.id<=>186308 OR company_name.id>186308) AND (company_name.name<=>\"Sundaram Sound Studios\" OR company_name.name>\"Sundaram Sound Studios\") AND (company_name.country_code<=>NULL OR company_name.country_codeNULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"S5365\" OR company_name.name_pcode_nf<\"S5365\") AND (company_name.name_pcode_sf<=>NULL OR company_name.name_pcode_sf\"4dab96f2a3bf6629cef292fd17bdfef2\" OR company_name.md5sum>\"4dab96f2a3bf6629cef292fd17bdfef2\")) LIMIT 100" query id=19.sql time="2020-07-21T11:33:46+08:00" level=info msg="complete plan collection" plan space size=8 query="SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:33:53+08:00" level=info msg="complete origin query" cost="[1826 1921 1701 1846]ms" query="SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:00+08:00" level=info msg="complete execution plan1" cost="[1357 2277 1036 2005]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:08+08:00" level=info msg="complete execution plan2" cost="[2112 2025 1763 1887]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:15+08:00" level=info msg="complete execution plan3" cost="[2045 1565 2054 1914]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:22+08:00" level=info msg="complete execution plan4" cost="[1812 1827 1763 1650]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:29+08:00" level=info msg="complete execution plan5" cost="[1916 1522 1698 1865]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:36+08:00" level=info msg="complete execution plan6" cost="[1796 1775 1684 1696]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:45+08:00" level=info msg="complete execution plan7" cost="[2401 2374 2193 2236]ms" query="SELECT /*+ NTH_PLAN(7)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:52+08:00" level=info msg="complete execution plan8" cost="[1707 1595 1460 1579]ms" query="SELECT /*+ NTH_PLAN(8)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:52+08:00" level=info msg="Complete a step" cost="[1826 1921 1701 1846]" default hints="use_index(@`sel_1` `imdb`.`role_type` ), use_index(@`sel_1` `imdb`.`aka_title` ), hash_join(@`sel_1` `imdb`.`role_type`), use_index(@`sel_1` `imdb`.`movie_link` ), hash_join(@`sel_1` `imdb`.`movie_link`)" default plan=0 plan size=8 query="SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>\"Five Bottles of Vodka\" OR aka_title.title<\"Five Bottles of Vodka\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>\"F1342\" OR aka_title.phonetic_code>\"F1342\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>\"8967ac41f4e49966612fe9a32fea51bc\" OR aka_title.md5sum>\"8967ac41f4e49966612fe9a32fea51bc\")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>\"writer\" OR role_type.role<\"writer\")) LIMIT 100" query id=2.sql time="2020-07-21T11:34:52+08:00" level=error msg="may choose a suboptimal plan(1585.25ms < 1823.50ms)" better hints="use_index(@`sel_1` `imdb`.`role_type` ), use_index(@`sel_1` `imdb`.`aka_title` ), hash_join(@`sel_1` `imdb`.`role_type`), use_index(@`sel_1` `imdb`.`movie_link` ), hash_join(@`sel_1` `imdb`.`movie_link`), nth_plan(8)" better plan=8 query id=2.sql time="2020-07-21T11:34:52+08:00" level=warning msg="Fails to parse, ignore this query" err="line 1 column 643 near \"Vincent Youmans' (qv) Performed by 'Walter B. Long' (qv)' OR movie_info.info < '\"Tea for Two\" (uncredited) Music by 'Vincent Youmans' (qv) Performed by 'Walter B. Long' (qv)')) LIMIT 100;\n\" " query="{20.sql SELECT * FROM keyword,kind_type,movie_info WHERE ((keyword.id <=> 226351 OR keyword.id < 226351) AND (keyword.keyword <=> 'the-grove-los-angeles' OR keyword.keyword > 'the-grove-los-angeles') OR (keyword.phonetic_code <=> 'T2614' OR keyword.phonetic_code < 'T2614')) AND ((kind_type.id <=> 8 OR kind_type.id < 8) AND (kind_type.kind <=> 'short' OR kind_type.kind < 'short')) AND ((movie_info.id <=> 1559685 OR movie_info.id > 1559685) OR (movie_info.movie_id <=> 2948203 OR movie_info.movie_id > 2948203) AND (movie_info.info_type_id <=> 14 OR movie_info.info_type_id > 14) OR (movie_info.info <=> '\"Tea for Two\" (uncredited) Music by 'Vincent Youmans' (qv) Performed by 'Walter B. Long' (qv)' OR movie_info.info < '\"Tea for Two\" (uncredited) Music by 'Vincent Youmans' (qv) Performed by 'Walter B. Long' (qv)')) LIMIT 100;\n}" time="2020-07-21T11:34:52+08:00" level=info msg="complete plan collection" plan space size=6 query="SELECT * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:35:16+08:00" level=info msg="complete origin query" cost="[7449 5853 4926 5291]ms" query="SELECT * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:35:37+08:00" level=info msg="complete execution plan1" cost="[5465 4997 5335 5457]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:35:59+08:00" level=info msg="complete execution plan2" cost="[5577 5549 4607 6386]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:36:22+08:00" level=info msg="complete execution plan3" cost="[6472 5696 5489 5339]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:36:32+08:00" level=info msg="complete execution plan4" cost="[3868 2210 2105 1919]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:36:40+08:00" level=info msg="complete execution plan5" cost="[2136 2141 1970 1860]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:36:49+08:00" level=info msg="complete execution plan6" cost="[2459 1942 2063 2407]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:36:49+08:00" level=info msg="Complete a step" cost="[7449 5853 4926 5291]" default hints="use_index(@`sel_1` `imdb`.`name` ), use_index(@`sel_1` `imdb`.`movie_keyword` ), hash_join(@`sel_1` `imdb`.`name`)" default plan=1 plan size=6 query="SELECT * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>\"López, Gaby\" OR name.name<\"López, Gaby\") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>\"f\" OR name.gender<\"f\") AND (name.name_pcode_cf<=>\"L121\" OR name.name_pcode_cf>\"L121\") AND (name.name_pcode_nf<=>\"G1412\" OR name.name_pcode_nf>\"G1412\") AND (name.surname_pcode<=>\"L12\" OR name.surname_pcode<\"L12\") OR (name.md5sum<=>\"14a2e9f03adf9be89fb406fb9e0b4748\" OR name.md5sum<\"14a2e9f03adf9be89fb406fb9e0b4748\")) LIMIT 100" query id=3.sql time="2020-07-21T11:36:49+08:00" level=error msg="may choose a suboptimal plan(2525.50ms < 5879.75ms)" better hints="use_index(@`sel_1` `imdb`.`name` ), use_index(@`sel_1` `imdb`.`movie_keyword` ), hash_join(@`sel_1` `imdb`.`name`), nth_plan(4)" better plan=4 query id=3.sql time="2020-07-21T11:36:49+08:00" level=error msg="may choose a suboptimal plan(2026.75ms < 5879.75ms)" better hints="use_index(@`sel_1` `imdb`.`name` ), use_index(@`sel_1` `imdb`.`movie_keyword` `movie_keyword_movie_id_keyword_id_idx`), hash_join(@`sel_1` `imdb`.`name`), nth_plan(5)" better plan=5 query id=3.sql time="2020-07-21T11:36:49+08:00" level=error msg="may choose a suboptimal plan(2217.75ms < 5879.75ms)" better hints="use_index(@`sel_1` `imdb`.`name` ), use_index(@`sel_1` `imdb`.`movie_keyword` `movie_keyword_keyword_id_movie_id_idx`), hash_join(@`sel_1` `imdb`.`name`), nth_plan(6)" better plan=6 query id=3.sql time="2020-07-21T11:36:49+08:00" level=info msg="complete plan collection" plan space size=2 query="SELECT * FROM (person_info) JOIN aka_name WHERE ((person_info.id<=>3436627 OR person_info.id>3436627) OR (person_info.person_id<=>3910045 OR person_info.person_id<3910045) OR (person_info.info_type_id<=>36 OR person_info.info_type_id<36)) AND ((aka_name.id<=>517606 OR aka_name.id<517606) OR (aka_name.person_id<=>1353499 OR aka_name.person_id<1353499) OR (aka_name.name<=>\"Villarreal, Rosendo Jose Lazo\" OR aka_name.name>\"Villarreal, Rosendo Jose Lazo\") OR (aka_name.name_pcode_cf<=>\"V4646\" OR aka_name.name_pcode_cf>\"V4646\") AND (aka_name.name_pcode_nf<=>\"R2532\" OR aka_name.name_pcode_nf>\"R2532\") OR (aka_name.surname_pcode<=>\"V464\" OR aka_name.surname_pcode>\"V464\") OR (aka_name.md5sum<=>\"4aa8c58bfbc37c1be87580909a3bc63b\" OR aka_name.md5sum>\"4aa8c58bfbc37c1be87580909a3bc63b\")) LIMIT 100" query id=4.sql time="2020-07-21T11:37:04+08:00" level=info msg="complete origin query" cost="[9086 3595 1117 1150]ms" query="SELECT * FROM (person_info) JOIN aka_name WHERE ((person_info.id<=>3436627 OR person_info.id>3436627) OR (person_info.person_id<=>3910045 OR person_info.person_id<3910045) OR (person_info.info_type_id<=>36 OR person_info.info_type_id<36)) AND ((aka_name.id<=>517606 OR aka_name.id<517606) OR (aka_name.person_id<=>1353499 OR aka_name.person_id<1353499) OR (aka_name.name<=>\"Villarreal, Rosendo Jose Lazo\" OR aka_name.name>\"Villarreal, Rosendo Jose Lazo\") OR (aka_name.name_pcode_cf<=>\"V4646\" OR aka_name.name_pcode_cf>\"V4646\") AND (aka_name.name_pcode_nf<=>\"R2532\" OR aka_name.name_pcode_nf>\"R2532\") OR (aka_name.surname_pcode<=>\"V464\" OR aka_name.surname_pcode>\"V464\") OR (aka_name.md5sum<=>\"4aa8c58bfbc37c1be87580909a3bc63b\" OR aka_name.md5sum>\"4aa8c58bfbc37c1be87580909a3bc63b\")) LIMIT 100" query id=4.sql time="2020-07-21T11:37:18+08:00" level=info msg="complete execution plan1" cost="[3388 3214 3677 3256]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM (person_info) JOIN aka_name WHERE ((person_info.id<=>3436627 OR person_info.id>3436627) OR (person_info.person_id<=>3910045 OR person_info.person_id<3910045) OR (person_info.info_type_id<=>36 OR person_info.info_type_id<36)) AND ((aka_name.id<=>517606 OR aka_name.id<517606) OR (aka_name.person_id<=>1353499 OR aka_name.person_id<1353499) OR (aka_name.name<=>\"Villarreal, Rosendo Jose Lazo\" OR aka_name.name>\"Villarreal, Rosendo Jose Lazo\") OR (aka_name.name_pcode_cf<=>\"V4646\" OR aka_name.name_pcode_cf>\"V4646\") AND (aka_name.name_pcode_nf<=>\"R2532\" OR aka_name.name_pcode_nf>\"R2532\") OR (aka_name.surname_pcode<=>\"V464\" OR aka_name.surname_pcode>\"V464\") OR (aka_name.md5sum<=>\"4aa8c58bfbc37c1be87580909a3bc63b\" OR aka_name.md5sum>\"4aa8c58bfbc37c1be87580909a3bc63b\")) LIMIT 100" query id=4.sql time="2020-07-21T11:37:22+08:00" level=info msg="complete execution plan2" cost="[1611 1060 1000 1271]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM (person_info) JOIN aka_name WHERE ((person_info.id<=>3436627 OR person_info.id>3436627) OR (person_info.person_id<=>3910045 OR person_info.person_id<3910045) OR (person_info.info_type_id<=>36 OR person_info.info_type_id<36)) AND ((aka_name.id<=>517606 OR aka_name.id<517606) OR (aka_name.person_id<=>1353499 OR aka_name.person_id<1353499) OR (aka_name.name<=>\"Villarreal, Rosendo Jose Lazo\" OR aka_name.name>\"Villarreal, Rosendo Jose Lazo\") OR (aka_name.name_pcode_cf<=>\"V4646\" OR aka_name.name_pcode_cf>\"V4646\") AND (aka_name.name_pcode_nf<=>\"R2532\" OR aka_name.name_pcode_nf>\"R2532\") OR (aka_name.surname_pcode<=>\"V464\" OR aka_name.surname_pcode>\"V464\") OR (aka_name.md5sum<=>\"4aa8c58bfbc37c1be87580909a3bc63b\" OR aka_name.md5sum>\"4aa8c58bfbc37c1be87580909a3bc63b\")) LIMIT 100" query id=4.sql time="2020-07-21T11:37:22+08:00" level=info msg="Complete a step" cost="[9086 3595 1117 1150]" default hints="use_index(@`sel_1` `imdb`.`aka_name` ), use_index(@`sel_1` `imdb`.`person_info` ), hash_join(@`sel_1` `imdb`.`aka_name`)" default plan=2 plan size=2 query="SELECT * FROM (person_info) JOIN aka_name WHERE ((person_info.id<=>3436627 OR person_info.id>3436627) OR (person_info.person_id<=>3910045 OR person_info.person_id<3910045) OR (person_info.info_type_id<=>36 OR person_info.info_type_id<36)) AND ((aka_name.id<=>517606 OR aka_name.id<517606) OR (aka_name.person_id<=>1353499 OR aka_name.person_id<1353499) OR (aka_name.name<=>\"Villarreal, Rosendo Jose Lazo\" OR aka_name.name>\"Villarreal, Rosendo Jose Lazo\") OR (aka_name.name_pcode_cf<=>\"V4646\" OR aka_name.name_pcode_cf>\"V4646\") AND (aka_name.name_pcode_nf<=>\"R2532\" OR aka_name.name_pcode_nf>\"R2532\") OR (aka_name.surname_pcode<=>\"V464\" OR aka_name.surname_pcode>\"V464\") OR (aka_name.md5sum<=>\"4aa8c58bfbc37c1be87580909a3bc63b\" OR aka_name.md5sum>\"4aa8c58bfbc37c1be87580909a3bc63b\")) LIMIT 100" query id=4.sql time="2020-07-21T11:37:23+08:00" level=info msg="complete plan collection" plan space size=6 query="SELECT * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:25+08:00" level=info msg="complete origin query" cost="[542 1469 326 347]ms" query="SELECT * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:31+08:00" level=info msg="complete execution plan1" cost="[3012 1002 962 946]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:35+08:00" level=info msg="complete execution plan2" cost="[936 989 963 987]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:39+08:00" level=info msg="complete execution plan3" cost="[994 1005 962 1005]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:40+08:00" level=info msg="complete execution plan4" cost="[122 362 345 346]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:42+08:00" level=info msg="complete execution plan5" cost="[389 366 345 396]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:43+08:00" level=info msg="complete execution plan6" cost="[349 333 357 365]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:43+08:00" level=info msg="Complete a step" cost="[542 1469 326 347]" default hints="use_index(@`sel_1` `imdb`.`company_type` ), use_index(@`sel_1` `imdb`.`char_name` ), hash_join(@`sel_1` `imdb`.`company_type`)" default plan=0 plan size=6 query="SELECT * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>\"Terrance - Bartender\" OR char_name.name>\"Terrance - Bartender\") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id\"T6521\" OR char_name.name_pcode_nf<\"T6521\") AND (char_name.surname_pcode<=>\"B6353\" OR char_name.surname_pcode>\"B6353\") AND (char_name.md5sum<=>\"734c7f358a22c8c0ead0873ac1cb2f4b\" OR char_name.md5sum<\"734c7f358a22c8c0ead0873ac1cb2f4b\")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>\"production companies\" OR company_type.kind>\"production companies\")) LIMIT 100" query id=5.sql time="2020-07-21T11:37:44+08:00" level=info msg="complete plan collection" plan space size=12 query="SELECT * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql time="2020-07-21T11:38:01+08:00" level=info msg="complete origin query" cost="[3838 4405 4883 3902]ms" query="SELECT * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql time="2020-07-21T11:38:32+08:00" level=info msg="complete execution plan1" cost="[7976 7652 7795 7569]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql time="2020-07-21T11:39:00+08:00" level=info msg="complete execution plan2" cost="[6883 7688 6302 7493]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql time="2020-07-21T11:39:29+08:00" level=info msg="complete execution plan3" cost="[7506 7561 7360 6821]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql time="2020-07-21T11:39:49+08:00" level=info msg="complete execution plan4" cost="[5256 3680 5753 4666]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql time="2020-07-21T11:40:08+08:00" level=info msg="complete execution plan5" cost="[4578 5201 5136 4890]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql time="2020-07-21T11:40:28+08:00" level=info msg="complete execution plan6" cost="[4566 5554 4746 4835]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM ((company_name) JOIN movie_companies) JOIN movie_keyword WHERE ((company_name.id<=>356262 OR company_name.id>356262) AND (company_name.name<=>\"Floating Train Productions\" OR company_name.name<\"Floating Train Productions\") OR (company_name.country_code<=>\"[us]\" OR company_name.country_code<\"[us]\") OR (company_name.imdb_id<=>NULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>\"F4352\" OR company_name.name_pcode_nf<\"F4352\") AND (company_name.name_pcode_sf<=>\"F4352\" OR company_name.name_pcode_sf>\"F4352\") AND (company_name.md5sum<=>\"35c1f47f016313f37230e779e3e8a968\" OR company_name.md5sum<\"35c1f47f016313f37230e779e3e8a968\")) AND ((movie_companies.id<=>1145731 OR movie_companies.id<1145731) AND (movie_companies.movie_id<=>3721414 OR movie_companies.movie_id<3721414) OR (movie_companies.company_id<=>246 OR movie_companies.company_id<246) OR (movie_companies.company_type_id<=>1 OR movie_companies.company_type_id>1)) AND ((movie_keyword.id<=>6341246 OR movie_keyword.id>6341246) OR (movie_keyword.movie_id<=>4417278 OR movie_keyword.movie_id<4417278) AND (movie_keyword.keyword_id<=>1646 OR movie_keyword.keyword_id>1646)) LIMIT 100" query id=6.sql [mysql] 2020/07/21 11:42:01 packets.go:36: unexpected EOF time="2020-07-21T11:42:01+08:00" level=warning msg="Occurs an error when benching one query" err="invalid connection" time="2020-07-21T11:44:01+08:00" level=info msg="complete plan collection" plan space size=2 query="SELECT * FROM name WHERE ((name.id<=>2460520 OR name.id>2460520) OR (name.name<=>\"van Braam, Remmert\" OR name.name>\"van Braam, Remmert\") OR (name.imdb_id<=>NULL OR name.imdb_id\"m\" OR name.gender>\"m\") AND (name.name_pcode_cf<=>\"V5165\" OR name.name_pcode_cf<\"V5165\") AND (name.name_pcode_nf<=>\"R5631\" OR name.name_pcode_nf>\"R5631\") OR (name.surname_pcode<=>NULL OR name.surname_pcode\"ef296cc36f28056e5b7c843a7969cdc4\" OR name.md5sum>\"ef296cc36f28056e5b7c843a7969cdc4\")) LIMIT 100" query id=7.sql time="2020-07-21T11:44:02+08:00" level=info msg="complete origin query" cost="[34 13 9 9]ms" query="SELECT * FROM name WHERE ((name.id<=>2460520 OR name.id>2460520) OR (name.name<=>\"van Braam, Remmert\" OR name.name>\"van Braam, Remmert\") OR (name.imdb_id<=>NULL OR name.imdb_id\"m\" OR name.gender>\"m\") AND (name.name_pcode_cf<=>\"V5165\" OR name.name_pcode_cf<\"V5165\") AND (name.name_pcode_nf<=>\"R5631\" OR name.name_pcode_nf>\"R5631\") OR (name.surname_pcode<=>NULL OR name.surname_pcode\"ef296cc36f28056e5b7c843a7969cdc4\" OR name.md5sum>\"ef296cc36f28056e5b7c843a7969cdc4\")) LIMIT 100" query id=7.sql time="2020-07-21T11:44:02+08:00" level=info msg="complete execution plan1" cost="[3 5 7 6]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM name WHERE ((name.id<=>2460520 OR name.id>2460520) OR (name.name<=>\"van Braam, Remmert\" OR name.name>\"van Braam, Remmert\") OR (name.imdb_id<=>NULL OR name.imdb_id\"m\" OR name.gender>\"m\") AND (name.name_pcode_cf<=>\"V5165\" OR name.name_pcode_cf<\"V5165\") AND (name.name_pcode_nf<=>\"R5631\" OR name.name_pcode_nf>\"R5631\") OR (name.surname_pcode<=>NULL OR name.surname_pcode\"ef296cc36f28056e5b7c843a7969cdc4\" OR name.md5sum>\"ef296cc36f28056e5b7c843a7969cdc4\")) LIMIT 100" query id=7.sql time="2020-07-21T11:44:03+08:00" level=info msg="complete execution plan2" cost="[34 1223 271 300]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM name WHERE ((name.id<=>2460520 OR name.id>2460520) OR (name.name<=>\"van Braam, Remmert\" OR name.name>\"van Braam, Remmert\") OR (name.imdb_id<=>NULL OR name.imdb_id\"m\" OR name.gender>\"m\") AND (name.name_pcode_cf<=>\"V5165\" OR name.name_pcode_cf<\"V5165\") AND (name.name_pcode_nf<=>\"R5631\" OR name.name_pcode_nf>\"R5631\") OR (name.surname_pcode<=>NULL OR name.surname_pcode\"ef296cc36f28056e5b7c843a7969cdc4\" OR name.md5sum>\"ef296cc36f28056e5b7c843a7969cdc4\")) LIMIT 100" query id=7.sql time="2020-07-21T11:44:03+08:00" level=info msg="Complete a step" cost="[34 13 9 9]" default hints="use_index(@`sel_1` `imdb`.`name` )" default plan=1 plan size=2 query="SELECT * FROM name WHERE ((name.id<=>2460520 OR name.id>2460520) OR (name.name<=>\"van Braam, Remmert\" OR name.name>\"van Braam, Remmert\") OR (name.imdb_id<=>NULL OR name.imdb_id\"m\" OR name.gender>\"m\") AND (name.name_pcode_cf<=>\"V5165\" OR name.name_pcode_cf<\"V5165\") AND (name.name_pcode_nf<=>\"R5631\" OR name.name_pcode_nf>\"R5631\") OR (name.surname_pcode<=>NULL OR name.surname_pcode\"ef296cc36f28056e5b7c843a7969cdc4\" OR name.md5sum>\"ef296cc36f28056e5b7c843a7969cdc4\")) LIMIT 100" query id=7.sql time="2020-07-21T11:44:04+08:00" level=info msg="complete plan collection" plan space size=8 query="SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:06+08:00" level=info msg="complete origin query" cost="[1163 334 346 293]ms" query="SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:08+08:00" level=info msg="complete execution plan1" cost="[483 525 522 478]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:10+08:00" level=info msg="complete execution plan2" cost="[448 444 496 473]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:12+08:00" level=info msg="complete execution plan3" cost="[406 455 520 471]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:13+08:00" level=info msg="complete execution plan4" cost="[287 409 355 357]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:14+08:00" level=info msg="complete execution plan5" cost="[353 354 334 343]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:16+08:00" level=info msg="complete execution plan6" cost="[357 329 316 350]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:22+08:00" level=info msg="complete execution plan7" cost="[1446 1832 1669 1659]ms" query="SELECT /*+ NTH_PLAN(7)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:27+08:00" level=info msg="complete execution plan8" cost="[1178 1196 1055 1275]ms" query="SELECT /*+ NTH_PLAN(8)*/ * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:27+08:00" level=info msg="Complete a step" cost="[1163 334 346 293]" default hints="use_index(@`sel_1` `imdb`.`role_type` ), use_index(@`sel_1` `imdb`.`aka_title` ), hash_join(@`sel_1` `imdb`.`role_type`), use_index(@`sel_1` `imdb`.`movie_link` ), hash_join(@`sel_1` `imdb`.`movie_link`)" default plan=0 plan size=8 query="SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>\"Night and Day\" OR aka_title.title<\"Night and Day\") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>\"N2353\" OR aka_title.phonetic_code<\"N2353\") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id\"993f6b7dcb7a46e7ca506c88b439363a\" OR aka_title.md5sum>\"993f6b7dcb7a46e7ca506c88b439363a\")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>\"editor\" OR role_type.role>\"editor\")) LIMIT 100" query id=8.sql time="2020-07-21T11:44:27+08:00" level=info msg="complete plan collection" plan space size=6 query="SELECT * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:28+08:00" level=info msg="complete origin query" cost="[21 127 151 139]ms" query="SELECT * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:30+08:00" level=info msg="complete execution plan1" cost="[587 439 439 444]ms" query="SELECT /*+ NTH_PLAN(1)*/ * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:31+08:00" level=info msg="complete execution plan2" cost="[444 460 427 459]ms" query="SELECT /*+ NTH_PLAN(2)*/ * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:33+08:00" level=info msg="complete execution plan3" cost="[423 423 441 449]ms" query="SELECT /*+ NTH_PLAN(3)*/ * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:34+08:00" level=info msg="complete execution plan4" cost="[14 164 152 120]ms" query="SELECT /*+ NTH_PLAN(4)*/ * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:34+08:00" level=info msg="complete execution plan5" cost="[162 148 145 149]ms" query="SELECT /*+ NTH_PLAN(5)*/ * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:35+08:00" level=info msg="complete execution plan6" cost="[133 167 135 154]ms" query="SELECT /*+ NTH_PLAN(6)*/ * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql time="2020-07-21T11:44:35+08:00" level=info msg="Complete a step" cost="[21 127 151 139]" default hints="use_index(@`sel_1` `imdb`.`role_type` ), use_index(@`sel_1` `imdb`.`movie_link` ), hash_join(@`sel_1` `imdb`.`role_type`)" default plan=0 plan size=6 query="SELECT * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>\"writer\" OR role_type.role>\"writer\")) LIMIT 100" query id=9.sql +--------+-------------+------------------------+--------------------------+---------------+-------------------------------+--------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ID | #PLAN SPACE | DEFAULT EXECUTION TIME | BEST PLAN EXECUTION TIME | EFFECTIVENESS | BETTER OPTIMAL PLANS | ESTROW Q-ERROR | QUERY | +--------+-------------+------------------------+--------------------------+---------------+-------------------------------+--------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1.sql | 2 | 623.0ms ±25% | 401.8ms ±30% | 50.0% | #1(64.5%) | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM (aka_title) JOIN movie_link WHERE ((aka_title.id<=>242091 OR aka_title.id>242091) AND (aka_title.movie_id<=>3865448 OR aka_title.movie_id>3865448) OR (aka_title.title<=>"Golden jade slave" OR aka_title.title<"Golden jade slave") OR (aka_title.kind_id<=>1 OR aka_title.kind_id>1) OR (aka_title.production_year<=>1962 OR aka_title.production_year>1962) OR (aka_title.phonetic_code<=>"G4352" OR aka_title.phonetic_code<"G4352") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id"0422d64139af699bceac3265e154fe04" OR aka_title.md5sum>"0422d64139af699bceac3265e154fe04")) AND ((movie_link.id<=>1996389 OR movie_link.id>1996389) AND (movie_link.movie_id<=>4352804 OR movie_link.movie_id>4352804) AND (movie_link.linked_movie_id<=>4352801 OR movie_link.linked_movie_id<4352801) AND (movie_link.link_type_id<=>1 OR movie_link.link_type_id>1)) LIMIT 100 | | 10.sql | 6 | 1.2ms ±100% | 1.2ms ±100% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM comp_cast_type WHERE ((comp_cast_type.id<=>2 OR comp_cast_type.id>2) OR (comp_cast_type.kind<=>"crew" OR comp_cast_type.kind>"crew")) LIMIT 100 | | 12.sql | 2 | 63.2ms ±5467% | 63.2ms ±5467% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM char_name WHERE ((char_name.id<=>3777407 OR char_name.id>3777407) OR (char_name.name<=>"Burqua Woman One" OR char_name.name>"Burqua Woman One") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id"B625" OR char_name.name_pcode_nf>"B625") AND (char_name.surname_pcode<=>"O5" OR char_name.surname_pcode<"O5") AND (char_name.md5sum<=>"a5d1f0d01bf3d9bec55ed09918652b57" OR char_name.md5sum<"a5d1f0d01bf3d9bec55ed09918652b57")) LIMIT 100 | | 15.sql | 6 | 20.2ms ±+Inf% | 20.2ms ±+Inf% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM company_type WHERE ((company_type.id<=>2 OR company_type.id>2) AND (company_type.kind<=>"production companies" OR company_type.kind<"production companies")) LIMIT 100 | | 16.sql | 6 | 145.0ms ±68% | 145.0ms ±68% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM (info_type) JOIN keyword WHERE ((info_type.id<=>63 OR info_type.id>63) OR (info_type.info<=>"LD quality program" OR info_type.info<"LD quality program")) AND ((keyword.id<=>235260 OR keyword.id>235260) AND (keyword.keyword<=>"italian-pilot" OR keyword.keyword>"italian-pilot") AND (keyword.phonetic_code<=>"I3451" OR keyword.phonetic_code>"I3451")) LIMIT 100 | | 17.sql | 2 | 1421.2ms ±1056% | 1421.2ms ±1056% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM (title) JOIN aka_title WHERE ((title.id<=>3740595 OR title.id<3740595) AND (title.title<=>"Golpe de gracia" OR title.title>"Golpe de gracia") OR (title.kind_id<=>1 OR title.kind_id>1) AND (title.production_year<=>1944 OR title.production_year>1944) AND (title.imdb_id<=>NULL OR title.imdb_id>NULL) AND (title.phonetic_code<=>"G4132" OR title.phonetic_code<"G4132") OR (title.episode_of_id<=>NULL OR title.episode_of_idNULL OR title.season_nr>NULL) AND (title.episode_nr<=>NULL OR title.episode_nr"45c5559eaec0b13dbcd6eff31c40853a" OR title.md5sum>"45c5559eaec0b13dbcd6eff31c40853a")) AND ((aka_title.id<=>29276 OR aka_title.id<29276) AND (aka_title.movie_id<=>1767606 OR aka_title.movie_id<1767606) OR (aka_title.title<=>"Der Tunnel" OR aka_title.title<"Der Tunnel") AND (aka_title.kind_id<=>7 OR aka_title.kind_id<7) AND (aka_title.production_year<=>NULL OR aka_title.production_year>NULL) AND (aka_title.phonetic_code<=>"T5436" OR aka_title.phonetic_code<"T5436") AND (aka_title.episode_of_id<=>29275 OR aka_title.episode_of_id>29275) AND (aka_title.md5sum<=>"f783fc3de44089f5bb0ca3719b35b03f" OR aka_title.md5sum<"f783fc3de44089f5bb0ca3719b35b03f")) LIMIT 100 | | 18.sql | 8 | 1911.8ms ±241% | 1911.8ms ±241% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM ((cast_info) JOIN comp_cast_type) JOIN company_name WHERE ((cast_info.id<=>1244604 OR cast_info.id<1244604) OR (cast_info.person_id<=>163171 OR cast_info.person_id<163171) AND (cast_info.movie_id<=>1172718 OR cast_info.movie_id<1172718) AND (cast_info.person_role_id<=>29785 OR cast_info.person_role_id<29785) AND (cast_info.role_id<=>1 OR cast_info.role_id>1)) AND ((comp_cast_type.id<=>4 OR comp_cast_type.id<4) OR (comp_cast_type.kind<=>"complete+verified" OR comp_cast_type.kind<"complete+verified")) AND ((company_name.id<=>69993 OR company_name.id>69993) OR (company_name.name<=>"Roma Film" OR company_name.name>"Roma Film") AND (company_name.country_code<=>"[it]" OR company_name.country_code<"[it]") AND (company_name.imdb_id<=>NULL OR company_name.imdb_id"R5145" OR company_name.name_pcode_nf>"R5145") OR (company_name.name_pcode_sf<=>"R5145" OR company_name.name_pcode_sf<"R5145") AND (company_name.md5sum<=>"660bb9a7a6d668394b1e809159a5fcdf" OR company_name.md5sum>"660bb9a7a6d668394b1e809159a5fcdf")) LIMIT 100 | | 19.sql | 2 | 11.5ms ±280% | 11.5ms ±280% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM company_name WHERE ((company_name.id<=>186308 OR company_name.id>186308) AND (company_name.name<=>"Sundaram Sound Studios" OR company_name.name>"Sundaram Sound Studios") AND (company_name.country_code<=>NULL OR company_name.country_codeNULL OR company_name.imdb_id>NULL) OR (company_name.name_pcode_nf<=>"S5365" OR company_name.name_pcode_nf<"S5365") AND (company_name.name_pcode_sf<=>NULL OR company_name.name_pcode_sf"4dab96f2a3bf6629cef292fd17bdfef2" OR company_name.md5sum>"4dab96f2a3bf6629cef292fd17bdfef2")) LIMIT 100 | | 2.sql | 8 | 1823.5ms ±13% | 1585.2ms ±17% | 87.5% | #8(86.9%) | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>376255 OR aka_title.id>376255) AND (aka_title.movie_id<=>4214852 OR aka_title.movie_id<4214852) OR (aka_title.title<=>"Five Bottles of Vodka" OR aka_title.title<"Five Bottles of Vodka") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2001 OR aka_title.production_year<2001) OR (aka_title.phonetic_code<=>"F1342" OR aka_title.phonetic_code>"F1342") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id>NULL) AND (aka_title.md5sum<=>"8967ac41f4e49966612fe9a32fea51bc" OR aka_title.md5sum>"8967ac41f4e49966612fe9a32fea51bc")) AND ((movie_link.id<=>553749 OR movie_link.id>553749) OR (movie_link.movie_id<=>2796348 OR movie_link.movie_id>2796348) OR (movie_link.linked_movie_id<=>3801095 OR movie_link.linked_movie_id>3801095) OR (movie_link.link_type_id<=>5 OR movie_link.link_type_id<5)) AND ((role_type.id<=>4 OR role_type.id<4) AND (role_type.role<=>"writer" OR role_type.role<"writer")) LIMIT 100 | | 3.sql | 6 | 5879.8ms ±51% | 2026.8ms ±15% | 50.0% | #4(43.0%),#5(34.5%),#6(37.7%) | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM (movie_keyword) JOIN name WHERE ((movie_keyword.id<=>2737256 OR movie_keyword.id>2737256) AND (movie_keyword.movie_id<=>3516666 OR movie_keyword.movie_id>3516666) OR (movie_keyword.keyword_id<=>48502 OR movie_keyword.keyword_id<48502)) AND ((name.id<=>3485090 OR name.id>3485090) AND (name.name<=>"López, Gaby" OR name.name<"López, Gaby") OR (name.imdb_id<=>NULL OR name.imdb_id>NULL) AND (name.gender<=>"f" OR name.gender<"f") AND (name.name_pcode_cf<=>"L121" OR name.name_pcode_cf>"L121") AND (name.name_pcode_nf<=>"G1412" OR name.name_pcode_nf>"G1412") AND (name.surname_pcode<=>"L12" OR name.surname_pcode<"L12") OR (name.md5sum<=>"14a2e9f03adf9be89fb406fb9e0b4748" OR name.md5sum<"14a2e9f03adf9be89fb406fb9e0b4748")) LIMIT 100 | | 4.sql | 2 | 3737.0ms ±713% | 3737.0ms ±713% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM (person_info) JOIN aka_name WHERE ((person_info.id<=>3436627 OR person_info.id>3436627) OR (person_info.person_id<=>3910045 OR person_info.person_id<3910045) OR (person_info.info_type_id<=>36 OR person_info.info_type_id<36)) AND ((aka_name.id<=>517606 OR aka_name.id<517606) OR (aka_name.person_id<=>1353499 OR aka_name.person_id<1353499) OR (aka_name.name<=>"Villarreal, Rosendo Jose Lazo" OR aka_name.name>"Villarreal, Rosendo Jose Lazo") OR (aka_name.name_pcode_cf<=>"V4646" OR aka_name.name_pcode_cf>"V4646") AND (aka_name.name_pcode_nf<=>"R2532" OR aka_name.name_pcode_nf>"R2532") OR (aka_name.surname_pcode<=>"V464" OR aka_name.surname_pcode>"V464") OR (aka_name.md5sum<=>"4aa8c58bfbc37c1be87580909a3bc63b" OR aka_name.md5sum>"4aa8c58bfbc37c1be87580909a3bc63b")) LIMIT 100 | | 5.sql | 6 | 671.0ms ±351% | 671.0ms ±351% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM (char_name) JOIN company_type WHERE ((char_name.id<=>1008911 OR char_name.id>1008911) OR (char_name.name<=>"Terrance - Bartender" OR char_name.name>"Terrance - Bartender") AND (char_name.imdb_id<=>NULL OR char_name.imdb_id"T6521" OR char_name.name_pcode_nf<"T6521") AND (char_name.surname_pcode<=>"B6353" OR char_name.surname_pcode>"B6353") AND (char_name.md5sum<=>"734c7f358a22c8c0ead0873ac1cb2f4b" OR char_name.md5sum<"734c7f358a22c8c0ead0873ac1cb2f4b")) AND ((company_type.id<=>2 OR company_type.id<2) OR (company_type.kind<=>"production companies" OR company_type.kind>"production companies")) LIMIT 100 | | 7.sql | 2 | 16.2ms ±278% | 16.2ms ±278% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM name WHERE ((name.id<=>2460520 OR name.id>2460520) OR (name.name<=>"van Braam, Remmert" OR name.name>"van Braam, Remmert") OR (name.imdb_id<=>NULL OR name.imdb_id"m" OR name.gender>"m") AND (name.name_pcode_cf<=>"V5165" OR name.name_pcode_cf<"V5165") AND (name.name_pcode_nf<=>"R5631" OR name.name_pcode_nf>"R5631") OR (name.surname_pcode<=>NULL OR name.surname_pcode"ef296cc36f28056e5b7c843a7969cdc4" OR name.md5sum>"ef296cc36f28056e5b7c843a7969cdc4")) LIMIT 100 | | 8.sql | 8 | 534.0ms ±297% | 534.0ms ±297% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM ((aka_title) JOIN movie_link) JOIN role_type WHERE ((aka_title.id<=>91361 OR aka_title.id<91361) AND (aka_title.movie_id<=>3406062 OR aka_title.movie_id>3406062) OR (aka_title.title<=>"Night and Day" OR aka_title.title<"Night and Day") OR (aka_title.kind_id<=>1 OR aka_title.kind_id<1) AND (aka_title.production_year<=>2008 OR aka_title.production_year>2008) AND (aka_title.phonetic_code<=>"N2353" OR aka_title.phonetic_code<"N2353") AND (aka_title.episode_of_id<=>NULL OR aka_title.episode_of_id"993f6b7dcb7a46e7ca506c88b439363a" OR aka_title.md5sum>"993f6b7dcb7a46e7ca506c88b439363a")) AND ((movie_link.id<=>2256672 OR movie_link.id<2256672) AND (movie_link.movie_id<=>4486955 OR movie_link.movie_id<4486955) AND (movie_link.linked_movie_id<=>4213373 OR movie_link.linked_movie_id>4213373) AND (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>9 OR role_type.id<9) AND (role_type.role<=>"editor" OR role_type.role>"editor")) LIMIT 100 | | 9.sql | 6 | 109.5ms ±619% | 109.5ms ±619% | 100.0% | | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT * FROM (movie_link) JOIN role_type WHERE ((movie_link.id<=>1671761 OR movie_link.id>1671761) OR (movie_link.movie_id<=>4111422 OR movie_link.movie_id<4111422) AND (movie_link.linked_movie_id<=>4111424 OR movie_link.linked_movie_id<4111424) OR (movie_link.link_type_id<=>2 OR movie_link.link_type_id<2)) AND ((role_type.id<=>4 OR role_type.id>4) AND (role_type.role<=>"writer" OR role_type.role>"writer")) LIMIT 100 | +--------+-------------+------------------------+--------------------------+---------------+-------------------------------+--------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+