SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458207 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458207 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348184,1015292,532094,427931,922651,133013,911144,760732,652288,1029732,902782,538417,115859,679943,680126,603122,275420,316835,377102,880663,665029,204924,100413,92420,514493,819377,571616,934253,702927,332059,216921,775810,480170,754583,937340,342264,12318,358086,552829,902745,168452,399538,202818,1013160,647998,257861,436209,852813,804370,30595,542946,279428,990181,394192,646968,508655,1018359,429969,359280,9266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]