SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 377897 LIMIT 1 [ RunTime:0.001140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 377897 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226986,352428,884938,921200,748414,297149,758767,219628,215820,14405,1005358,11493,267518,481522,864388,240415,113319,643151,99991,853981,118679,127934,130062,391549,201346,409942,558710,839205,366002,290831,793209,118223,401123,1017986,1005940,860706,473725,165561,632645,748880,407382,693518,529164,336733,444470,54172,19957,1020575,576586,188292,770822,253649,234281,614920,577140,485971,800555,415294,929127,487605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 377897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 377897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]