SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407910 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407910 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826806,678391,1044395,314872,489130,1018986,81738,979927,231790,1048393,952503,315686,865865,900046,630347,993749,622672,710955,949444,42005,761554,938806,504043,429241,171276,991538,577312,76820,1002032,732114,875802,973806,1033364,927891,203711,810895,200742,169079,588200,105258,46907,291241,150078,471342,172654,827507,914183,270647,710057,838909,758104,373012,985950,661712,491296,384288,96963,778162,204982,142726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]