SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316097 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316097 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927855,383237,739176,768048,169921,966523,8040,265210,569143,55514,767100,298408,622291,602695,426073,573318,626781,1020164,337153,271956,166256,330488,942591,1042077,762843,694178,261552,643536,4069,859793,788367,823217,801505,847767,693649,314469,203400,54724,584027,311128,963708,65231,190015,644014,81601,362191,128161,36152,55758,265050,351986,272582,368589,200279,162095,604469,561083,822241,141561,158776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]