Wyszukiwanie semantyczne
Z Nondanych
Debug output SQLStore
ASK Query
[[Istnieje jako strona Gry::prawda]] [[Linkuje do::Gra:Strona 5]]
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=890)
)
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=890)
)
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 45,6879 | 2012-01-01 14:59 |
Strona 48 | 2006-12-29 14:33 |
Strona 48,1 | 2010-08-21 08:54 |
Strona 54 | 2007-04-05 18:17 |
Strona 56 | 2007-02-06 20:10 |
Strona 61,66 | 2011-08-23 16:35 |
Strona 61,67 | 2011-09-11 18:48 |
Strona 61,73,2 | 2011-10-08 16:20 |
Strona 68 | 2007-01-01 16:10 |
Strona 69 | 2007-12-14 13:58 |
Strona 69,696969 | 2013-01-30 16:36 |
Strona 73,7893W | 2009-10-15 03:14 |
Strona 85,999 | 2008-11-21 20:04 |
Strona 88.8132 | 2010-07-19 12:11 |
Strona 95 | 2008-06-01 15:51 |
Strona 96 | 2006-05-02 18:59 |
Strona 100 | 2008-06-30 07:56 |
Strona 100,5 | 2014-07-30 12:31 |
Strona 101,99 | 2013-08-08 11:41 |
Strona 102,76 | 2016-11-13 14:53 |
Strona 130 | 2010-08-24 13:38 |
Strona 130,000 | 2010-04-29 12:46 |
Strona 162,09 | 2008-09-16 07:03 |
Strona 163 | 2010-08-10 10:47 |
Strona 192 | 2008-12-19 18:05 |
Strona 225 | 2008-08-25 14:10 |
Strona 238 | 2009-01-07 17:20 |
Strona 245 | 2010-06-02 12:09 |
Strona 294 | 2008-07-22 14:03 |
Strona 322 | 2016-08-30 21:24 |
Strona 328,121 | 2011-08-22 20:00 |
Strona 333,23 | 2008-07-23 13:26 |
Strona 367 | 2007-08-21 15:01 |
Strona 369 | 2011-04-12 06:34 |
Strona 396 | 2015-10-12 19:44 |
Strona 411 | 2008-07-22 14:12 |
Strona 510 | 2007-04-06 10:14 |
Strona 511,22 | 2008-08-05 16:17 |
Strona 530,87 | 2013-08-07 13:55 |
Strona 571.2 | 2010-05-17 15:02 |
Strona 597 | 2009-08-22 16:59 |
Strona 000606 | 2011-11-25 09:54 |
Strona 621,003 | 2009-03-12 19:35 |
Strona 680 | 2007-04-09 07:35 |
Strona 696 | 2017-04-01 09:27 |
Strona 723 | 2010-09-14 13:31 |
Strona 730 | 2007-04-06 08:10 |
Strona 741,5 | 2011-03-19 09:54 |
Strona 777,1235 | 2010-12-16 18:22 |
Strona 785r530 | 2011-04-12 06:46 |