SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487820 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487820 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509167,105246,558274,796692,773461,609551,140228,626161,163010,413140,674696,851095,50220,774772,135950,78449,360934,558029,49870,66351,871171,428196,170226,974142,865419,632753,929350,576830,105318,838465,398923,1016265,1012426,857782,22681,463239,730981,167369,438615,123290,232882,477340,864763,586631,1017441,426958,78659,268726,517040,439701,854400,523324,334072,345634,237986,408553,96792,278215,900735,470765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]