Semantische Suche
Aus Aifbportal
SQLStore debug output
ASK Query
[[Kategorie:Projekt]]
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='176104')
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='176104')
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 | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | const | 234 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | kit_smw1.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
Nonehomepage | |
---|---|
Digilog@bw“ | |
Dot.Kom | |
E-Certification | |
EBusInstand | |
EBusinessLotse | |
EIT Digital | |
ENSURE | |
EOrgisation | |
EPill | |
ESkills Cert | |
EUCLID | |
EUCOR Virtuale | |
EVOLEARN | |
EnSoC OleCC | |
Energie-Allianz | |
Entwicklung eines Verlinkungsframeworks | |
ExpresST | |
FIS-I | |
FOR5339 | |
Finanzportal | |
FlexAn | |
GETESS | |
GO | |
GenAChange | |
GlobaliSE | |
Graduiertenkolleg IME | |
Grid-control | |
HARMONISE | |
HEGRID | |
Helmholtz Storage and Cross-Linked Infrastructures | |
Helmholtz Supercomputing and Big Data | |
Holistic SLA Management in the Cloud | |
Hybrides und agiles Arbeiten | |
I-VISION | |
IBROW | |
IFS | |
IGreen | |
IIDI | |
IILSE | |
IKT-Landschaft im Jahre 2020 | |
IMPaCT | |
ISF | |
ITSAM | |
ITSLM | |
IZEUS | |
Ilustre Lehre | |
InnoEnergy | |
InterLogGrid | |
KAON | |
KAON WS |