语义搜索
来自戏曲百科
Debug output SQLStore
ASK Query
[[演员等级::国家一级演员]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=12683 AND t1.o_id=12684)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
100
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=12683 AND t1.o_id=12684)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
100
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, s_id_3, s_id_2, o_id, o_id_3, o_id_2, p_id | o_id | 5 | const | 133 | 0.04 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_iw, smw_iw_2, smw_id | PRIMARY | 4 | wiki66.t1.s_id | 1 | 50.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None- 蔡正仁#演员信息框(昆剧演员)
- 袁国良#演员信息框(昆剧演员)
- 袁慧琴#演员信息框(京剧演员)
- 裘婷羽#演员信息框(越剧演员)
- 计镇华#演员信息框(昆剧演员)
- 许荷英#演员信息框(河北梆子演员)
- 谢群英#演员信息框(越剧演员)
- 谷文月#演员信息框(评剧演员)
- 贾文龙#演员信息框(豫剧演员)
- 赵于涛#演员信息框(昆剧演员)
- 赵志刚#演员信息框(越剧演员)
- 赵秀君#演员信息框(京剧演员)
- 赵秀治#演员信息框(绍剧演员)
- 迟小秋#演员信息框
- 邢险峰#演员信息框(花鼓戏演员)
- 郑惠兵#演员信息框(歌仔戏演员)
- 郑芳芳#演员信息框(晋剧演员)
- 郭泽民#演员信息框(蒲剧演员)
- 金不换(豫剧演员)#演员信息框(豫剧演员)
- 陈媛#演员信息框(柳子戏演员)
- 陈少云#演员信息框(京剧演员)
- 陈巧茹#演员信息框(川剧演员)
- 陈晓红(越剧演员)#演员信息框(越剧演员)
- 陈湜#演员信息框(越剧演员)
- 陈美兰#演员信息框(婺剧演员)
- 陈辉玲#演员信息框(越剧演员)
- 韦小兵#演员信息框(秦腔演员)
- 顾亮#演员信息框(京剧演员)
- 高桂枝#演员信息框(曲剧演员)
- 高闯#演员信息框(评剧演员)
- 魏春芳#演员信息框(越剧演员)
- 黄新德#演员信息框(黄梅戏演员)
- 黄齐峰#演员信息框(京剧演员)