Semantische Suche
Aus LaborWiki
Debug output SQLStore
ASK Query
[[Kategorie:Blogpost]] [[Blog draft::no]]
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, t7.o_sortkey
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
INNER JOIN
`smw_di_time` AS t7 ON t0.smw_id=t7.s_id
WHERE
(t2.o_id=9541
AND (
(t4.o_hash='no') AND t4.p_id=9537)
)
AND (t7.p_id=9535)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_sortkey DESC
LIMIT
9
OFFSET
4
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, t7.o_sortkey
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
INNER JOIN
`smw_di_time` AS t7 ON t0.smw_id=t7.s_id
WHERE
(t2.o_id=9541
AND (
(t4.o_hash='no') AND t4.p_id=9537)
)
AND (t7.p_id=9535)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_sortkey DESC
LIMIT
9
OFFSET
4
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 323 | Using index; Using temporary; Using filesort | |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | mediawiki.t2.s_id | 1 | Using where | |
| 1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | mediawiki.t2.s_id, const | 1 | Using where | |
| 1 | SIMPLE | t7 | ref | s_id, p_id, p_id_2, s_id_2 | s_id_2 | 8 | mediawiki.t2.s_id, const | 1 | Using index |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneDonnerstag 26. September 2024 von Mythozz
UPDATE: WIR SIND LEIDER AUSGEBUCHT!!
Das Labor in Bochum macht am 3. Oktober beim Maus-Türöffnertag mit!
Weiterlesen...
Das Labor in Bochum macht am 3. Oktober beim Maus-Türöffnertag mit!
Weiterlesen...
Sonntag 15. September 2024 von Schwiemel
Welche Drehzahl welcher Vorschub?
und was bedeuten all diese Begriffe in CAM
Freitag 30. August 2024 von Schwiemel
Welchen Fräser für welchen Zweck
Montag 26. August 2024 von Schwiemel