Wyszukiwanie semantyczne
Z Nondanych
Debug output SQLStore
ASK Query
[[Istnieje jako strona Gry::prawda]] [[Linkuje do::Gra:Strona 85]]
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_bool` AS t2
INNER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`t5` AS t5 ON t4.p_id=t5.id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_value=1) AND t2.p_id=527
AND (t4.o_id=535)
)
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
50
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_bool` AS t2
INNER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`t5` AS t5 ON t4.p_id=t5.id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_value=1) AND t2.p_id=527
AND (t4.o_id=535)
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t5 | ALL | PRIMARY | 3 | Using temporary; Using filesort | ||||
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, nondane.t5.id | 2 | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | nondane.t4.s_id | 1 | Using where | |
1 | SIMPLE | t2 | ref | s_id, o_value | s_id | 8 | nondane.t4.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
- Temporary table t5
Recursively computed hierarchy for element(s) (513).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=513 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneStrona | Data utworzenia strony |
---|---|
Strona 5.3 | 2010-04-17 17:21 |
Strona 06 | 2010-01-22 14:06 |
Strona 008,11 | 2008-08-24 17:34 |
Strona 8O | 2011-05-30 18:20 |
Strona 10,102 | 2008-08-02 18:38 |
Strona 10.0 | 2008-04-01 20:30 |
Strona 11,67 | 2009-03-10 17:24 |
Strona 12.9 | 2010-01-04 18:26 |
Strona 18,5 | 2010-08-20 18:49 |
Strona 33.1 | 2009-02-07 09:29 |
Strona 36,37062 | 2019-07-29 20:52 |
Strona 49,21 | 2008-08-10 15:18 |
Strona 54,54554 | 2008-07-15 20:24 |
Strona 58,61 | 2010-03-07 13:47 |
Strona 58,67 | 2011-12-18 12:28 |
Strona 58,612 | 2011-04-08 19:36 |
Strona 65,66 | 2012-07-05 12:21 |
Strona 65,86 | 2009-10-09 03:40 |
Strona 76,3 | 2010-08-24 11:22 |
Strona 84 | 2008-03-10 17:37 |
Strona 85,002 | 2008-08-29 11:17 |
Strona 85,041 | 2008-10-20 20:38 |
Strona 86- | 2009-12-28 15:05 |
Strona 86,8686 | 2016-07-02 13:29 |
Strona 86,9823759 | 2010-08-05 09:02 |
Strona 90bat | 2010-04-28 12:08 |
Strona 99,1 | 2008-08-25 19:06 |
Strona 99,86 | 2009-11-05 18:05 |
Strona 99,0922 | 2008-08-27 20:40 |
Strona 99,0926 | 2008-08-28 08:05 |
Strona 106,1 | 2008-08-25 08:23 |
Strona 112,1 | 2010-03-14 22:20 |
Strona 120,1 | 2009-10-18 18:10 |
Strona 120,3 | 2011-05-05 19:32 |
Strona 123,74 | 2011-02-18 11:01 |
Strona 123,75 | 2010-07-27 11:37 |
Strona 123,86 | 2010-07-26 09:51 |
Strona 123,88 | 2010-05-12 11:38 |
Strona 128,6 | 2011-07-20 12:03 |
Strona 182,03 | 2009-06-13 16:18 |
Strona 234,9 | 2012-02-12 14:07 |
Strona 247 | 2010-03-16 19:05 |
Strona 000256 | 2008-07-07 08:56 |
Strona 278,666 | 2008-12-22 19:00 |
Strona 328,12 | 2009-11-10 22:09 |
Strona 328,122 | 2010-03-10 09:58 |
Strona 457 | 2008-05-13 20:58 |
Strona 494 | 2010-04-27 19:36 |
Strona 511,22 | 2008-08-05 16:17 |
Strona 511,23 | 2008-08-05 16:32 |