Semantic search
From Cyberpunk 2077 Wiki
Debug output SQLStore
ASK Query
[[Tag::weapons main pages]] [[:+]] [[Modification date::+]]
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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_blob` AS t2
INNER JOIN
`smw_object_ids` AS t4 ON t2.s_id=t4.smw_id
INNER JOIN
`smw_fpt_mdat` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='weapons main pages') AND t2.p_id=526
AND (t4.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey DESC
LIMIT
255
OFFSET
0
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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_blob` AS t2
INNER JOIN
`smw_object_ids` AS t4 ON t2.s_id=t4.smw_id
INNER JOIN
`smw_fpt_mdat` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='weapons main pages') AND t2.p_id=526
AND (t4.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey DESC
LIMIT
255
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_hash, s_id_2, p_id | o_hash | 258 | const | 4 | 16.67 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | t5 | ref | s_id | s_id | 4 | gamewiki_1.t2.s_id | 1 | 100.00 | |
1 | SIMPLE | t4 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | gamewiki_1.t2.s_id | 1 | 50.00 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | gamewiki_1.t2.s_id | 1 | 85.63 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
Nonetag: weapons main pages (4)
5 February 2021 01:18:21Cyberpunk 2077 | Cyberpunk weapons
Cyberpunk 2077 weapons This page is the starting point for all Cyberpunk 2077 weapons. Legendary Cyberpunk 2077 weapons, iconic Cyberpunk 2077 weapons, etc. all go under this page in some way shape or form.
9 January 2021 16:15:38Cyberpunk 2077 | Cyberpunk weapons
Iconic Weapons This page is for cataloging all the iconic weapons in Cyberpunk 2077 as well as how to get them.
7 January 2021 15:09:45Cyberpunk 2077 | Cyberpunk weapons
Grenades A list of all the grenades in Cyberpunk 2077.
7 January 2021 15:09:36Cyberpunk 2077
Legendary Melee Weapons This page is a collection of all Cyberpunk 2077 melee weapons.