SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744380 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744380 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983191,140683,707403,601598,441059,485886,166058,1028511,922008,487779,709664,1002384,967752,923658,863908,574089,987868,880679,34528,96379,406474,25187,540162,102252,1001164,995227,545764,959448,952532,402195,924600,171472,586383,141341,265931,823343,668151,170080,788393,357345,634460,22965,717622,848644,1003950,181178,192840,558563,292120,203236,397696,395358,866550,445775,704375,1031510,962734,937378,961198,608850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]