Wyszukiwanie semantyczne
Z Nondanych
Debug output SQLStore
ASK Query
[[Istnieje jako strona Gry::prawda]] [[Linkuje do::Gra:Strona 84]]
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=977)
)
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=977)
)
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 2404 | 2015-11-15 14:02 |
Strona 3712 | 2008-09-16 07:08 |
Strona 4117 | 2017-11-05 08:25 |
Strona 5192 | 2007-10-06 20:23 |
Strona 5193 | 2007-12-21 17:50 |
Strona 5195,001 | 2008-04-04 20:49 |
Strona 5199 | 2008-03-09 09:18 |
Strona 5201 | 2008-03-09 12:03 |
Strona 5267.1 | 2013-11-09 17:02 |
Strona 6304.03 | 2010-10-01 16:10 |
Strona 6304.04 | 2008-04-09 19:28 |
Strona 7622 | 2008-09-10 17:44 |
Strona 7759 | 2014-06-08 15:57 |
Strona 7761 | 2014-06-08 16:06 |
Strona 8760 | 2010-11-22 07:33 |
Strona 9087 | 2012-02-05 16:50 |
Strona 9699 | 2012-12-20 21:36 |
Strona 10231 | 2010-01-30 18:56 |
Strona 19424 | 2009-01-24 16:31 |
Strona 19438 | 2008-12-16 20:16 |
Strona 36197 | 2009-11-23 13:28 |
Strona 41000 | 2008-01-24 14:58 |
Strona 76120,69 | 2010-03-16 20:11 |
Strona 79548,5 | 2007-12-05 15:45 |
Strona 88916 | 2009-08-17 16:00 |
Strona 201203 | 2009-11-09 14:26 |
Strona 543221 | 2015-03-15 08:26 |
Strona 0700677 | 2008-10-30 14:09 |
Strona 0700880 | 2009-06-24 11:46 |
Strona 855552 | 2011-12-20 12:03 |
Strona 997712 | 2008-05-23 18:03 |
Strona 1273783 | 2012-11-11 11:39 |
Strona 7024033 | 2008-07-23 13:35 |
Strona 0123456789 | 2011-05-01 17:52 |
Strona pochówek2 | 2008-03-09 11:34 |
Strona pochówek313 | 2010-08-10 18:46 |
Strona!/Afryka/Strona 5,34 | 2019-06-14 11:42 |
Strona!/Janusz/Pożyczka | 2019-04-27 07:48 |
Strona!/Strona 1070 | 2009-11-22 10:06 |
Strona./Prehistoria/Strona 185 | 2010-05-19 11:10 |