SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104460 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104460 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272917,1016897,908951,285751,961905,189386,267666,730577,995403,1031537,1002177,387765,601348,837527,935936,944745,216524,482701,849314,650116,268637,411629,112647,563770,479550,987804,792856,656186,528441,783837,441910,581873,233889,236981,600153,172544,398383,379489,930414,422831,875991,990457,75071,628761,192622,132298,452063,646559,126457,350672,10275,983110,638726,596246,633314,1038146,321966,25394,117217,381798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]