SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424685 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424685 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967804,906216,469185,875268,191484,1039162,642062,892173,213940,694066,431262,951663,451631,847178,192480,681230,147203,1043115,64497,15325,243482,264397,561010,925552,124945,692555,842535,625471,958544,136273,742119,561450,331755,953944,466235,338119,180305,828623,526403,204711,998844,594816,528061,63835,858404,841642,534252,879076,965126,607539,12320,753890,352778,539195,910160,733141,693527,216377,870567,942151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]