Semantische Suche
Zur Navigation springen
Zur Suche springen
Query-Depth:1
Debug output SQLStore
ASK Query
[[Kategorie:Bilder]] [[Strasse::Schwabacher Straße]] [[ZeigeNichtInStrasse::falsch]] OR [[Kategorie:Bilder]] [[Ort::Schwabacher Straße]] [[ZeigeNichtInOrt::falsch]]
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
`fw_smw_object_ids` AS t0
INNER JOIN
`fw_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
55
OFFSET
500
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
`fw_smw_object_ids` AS t0
INNER JOIN
`fw_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
55
OFFSET
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 620 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | fuerthwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `fw_t1` SELECT DISTINCT t3.s_id FROM `fw_smw_fpt_inst` AS t3 INNER JOIN `fw_t4` AS t4 ON t3.o_id=t4.id INNER JOIN `fw_smw_di_wikipage` AS t5 ON t3.s_id=t5.s_id INNER JOIN `fw_smw_di_bool` AS t8 ON t3.s_id=t8.s_id WHERE (t5.p_id=190662 AND t5.o_id=1367) AND ((t8.o_value=0) AND t8.p_id=221431)
INSERT IGNORE INTO `fw_t1` SELECT DISTINCT t11.s_id FROM `fw_smw_fpt_inst` AS t11 INNER JOIN `fw_t12` AS t12 ON t11.o_id=t12.id INNER JOIN `fw_smw_di_wikipage` AS t13 ON t11.s_id=t13.s_id INNER JOIN `fw_smw_di_bool` AS t16 ON t11.s_id=t16.s_id WHERE (t13.p_id=548 AND t13.o_id=1367) AND ((t16.o_value=0) AND t16.p_id=221319) - Temporary table t4
Recursively computed hierarchy for element(s) (2000).
SELECT s_id FROM `fw_smw_fpt_subc` WHERE o_id=2000 LIMIT 1 - Temporary table t12
Recursively computed hierarchy for element(s) (2000).
SELECT s_id FROM `fw_smw_fpt_subc` WHERE o_id=2000 LIMIT 1
Query Metrics
Query-Size:10Query-Depth:1
Errors and Warnings
None- Stichstraße zu den Firmen Kurz, Barthelmess u.a. Richtung Norden. Acker links jetzt Firma Kurz, Standort Käfer Zufahrt zu dieser Firma. Andere Straßenseite heute Tucherstraße. Die Felder hinten links sind heute mit Firmen wie Reifen Lorenz u.a. voll bebaut. Rechts hinten die ehem. Waffelfabrik Neubauer. Der 4-spurige Ausbau der Schwabacher Straße ab der Jahnstraße lag erst kurz zurück. Vorher eine Allee gesäumte normale Landstraße, 1966