SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442928 LIMIT 1 [ RunTime:0.000703s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442928 [ RunTime:0.002926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335044,516079,862355,319511,284628,777215,962302,1024991,247427,1022694,826554,1006440,96120,39867,158003,181445,348261,780504,140155,641218,638079,230206,150756,863865,839643,99300,62312,672732,977925,393954,109683,525519,327650,674296,192725,423543,101930,613724,1035282,962533,596397,671245,150782,312989,133827,616770,112133,528435,789788,366252,944653,748370,825328,291998,133277,279189,638332,175602,269923,72533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003330s ]