Búsqueda semántica
De OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[ContainsPdfDrawings::Yes]]
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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
LEFT OUTER JOIN
`smw_fpt_cdat` AS t5 ON t0.smw_id=t5.s_id
WHERE
(t1.p_id=53921 AND t1.o_id=40542)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey DESC
LIMIT
25
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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
LEFT OUTER JOIN
`smw_fpt_cdat` AS t5 ON t0.smw_id=t5.s_id
WHERE
(t1.p_id=53921 AND t1.o_id=40542)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey DESC
LIMIT
25
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 192 | Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | oho_wiki_es.t1.s_id | 1 | Using where | |
1 | SIMPLE | t5 | ref | s_id | s_id | 4 | oho_wiki_es.t1.s_id | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneCocina Solar de diámetro 1.4m Turbina Darrieus combinada de 2m Calentador Solar de Agua - Capacidad 100L Remolque para bicicleta basado en el diseño Carla Cargo Trailer compacto para bicicleta Prensa de esquinas Prensa tipo sargento Prensa para taladro Extractor de poleas con 3 quijadas Cizalla manual para plancha de 3mm Dobladora de barras para espesores de 5 a 15 mm Prensa de banco con mordaza de 150mm Soporte para amoladora angular Base para taladro manual Dobladora de Chapa manual 1000mm-JJ Dobladora de Chapa manual 1000mm-NV Bloquera con capacidad de 100 piezas por hora Turbina Eólica con Velas Verticales de Tambor Metálico Turbina Darrieus Fabricada con Tubos de PVC Turbina de Eje Horizontal con Cola de Seguridad