SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319057 LIMIT 1 [ RunTime:0.001101s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319057 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348716,454898,122420,766422,1040277,225460,237091,538471,945963,1016935,77821,188049,442772,446635,434942,550653,953858,128002,917516,388564,146521,917721,329160,35354,390925,214956,311796,510072,313616,154086,57989,385636,82417,750096,267076,876738,488862,213085,263667,942588,550848,269385,453792,102263,62436,588819,832972,688072,978692,538549,543460,886556,66383,830949,1026468,54233,169909,923227,453689,954856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]