SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286145 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286145 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196860,241521,513293,304592,109208,356096,118282,81280,663734,1008725,27805,888801,815392,57265,1027652,890831,512063,939557,583364,19766,24758,388603,452774,563338,379684,1022094,323569,130211,527316,714989,494598,492693,734929,713221,570325,51752,665479,751804,325395,425878,489644,108870,780244,158449,593262,237546,816477,246021,70890,840603,975516,644239,149339,966153,1029581,812591,333506,824880,129908,32760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]