SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320610 LIMIT 1 [ RunTime:0.004469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320610 [ RunTime:0.004787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206910,163419,978162,417842,607059,497332,115431,826196,759024,59238,787197,234429,915504,466253,633439,767006,237378,978852,693256,362751,108788,912600,1017401,136840,267709,132461,860200,967347,828819,508217,614771,955663,654310,699191,795137,21718,463329,496370,470985,165218,679667,616674,185594,863765,493727,795372,423337,853336,394582,428380,471136,222371,624809,738085,690311,734569,650221,367469,623110,721794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003623s ]