Semantic search
From Lexicon Leponticum
Jump to navigationJump to search
Debug output SQLStore
ASK Query
[[Category:Word]]
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
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1170)
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
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
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1170)
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
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 653 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | lexlepwebu54.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- sipiu: BI·1, BI·8, sipionios, uipios
- siteś: CO·48, The Cisalpine Celtic Languages, atoś, pirauiχeś, pompeteχuaios
- siuilios: MI·7.2
- siś: BG·41.25
- sla(: CO·7
- slaniai: )aniui, )nialui, TI·36.1
- snaśiouitos: VA·20
- sola: NO·20, solos
- solos: BG·41.6
- spt: PV·2
- spuris: TI·4, atios
- stu(: CO·26
- suloikei: )ei(, )ploi(, CO·21
- sunalei: )ei(, )kionei, -al- 2, TI·37, tunal, ualaunal
- sur: BG·43, VA·12
- sura: MI·10.6, NO·6, sur, surica
- surica: VB·30, sur, sura
- sutiuakos: NO·24
- ta: BS·1, VR·9.1, ta(
- ta(: CO·5, CO·70, ta
- tai: BG·36.2, ta(
- tak: none
- taka: BS·8, ta(, tak
- takos: BS·5, NO·21.2, ta(, tak
- talu: BG·31, ta(
- tanatani: BG·41.19
- tanotaliknoi: NO·21.1
- tanotalos: NO·21.1, ta(, tanotaliknoi
- tau: BG·29, pau, ta(
- te(: CO·27
- tekialui: )tek, TI·27.1, TI·39, ial, te(
- telialui: TI·27.1
- terialui: TI·27.1, ial, te(, teromui
- teromui: )rkomui, TI·26, TI·27.1, te(, terialui
- tetu: -ū (3sg.), CO·48, te(
- tetumus: BS·3.1, BS·3.2, te(
- teu: VA·6, te(
- teua: BG·41.17
- teuoχtom: VC·1.2
- teuoχtoni(o)n: VC·1.1, VC·1.2, teuoχtom
- ti: BG·41.14, BG·41.15, BG·41.21, BG·41.26, BG·41.30, CO·23.3, MI·5, isiti
- tikou: NM·9, anatikou, ti
- timirios: BG·41.2
- tiou: CO·76, ti
- tisiui: TI·36.2, ti
- to: BG·40, NO·14, VA·2
- tokra: VR·18
- tokua: VR·18, to
- tonoiso: BG·41.5, to
- tou: BG·8, to