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
105
OFFSET
350
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
105
OFFSET
350
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
- Busybox false
- Set of common utilities built as single binary
- Butter false
- Play shareable videos from various places
- Bwa false
- Burrows-Wheeler Aligner.
- Bwstats false
- bandwidth utilization diagram generator
- BzrPublish false
- Eases publishing releases of software developed in bzr.
- C ElementTree false
- an add-on to the standard ElementTree package.
- C to C++ converter false
- Converts C sources or whole project into C++
- C++ Annotations false
- An extensive C++ tutorial/textbook
- C-graph true
- Visualize convolution and demonstrate convolution theorem.
- C2hs false
- Simplifies the development of Haskell bindings to C libraries
- C2lib false
- Perl/STL-like library of tools for C programming
- CDimgtools false
- inspect and manipulate disc images
- CFFI false
- Foreign Function Interface for Python calling C code
- CHEAT false
- C Unit testing framework
- CIA false
- Realtime project tracking system
- CImg false
- Template Image Processing Toolkit.
- CMDln false
- An improved cmd.py for writing multi-command scripts and shells.
- CMUCL false
- Free implementation of Common Lisp
- CMake false
- Build system
- CONSUL false
- Open Government
- CP: Cerebral Procreation false
- A BF (BrainF***) interpreter and compiler.
- CPG false
- Specifies language grammars and computes, generates, and simulates the corresponding automatons
- CRCmod false
- a CRC generator
- CSS-parser false
- Ruby CSS Parser.
- CSSPool false
- a CSS SAC parser and by default will output a DOM Level 2 style tree.
- CUPS false
- Portable printing layer
- CUnit false
- A unit testing library for the C language
- CVAssistant false
- World's most advanced job application software
- CVSGraph false
- Generates graphical representations of CVS revisions and branches
- CVSHistory false
- Tool for browsing CVS activity which integrates with ViewCVS or CVSweb
- CVSSearch false
- Searches code using CVS comments
- CVSTrac false
- Bug and patch-set tracking system for use with CVS
- CVSps false
- Generates 'patchset' information from a CVS repository
- CYTHAR false
- StandAlone MIDI Step Sequencer
- Cache Money false
- A Write-Through Cacheing Library for ActiveRecord.
- Cachet false
- An HTTP Cache Proxy in Scala.
- Cachy false
- a library to simplify and organize caching.
- CacoCloud false
- A SIMPLE, FAST AND SECURE SELF HOSTED FEED AND MAIL READER, PASSWORD AND BOOKMARK MANAGER.
- Cairo false
- A vector graphics library with cross-device output support.
- Cajo false
- a small library, enabling powerful dynamic multi-machine coöperation.
- CakePHP false
- PHP Web development framework
- Calamares false
- The universal installer framework
- Calc false
- Advanced desk calculator for GNU Emacs.
- CalcChecksum false
- Calculates checksums
- Calconsole false
- A calendar and schedule command-line application.
- Calendar Lock PEA false
- Privacy-focussed calendar application.
- Calendar Maker false
- Rails plugin to build a simple calendar scaffold, with events signified by class names added to the day.
- Calibre false
- A complete e-library solution, including e-reader synchronization
- Calltree false
- Static call tree generator for C programs
- CamlTemplate false
- Template processor library for Objective Caml
- Camping false
- small Ruby web framework for Model-View-Controller type applications
- Cancan false
- Simple authorization for Rails.
- Candela false
- Command-line tool builder with DSL
- Candygram false
- Python implementation of Erlang concurrency primitives
- Canvas false
- Educational courseware/learning management system
- Capybara false
- webrat alternative which aims to support all browser simulators.
- Carl9170fw false
- Libre firmware for AR9170 USB wireless adapters
- Caro false
- A gomoku-like game with addtional rules
- Carp-Clan false
- reports errors from a group of modules
- Carrot false
- an AMQP messaging queue framework.
- Castle Game Engine false
- Cross-platform 3D and 2D game engine for modern Object Pascal with a lot of graphic effects and a scene graph based on X3D
- CataclysmDDA false
- Roguelike survival game set in a post-apocalyptic world
- Ccache false
- Compiler cache
- Ccaudio true
- Library and software for manipulating audio data.
- Ccbuild false
- Autobuild utility
- Ccd2cue true
- CCD sheet to CUE sheet converter.
- Ccide true
- Decision Table Code Generator.
- Ccl false
- Interface to configuration files containing key/value pairs
- Ccrtp true
- RTP protocol stack of GNU Common C++ and the GNU project.
- Ccscript true
- C++ class framework for creating a virtual machine execution system.
- Ccvssh false
- Secure ext-to-pserver bridge for cvs
- Cdecl false
- Composing and deciphering C (or C++) declarations or casts, aka ‘‘gibberish.’’
- Cereal false
- Emulation framework for 8051-compatible CPUs and connected devices
- Certi false
- High-Level Architecture RTI.
- Cervisia false
- Graphical frontend for CVS
- Cf4ocl false
- C Framework for OpenCL
- Cfengine false
- Maintains configuration of a heterogenous UNIX network.
- Cfengine (non-GNU) false
- Maintains configuration of a heterogenous UNIX network.
- Cflow true
- Charts control flow within source code.
- Cflow2vcg false
- Cflow to VCG converter
- Cfs-el false
- Frontend for CFS.
- Cgicc true
- C++ class library for writing CGI applications.
- Cgipplib false
- Support classes for building CGI applications
- Chafa false
- Terminal Graphics for the 21st Century
- Challis false
- a lightweight markup language.
- CharLS false
- Implementation of the JPEG-LS standard.
- Check false
- Unit testing framework for C
- Check modbus false
- Nagios plugin for Modbus TCP and RTU
- Check-license false
- Check source code files against a database of known licenses
- Checkaliases false
- Reads and monitors a sendmail alias file
- Checker false
- Finds memory errors at runtime.
- Checkstyle false
- Java syntax checker
- Checkurls false
- Checks to see if a file at a specified URL has been changed.
- CheetahTemplate false
- Template engine and code generator
- Cherokee false
- Web server
- Chess true, false
- Full chess implementation
- Chestnut Package Manager false
- a utility to handle executables and resource files in a transparent, platform independent and relocatable way.
- Chicago false
- a collection of runtime and test extensions and helpers.
- Chicken false
- Scheme to C compiler.
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.
