Ladsgroup added a comment.
[email protected](wikidatawiki)> EXPLAIN SELECT /*
Wikibase\Lib\Store\Sql\Terms\DatabaseItemTermStore::cleanTermsIfUnused */
DISTINCT wbit_term_in_lang_id AS `value` FROM `wbt_item_terms` WHERE
wbit_term_in_lang_id IN ('828227', '828232', '828257', '828265', '828269',
'828272', '828276', '828287', '828290', '828293', '828297', '828302', '828314',
'828315', '828319', '828333', '828336', '828337', '828342', '828350', '828358',
'828362', '828363', '828368', '828374', '828377', '828380', '828382', '828386',
'828387', '828388', '828390', '828401', '828404', '828405', '828414', '828428',
'828433', '828435', '828438', '828448', '828449', '828450', '828451', '870671',
'870674', '870679');
+------+-------------+----------------+-------+----------------------------------------+----------------------------------------+---------+------+----------+--------------------------+
| id | select_type | table | type | possible_keys
| key | key_len | ref | rows
| Extra |
+------+-------------+----------------+-------+----------------------------------------+----------------------------------------+---------+------+----------+--------------------------+
| 1 | SIMPLE | wbt_item_terms | range |
wbt_item_terms_term_in_lang_id_item_id | wbt_item_terms_term_in_lang_id_item_id
| 4 | NULL | 30481196 | Using where; Using index |
+------+-------------+----------------+-------+----------------------------------------+----------------------------------------+---------+------+----------+--------------------------+
1 row in set (0.16 sec)
😊🔫
TASK DETAIL
https://phabricator.wikimedia.org/T234948
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup
Cc: Addshore, #dba, Liuxinyu970226, LarsWirzenius, Lydia_Pintscher, alaa_wmde,
Jdforrester-WMF, WMDE-leszek, Marostegui, Ladsgroup, Aklapper, jcrespo,
Hook696, Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, Iflorez,
darthmon_wmde, Meekrab2012, joker88john, DannyS712, CucyNoiD, Nandana,
NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985,
Cpaulf30, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, Pablo-WMDE,
GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden,
LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Jonas,
Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
