SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002954s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409210 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409210 [ RunTime:0.005700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696155,851557,384532,708212,1023422,906837,177600,304477,289283,909514,307179,728442,644096,98306,168470,836161,277381,787638,383403,861004,1028375,341377,784839,778270,684233,332664,839541,905920,664087,573221,499252,43103,253109,1042724,961081,592050,215542,1037716,508607,433151,449934,737215,630356,168873,977667,949763,293665,334332,626257,203991,81548,109971,930076,619304,7685,754112,575694,106902,965413,289734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]