Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Is equipment::true]]
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_di_bool` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_value=1) AND t1.p_id=1045)
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
0
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_di_bool` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_value=1) AND t1.p_id=1045)
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | s_id, o_value | 259 | 10.00 | Using where; Using temporary; Using filesort | |||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki_thehub.t1.s_id | 1 | 95.91 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneName | Company | Model |
---|---|---|
3D Scanners | Artec | Spider & Eva |
Bead Roller | Mittler Brothers | 210-24M |
Belt Sander | Rigid | R2740 |
Belt/Disc Sander | PowerMatic | BD31A |
Bending Brake | Chicago Steel | W31 |
Blast Cabinet | Skat Blast | SC-40 |
Buffers | Baldor | 332B |
CNC Router | Laguna | SmartShop II |
Compound Miter Saw | Dewalt | DWS780 |
Dissolvable Support Bath | Support Cleaning Apparatus | 1200HT |
Drill Press | Clausing | 20" Variable Speed |
Electronics Workstation | BK Precision Teletronix | 1651A DC Power Supply 2831 4 1/2 Digital Multimeter 4017A Function Generator TDS 2024 Oscilloscope |
F370 3D Printer | Stratasys | F370 |
Foam Cutter | Proxxon | Thermocut 12E & 115E |
Formlabs 3D Printer | Formlabs | Form 3 |
Hand Bender | Di-Acro | Model 2 Bender (02HB) |
Hand Router | Porter Cable | 8902 |
Handheld CNC Router | Shaper | S01-NN Origin |
Heat Press | Stahls' Hotronix | Maxx20 |
Heavy Duty Sewing Machine | Consew | 206RB |
High Speed Camera | Chronos | CH14-1.0-32C |
Horizontal Bandsaw | Ellis Mfg. Company Inc. | 1600 |
Hydraulic Press | Baileigh | 30T Air Press |
Injection Molding Machine | Pim-shooter | 150A |
Jewelry Station | Jason's Works | Master Deluxe Kit |
Jointer | Powermatic | 54HH |
Laser Cutters | Trotec | |
Lathe | Monarch | 10EE |
Leatherworking Station | Various | Various |
MIG Welder | Miller Electric | Millermatic 210 |
Markforged 3D Printer | Markforged | Mark II |
Metal Laser Cutter | FabLight | Tube and Sheet FL4500 |
Milling Machine | Hardinge | Bridgeport |
Mug Press | Heat Press Nation | HPN-SIG-MUG |
Oscillating Spindle Sander | Grizzly Industrial | G1071 |
PCB Printer | Voltera | V-One |
Pedestal Grinder | Baldor | 332B |
Photo Table | Ortery | 3D PhotoBench 260 |
Pick and Place | LPKF | Protoplace S |
Planer | Powermatic | 209HH-3 |
Plasma Cutter | Miller | Spectrum 875 |
Power Carver | Foredom | SR - K5200 Deluxe |
Prusa 3D Printer | Prusa | i3 MK3 / i3 MK3S |
Reflow Oven | LPKF | ProtoFlow S N2 |
Rework Station | Zephyrtronics | ZT-2, ZT-3, ZT-1-CLS-DPU, Hakko FR-301, Quick861DW |
Ring Roller | Baileigh Industrial | R-M5 |
Rotary Punch | Di-Acro | Turret Punch No. 12 |
Router Table | SawStop/Bora Portamate Motor | RT-LFT 4-Post |
Scroll Saw | Excalibur | EX-21 |
Serger | Janome | MyLock 634D |