SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205188 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205188 [ RunTime:0.003886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35354,656140,249268,351746,288346,785192,55344,128508,425193,1006552,830925,859304,180525,803575,448371,810391,957479,847717,706716,654625,1019826,197943,833370,763581,169165,447656,224481,923534,728318,1025850,284418,212487,546293,198218,700050,699955,829660,1027326,343869,765780,525631,91176,576234,208993,130474,391289,32244,895439,958615,521352,34175,60306,912005,434645,985033,414826,23226,273014,568234,975017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]