Semantische Suche
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
`public_smw_object_ids` AS t0
INNER JOIN
(`public_smw_fpt_inst` AS t2
INNER JOIN
`public_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`public_smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`public_smw_di_bool` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
`public_smw_di_blob` AS t8 ON t2.s_id=t8.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=35350)
AND (
(t6.o_value=1) AND t6.p_id=35420)
AND (
(t8.o_hash='werktags') AND t8.p_id=35374)
)
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
0
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t8 | index_merge | s_id, p_id, s_id_2, o_hash | o_hash,p_id | 258,262 | 1 | Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2 | s_id | 8 | demo.t8.s_id, const | 1 | Using index | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | demo.t8.s_id | 1 | Using where; Using index | |
1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | demo.t2.o_id | 1 | ||
1 | SIMPLE | t6 | ref | s_id, o_value | s_id | 8 | demo.t8.s_id, const | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | demo.t8.s_id | 1 | Using where |
- Temporary table t3
Recursively computed hierarchy for element(s) (35463).
SELECT s_id FROM `public_smw_fpt_subc` WHERE o_id=35463 LIMIT 1
Query-Depth:1
AST Mitterndorf, AST Moosbrunn, AST St. Valentin, AST Weiz "Wasti", Anrufsammeltaxi 962T Pustertaler Höhenstraße, Bunter Verdl Lenzing, Bürgerbus Zell am See, City Taxi Enns, CityAST Amstetten, Citytaxi Liezen, E-Mobilität Laabental, E-defMobil 2.0 Hopfgarten, E-defMobil 2.0 St. Jakob, E-defMobil 2.0 St. Veit, EMA-Bus Enzersdorf an der Fischa, EMIL Ardagger, EMIL Euratsfeld, EMIL Ferschnitz, EMIL Neuhofen, ElektroMobil Eichgraben, Elektromobil Neulengbach, Elektromobil Pressbaum, Fahrtendienst Kirchberg an der Pielach, Freistädter Citymobil, Gemeindetaxi Paternion, Gmoabus Breitenbrunn, Gmoabus Purbach, InRegion-Taxi Wieselburg, Mobil-E Ebenthal, Postbus Shuttle Liesingtal, Postbus Shuttle Zukunftsraum Donau Gusen, RegioFlink Reutte, RegioFlink Wattens, Stadttaxi Purkersdorf, Stanzer E-Mobil, Tatz-Taxi Bad Tatzmannsdorf, Taufkirchen Mobil, VOR Flex Ebreichsdorf, VOR Flex Maria Anzbach, VOR Flex Mostviertel West