Debug output SQLStore
ASK Query
[[Category:RLSH Directory]]
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
`mwg1_smw_object_ids` AS t0
INNER JOIN
(`mwg1_smw_fpt_inst` AS t1
INNER JOIN
`mwg1_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_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
50
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
`mwg1_smw_object_ids` AS t0
INNER JOIN
(`mwg1_smw_fpt_inst` AS t1
INNER JOIN
`mwg1_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 139 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | admin_wiki.t2.id | 7 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | admin_wiki.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (518).
SELECT s_id FROM `mwg1_smw_fpt_subc` WHERE o_id=518 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None-
Blind-Side Location: New York, USA Status: Inactive -
Blu Falcon Location: Biloxi, Mississippi, USA Status: Inactive -
Blue Location: Minnesota, USA Status: Inactive -
Blue Alpha Location: San Bernardino, California, USA Status: Inactive -
Blue Beacon Location: Raleigh, North Carolina, USA Status: Inactive -
Blue Potato Location: Henryville, PA Status: Retired -
Blue Rattler File:Blue Rattler.jpg Location: Dallas, Texas, USA Status: Inactive -
Blue Smash Location: France Status: Inactive -
Blue Sparrow Location: Seattle, Washington, USA Status: Inactive -
Bone Fist Location: Peterborough, Ontario, Canada Status: Active -
Bones Location: Brooklyn, New York, USA Status: Active -
Boomer Location: Seattle, Washington Status: Retired -
Boots Location: San Francisco, California Status: Unknown -
Brennan Location: Ontario, Canada Status: Active -
Brick Location: San Diego, California, USA Status: Active -
Bridgette Storms Location: Los Angeles, California Status: Inactive -
Buster Doe Location: Seattle, Washington Status: Inactive -
Canadian Justice Location: Windsor, Ontario, Canada Status: Active -
Caped Crusader File:CapedCrusader.jpg Location: New Cleveland, Ohio, USA Status: Unknown -
Captain Australia Location: Brisbane, Australia Status: Active -
Captain Black Location: New Orleans, Louisiana, USA Status: Active -
Captain Jackson Location: Jackson, Michigan, USA Status: Retired -
Captain Karma Location: Seattle, Washington, USA Status: Inactive -
Captain Ozone Location: Washington Status: Retired -
Captain Prospect Location: Washington, D.C., USA Status: Inactive -
Captain Sticky Location: San Diego, California Status: Deceased -
Catman Location: McMinnville, Tennessee, USA Status: Active -
Charade Location: Orlando, Florida, USA Status: Inactive -
Cheshire Cat Location: San Jose, California Status: Inactive -
Chimera Location: Spokane, Washington, USA Status: Inactive -
Citizen Change Location: Oakland, California, USA Status: Inactive -
Citizen French Location: Paris, France, EU Status: Inactive -
Citizen Prime Location: Salt Lake City, Utah, USA Status: Retired -
Citizen Saint Location: Florissant, Missouri, USA Status: Inactive -
Citizen Tiger Location: Huntington, Indiana, USA Status: Active -
Civil Defender Location: Chicago, Illinois, USA Status: Inactive -
Civitron Location: New Bedford, Massachusetts, USA Status: Inactive -
Clean Panther Location: Nagoya, Japan Status: Active -
Clock Work Location: San Francisco, California, USA Status: Semi-Active -
Conundrum Location: New Jersey, USA Status: Inactive -
Corveus Location: Phoenix, Arizona, USA Status: Inactive -
Crackdown Location: Biloxi, Mississippi, USA Status: Inactive -
The Cremator Location: Wichita Falls, Texas, USA Status: Inactive -
Crimson Canuck Location: Windsor, Ontario, Canada Status: Inactive -
Crimson Catalyst Location: Chicago, Illinois, USA Status: Retired -
Crimson Crow Location: San Diego, California, USA Status: Inactive -
Crimson Crusader Location: Milwaukee, Wisconsin, USA Status: Inactive -
Crimson Fist Location: Oakland, California, USA Status: Active -
Crimsonbat Location: Penang, Malaysia Status: Semi-Active -
Crossfire the Crusader Location: Hot Springs, Arkansas, USA Status: Inactive