SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331996 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331996 [ RunTime:0.002903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975480,96191,818236,483563,169469,190743,76731,382075,181483,817991,1012765,71253,732911,35856,103065,308507,636724,627715,827658,1006070,722189,670846,962511,573594,472922,92278,721736,1041689,437055,301415,274500,201499,594107,803287,893424,111949,582948,719906,282571,309526,826176,491258,281995,241169,359218,976470,546661,257009,925355,706870,539324,328601,724034,194758,722475,514742,952493,35941,275613,787678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002998s ]