SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416697 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416697 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999252,181908,847000,1032389,6954,232358,102182,124479,880789,134206,734752,378272,998310,247764,215643,133437,91262,96754,525627,756620,591990,620952,421684,438263,467197,191856,550017,462532,594807,859173,941023,766474,188101,138207,433606,683018,943458,190966,334132,491612,892418,753294,650227,338936,782037,1043447,326513,610180,407656,666071,937123,52878,290141,613812,584789,135003,222594,692620,841568,213043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]