SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358006 LIMIT 1 [ RunTime:0.002952s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358006 [ RunTime:0.004441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37402,898936,190136,446050,127814,615268,1024307,547231,475955,507206,65598,592144,992946,953038,449768,629942,90664,299460,917160,993796,1022702,660532,292411,42394,18224,369202,877662,1009584,825592,591762,889112,843195,290221,57490,421526,679188,553072,749531,5350,144544,99045,809522,1033165,645346,597122,713425,278102,223495,900463,100199,537466,223620,134098,684252,433730,1007012,929766,267505,439669,870324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]