Uit Hack42
Debug output SQLStore
ASK Query
[[Categorie:Tool]]
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=22382)
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_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=22382)
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 | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 123 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | deckart_hack42wiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneTool Name | Tool Desc | Tool Usage | Tool Costs | Tool Warnings | |
---|---|---|---|---|---|
Tool:Steekwagen traploper | Steekwagen traploper | Steekwagen traploper | Deelnemer | ||
Tool:Stereomicroscoop | Microscoop | Stereo microscoop met camera | Iedereen | €333,33 | |
Tool:TrageNatteSlijpmachine | TrageNatteSlijpmachine | ||||
Tool:Tsar Bomba | Tsar_Bomba | Grote_100W_lazor | Deelnemer | tbd(>10) euro / uur | |
Tool:Tuftgun | Tuft Gun | Tuft Gun | Deelnemer | ||
Tool:TurboTronic TT-FD45 Voedseldroger | Dori de Droger | TurboTronic 45-liter (9 etages) TurboWave Bio voedseldroger | Deelnemer | Geen | |
Tool:Ultimaker Original | Ultimaker original | Ultimaker original 3D printer | Deelnemer | 84ct/meter | |
Tool:Ultrasoon reinigingsapparaat | Ultrasoon reinigingsapparaat | SilverCrest SUR 48 | Iedereen | ||
Tool:Unicorn | Unicorn | Gemotoriseerde kloof-unit voor het verwerken van boomstammen tot brandhout | Deelnemer | ||
Tool:VideoMicroscoop | Video Microscoop | Microscoop met Full HD output | Iedereen | ||
Tool:Vinylsnijder | Vinylsnijder | Silhouette Portrait | Deelnemer | ||
Tool:Vlakschuurmachine | Vlakschuurmachine | 2 vlakschuurmachines | Deelnemer | ||
Tool:Voeding 12V 5A | Voeding 12V 5A | Voeding, doet 12V en max 5A | Deelnemer | ||
Tool:Wipzaag | Wipzaag | Wipzaag, om stammetjes te zagen (max 12cm) | Deelnemer | ||
Tool:Woei | Woei | Bladblazer | Iedereen | ||
Tool:X-Y Recorder Philips PM 8143 | X-Y Recorder Philips PM 8143 | Soort plotter, voor electronerds | Deelnemer | ||
Tool:Zaagbok | Zaagbok | Om te zagen stukken boom op te leggen | |||
Tool:Zaagtafel | Zaagtafel | Zaagtafel met galei | Deelnemer | ||
Tool:koffiemonstertje | Koffiemonstertje | Koffie zoals het hoort | Deelnemer | ||
Tool:lacimbali m32 | Espressomachine | Koffie zoals het hoort | Deelnemer | ||
Tool:x25 | x25 | Fiskars x25 kloofbijl | Deelnemer | ||
Tool:x27 | x27 | Fiskars x27 kloofbijl | Deelnemer | ||
Tool:x46 | x46 | Fiskars x46 kloofbijl | Deelnemer |