SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599801 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599801 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645817,85497,189787,158824,917552,380144,966100,135303,902566,859738,377148,440851,931676,412508,483611,398441,819479,990726,214330,440486,76220,211209,196215,901243,234504,348367,13080,788380,115593,358978,228846,272491,142332,563594,727007,676123,1034283,881640,140468,391683,167343,233856,167782,255195,344399,82492,622649,154572,960932,177402,529335,513356,378239,967001,190897,982427,714770,833572,338577,669738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001061s ]