SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 845001 LIMIT 1 [ RunTime:0.001487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 845001 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103441,514818,341296,246648,923914,658167,858445,660725,687246,483761,354128,619714,608693,455311,781649,477827,812517,1025994,883835,697780,412173,615815,344968,457219,717165,476687,149505,290099,260717,687607,591485,355137,632950,617190,533731,348511,639827,450656,97938,444020,984139,977065,263562,878188,912865,621946,685440,886273,476511,551175,149108,782752,888077,382187,680379,527285,643004,41001,342552,916411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 845001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 845001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]