Wyszukiwanie semantyczne
Debug output SQLStore
ASK Query
[[Kategoria:Biogramy]] [[Faculty::Wydział Górnictwa i Geoinżynierii]] OR[[Unit::Wydział Górnictwa i Geoinżynierii]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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 | t1 | ALL | PRIMARY | 77 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | historia.t1.id | 1 | 50.03 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t3.s_id FROM `smw_fpt_inst` AS t3 INNER JOIN `smw_di_wikipage` AS t5 ON t3.s_id=t5.s_id WHERE t3.o_id=11904 AND (t5.p_id=2657 AND t5.o_id=2784)
INSERT IGNORE INTO `t1` SELECT DISTINCT t8.s_id FROM `smw_di_wikipage` AS t8 WHERE t8.p_id=30877 AND t8.o_id=2784
Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
NoneWłodzimierz Roszczynialski, Janusz Ryszard Roszkowski, Jerzy Franciszek Rydlewski, Jacek Ignacy Sepiał, Antoni Siwiec, Jerzy Słowik, Józef Bolesław Stachurski, Michał Bogumił Stopyra, Adam Sucheta, Jan Szlązak, Nikodem Szlązak, Kazimierz Stanisław Sztaba, Andrzej Bronisław Szumiński, Maria Szymańska-Czaja, Edward Stewarski, Marek Bolesław Stryszewski, Zbigniew Tajchman, Antoni Józef Tajduś, Kazimierz Antoni Trybalski, Alfred Zdzisław Trzaska, Tadeusz Tumidajski, Ryszard Henryk Uberman, Jan Walaszczyk, Stanisław Wasilewski, Andrzej Franciszek Wichur, Jan Józef Winzer, Ryszard Józef Wosz