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` = 807601 LIMIT 1 [ RunTime:0.000842s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807601 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41167,1017718,126218,375522,133351,803655,534762,337253,734422,667113,440012,379457,750935,208517,518893,646902,480986,137493,1013926,113932,958675,681013,506445,401672,27106,121135,491230,638227,957630,364822,259195,646350,736601,992274,155992,448541,470653,247017,408142,989176,850613,325729,869575,917167,812492,145321,269333,182660,10503,471336,913689,820535,104307,726056,673279,28632,686932,1012546,341203,821690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]