SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201164 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201164 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631575,282607,812109,22622,199982,545317,514643,551472,530568,1033609,194911,413431,750771,731580,71311,334583,167036,691490,719140,264650,112740,770280,613789,341911,981304,817306,161674,221992,983528,108221,897278,912,812729,610557,920012,317861,854819,3498,817922,336432,863488,791268,451084,111905,985821,905300,891828,216516,614910,170398,786869,960193,512708,357410,646848,492280,328296,811108,1018097,649049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]