SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107841 LIMIT 1 [ RunTime:0.002784s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107841 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876241,288791,110655,589053,898512,134604,798517,817741,20238,187356,610338,655948,75025,125348,518376,640616,547797,655788,141473,699018,694436,738095,1003093,538025,694122,431787,766583,794228,147442,722640,845503,1044680,1043225,539298,959448,669523,134551,1015560,547696,630336,30942,160211,211666,590659,592806,666918,367356,852499,886856,759075,146751,395761,1011374,266247,941877,430392,415744,834481,994723,1046897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]