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
25
OFFSET
330
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
25
OFFSET
330
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 3431 | 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
- Budgie false
- A feature-rich and modern desktop environment
- Bug-A-Boo false
- Web-based bug tracking system
- Bug-buddy false
- GNOME bug-reporting utility
- BugPort false
- QA system for software development
- Bugdar false
- Is a bug tracking system.
- Bugs false
- Dynamic private key encryption algorithm and applications
- Bugtrack false
- Bug tracking system
- BuildBot false
- Automates the compile/test cycle of software development
- Buildtool false
- Portable build infrastructure
- Buildutils false
- Distutils extensions for developing Python libraries and applications.
- Bullet dodger false
- A fun and challenging mouse game where you must dodge bullets
- Bundler false
- a tool that manages gem dependencies for your ruby application.
- Bunny the Fuzzer false
- closed loop, high-performance, general purpose protocol-blind fuzzer
- Burn false
- command-line tool for writing optical media
- Burn 360 false
- Burn 360 - VCD ripping, Encoding and Creation GUI written in perl-Gtk2
- Bustd false
- bustd is a lightweight process killer daemon for out-of-memory scenarios for Linux!
- Busted false
- busted is a tool for gathering and reporting information about a broken gem.
- Busybox false
- Set of common utilities built as single binary
- Butter false
- Play shareable videos from various places
- Bwa false
- Burrows-Wheeler Aligner.
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.
