SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333919 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333919 [ RunTime:0.003275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79984,469643,149158,476009,544618,746606,96214,1001236,206534,724924,1027869,67451,542043,24431,321622,426436,563553,976355,833209,526945,1015181,30585,521483,586085,764528,473362,520930,741071,972990,85416,580932,560872,1042283,850422,155561,1029007,449201,868861,41567,486736,307940,852267,426105,515300,73846,286940,62169,39540,358783,961638,140263,707489,860808,1029935,339721,370664,855659,386917,952157,936289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]