SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401989 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401989 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213208,362832,679056,365283,148440,334574,530207,993241,639874,734984,926424,235019,303607,800549,920447,654492,950061,992934,769832,179613,80538,851642,776016,731873,843892,396503,692515,297440,385527,562833,50553,214456,146294,538289,782361,129331,861915,437670,89683,759324,503006,25593,71965,749573,809015,755734,618274,622043,192256,1035012,371280,256240,171167,100715,261270,923470,249689,262579,844845,400019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002991s ]