SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339575 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339575 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26058,591098,474187,142286,880095,943351,858686,397222,854515,658313,439213,424767,197402,430071,587282,926946,435435,375125,79370,466130,515257,51103,1004102,852701,1030098,871778,816439,185950,707394,415104,474975,594407,714238,372254,834701,981609,755520,889070,646192,690318,519697,963389,404701,865991,227286,763951,731123,411227,565274,689026,390144,516862,442453,395870,91518,797637,20518,698340,827991,901271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]