SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31104 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31104 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171741,934908,613086,590770,801593,72421,240243,113510,883683,484768,747363,703628,667371,689264,115534,343042,960922,466504,488319,91467,488798,170805,513683,900115,135773,895291,828367,179285,328116,560100,634201,448932,694539,282206,891080,347673,47919,79003,987540,1012133,875603,972724,770230,465870,642795,139097,984813,334406,16864,677242,55927,1029791,178154,875470,177053,771784,366366,357058,985233,81317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]