SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141043 LIMIT 1 [ RunTime:0.002212s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141043 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359159,1037012,133631,639348,993748,340303,169782,780637,936796,43527,984861,527383,422413,372176,1016064,323663,10084,560007,793640,352615,77704,757463,162993,742333,230163,1039449,618371,110804,593494,430594,423587,299514,222003,10601,65374,1011625,368663,868300,1032332,455761,895437,739670,225699,759128,995850,856562,853809,693430,16622,426794,965666,887822,94506,57809,735822,735714,355171,286280,926348,680364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]