SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335438 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335438 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49877,1001116,499015,609549,286526,119529,320487,326716,957735,839763,28694,986723,521479,606421,400973,169493,594278,89782,155960,64757,44510,51510,726470,458747,747881,712403,605021,472021,200045,11094,641939,79777,535936,423884,48326,1006713,847563,820598,285075,193626,67668,520176,954188,88196,41338,47338,244166,144091,25100,41579,169044,455901,712641,767218,1015090,225294,936153,285830,479523,10244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]