Wyszukiwanie semantyczne
Przejdź do nawigacji
Przejdź do wyszukiwania
Query-Depth:1
Debug output SQLStore
ASK Query
[[Kategoria:Zestawienie wąskotorowych pojazdów trakcyjnych]] [[Lw typ fabryczny::L45H]]
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_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=39559
AND (
(t4.o_hash='L45H') AND t4.p_id=39341)
)
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_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=39559
AND (
(t4.o_hash='L45H') AND t4.p_id=39341)
)
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 | t4 | index_merge | s_id, p_id, s_id_2, o_hash | o_hash,p_id | 258,262 | 7 | Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | wiki-enkol.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki-enkol.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneLw stan | Lw numer seryjny | |
---|---|---|
L45H 20865 | Nieznany | 20865 |
L45H 20866 | Nieznany | 20866 |
L45H 20867 | Sprawna | 20867 |
L45H 20921 | Złom | 20921 |
L45H 20922 | Złom | 20922 |
L45H 20923 | Złom | 20923 |
L45H 20924 | Złom | 20924 |
L45H 20925 | Złom | 20925 |
L45H 20926 | Sprawna | 20926 |
L45H 20927 | Złom | 20927 |
L45H 20928 | Odstawiona | 20928 |
L45H 20929 | Złom | 20929 |
L45H 20930 | Odstawiona | 20930 |
L45H 20931 | Nieznany | 20931 |
L45H 20932 | Nieznany | 20932 |
L45H 20933 | Nieznany | 20933 |
L45H 20934 | Nieznany | 20934 |
L45H 20935 | Nieznany | 20935 |
L45H 20936 | Nieznany | 20936 |
L45H 20937 | Nieznany | 20937 |
L45H 20938 | Nieznany | 20938 |
L45H 20939 | Nieznany | 20939 |
L45H 20940 | Nieznany | 20940 |
L45H 21258 | Sprawna | 21258 |
L45H 21259 | Nieznany | 21259 |
L45H 21260 | Złom | 21260 |
L45H 21261 | Złom | 21261 |
L45H 21262 | Złom | 21262 |
L45H 21263 | Złom | 21263 |
L45H 21264 | W trakcie remontu | 21264 |
L45H 21265 | Sprawna | 21265 |
L45H 21266 | Złom | 21266 |
L45H 21267 | Złom | 21267 |
L45H 21268 | Złom | 21268 |
L45H 21269 | Sprawna | 21269 |
L45H 21270 | Nieznany | 21270 |
L45H 21271 | Sprawna | 21271 |
L45H 21272 | Złom | 21272 |
L45H 21273 | Sprawna | 21273 |
L45H 21274 | Złom | 21274 |
L45H 21275 | Złom | 21275 |
L45H 21276 | Złom | 21276 |
L45H 21277 | Złom | 21277 |
L45H 21568 | Sprawna | 21568 |
L45H 21569 | Sprawna | 21569 |
L45H 21570 | Sprawna | 21570 |
L45H 21571 | Sprawna | 21571 |
L45H 21572 | Sprawna | 21572 |
L45H 21573 | Sprawna | 21573 |
L45H 21574 | Złom | 21574 |