Difference between revisions of "User:Dl88008/sandbox7"
From Scientolipedia
(Created page with "{{#ask: {{SumWDAH}}|format=jqPlot chart}}") |
|||
| Line 1: | Line 1: | ||
| − | {{#ask: | + | {{#ask:[[Category:Success Stories]] |
| + | |mainlabel=Title | ||
| + | |?Auditing Success | ||
| + | |?Training Success | ||
| + | |format=debug | ||
| + | }} | ||
Revision as of 04:48, December 19, 2013
Contents
Debug Output by SQLStore
Ask query
[[Category:Success Stories]]
SQL Query
SELECT DISTINCT
t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_subobject AS so,t2.smw_sortkey AS sortkey
FROM
`mw_smw_object_ids` AS t2
INNER JOIN
`mw_smw_fpt_inst` AS t0 ON t2.smw_id=t0.s_id
INNER JOIN
`mw_t1` AS t1 ON t0.o_id=t1.id
ORDER BY
t2.smw_sortkey ASC
LIMIT
55
OFFSET
0
t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_subobject AS so,t2.smw_sortkey AS sortkey
FROM
`mw_smw_object_ids` AS t2
INNER JOIN
`mw_smw_fpt_inst` AS t0 ON t2.smw_id=t0.s_id
INNER JOIN
`mw_t1` AS t1 ON t0.o_id=t1.id
ORDER BY
t2.smw_sortkey ASC
LIMIT
55
OFFSET
0
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 2 | Using temporary; Using filesort | |||
| 1 | SIMPLE | t0 | ref | s_id,o_id | o_id | 5 | dl88008_scnped.t1.id | 38 | |
| 1 | SIMPLE | t2 | eq_ref | PRIMARY,smw_id | PRIMARY | 4 | dl88008_scnped.t0.s_id | 1 |
Auxilliary Tables Used
- Temporary table t1
Recursively computed hierarchy for element(s) ('274').
Query Metrics
Query-Size:1Query-Depth:0
