SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 927899 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 927899 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130995,932672,413980,440404,440208,727113,388407,489151,981739,936201,872691,548708,257831,1039419,91435,826298,681726,77655,275070,198643,325565,105326,248351,558100,819948,999483,931243,1035453,743890,1013039,378370,828772,213164,913008,572016,18802,891678,746496,179454,448577,153899,312773,707324,834464,1012912,124027,832721,1004664,580198,714639,965863,51945,104580,296953,344520,771935,338131,165942,868241,827249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 927899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 927899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003432s ]