SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428253 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428253 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242276,1019712,50925,109164,594761,534442,869698,379457,328846,868313,357841,649151,207221,38249,813342,371767,1029124,966071,735913,326787,994618,296038,534293,395120,870798,543568,824314,807204,628640,1032665,113018,958768,498944,853546,879851,1017195,603686,213768,148734,916158,601201,223973,176928,792170,452455,945351,698374,616253,497235,850847,532070,648634,767877,812586,242464,151078,255097,651796,961529,481192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]