Wyszukiwanie semantyczne
Z Nondanych
Debug output SQLStore
ASK Query
[[Istnieje jako strona Gry::prawda]] [[Linkuje do::Gra:Strona 87]]
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=536)
)
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=536)
)
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 0,19282 | 2009-02-15 10:42 |
Strona 00,45431 | 2009-11-16 17:24 |
Strona 0,1234978 | 2009-02-14 21:11 |
Strona 0,2135834 | 2010-03-13 22:05 |
Strona 0,2179223 | 2009-02-14 20:06 |
Strona 0,12468543 | 2009-02-14 21:47 |
Strona 0,12332153795 | 2009-02-14 20:53 |
Strona 0,92375234685 | 2009-02-14 20:34 |
Strona 0,456795364696 | 2009-10-17 07:34 |
Strona 000+0 | 2007-10-21 07:12 |
Strona 001 | 2008-08-22 12:00 |
Strona 1,(11) | 2015-07-25 11:32 |
Strona 1,(55) | 2011-05-13 18:55 |
Strona 1,(83) | 2011-05-21 18:08 |
Strona 1,(87) | 2011-05-21 18:15 |
Strona 1,(745) | 2012-12-29 23:35 |
Strona 001% | 2017-07-06 15:59 |
Strona 2,32+13 | 2014-06-05 10:41 |
Strona 2,99 | 2014-07-30 09:26 |
Strona 3RPGVirusDownloadE2 | 2010-06-26 09:09 |
Strona 5.3 | 2010-04-17 17:21 |
Strona 8X | 2009-11-21 08:27 |
Strona 11,4 | 2010-08-16 07:06 |
Strona 12,09 | 2009-01-07 13:20 |
Strona 12.9 | 2010-01-04 18:26 |
Strona 015 | 2010-09-19 12:08 |
Strona 33,4 | 2008-09-10 16:52 |
Strona 33.3210 | 2013-10-12 18:17 |
Strona 34,79 | 2009-03-20 09:27 |
Strona 34,80 | 2009-05-19 16:47 |
Strona 42,01 | 2008-09-18 17:14 |
Strona 44,4 | 2008-04-20 15:03 |
Strona 45,57,3 | 2011-03-02 16:33 |
Strona 45,6879 | 2012-01-01 14:59 |
Strona 48 | 2006-12-29 14:33 |
Strona 48,1 | 2010-08-21 08:54 |
Strona 63.63 | 2009-10-07 18:13 |
Strona 65,77 | 2012-07-05 11:22 |
Strona 67,8458 | 2009-10-13 17:21 |
Strona 68 | 2007-01-01 16:10 |
Strona 68,8943 | 2009-10-13 18:22 |
Strona 071.2 | 2019-03-10 14:01 |
Strona 75 | 2006-12-30 07:34 |
Strona 75,8 | 2013-07-31 09:35 |
Strona 76,5 | 2010-08-24 11:29 |
Strona 78 | 2007-04-04 18:16 |
Strona 84 | 2008-03-10 17:37 |
Strona 85+ | 2009-11-26 14:10 |
Strona 86- | 2009-12-28 15:05 |
Strona 86,004 | 2011-11-15 17:23 |