SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404075 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404075 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311254,102799,511332,317058,78981,143719,561680,610841,812033,601824,961099,78280,309532,674313,846911,223992,60802,792344,943552,967516,197030,843544,650284,455768,994654,516740,65158,1012253,423517,370423,717054,118331,774048,792474,121195,496224,199314,115263,799061,639634,875445,597478,196456,284102,249691,421347,191378,423567,482447,370907,753577,898000,431316,47280,626244,1048143,765859,544765,585074,23407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]