SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349771 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349771 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428798,755811,321164,1040753,931353,323305,502643,439401,478256,198624,291212,910481,693520,219572,961141,799640,652112,550211,136171,356849,1029744,316354,387512,100202,800149,99758,343672,21025,322942,840655,697543,732105,781890,921494,268864,597566,179905,631529,186077,831643,424710,261219,931321,889217,1007591,380171,423283,50824,504931,32835,388989,1031337,355863,232041,593994,675001,695410,808965,620873,171237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]