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
130
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
130
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 3469 | 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
- 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.
- Archives2git false
- recreate a Git history from release archives
- Arduino false
- AVR development board IDE and built-in libraries
- Arfg false
- Meta-language that combines m4, eperl, and divert
- Arg-parser false
- Argument parser that follows POSIX and GNU conventions.
- Argbash false
- Bash argument parsing code generator
- Argp false
- argp for bash
- Aria false
- Download tool with GUI that can pause, resume, and queue downloads
- Aris true
- Formal logical proofing.
- Arkanoid (Uzebox) false
- Implementation of the Arkanoid game to run on the Uzeboz
- Aroundme false
- Social networking and team interaction.
- Arrangeit false
- Cross-platform desktop utility for easy windows management
- Artanis true
- Web application framework written in Guile Scheme.
- Article Difficulty Level false
- Through this plugin, user can able to select the post difficulty level in admin dash board post area for each post.
- Arvados false
- Arvados is a free and open source platform for big data science.
- Asciinema-player false
- Web player for terminal session recordings
- Asdf false
- a system definition facility for Common Lisp programs and libraries
- Asdf-vm false
- Version manager for multiple programming languages
- Aseprite false
- Pixel art editor
- Ash text editor false
- a terminal based text editor
- AsmEdit false
- Editor and IDE written in assembler
- AsmIDE false
- Is a utility programs that support assembler development
- AsmRef false
- Reference for x86 assembly language programmers
- Aspell true
- Spell checker.
- Asset Trip false
- Rails asset bundling plugin that will expand your mind.
- Association Freezer false
- Freeze a belongs_to association in Active Record.
- Astroid false
- a Mail User Agent for notmuch
- Astronomical Papers Library false
- A C library of published theories of motion of solar system objects.
- Astyle false
- Source code formatter
- Asymptopia Blackjack false
- Blackjack for kids!
- Async-timeout false
- Manages timeout contexts for programs using Python's asyncio
- Aterr false
- Threaded forum system
- Atom false
- Text and source code editor based on Web technologies
- Atomthreads false
- a lightweight, portable, real-time scheduler for embedded systems.
- Atrack false
- A Tracker for Google's App Engine
- Attrs false
- Classes in Python without object protocols
- Auale false
- Play oware abapa against the computer or annotate your games
- Auctex true
- A sophisticated TeX environment for Emacs.
- Audacious false
- Audacious Audio Player
- Audacity false
- Audio editor and recorder
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.
