Semantic search
SQLStore debug output
ASK Query
[[Place.Latlong::+]] [[Rtype::bus]] [[Provider::AC Transit]]
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_di_wikipage` AS t2
INNER JOIN
`wiki_t3` AS t3 ON t2.p_id=t3.id
INNER JOIN
`wiki_smw_di_coords` AS t4 ON t2.o_id=t4.s_id
INNER JOIN
`wiki_smw_di_blob` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
(`wiki_smw_di_blob` AS t8
INNER JOIN
`wiki_t9` AS t9 ON t8.p_id=t9.id) ON t2.s_id=t8.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id='318781')
AND (
(t6.o_hash='bus') AND t6.p_id='318838')
AND (
(t8.o_hash='AC Transit')
))
AND 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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_di_wikipage` AS t2
INNER JOIN
`wiki_t3` AS t3 ON t2.p_id=t3.id
INNER JOIN
`wiki_smw_di_coords` AS t4 ON t2.o_id=t4.s_id
INNER JOIN
`wiki_smw_di_blob` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
(`wiki_smw_di_blob` AS t8
INNER JOIN
`wiki_t9` AS t9 ON t8.p_id=t9.id) ON t2.s_id=t8.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id='318781')
AND (
(t6.o_hash='bus') AND t6.p_id='318838')
AND (
(t8.o_hash='AC Transit')
))
AND 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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t9 | ALL | PRIMARY | 2 | Using temporary; Using filesort | |||
| 1 | SIMPLE | t8 | ref | s_id,p_id,s_id_2,o_hash | p_id | 262 | transitunlimited.t9.id,const | 1 | Using index condition |
| 1 | SIMPLE | t6 | ref | s_id,p_id,s_id_2,o_hash | s_id | 8 | transitunlimited.t8.s_id,const | 1 | Using where |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | transitunlimited.t8.s_id | 1 | Using where |
| 1 | SIMPLE | t2 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 4 | transitunlimited.t8.s_id | 2 | Using where; Using index; Distinct |
| 1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | transitunlimited.t2.p_id | 1 | Distinct |
| 1 | SIMPLE | t4 | ref | s_id,p_id | s_id | 8 | transitunlimited.t2.o_id,const | 1 | Using index; Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) ('318779').
SELECT s_id FROM `wiki_smw_fpt_subp` WHERE o_id='318779' LIMIT 1 - Temporary table t9
Recursively computed hierarchy for element(s) ('318795').
SELECT s_id FROM `wiki_smw_fpt_subp` WHERE o_id='318795' LIMIT 1
Query Metrics
Query-Size:6Query-Depth:2
Errors and Warnings
NoneAll-Nighter: San Francisco - Richmond Station
All-Nighter: San Leandro BART - Fremont Station
All-Nighter: Downtown Oakland - Berkeley Amtrak Station via San Pablo
All-Nighter: Downtown Oakland - Oakland International Airport
All-Nighter: Downtown Oakland - Eastmont Transit Center via Foothill
All-Nighter: Fruitvale BART - Downtown Berkeley
Winton - Industrial - Tennyson
Market: Lake Merritt Station - Downtown Berkeley
Coliseum Station - Foothill Square via 90th
Castro Valley BART - Hayward - San Lorenzo - Bayfair
Hayward BART Station - Kelly and Eddy
Fruitvale Montana/ Alameda Point
Hesperian: Union City Station - Bay Fair Station
Coliseum Station - Eastmont via Edgewater, 98th, MacArthur
Fremont Station - Hayward Station via Fremont, Decoto, Mission Blvd
Tunnel Rd/Claremont - San Francisco
Adeline: Downtown Berkeley (Hearst and Shattuck) - San Francisco
North Berkeley: Berkeley (Solano and Colusa) - San Francisco
Solano: El Cerrito (Potrero and Richmond) - San Francisco
Sacramento: Berkeley (Sacramento and University) - San Francisco
Pierce: San Pablo (Princeton Plaza) - San Francisco
Hilltop: Richmond (Park Central and Hilltop) - San Francisco
MacArthur Limited: Eastmont Transit Center - San Francisco
Morning: Oakland (Seminary and MacArthur) - San Francisco
Afternoon: San Francisco (Transbay Terminal) - Oakland (Fruitvale and MacArthur)
Afternoon: San Francisco (Transbay Terminal) - Oakland (High and MacArthur)
MacArthur/Eastmont - San Francisco
Santa Clara: Fruitvale BART - San Francisco via Alameda
Bay Farm/Park St. - San Francisco
Oakland Avenue: Piedmont - San Francisco
Fremont Station - Stanford University
Park Blvd: Oakland (College and Broadway) - San Francisco via Montclair
Otis: Alameda (Broadway and Blanding) - San Francisco
Tempo Bus Rapid Transit: Uptown Oakland - San Leandro Station via International
School days only: Berkeley - Oakland - H.Royce School
School days only: Berkeley - Oakland - H.Royce School
School days only: Piedmont - H.Royce School
School days only: Point Richmond - Richmond H.S.
School days only: Diamond Dist./ Westlake M.S./ Piedmont
School days only: Seminary Ave/ Skyline H.S.
School days only: Cedar Blvd-Newark Memorial H.S.
School days only: Fremont - American H.S.
School days only: Milpitas Blvd. & Dixon Landing - Horner JH
School days only: Paseo Padre - Mission S.J. High School
School days only: Niles & El Portal - Centerville JHS
School days only: Newark Blvd.
School days only: Cedar Blvd.
School days only: Cherry St.
School days only: Alameda/ Encinal H.S.
School days only: 73rd International Blvd - Skyline High
