SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432873 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432873 [ RunTime:0.003069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854905,474353,889137,449162,426564,360086,782558,705780,185390,119643,428886,1030912,298867,80148,1046290,816792,734624,499837,1006560,124914,762805,922377,94203,487496,543592,865283,604184,374382,265206,923288,219611,801242,942809,708912,854259,977081,432743,300092,793458,394133,218913,1019742,447692,947991,935729,971965,112888,426595,823660,83736,933958,507926,1007017,891597,811283,455343,652098,169648,812089,641407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]