SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311010 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311010 [ RunTime:0.003637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959235,1001857,586607,369548,302850,115614,691884,710213,740146,747141,446177,771713,558601,463269,778260,232239,221631,398132,844486,956938,639070,1009993,20385,827712,398789,601707,88338,963080,352440,445425,928085,418851,216712,77667,608684,381819,559967,660257,593207,246766,545856,922736,895876,475705,303769,323844,413665,925626,599062,1028945,243105,158693,80,390640,691038,94078,886691,430689,227553,1039198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001564s ]