SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 762012 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 762012 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920344,28908,1002518,806789,890294,633100,262643,271202,785639,1018100,409587,342774,39261,553642,892809,440458,1035195,916244,455403,238722,680926,965219,274963,340208,964193,337991,987394,1005723,917192,546585,586661,532874,961750,794724,810569,683774,537153,92230,329465,297869,758868,531153,999409,708830,179101,376816,363167,878486,853789,781163,590429,97746,171555,35447,667831,356131,626280,627484,160597,41649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 762012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 762012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]