SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511563 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511563 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303430,584726,465825,613348,1041343,613303,548883,371552,559591,810130,658748,421828,920375,921430,933692,356829,127418,690405,638595,488404,898805,380277,1006156,978822,559104,269493,880949,159364,926473,191336,451982,917918,1022378,357390,533299,693898,313086,122814,917741,404405,868528,725909,102780,445168,731196,702236,816082,245493,892382,455144,332219,727635,356122,598638,613310,1000763,410907,499164,502754,138946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]