SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311036 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311036 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616012,793823,615668,1026362,947961,1005522,938330,360610,256580,617746,571691,827327,637144,1032432,245636,594992,494737,814946,363441,796131,393407,827310,892504,693328,901853,267411,380130,719991,667543,149597,272345,234301,138011,741328,560557,968823,642553,83638,597435,587293,490789,12306,87295,455343,315473,292677,261940,67972,1027022,31006,916425,359147,441768,697426,730367,409245,77463,651560,504687,155391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]