SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599563 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599563 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849840,657900,487011,556166,163413,416757,397282,973486,22409,405746,904681,904047,130605,256867,849872,374668,919389,357895,755556,752641,796746,772575,525841,36331,24823,102541,220436,596560,216208,851700,359685,184771,272865,53877,356670,290873,254517,437146,398797,171698,933732,88383,957276,374942,18869,86898,1009757,355536,493923,279151,893286,363117,839949,130758,144187,703344,906677,582618,220756,339748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]