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
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_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
100
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 788,9 | 2017-04-21 19:16 |
Strona 792 | 2007-07-16 13:57 |
Strona 904 | 2008-07-23 13:07 |
Strona 951,2 | 2008-09-01 09:24 |
Strona 987 | 2007-07-28 14:44 |
Strona 997,998 | 2011-11-15 17:40 |
Strona 1042,6 | 2008-12-05 14:50 |
Strona 1234,8 | 2008-07-16 16:36 |
Strona 1269,1 | 2008-08-26 09:18 |
Strona 1371 | 2013-02-21 16:14 |
Strona 1407,556 | 2011-09-10 17:12 |
Strona 1498 | 2007-03-11 14:13 |
Strona 1554 | 2008-04-27 11:22 |
Strona 1567 | 2017-06-12 13:12 |
Strona 1917 | 2008-04-20 17:01 |
Strona 2517 | 2013-01-05 18:40 |
Strona 2560 | 2017-06-01 12:58 |
Strona 2845 | 2017-07-06 15:47 |
Strona 2887,1 | 2009-01-07 16:22 |
Strona 03013 | 2009-11-01 17:43 |
Strona 3712,090 | 2008-11-02 21:41 |
Strona 3915 | 2009-10-02 20:29 |
Strona 4093 | 2015-12-06 17:55 |
Strona 5905 | 2013-07-03 19:38 |
Strona 5958 | 2008-09-01 18:22 |
Strona 6304.04 | 2008-04-09 19:28 |
Strona 7130 | 2008-09-15 16:25 |
Strona 7233 | 2013-07-24 23:53 |
Strona 7701,86 | 2010-03-09 17:11 |
Strona 7970 | 2009-01-02 10:25 |
Strona 8102 | 2018-08-06 16:59 |
Strona 9300 | 2011-11-10 15:49 |
Strona 9462 | 2009-06-23 11:04 |
Strona 9696 | 2008-06-30 11:23 |
Strona 10000 | 2019-03-11 16:30 |
Strona 10001 | 2008-12-20 19:37 |
Strona 10482 | 2007-11-25 14:49 |
Strona 11111... | 2007-03-17 08:46 |
Strona 12302,4 | 2016-09-15 17:50 |
Strona 12302,5 | 2016-09-16 16:59 |
Strona 12302,6 | 2016-09-17 12:11 |
Strona 12345,67 | 2013-02-25 20:16 |
Strona 12345,6789 | 2013-02-26 16:43 |
Strona 12348 | 2017-03-26 18:34 |
Strona 13333 | 2009-02-02 17:59 |
Strona 13466 | 2008-04-04 19:07 |
Strona 15005 | 2008-05-27 14:05 |
Strona 41723 | 2009-12-18 22:35 |
Strona 53464 | 2011-05-20 17:24 |
Strona 55555 | 2009-02-20 18:08 |