SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314180 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314180 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195901,380020,316144,871415,851782,147786,507056,818920,526542,66979,823587,463310,723981,658114,342942,420422,588303,571540,641543,267262,327123,839381,16722,244355,342107,128040,761382,458381,276904,68820,106522,232700,180474,103242,203563,327983,633127,1016743,982486,84229,110634,756803,850086,146722,488926,168835,608961,401007,453243,490832,90744,380856,582774,784036,142235,94788,984117,987415,911778,824538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]