SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313091 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313091 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995299,987996,101019,1013618,172538,177666,25881,712439,891169,957392,753032,240499,526278,1064,260365,1003800,445243,35076,216778,452831,370322,510429,934348,758779,789753,961188,929011,323598,448394,302136,1001741,1046598,965365,269676,485219,559214,68536,960992,564971,493500,965337,140781,234030,407102,363366,85179,478989,172550,483487,97041,368455,573741,3937,711256,1021169,826665,874269,370498,341195,1007978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003144s ]