SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414132 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414132 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230094,65118,625820,800305,778948,736355,258135,24891,439243,940820,328865,1003966,537842,800011,975796,117536,28143,89210,624871,36133,890190,18953,948853,546384,269092,716941,1040283,323320,216371,670969,504935,209930,162044,198127,203241,730450,1039756,665020,919207,740888,777431,967897,444500,938003,775607,952997,490012,876028,600682,319436,898793,246481,404280,162016,439122,978315,569301,34533,744319,99500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000990s ]