SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428936 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428936 [ RunTime:0.002845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435791,760734,659572,79830,620286,1043748,409454,712712,855726,410261,191627,145341,804556,890366,682921,91501,332751,958791,970342,250245,510135,352029,1010915,303229,278833,749273,75447,356889,409765,20547,848136,133582,625796,837831,728505,98265,803899,815918,561654,664635,564563,209890,487524,478276,646260,294051,106394,898600,864899,864231,571305,708461,570515,21993,398704,840098,662729,2832,14523,976809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]