SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290514 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290514 [ RunTime:0.002440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378432,898285,345869,689372,20539,598804,873573,280996,205017,733883,901441,99085,472608,607105,540613,460292,96973,550846,731987,192999,9774,766551,629780,225608,1016471,458562,342855,556659,548745,640151,82332,803244,396931,596739,175869,88923,487600,145374,52796,55251,942683,705527,520839,366222,566212,464673,608496,61982,476415,180106,645879,9134,654573,54702,334301,1007034,449817,556762,958819,1044283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]