SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428038 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428038 [ RunTime:0.002654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184481,291671,368126,548267,399227,292262,705809,479630,627756,661596,632885,792679,730295,125470,94162,448331,276779,37115,902168,824607,380877,84082,707878,391886,579624,204290,951964,165098,866311,281509,395494,267438,290066,776138,486000,343593,242640,9178,364282,610180,836428,544013,276178,165810,427767,13231,793728,213271,843270,325213,800943,558845,499187,217676,373089,410087,896215,395105,385004,783558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]