Wyszukiwanie semantyczne
Debug output SQLStore
ASK Query
[[Kategoria:Biogramy]] [[Faculty::Wydział Górniczy]] OR[[Unit::Wydział Górniczy]]
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
25
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
25
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 109 | 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=3164)
INSERT IGNORE INTO `t1` SELECT DISTINCT t8.s_id FROM `smw_di_wikipage` AS t8 WHERE t8.p_id=30877 AND t8.o_id=3164
Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
NoneZdzisław Kazimierz Maciejasz, Stanisław Włodzimierz Majewski, Antoni Bronisław Matysik, Stanisław Mazurkiewicz, Antoni Józef Konstanty Meyer, Władysław Józef Michejda, Zygmunt Mitera, Jan Naturski, Oskar Nowotny, Zbigniew Zygmunt Obuchowicz, Tadeusz Ozog, Stanisław Paraszczak, Jan Pawiński, Bronisław Piątkiewicz, Władysław Pilch, Marian Ptak, Wiktor Pudło, Tadeusz Ramza, Tadeusz Reguła, Roman Zygmunt Rieger