Semantic search
SQLStore debug output
ASK Query
[[Software-development::+]]OR[[Use::software-development]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
90
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
90
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 3473 | Using temporary; Using filesort | |||
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikidb.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_blob` AS t4 INNER JOIN `t5` AS t5 ON t4.p_id=t5.id WHERE (t4.o_hash='software-development') - Temporary table t3
Recursively computed hierarchy for element(s) ('1014289').
SELECT s_id FROM `smw_fpt_subp` WHERE o_id='1014289' LIMIT 1 - Temporary table t5
Recursively computed hierarchy for element(s) ('1014157').
SELECT s_id FROM `smw_fpt_subp` WHERE o_id='1014157' LIMIT 1
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None
- AllPairs false
- Pairwise test combinations generator
- Allegro false
- Game programming library
- Alot false
- Text mode MUA using notmuch mail
- Alpine false
- A screen-oriented message-handling tool- Alternatively Licensed Program for Internet News and Email
- Alpine3D false
- Distributed alpine surface processes model
- Alpy false
- Python bindings to the Allegro game programming library
- Altium2kicad false
- Altium to KiCad converter for PCB and schematics
- Amarok false
- Multimedia player suited for KDE
- Amnesia false
- A Sinatra app that presents memcached server stats.
- Analog false
- Web logfile analysis program
- Anastasis false, true
- Key backup and recovery
- AndStatus false
- Low traffic social networking client with tree-like threaded conversations
- Andesaurux false
- Simple OS
- Android-latinoware false
- Android application to view schedule of Latinoware event
- Anemone false
- An easy-to-use Ruby web spider framework
- AngelScript false
- Extension programming language
- Angry, Drunken Dwarves false
- A falling block puzzle game.
- Angular2 false
- A front-end web application platform
- Animail false
- Multiserver mail retrieval utility
- Anise false
- one software project administration tool for all environments
- Anjuta false
- Integrated development environment
- Anki false
- A spaced repetition flashcard program.
- AnonAddy false
- A privacy tool for anonymous email forwarding
- Anontwi false
- Tool to have more privacy on social networking sites
- Anonymine false
- curses mode minesweeper without guessing
- AnonymousMessenger false
- a peer to peer private anonymous and secure messenger that works over tor.
- Anonymouth false
- tools for text anonymization
- Ansible false
- Configuration management, deployment, and task execution system
- Ant false
- Java-based build tool
- Ant-phone false
- ISDN telephony application.
- Antidote false
- IEEE 11073-20601 stack
- Antimicro false
- map keyboard and mouse controls to a gamepad
- Antiparser false
- a fuzz testing and fault injection API.
- Antiright false
- Desktop optimized to work with the Motif API.
- Antlr false
- ANother Tool for Language Recognition.
- Anubis true
- Processes outgoing mail.
- Apache CouchDB false
- is a distributed, fault-tolerant and schema-free document-oriented database accessible via a RESTful HTTP/JSON API.
- Apache HTTP Server false
- Featureful HTTP server.
- Apel false
- Version of APEL maintained by the developers of Wanderlust.
- Aping false
- Advanced ping program.
- Apl true
- Interpreter for APL Programming Language.
- Aplakons false
- Activity plans constructor
- App Manager false
- A full-featured package manager and viewer for Android
- AppTools false
- a set of packages for creating applications.
- Appleseed false
- physically-based global illumination production rendering
- Apsfilter false
- Magic print filter with automatic file type recognition
- Apydia false
- API Reference Documentation Generator for Python.
- Arbitools false
- Tools for chess arbiters
- ArchZoom false
- A Web-based browser for the GNU Arch revision control system.
- Archimedes true
- Designing and simulating submicron semiconductor devices.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.
The copyright and license notices on this page only apply to the text on this page. Any software or copyright-licenses or other similar notices described in this text has its own copyright notice and license, which can usually be found in the distribution or license text itself.
